SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.002062s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000651s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001335s ]
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.000519s ]
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.000426s ]
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.000514s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001768s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479763 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000984s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000508s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001054s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479763,') > 0 ) AND `status` = 1 [ RunTime:0.000500s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.439622s ]
SELECT * FROM `tp_soft` WHERE `id` IN (259421,209476,261253,464922,482495,174709,201497,271219,479760,464224,479686,267490,245044,183416,181020,224994) AND `status` = '1' AND `id` <> 479763 [ RunTime:0.002498s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '巴图鲁汽%' AND `status` = '1' AND `id` NOT IN (479763,174709,181020,183416,201497,209476,224994,245044,259421,261253,267490,271219,464224,464922,479686,479760,482495) [ RunTime:0.004462s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.214383s ]
SELECT * FROM `tp_soft` WHERE `id` IN (230326,478227,216635,466430,464191) AND `id` NOT IN (479763,174709,181020,183416,201497,209476,224994,245044,259421,261253,267490,271219,464224,464922,479686,479760,482495) [ RunTime:0.001460s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.250375s ]
SELECT * FROM `tp_soft` WHERE `id` IN (113076,457788,110323,480861,473892) AND `status` = '1' AND `id` NOT IN (479763,174709,181020,183416,201497,209476,224994,245044,259421,261253,267490,271219,464224,464922,479686,479760,482495,216635,230326,464191,466430,478227) [ RunTime:0.002277s ]
共有 0条评论