SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001461s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000682s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001318s ]
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.000440s ]
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.000344s ]
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.000343s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000453s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001085s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479248 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000787s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000400s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000895s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479248,') > 0 ) AND `status` = 1 [ RunTime:0.000642s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.286900s ]
SELECT * FROM `tp_soft` WHERE `id` IN (237090,164396,255489,477478,469171,271675,341113,402161,348434,260193,253208,227583,269614,474089,171527,482673) AND `status` = '1' AND `id` <> 479248 [ RunTime:0.002978s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '小米爱家%' AND `status` = '1' AND `id` NOT IN (479248,164396,171527,227583,237090,253208,255489,260193,269614,271675,341113,348434,402161,469171,474089,477478,482673) [ RunTime:0.006103s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.266093s ]
SELECT * FROM `tp_soft` WHERE `id` IN (219920,258328,221099,232167,198303) AND `id` NOT IN (479248,164396,171527,227583,237090,253208,255489,260193,269614,271675,341113,348434,402161,469171,474089,477478,482673) [ RunTime:0.000984s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.151950s ]
SELECT * FROM `tp_soft` WHERE `id` IN (90936,115877,480476,116485,212895) AND `status` = '1' AND `id` NOT IN (479248,164396,171527,227583,237090,253208,255489,260193,269614,271675,341113,348434,402161,469171,474089,477478,482673,198303,219920,221099,232167,258328) [ RunTime:0.001389s ]
共有 0条评论