SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001589s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000544s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001174s ]
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.000449s ]
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.000348s ]
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.000338s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001279s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 478330 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000898s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000387s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001018s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',478330,') > 0 ) AND `status` = 1 [ RunTime:0.000410s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.436516s ]
SELECT * FROM `tp_soft` WHERE `id` IN (161579,461032,236719,209613,170866,483665,258366,467934,407709,347512,470245,232566,293528,461321,374488,253521) AND `status` = '1' AND `id` <> 478330 [ RunTime:0.003375s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '易控全屋%' AND `status` = '1' AND `id` NOT IN (478330,161579,170866,209613,232566,236719,253521,258366,293528,347512,374488,407709,461032,461321,467934,470245,483665) [ RunTime:0.005294s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.532577s ]
SELECT * FROM `tp_soft` WHERE `id` IN (267906,483707,241358,214543,266422) AND `id` NOT IN (478330,161579,170866,209613,232566,236719,253521,258366,293528,347512,374488,407709,461032,461321,467934,470245,483665) [ RunTime:0.001731s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.366134s ]
SELECT * FROM `tp_soft` WHERE `id` IN (126655,89668,192345,138015,126462) AND `status` = '1' AND `id` NOT IN (478330,161579,170866,209613,232566,236719,253521,258366,293528,347512,374488,407709,461032,461321,467934,470245,483665,214543,241358,266422,267906,483707) [ RunTime:0.001772s ]
共有 0条评论