SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001480s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000602s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001311s ]
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.000418s ]
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.000482s ]
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.000418s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001430s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 474834 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000854s ]
SELECT * FROM `tp_cate` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000372s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000379s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001089s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',474834,') > 0 ) AND `status` = 1 [ RunTime:0.000630s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 40 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.268750s ]
SELECT * FROM `tp_soft` WHERE `id` IN (136019,136452,260438,91024,217580,218830,260440,135885,90381,259852,217307,281583,156705,115763,177433,236469) AND `status` = '1' AND `id` <> 474834 [ RunTime:0.019455s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '奇妙数字%' AND `status` = '1' AND `id` NOT IN (474834,90381,91024,115763,135885,136019,136452,156705,177433,217307,217580,218830,236469,259852,260438,260440,281583) [ RunTime:0.006931s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.536879s ]
SELECT * FROM `tp_soft` WHERE `id` IN (484459,187458,232604,460241,208157) AND `id` NOT IN (474834,90381,91024,115763,135885,136019,136452,156705,177433,217307,217580,218830,236469,259852,260438,260440,281583,473823,154537) [ RunTime:0.002169s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.493347s ]
SELECT * FROM `tp_soft` WHERE `id` IN (125525,141103,166808,165806,206282) AND `status` = '1' AND `id` NOT IN (474834,90381,91024,115763,135885,136019,136452,156705,177433,217307,217580,218830,236469,259852,260438,260440,281583,473823,154537,187458,208157,232604,460241,484459) [ RunTime:0.002199s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000525s ]
共有 0条评论