SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001697s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000739s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001232s ]
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.000594s ]
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.000532s ]
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.000599s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001250s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 474930 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000912s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000533s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001115s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',474930,') > 0 ) AND `status` = 1 [ RunTime:0.000707s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.265798s ]
SELECT * FROM `tp_soft` WHERE `id` IN (190362,119765,119897,114634,475691,276088,188336,274948,152475,200761,121969,137164,209925,475674,113849,140519) AND `status` = '1' AND `id` <> 474930 [ RunTime:0.003169s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '猛男宿舍%' AND `status` = '1' AND `id` NOT IN (474930,113849,114634,119765,119897,121969,137164,140519,152475,188336,190362,200761,209925,274948,276088,475674,475691) [ RunTime:0.004554s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.276552s ]
SELECT * FROM `tp_soft` WHERE `id` IN (460924,201166,162302,266227,182519) AND `id` NOT IN (474930,113849,114634,119765,119897,121969,137164,140519,152475,188336,190362,200761,209925,274948,276088,475674,475691) [ RunTime:0.001341s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.221963s ]
SELECT * FROM `tp_soft` WHERE `id` IN (116950,112384,185182,118055,278095) AND `status` = '1' AND `id` NOT IN (474930,113849,114634,119765,119897,121969,137164,140519,152475,188336,190362,200761,209925,274948,276088,475674,475691,162302,182519,201166,266227,460924) [ RunTime:0.001522s ]
共有 0条评论