SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001415s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000674s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001067s ]
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.000458s ]
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.000365s ]
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.000342s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000481s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001188s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 470489 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000828s ]
SELECT * FROM `tp_cate` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000475s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000397s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000971s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',470489,') > 0 ) AND `status` = 1 [ RunTime:0.000601s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 40 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.188228s ]
SELECT * FROM `tp_soft` WHERE `id` IN (259778,118809,146753,93591,225779,90673,89969,148435,156497,141889,471844,201889,136124,118633,322430,321058) AND `status` = '1' AND `id` <> 470489 [ RunTime:0.047674s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '百变躲猫%' AND `status` = '1' AND `id` NOT IN (470489,89969,90673,93591,118633,118809,136124,141889,146753,148435,156497,201889,225779,259778,321058,322430,471844) [ RunTime:0.004349s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.215820s ]
SELECT * FROM `tp_soft` WHERE `id` IN (234656,263076,238720,195998,288063) AND `id` NOT IN (470489,89969,90673,93591,118633,118809,136124,141889,146753,148435,156497,201889,225779,259778,321058,322430,471844,191305,261956,191303,248576,191301) [ RunTime:0.001572s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.170726s ]
SELECT * FROM `tp_soft` WHERE `id` IN (149257,104282,475180,117910,188538) AND `status` = '1' AND `id` NOT IN (470489,89969,90673,93591,118633,118809,136124,141889,146753,148435,156497,201889,225779,259778,321058,322430,471844,191305,261956,191303,248576,191301,195998,234656,238720,263076,288063) [ RunTime:0.001586s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000326s ]
共有 0条评论