SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001619s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000753s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001348s ]
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.000642s ]
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.000575s ]
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.000606s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000650s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001294s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 474098 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000943s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000568s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001086s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',474098,') > 0 ) AND `status` = 1 [ RunTime:0.000701s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.291847s ]
SELECT * FROM `tp_soft` WHERE `id` IN (245583,478513,170842,466472,214495,271792,479469,261550,219497,199729,261410,271643,235731,483520,176539,246974) AND `status` = '1' AND `id` <> 474098 [ RunTime:0.005025s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '快手手表%' AND `status` = '1' AND `id` NOT IN (474098,170842,176539,199729,214495,219497,235731,245583,246974,261410,261550,271643,271792,466472,478513,479469,483520) [ RunTime:0.007600s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.348655s ]
SELECT * FROM `tp_soft` WHERE `id` IN (179489,170532,305064,484041,460340) AND `id` NOT IN (474098,170842,176539,199729,214495,219497,235731,245583,246974,261410,261550,271643,271792,466472,478513,479469,483520,222015) [ RunTime:0.001349s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.230664s ]
SELECT * FROM `tp_soft` WHERE `id` IN (472480,112304,138338,127565,166559) AND `status` = '1' AND `id` NOT IN (474098,170842,176539,199729,214495,219497,235731,245583,246974,261410,261550,271643,271792,466472,478513,479469,483520,222015,170532,179489,305064,460340,484041) [ RunTime:0.001719s ]
共有 0条评论