SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001183s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000600s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000901s ]
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.000445s ]
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.000307s ]
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.000310s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.000987s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 475206 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000665s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000798s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',475206,') > 0 ) AND `status` = 1 [ RunTime:0.000557s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.317902s ]
SELECT * FROM `tp_soft` WHERE `id` IN (203726,199781,476311,229447,484677,201489,196304,247276,256522,473274,482308,208077,241922,224295,236861,482174) AND `status` = '1' AND `id` <> 475206 [ RunTime:0.004038s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '天和云脉%' AND `status` = '1' AND `id` NOT IN (475206,196304,199781,201489,203726,208077,224295,229447,236861,241922,247276,256522,473274,476311,482174,482308,484677) [ RunTime:0.005447s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.307741s ]
SELECT * FROM `tp_soft` WHERE `id` IN (303013,460522,258281,256235,201186) AND `id` NOT IN (475206,196304,199781,201489,203726,208077,224295,229447,236861,241922,247276,256522,473274,476311,482174,482308,484677) [ RunTime:0.040557s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.232073s ]
SELECT * FROM `tp_soft` WHERE `id` IN (113201,275731,92752,93381,80497) AND `status` = '1' AND `id` NOT IN (475206,196304,199781,201489,203726,208077,224295,229447,236861,241922,247276,256522,473274,476311,482174,482308,484677,201186,256235,258281,303013,460522) [ RunTime:0.001611s ]
共有 0条评论