SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001525s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001137s ]
SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` IN (14,16,8,44) OR `parent_id` IN (14,16,8,44) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000396s ]
SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` = 4 OR `parent_id` = 4 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000288s ]
SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` = 1 OR `parent_id` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000270s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000386s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001269s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 260479 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000743s ]
SELECT * FROM `tp_cate` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000302s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000292s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000929s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',260479,') > 0 ) AND `status` = 1 [ RunTime:0.000534s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 40 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.301479s ]
SELECT * FROM `tp_soft` WHERE `id` IN (476436,184778,263197,211552,188968,186767,167222,163675,268289,211721,275766,201167,147285,128730,269703,471845) AND `status` = '1' AND `id` <> 260479 [ RunTime:0.004166s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '墨子守城%' AND `status` = '1' AND `id` NOT IN (260479,128730,147285,163675,167222,184778,186767,188968,201167,211552,211721,263197,268289,269703,275766,471845,476436) [ RunTime:0.006627s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.278446s ]
SELECT * FROM `tp_soft` WHERE `id` IN (253050,264767,462336,469194,465374) AND `id` NOT IN (260479,128730,147285,163675,167222,184778,186767,188968,201167,211552,211721,263197,268289,269703,275766,471845,476436,435423) [ RunTime:0.001262s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.221116s ]
SELECT * FROM `tp_soft` WHERE `id` IN (321777,276919,277982,202574,92720) AND `status` = '1' AND `id` NOT IN (260479,128730,147285,163675,167222,184778,186767,188968,201167,211552,211721,263197,268289,269703,275766,471845,476436,435423,253050,264767,462336,465374,469194) [ RunTime:0.001792s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000401s ]
共有 0条评论