SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001477s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000543s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001124s ]
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.000479s ]
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.000437s ]
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.000350s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000503s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001292s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 475954 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000812s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000975s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',475954,') > 0 ) AND `status` = 1 [ RunTime:0.000684s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.231859s ]
SELECT * FROM `tp_soft` WHERE `id` IN (156250,472572,189685,156389,92925,480420,91169,90016,116746,146474,110330,482315,135193,279043,323803,119595) AND `status` = '1' AND `id` <> 475954 [ RunTime:0.003217s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '生存模拟%' AND `status` = '1' AND `id` NOT IN (475954,90016,91169,92925,110330,116746,119595,135193,146474,156250,156389,189685,279043,323803,472572,480420,482315) [ RunTime:0.006024s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.283611s ]
SELECT * FROM `tp_soft` WHERE `id` IN (296379,484094,426549,269249,484384) AND `id` NOT IN (475954,90016,91169,92925,110330,116746,119595,135193,146474,156250,156389,189685,279043,323803,472572,480420,482315,218602) [ RunTime:0.014423s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.229094s ]
SELECT * FROM `tp_soft` WHERE `id` IN (281028,149964,149066,111292,279182) AND `status` = '1' AND `id` NOT IN (475954,90016,91169,92925,110330,116746,119595,135193,146474,156250,156389,189685,279043,323803,472572,480420,482315,218602,269249,296379,426549,484094,484384) [ RunTime:0.010317s ]
共有 0条评论