SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001437s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000547s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001032s ]
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.000435s ]
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.000354s ]
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.000332s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000468s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001111s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 469197 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000801s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000922s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',469197,') > 0 ) AND `status` = 1 [ RunTime:0.000618s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.291585s ]
SELECT * FROM `tp_soft` WHERE `id` IN (475252,225850,220590,342330,173654,248235,209369,465681,182198,230244,254889,466834,223558,231926,243855,347094) AND `status` = '1' AND `id` <> 469197 [ RunTime:0.004425s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '播客%' AND `status` = '1' AND `id` NOT IN (469197,173654,182198,209369,220590,223558,225850,230244,231926,243855,248235,254889,342330,347094,465681,466834,475252) [ RunTime:0.027506s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.307445s ]
SELECT * FROM `tp_soft` WHERE `id` IN (245527,230044,297269,222484,160782) AND `id` NOT IN (469197,173654,182198,209369,220590,223558,225850,230244,231926,243855,248235,254889,342330,347094,465681,466834,475252,180385) [ RunTime:0.001531s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.229992s ]
SELECT * FROM `tp_soft` WHERE `id` IN (211582,80875,281045,125913,169177) AND `status` = '1' AND `id` NOT IN (469197,173654,182198,209369,220590,223558,225850,230244,231926,243855,248235,254889,342330,347094,465681,466834,475252,180385,160782,222484,230044,245527,297269) [ RunTime:0.001609s ]
共有 0条评论