[ DB ] CONNECT:[ UseTime:0.000824s ] mysql:host=127.0.0.1;port=3306;dbname=jdsc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.002413s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_goods` WHERE `is_on_sale` = 1 AND `is_virtual` = 0 AND `cat_id` IN (12,13,14,15,16,17,18,19,20,21,22,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,23,24,25,29,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,26,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,27,232,233,234,235,236,237,238,239,240,241,242,243,244,245,28,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261) AND ( `exchange_integral` > 0 ) LIMIT 1 [ RunTime:0.001557s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `is_virtual` = 0 AND `cat_id` IN (12,13,14,15,16,17,18,19,20,21,22,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,23,24,25,29,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,26,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,27,232,233,234,235,236,237,238,239,240,241,242,243,244,245,28,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261) AND ( `exchange_integral` > 0 ) LIMIT 0,15 [ RunTime:0.001374s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.001219s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `level` = 1 [ RunTime:0.000998s ]
[ SQL ] select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.005176s ]
[ SQL ] select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000622s ]
[ SQL ] select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.001011s ]
[ SQL ] select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.002358s ]
[ SQL ] SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.000387s ]
[ SQL ] select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.000421s ]
