SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001901s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000547s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001273s ]
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.000433s ]
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.000444s ]
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.000289s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000527s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001139s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 468729 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000900s ]
SELECT * FROM `tp_cate` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000428s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000405s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000854s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',468729,') > 0 ) AND `status` = 1 [ RunTime:0.000575s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 43 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.135200s ]
SELECT * FROM `tp_soft` WHERE `id` IN (202023,214604,188281,166787,216336,173006,160603,218750,283053,202188,168986,215513,167567,184417,216944,219748) AND `status` = '1' AND `id` <> 468729 [ RunTime:0.026732s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '快乐沙盒%' AND `status` = '1' AND `id` NOT IN (468729,160603,166787,167567,168986,173006,184417,188281,202023,202188,214604,215513,216336,216944,218750,219748,283053) [ RunTime:0.007712s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.242302s ]
SELECT * FROM `tp_soft` WHERE `id` IN (221033,242220,302461,335693,477604) AND `id` NOT IN (468729,160603,166787,167567,168986,173006,184417,188281,202023,202188,214604,215513,216336,216944,218750,219748,283053,264713,321195,213639) [ RunTime:0.001964s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.375950s ]
SELECT * FROM `tp_soft` WHERE `id` IN (167046,323783,114475,119454,115989) AND `status` = '1' AND `id` NOT IN (468729,160603,166787,167567,168986,173006,184417,188281,202023,202188,214604,215513,216336,216944,218750,219748,283053,264713,321195,213639,221033,242220,302461,335693,477604) [ RunTime:0.001938s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000422s ]
共有 0条评论