SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001378s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000513s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000994s ]
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.000424s ]
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.000334s ]
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.000331s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001069s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480155 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000799s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000875s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480155,') > 0 ) AND `status` = 1 [ RunTime:0.000580s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.228486s ]
SELECT * FROM `tp_soft` WHERE `id` IN (156856,157224,136039,477048,149450,158912,119467,279724,209953,95039,136836,322588,156260,321603,205006,117333) AND `status` = '1' AND `id` <> 480155 [ RunTime:0.023950s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'nba2%' AND `status` = '1' AND `id` NOT IN (480155,95039,117333,119467,136039,136836,149450,156260,156856,157224,158912,205006,209953,279724,321603,322588,477048) [ RunTime:0.017116s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.298744s ]
SELECT * FROM `tp_soft` WHERE `id` IN (465477,234128,464867,233342,283886) AND `id` NOT IN (480155,95039,117333,119467,136039,136836,149450,156260,156856,157224,158912,205006,209953,279724,321603,322588,477048,101117,184705,469800,474992,109058,475692,140315,471256,273546,140314,237032,469793,459015,480157,140313,140316,469792,433604,138077,468881,165864,191502,172573,140312,110978,166908,221170,469797,474995,127778,272841,109025,109023,474990,111347,474989,109055,101118,221075,169185,221077,165019,236373,112174,221168,221079,146423,135610,319683,165814,178885,348617,474983,469795,424381,468905,109821,188334,135607,190473,101119,476386,166907,109057,321362,127779,108989,460048,236385,109022,127780,165857,191498,138075,139855,191269,140332,237044,112176,138073,95027,226236,169210,165245,165509,221166,164904,166906,433487,348616,474962,319681,465574,191453,127791,103888,235111,475880,212288,145674,237033,459004) [ RunTime:0.002483s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.223759s ]
SELECT * FROM `tp_soft` WHERE `id` IN (136150,276250,279449,186935,473003) AND `status` = '1' AND `id` NOT IN (480155,95039,117333,119467,136039,136836,149450,156260,156856,157224,158912,205006,209953,279724,321603,322588,477048,101117,184705,469800,474992,109058,475692,140315,471256,273546,140314,237032,469793,459015,480157,140313,140316,469792,433604,138077,468881,165864,191502,172573,140312,110978,166908,221170,469797,474995,127778,272841,109025,109023,474990,111347,474989,109055,101118,221075,169185,221077,165019,236373,112174,221168,221079,146423,135610,319683,165814,178885,348617,474983,469795,424381,468905,109821,188334,135607,190473,101119,476386,166907,109057,321362,127779,108989,460048,236385,109022,127780,165857,191498,138075,139855,191269,140332,237044,112176,138073,95027,226236,169210,165245,165509,221166,164904,166906,433487,348616,474962,319681,465574,191453,127791,103888,235111,475880,212288,145674,237033,459004,233342,234128,283886,464867,465477) [ RunTime:0.002572s ]
共有 0条评论