SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001488s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000620s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001240s ]
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.000542s ]
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.000408s ]
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.000450s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000510s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001563s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 476023 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000846s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001112s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',476023,') > 0 ) AND `status` = 1 [ RunTime:0.000655s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.185266s ]
SELECT * FROM `tp_soft` WHERE `id` IN (114630,203103,115279,93068,117331,110616,165022,177794,470366,216068,110408,112180,275495,127639,481468,188134) AND `status` = '1' AND `id` <> 476023 [ RunTime:0.002375s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'CarX%' AND `status` = '1' AND `id` NOT IN (476023,93068,110408,110616,112180,114630,115279,117331,127639,165022,177794,188134,203103,216068,275495,470366,481468) [ RunTime:0.008156s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.207583s ]
SELECT * FROM `tp_soft` WHERE `id` IN (343115,170976,479102,232736,237201) AND `id` NOT IN (476023,93068,110408,110616,112180,114630,115279,117331,127639,165022,177794,188134,203103,216068,275495,470366,481468,161203,178533,467819,459320,321705,115893,113138,465400,235063,221137,233460,80358,319643,459943,178868,114871,233588,178866,233586,481266,80372,433454,470841,114890,178865,220780,165038,103709,221051,459942,165018,164319,233585,459941,295489,466625,178867,233587,221227,163233,114891) [ RunTime:0.001474s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.162360s ]
SELECT * FROM `tp_soft` WHERE `id` IN (178597,282551,157247,159916,124402) AND `status` = '1' AND `id` NOT IN (476023,93068,110408,110616,112180,114630,115279,117331,127639,165022,177794,188134,203103,216068,275495,470366,481468,161203,178533,467819,459320,321705,115893,113138,465400,235063,221137,233460,80358,319643,459943,178868,114871,233588,178866,233586,481266,80372,433454,470841,114890,178865,220780,165038,103709,221051,459942,165018,164319,233585,459941,295489,466625,178867,233587,221227,163233,114891,170976,232736,237201,343115,479102) [ RunTime:0.001644s ]
共有 0条评论