SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001892s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000674s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001442s ]
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.000525s ]
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.000454s ]
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.000356s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000648s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001752s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 471108 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001268s ]
SELECT * FROM `tp_cate` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000481s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000449s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001384s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',471108,') > 0 ) AND `status` = 1 [ RunTime:0.000826s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 39 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.411524s ]
SELECT * FROM `tp_soft` WHERE `id` IN (188600,126615,189228,140634,249504,258678,172991,237600,168486,189200,335581,239651,162704,258591,118525,111685) AND `status` = '1' AND `id` <> 471108 [ RunTime:0.058992s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '梦幻狂奔%' AND `status` = '1' AND `id` NOT IN (471108,111685,118525,126615,140634,162704,168486,172991,188600,189200,189228,237600,239651,249504,258591,258678,335581) [ RunTime:0.008434s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.449573s ]
SELECT * FROM `tp_soft` WHERE `id` IN (467308,209590,236489,466659,254640) AND `id` NOT IN (471108,111685,118525,126615,140634,162704,168486,172991,188600,189200,189228,237600,239651,249504,258591,258678,335581,186161,269481,162985,269476) [ RunTime:0.001562s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.616059s ]
SELECT * FROM `tp_soft` WHERE `id` IN (472674,274933,159582,103931,95683) AND `status` = '1' AND `id` NOT IN (471108,111685,118525,126615,140634,162704,168486,172991,188600,189200,189228,237600,239651,249504,258591,258678,335581,186161,269481,162985,269476,209590,236489,254640,466659,467308) [ RunTime:0.002831s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.001396s ]
共有 0条评论