SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001329s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001016s ]
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.000448s ]
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.000351s ]
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.000335s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000460s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001120s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 469913 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000791s ]
SELECT * FROM `tp_cate` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000418s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000387s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000920s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',469913,') > 0 ) AND `status` = 1 [ RunTime:0.000632s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 43 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.209367s ]
SELECT * FROM `tp_soft` WHERE `id` IN (206450,210683,217949,185929,282641,209514,189508,186980,202224,164705,219707,177602,160321,212122,218771,213031) AND `status` = '1' AND `id` <> 469913 [ RunTime:0.074074s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '进击的赵%' AND `status` = '1' AND `id` NOT IN (469913,160321,164705,177602,185929,186980,189508,202224,206450,209514,210683,212122,213031,217949,218771,219707,282641) [ RunTime:0.008898s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.337346s ]
SELECT * FROM `tp_soft` WHERE `id` IN (478688,195329,268129,231332,201624) AND `id` NOT IN (469913,160321,164705,177602,185929,186980,189508,202224,206450,209514,210683,212122,213031,217949,218771,219707,282641,287941,306724,278518,281862,281863) [ RunTime:0.001342s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.245280s ]
SELECT * FROM `tp_soft` WHERE `id` IN (474890,164801,476520,158683,483987) AND `status` = '1' AND `id` NOT IN (469913,160321,164705,177602,185929,186980,189508,202224,206450,209514,210683,212122,213031,217949,218771,219707,282641,287941,306724,278518,281862,281863,195329,201624,231332,268129,478688) [ RunTime:0.001557s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000342s ]
共有 0条评论