SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001813s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000611s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001421s ]
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.000412s ]
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.000335s ]
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.000311s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000472s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001190s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 482865 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000816s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000366s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000955s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',482865,') > 0 ) AND `status` = 1 [ RunTime:0.000430s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.273201s ]
SELECT * FROM `tp_soft` WHERE `id` IN (459643,225052,238625,462848,460096,458996,261410,255396,458477,262897,459769,463045,160967,251915,460969,237223) AND `status` = '1' AND `id` <> 482865 [ RunTime:0.002890s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '当贝市场%' AND `status` = '1' AND `id` NOT IN (482865,160967,225052,237223,238625,251915,255396,261410,262897,458477,458996,459643,459769,460096,460969,462848,463045) [ RunTime:0.005722s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.441711s ]
SELECT * FROM `tp_soft` WHERE `id` IN (268318,477840,181692,459856,212325) AND `id` NOT IN (482865,160967,225052,237223,238625,251915,255396,261410,262897,458477,458996,459643,459769,460096,460969,462848,463045,174742,80726,482863,174887,482864,174725,183545,342300,474203,174758,174946,230161,162250,474202,336082,467729,117375,174793,482861,342302,342301,482862) [ RunTime:0.001871s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.298059s ]
SELECT * FROM `tp_soft` WHERE `id` IN (169146,275856,142135,119128,92622) AND `status` = '1' AND `id` NOT IN (482865,160967,225052,237223,238625,251915,255396,261410,262897,458477,458996,459643,459769,460096,460969,462848,463045,174742,80726,482863,174887,482864,174725,183545,342300,474203,174758,174946,230161,162250,474202,336082,467729,117375,174793,482861,342302,342301,482862,181692,212325,268318,459856,477840) [ RunTime:0.002842s ]
共有 0条评论