SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001037s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000531s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001132s ]
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.000338s ]
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.000922s ]
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.000429s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000517s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001317s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 477788 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000709s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001494s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',477788,') > 0 ) AND `status` = 1 [ RunTime:0.000456s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.448305s ]
SELECT * FROM `tp_soft` WHERE `id` IN (484628,231755,267872,460597,199667,246895,201207,187311,235151,203653,243520,163401,324785,339152,181713,463240) AND `status` = '1' AND `id` <> 477788 [ RunTime:0.002938s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'Ends%' AND `status` = '1' AND `id` NOT IN (477788,163401,181713,187311,199667,201207,203653,231755,235151,243520,246895,267872,324785,339152,460597,463240,484628) [ RunTime:0.003109s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.419867s ]
SELECT * FROM `tp_soft` WHERE `id` IN (227401,324240,459789,199131,265935) AND `id` NOT IN (477788,163401,181713,187311,199667,201207,203653,231755,235151,243520,246895,267872,324785,339152,460597,463240,484628) [ RunTime:0.001432s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.332451s ]
SELECT * FROM `tp_soft` WHERE `id` IN (139709,323204,109938,160018,212833) AND `status` = '1' AND `id` NOT IN (477788,163401,181713,187311,199667,201207,203653,231755,235151,243520,246895,267872,324785,339152,460597,463240,484628,199131,227401,265935,324240,459789) [ RunTime:0.001518s ]
共有 0条评论