SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001151s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000426s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000886s ]
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.000344s ]
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.000413s ]
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.000394s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000640s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001012s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 475224 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000754s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000867s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',475224,') > 0 ) AND `status` = 1 [ RunTime:0.000688s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.221450s ]
SELECT * FROM `tp_soft` WHERE `id` IN (271565,270794,462548,268912,209598,204445,318400,267249,338388,262231,254205,473290,270225,349997,219350,462227) AND `status` = '1' AND `id` <> 475224 [ RunTime:0.003341s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '思尔健康%' AND `status` = '1' AND `id` NOT IN (475224,204445,209598,219350,254205,262231,267249,268912,270225,270794,271565,318400,338388,349997,462227,462548,473290) [ RunTime:0.004913s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.324386s ]
SELECT * FROM `tp_soft` WHERE `id` IN (251488,458961,477305,303035,461021) AND `id` NOT IN (475224,204445,209598,219350,254205,262231,267249,268912,270225,270794,271565,318400,338388,349997,462227,462548,473290,130049,182291) [ RunTime:0.001771s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.259863s ]
SELECT * FROM `tp_soft` WHERE `id` IN (118117,135942,156687,189831,323193) AND `status` = '1' AND `id` NOT IN (475224,204445,209598,219350,254205,262231,267249,268912,270225,270794,271565,318400,338388,349997,462227,462548,473290,130049,182291,251488,303035,458961,461021,477305) [ RunTime:0.002294s ]
共有 0条评论