SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001542s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000544s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001196s ]
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.000385s ]
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.000579s ]
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.000291s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000519s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001327s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480401 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000809s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000372s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001006s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480401,') > 0 ) AND `status` = 1 [ RunTime:0.000653s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.218487s ]
SELECT * FROM `tp_soft` WHERE `id` IN (464621,91173,480891,114390,275426,273670,476465,169088,109568,435515,109329,475848,475121,151113,80590,142335) AND `status` = '1' AND `id` <> 480401 [ RunTime:0.002679s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '2024%' AND `status` = '1' AND `id` NOT IN (480401,80590,91173,109329,109568,114390,142335,151113,169088,273670,275426,435515,464621,475121,475848,476465,480891) [ RunTime:0.032117s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.399324s ]
SELECT * FROM `tp_soft` WHERE `id` IN (252028,176866,187478,229438,253849) AND `id` NOT IN (480401,80590,91173,109329,109568,114390,142335,151113,169088,273670,275426,435515,464621,475121,475848,476465,480891,260275,476322,79567,474829,108099,475706,153887,79467,476128,473862,220316,474533,473048,475784,473895,160904,107999,79102,133624,474197,480963,226080,473856,473892,220000,472955,230685,475051,473003,481960,91785,89732,112043,474979,80172,481971,480292,485356,481614,273286,473652,136753,220494,222277,231081,128031,485167,473028,475021,481307,474852,474855,476342,473873,477044,485166,474817,79572,474910,108412) [ RunTime:0.003128s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.268898s ]
SELECT * FROM `tp_soft` WHERE `id` IN (152282,94711,213874,119607,209958) AND `status` = '1' AND `id` NOT IN (480401,80590,91173,109329,109568,114390,142335,151113,169088,273670,275426,435515,464621,475121,475848,476465,480891,260275,476322,79567,474829,108099,475706,153887,79467,476128,473862,220316,474533,473048,475784,473895,160904,107999,79102,133624,474197,480963,226080,473856,473892,220000,472955,230685,475051,473003,481960,91785,89732,112043,474979,80172,481971,480292,485356,481614,273286,473652,136753,220494,222277,231081,128031,485167,473028,475021,481307,474852,474855,476342,473873,477044,485166,474817,79572,474910,108412,176866,187478,229438,252028,253849) [ RunTime:0.003197s ]
共有 0条评论