Ibatis SQL性能求助

lemonrains 2014-01-28 01:32:36

web框架是Struts+spring+ibatis整合的

在执行一条SQL的时候，直接在数据库中运行的时候，基本上是秒出，
但是通过ibatis，queryForObjectList方法调用的时候，需要5分钟左右的样子
无法定位原因，麻烦各位大神帮忙参考给个方向

表里面的VAL1-VAL24里面存的是二进制数据，binary(300)

IBATIS LOG
----------



<2014-01-27 23:34:53,109> {conn-100018} Connection

<2014-01-27 23:34:53,109> {conn-100018} Preparing Statement:    SELECT        T1.DATE_ID AS dateId,   T1.DEV_ID AS devId,   T1.LIB_NO AS libNum,   T1.REC_ID AS recId,   T1.VAL1 AS val1,   T1.VAL2 AS val2,   T1.VAL3 AS val3,   T1.VAL4 AS val4,   T1.VAL5 AS val5,   T1.VAL6 AS val6,   T1.VAL7 AS val7,   T1.VAL8 AS val8,   T1.VAL9 AS val9,   T1.VAL10 AS val10,   T1.VAL11 AS val11,   T1.VAL12 AS val12,   T1.VAL13 AS val13,   T1.VAL14 AS val14,   T1.VAL15 AS val15,   T1.VAL16 AS val16,   T1.VAL17 AS val17,   T1.VAL18 AS val18,   T1.VAL19 AS val19,   T1.VAL20 AS val20,   T1.VAL21 AS val21,   T1.VAL22 AS val22,   T1.VAL23 AS val23,   T1.VAL24 AS val24           FROM curvedb_1m T1         INNER JOIN(   SELECT        T1.DATE_ID,   T1.DEV_ID,   T1.LIB_NO,   T1.REC_ID     FROM       curvedb_1m T1    ,fac_info_lib T2    ,curve_config T3   WHERE      T1.DEV_ID = T2.REC_ID    AND T2.substation_id in (     SELECT       REC_ID      FROM      substation_info     WHERE      PROJECT_ID = ?    )    AND T1.REC_ID  = T3.CURVE_ID    AND T3.DEV_TYPE = T2.DEV_TYPE    AND T3.CURVE_NAME = ?             AND T3.DEV_TYPE = T3.DEV_TYPE    AND T1.LIB_NO = ?        AND T1.DATE_ID  BETWEEN ? AND ?             ) TB ON              T1.REC_ID = TB.REC_ID        AND T1.LIB_NO = TB.LIB_NO        AND T1.DATE_ID = TB.DATE_ID        AND T1.DEV_ID = TB.DEV_ID        ORDER BY          T1.DATE_ID DESC  

<2014-01-27 23:34:53,109> {pstm-100019} Executing Statement:    SELECT        T1.DATE_ID AS dateId,   T1.DEV_ID AS devId,   T1.LIB_NO AS libNum,   T1.REC_ID AS recId,   T1.VAL1 AS val1,   T1.VAL2 AS val2,   T1.VAL3 AS val3,   T1.VAL4 AS val4,   T1.VAL5 AS val5,   T1.VAL6 AS val6,   T1.VAL7 AS val7,   T1.VAL8 AS val8,   T1.VAL9 AS val9,   T1.VAL10 AS val10,   T1.VAL11 AS val11,   T1.VAL12 AS val12,   T1.VAL13 AS val13,   T1.VAL14 AS val14,   T1.VAL15 AS val15,   T1.VAL16 AS val16,   T1.VAL17 AS val17,   T1.VAL18 AS val18,   T1.VAL19 AS val19,   T1.VAL20 AS val20,   T1.VAL21 AS val21,   T1.VAL22 AS val22,   T1.VAL23 AS val23,   T1.VAL24 AS val24           FROM curvedb_1m T1         INNER JOIN(   SELECT        T1.DATE_ID,   T1.DEV_ID,   T1.LIB_NO,   T1.REC_ID     FROM       curvedb_1m T1    ,fac_info_lib T2    ,curve_config T3   WHERE      T1.DEV_ID = T2.REC_ID    AND T2.substation_id in (     SELECT       REC_ID      FROM      substation_info     WHERE      PROJECT_ID = ?    )    AND T1.REC_ID  = T3.CURVE_ID    AND T3.DEV_TYPE = T2.DEV_TYPE    AND T3.CURVE_NAME = ?             AND T3.DEV_TYPE = T3.DEV_TYPE    AND T1.LIB_NO = ?        AND T1.DATE_ID  BETWEEN ? AND ?             ) TB ON              T1.REC_ID = TB.REC_ID        AND T1.LIB_NO = TB.LIB_NO        AND T1.DATE_ID = TB.DATE_ID        AND T1.DEV_ID = TB.DEV_ID        ORDER BY          T1.DATE_ID DESC  

<2014-01-27 23:34:53,109> {pstm-100019} Parameters: [2, 辐射1日累计, 11, 2013-12-01, 2013-12-31]

<2014-01-27 23:34:53,109> {pstm-100019} Types: [java.lang.String, java.lang.String, java.lang.Integer, java.lang.String, java.lang.String]

<2014-01-27 23:34:54,359> {rset-100020} ResultSet

<2014-01-27 23:34:54,359> {rset-100020} Header: [dateId, devId, libNum, recId, val1, val2, val3, val4, val5, val6, val7, val8, val9, val10, val11, val12, val13, val14, val15, val16, val17, val18, val19, val20, val21, val22, val23, val24]

<2014-01-27 23:34:54,359> {rset-100020} Result: [2013-12-25 00:00:00.0, 271, 11, 0, [B@2b2c3, [B@1264f66, [B@26cccc, [B@14f9978, [B@e4d58d, [B@18057ef, [B@10d3ad7, [B@1921db2, [B@1dbac98, [B@120353d, [B@1873965, [B@c9325e, [B@109c0e7, [B@1579bf8, [B@c0f712, [B@9cc027, [B@10b66b5, [B@1843328, null, null, null, null, null, null]

<2014-01-27 23:34:54,515> {rset-100020} Result: [2013-12-24 00:00:00.0, 271, 11, 0, [B@2cb5dc, [B@1579d61, [B@11d594d, [B@1d1d90f, [B@18571, [B@1dfbdb7, [B@206c9a, [B@ba2f0c, [B@166e328, [B@1cb59dd, [B@178cf8d, [B@8257aa, [B@149677e, [B@29b41e, [B@1f052ff, [B@d8e872, [B@8494cd, [B@452f68, [B@2b8638, [B@178f6d4, [B@9517a0, [B@422b86, [B@379080, [B@1efe369]

<2014-01-27 23:34:54,656> {rset-100020} Result: [2013-12-23 00:00:00.0, 271, 11, 0, [B@b27055, [B@ece2f6, [B@28903c, [B@115608e, [B@763a60, [B@1f2885a, [B@1d5db0b, [B@11fd81f, [B@1a60d09, [B@a20429, [B@bf470d, [B@1d1b746, [B@1578cfd, [B@e968ff, [B@1ec41eb, [B@1dbb584, [B@16a2ca3, [B@1988c50, [B@241066, [B@1b0b65c, [B@945d24, [B@6ee8d5, [B@1780cb0, [B@88fbab]

<2014-01-27 23:35:11,343> {rset-100020} Result: [2013-12-22 00:00:00.0, 271, 11, 0, [B@40a11f, [B@1121f48, [B@c3b5a5, [B@ca8e16, [B@365e59, [B@16c60aa, [B@3e47fd, [B@e84edd, [B@191a947, [B@8dbd, [B@599d5a, [B@1699154, [B@1c43709, [B@f959cf, [B@773a0d, [B@18430d9, [B@1a303a5, [B@1446125, [B@45f606, [B@11b2d16, [B@12d1054, [B@18b3c06, [B@11e305, [B@4f919d]

<2014-01-27 23:35:27,921> {rset-100020} Result: [2013-12-21 00:00:00.0, 271, 11, 0, [B@b40153, [B@1c2fedd, [B@ea9777, [B@17e1475, [B@71457b, [B@88c7e9, [B@1fca0a1, [B@95d728, [B@1608885, [B@a30ef0, [B@129d2ca, [B@ce0af1, [B@1309126, [B@1897f6e, [B@d3580, [B@1337f25, [B@1e07065, [B@1f33565, [B@36ba7c, [B@10d595e, [B@1664274, [B@94d8a5, [B@1b7054, [B@16bab43]

<2014-01-27 23:36:00,015> {rset-100020} Result: [2013-12-20 00:00:00.0, 271, 11, 0, [B@1e23688, [B@6a22dd, [B@17025c, [B@9c0d0a, [B@11c4a69, [B@594166, [B@1d4bfee, [B@84bdde, [B@cd4b86, [B@19678c, [B@1dd2ff9, [B@788770, [B@10409e7, [B@264431, [B@470feb, [B@1662402, [B@c6376a, [B@1603786, [B@1dd7476, [B@90579, [B@467816, [B@760937, [B@1570773, [B@aa2d74]

<2014-01-27 23:36:00,015> {rset-100020} Result: [2013-12-19 00:00:00.0, 271, 11, 0, null, null, null, null, null, null, null, null, null, null, [B@1d2009f, null, [B@26faf2, [B@12545be, [B@5f6fa, [B@199bb00, [B@1c41670, [B@9d463b, [B@16dfc04, [B@1bc7ed5, [B@2ae54d, [B@3460e4, [B@c5241f, [B@c6948c]

<2014-01-27 23:36:00,171> {rset-100020} Result: [2013-12-14 00:00:00.0, 271, 11, 0, [B@85b97c, [B@154a323, [B@1a27fba, [B@16fa3be, [B@6712c2, [B@1009868, [B@15da83, [B@bcdff0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]

<2014-01-27 23:36:29,656> {rset-100020} Result: [2013-12-13 00:00:00.0, 271, 11, 0, [B@18874d7, [B@1aedf6d, [B@1ce89aa, [B@b0158c, [B@56ae2b, [B@c4c3b2, [B@be7d2, [B@1a09b67, [B@13a9769, [B@1aaa478, [B@13c530, [B@1f6d56d, [B@3626b0, [B@125f20c, [B@3627c2, [B@16c4f69, [B@1d193f2, [B@48314c, [B@19c7df4, [B@1113fd3, [B@1753a4b, [B@14638a0, [B@12fd0a1, [B@2a00ca]

<2014-01-27 23:36:29,656> {rset-100020} Result: [2013-12-12 00:00:00.0, 271, 11, 0, [B@c1cd1c, [B@18117d0, [B@428ecd, [B@1ad4233, [B@1d52634, [B@bf617d, [B@9956f3, [B@11b9e17, [B@281965, [B@9b7591, [B@439978, [B@109ea6, [B@11fae94, [B@fe9f21, [B@81448d, [B@bbb887, [B@4fd9b5, [B@5e0377, [B@35968a, [B@2e5098, [B@ad48ff, [B@937964, [B@6aa12, [B@187a07a]

<2014-01-27 23:36:48,796> {rset-100020} Result: [2013-12-11 00:00:00.0, 271, 11, 0, [B@11da5fe, [B@17d02c3, [B@40885d, [B@b8a756, [B@f239f1, [B@ba1a6c, [B@1cbc51, [B@8f6bf2, [B@1f81bba, [B@1e48088, [B@b287a5, [B@e76512, [B@19c9ad9, [B@7a58e1, [B@615b9f, [B@1c646cb, [B@51e464, [B@69a206, [B@10c51c5, [B@1cc77b8, [B@c7efb3, [B@4a0890, [B@7843d5, [B@1ad7f3f]

<2014-01-27 23:37:17,718> {rset-100020} Result: [2013-12-10 00:00:00.0, 271, 11, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, [B@c519d7, [B@2399a1, [B@13b2983, [B@1225816, [B@1c536fd, [B@9d576c, [B@1d68014]

<2014-01-27 23:37:17,718> {rset-100020} Result: [2013-12-07 00:00:00.0, 271, 11, 0, [B@e8fe4d, [B@8f8429, [B@2dbece, [B@14a00f2, [B@1841cd6, [B@814b4f, [B@772fcb, [B@e2cd2e, [B@c9bfa, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]

<2014-01-27 23:37:35,953> {rset-100020} Result: [2013-12-06 00:00:00.0, 271, 11, 0, [B@e19958, [B@11a6b1d, [B@16e71cc, [B@1f14555, [B@ff0aea, [B@25bc73, [B@177348f, [B@11bad8d, [B@1f2d94, [B@e9890e, [B@24fdc8, [B@91589e, [B@5121ad, [B@7a0e0c, [B@13076b2, [B@c0e15a, [B@10b0000, [B@12d10f2, [B@1b3ad9b, [B@14aaa58, [B@f5b8b1, [B@30ad95, [B@1d42cfe, [B@d5f34d]

<2014-01-27 23:37:53,031> {rset-100020} Result: [2013-12-05 00:00:00.0, 271, 11, 0, [B@1319134, [B@1340b48, [B@1d0be3b, [B@17922c7, [B@1da720b, [B@753b62, [B@8dbbe3, [B@12a40ad, [B@fc1e73, [B@335020, [B@d16b21, [B@d0838c, [B@16c690e, [B@652746, [B@f58ff3, [B@1bdb9c9, [B@f04a60, [B@1a2ee56, [B@1cd8020, [B@96f045, [B@1785f09, [B@1a76766, [B@1756ee7, [B@c41701]

<2014-01-27 23:38:05,578> {rset-100020} Result: [2013-12-04 00:00:00.0, 271, 11, 0, [B@888443, [B@a38887, [B@587d59, [B@18d79ee, [B@1402f6c, [B@e9665a, [B@13eb3b1, [B@1876493, [B@1dbfbfd, [B@17ca312, [B@1b63214, [B@91d991, [B@162ff82, [B@74bcd3, [B@18da86, [B@1b29aa5, [B@c6c781, [B@54220c, [B@187557c, [B@1fd6fdc, [B@1bb05bf, [B@1767c02, [B@1c77356, [B@1654647]

<2014-01-27 23:38:56,671> {rset-100020} Result: [2013-12-03 00:00:00.0, 271, 11, 0, [B@1b275e3, [B@159c258, [B@1e6504f, [B@1a2b31c, [B@9d0170, [B@1c98c7c, [B@12650fe, [B@8f8272, [B@1bd2346, [B@56d7ea, [B@1797b37, [B@88755b, [B@d0d5bf, [B@80fb53, [B@1f42219, [B@eabf4a, [B@1b4bfda, [B@19fa911, [B@114a62e, [B@aa2906, [B@16b81ac, [B@10e7738, [B@b53992, [B@1d6a4b5]

<2014-01-27 23:38:56,671> {rset-100020} Result: [2013-12-02 00:00:00.0, 271, 11, 0, null, null, null, null, null, null, null, null, [B@3e4eca, [B@a6b921, [B@1c44295, [B@1ef6a08, [B@11a6eae, [B@589871, [B@802d26, [B@1143cec, [B@1abc841, [B@e83ad3, [B@6e2873, [B@21ca8e, [B@7956a7, [B@2827a1, [B@41d2b3, [B@1700de8]

<2014-01-27 23:38:56,671> {rset-100020} Result: [2013-12-01 00:00:00.0, 271, 11, 0, [B@72878a, [B@120795b, [B@ff5139, [B@2da0c7, [B@1968ccf, [B@f69a09, [B@1fae944, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]

<2014-01-28 00:33:52,890> Root WebApplicationContext: initialization started