SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001219s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000485s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000995s ]
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.000426s ]
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.000319s ]
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.000321s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001037s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479630 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000754s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000953s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479630,') > 0 ) AND `status` = 1 [ RunTime:0.000584s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.274872s ]
SELECT * FROM `tp_soft` WHERE `id` IN (460386,220160,465586,466559,196397,368200,253711,230295,177018,464772,225054,465840,483086,269182,182646,469230) AND `status` = '1' AND `id` <> 479630 [ RunTime:0.002823s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '小猿搜题%' AND `status` = '1' AND `id` NOT IN (479630,177018,182646,196397,220160,225054,230295,253711,269182,368200,460386,464772,465586,465840,466559,469230,483086) [ RunTime:0.006006s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.266326s ]
SELECT * FROM `tp_soft` WHERE `id` IN (176580,223671,199948,478339,262832) AND `id` NOT IN (479630,177018,182646,196397,220160,225054,230295,253711,269182,368200,460386,464772,465586,465840,466559,469230,483086,160782,88030,232902,88029,241714,238842) [ RunTime:0.001281s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.168311s ]
SELECT * FROM `tp_soft` WHERE `id` IN (275303,433367,154605,116380,178967) AND `status` = '1' AND `id` NOT IN (479630,177018,182646,196397,220160,225054,230295,253711,269182,368200,460386,464772,465586,465840,466559,469230,483086,160782,88030,232902,88029,241714,238842,176580,199948,223671,262832,478339) [ RunTime:0.001475s ]
共有 0条评论