SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.002065s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001149s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001480s ]
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.001184s ]
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.002346s ]
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.000422s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000619s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001722s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 478458 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001067s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000487s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001307s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',478458,') > 0 ) AND `status` = 1 [ RunTime:0.000788s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.563359s ]
SELECT * FROM `tp_soft` WHERE `id` IN (334832,303856,198763,469396,474360,172145,216503,477330,306551,199675,182707,199750,350153,234039,258218,182603) AND `status` = '1' AND `id` <> 478458 [ RunTime:0.003738s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '一应生活%' AND `status` = '1' AND `id` NOT IN (478458,172145,182603,182707,198763,199675,199750,216503,234039,258218,303856,306551,334832,350153,469396,474360,477330) [ RunTime:0.007402s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.549993s ]
SELECT * FROM `tp_soft` WHERE `id` IN (234022,231958,484534,214728,170386) AND `id` NOT IN (478458,172145,182603,182707,198763,199675,199750,216503,234039,258218,303856,306551,334832,350153,469396,474360,477330,219603) [ RunTime:0.001934s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.294017s ]
SELECT * FROM `tp_soft` WHERE `id` IN (136965,178048,272546,209578,143037) AND `status` = '1' AND `id` NOT IN (478458,172145,182603,182707,198763,199675,199750,216503,234039,258218,303856,306551,334832,350153,469396,474360,477330,219603,170386,214728,231958,234022,484534) [ RunTime:0.001504s ]
共有 0条评论