SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001758s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000709s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001781s ]
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.000578s ]
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.000426s ]
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.000550s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000643s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001347s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 476570 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001034s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000589s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001189s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',476570,') > 0 ) AND `status` = 1 [ RunTime:0.000828s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.220547s ]
SELECT * FROM `tp_soft` WHERE `id` IN (481017,194844,278240,209252,118135,319450,468900,80192,101497,476876,434583,190646,193798,210826,109896,200743) AND `status` = '1' AND `id` <> 476570 [ RunTime:0.002053s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'biub%' AND `status` = '1' AND `id` NOT IN (476570,80192,101497,109896,118135,190646,193798,194844,200743,209252,210826,278240,319450,434583,468900,476876,481017) [ RunTime:0.003093s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.186026s ]
SELECT * FROM `tp_soft` WHERE `id` IN (247278,174889,463979,264860,304051) AND `id` NOT IN (476570,80192,101497,109896,118135,190646,193798,194844,200743,209252,210826,278240,319450,434583,468900,476876,481017,162871,85192,82346,469959,173217,82352,185848,85959) [ RunTime:0.001632s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.149619s ]
SELECT * FROM `tp_soft` WHERE `id` IN (190584,276323,125542,150200,126554) AND `status` = '1' AND `id` NOT IN (476570,80192,101497,109896,118135,190646,193798,194844,200743,209252,210826,278240,319450,434583,468900,476876,481017,162871,85192,82346,469959,173217,82352,185848,85959,174889,247278,264860,304051,463979) [ RunTime:0.137091s ]
共有 0条评论