SHOW FULL COLUMNS FROM `cmf_car_model` [ RunTime:0.001354s ]
SELECT * FROM `cmf_car_model` ORDER BY `sort` DESC [ RunTime:0.000749s ]
SHOW FULL COLUMNS FROM `cmf_portal_post` [ RunTime:0.001530s ]
SELECT DISTINCT year,`car_model` FROM `cmf_portal_post` WHERE `post_status` = 1 AND `delete_time` = 0 AND `year` > 0 AND `post_type` = 1 [ RunTime:0.001766s ]
SELECT * FROM `cmf_car_model` WHERE `id` IN (2,3,4,9,10,11,12,14,15,1) [ RunTime:0.000795s ]
SHOW FULL COLUMNS FROM `cmf_portal_category` [ RunTime:0.001460s ]
SELECT * FROM `cmf_portal_category` WHERE `id` IN ('11','12') [ RunTime:0.000877s ]
SHOW FULL COLUMNS FROM `cmf_portal_post_year` [ RunTime:0.001284s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000717s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000580s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000591s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000489s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000444s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000489s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000495s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000501s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000406s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000454s ]
SHOW FULL COLUMNS FROM `cmf_portal_modules` [ RunTime:0.001328s ]
SELECT `id`,`code` FROM `cmf_portal_modules` WHERE `code` = 'parts' LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`module_id` FROM `cmf_portal_category` WHERE `module_id` = 3 [ RunTime:0.000557s ]
SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = '56' [ RunTime:0.000119s ]
SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = '58' [ RunTime:0.000078s ]
SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = '59' [ RunTime:0.000143s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `t1` INNER JOIN `cmf_portal_category_post` `t2` ON `t1`.`id`=`t2`.`post_id` INNER JOIN `cmf_portal_category` `t3` ON `t2`.`category_id`=`t3`.`id` WHERE `t2`.`category_id` IN ('58','59','56') AND `t1`.`delete_time` = '0' AND ( `t1`.`post_type` = '1' ) GROUP BY `t1`.`id` ) `_group_count_` [ RunTime:0.000168s ]
SELECT count(*) AS think_count,t1.id,t1.post_content,t1.slug,t1.update_time,t1.published_time,t1.post_title,t1.thumbnail,t1.is_top,t1.recommended,t1.post_hits,t1.post_status,t1.post_type,t1.year,t1.config,c.name as car_model,GROUP_CONCAT(DISTINCT t3.`name` SEPARATOR ",") AS category_names FROM `cmf_portal_post` `t1` INNER JOIN `cmf_portal_category_post` `t2` ON `t1`.`id`=`t2`.`post_id` INNER JOIN `cmf_portal_category` `t3` ON `t2`.`category_id`=`t3`.`id` LEFT JOIN `cmf_car_model` `c` ON `t1`.`car_model`=`c`.`id` WHERE `t2`.`category_id` IN ('58','59','56') AND `t1`.`delete_time` = '0' AND ( `t1`.`post_type` = '1' ) AND `t1`.`delete_time` = '0' AND ( `t1`.`post_type` = '1' ) GROUP BY `t1`.`id` ORDER BY `t1`.`sort` LIMIT 5 [ RunTime:0.000146s ]
SHOW FULL COLUMNS FROM `cmf_slide` [ RunTime:0.000401s ]
SELECT * FROM `cmf_slide` WHERE `type` = 2 AND `delete_time` = 0 AND `page` = 58 [ RunTime:0.000678s ]
SHOW FULL COLUMNS FROM `cmf_slide_item` [ RunTime:0.000390s ]
SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 26 ORDER BY `list_order` ASC [ RunTime:0.000414s ]
SELECT `more`,`file`,`id`,`is_public` FROM `cmf_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'portal/vechile/models' ) ORDER BY `is_public` DESC [ RunTime:0.000242s ]
SHOW FULL COLUMNS FROM `cmf_nav_menu` [ RunTime:0.000519s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000300s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000252s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000178s ]
SELECT * FROM `cmf_car_model` ORDER BY `sort` DESC [ RunTime:0.000168s ]
SELECT DISTINCT year,`car_model` FROM `cmf_portal_post` WHERE `post_status` = 1 AND `delete_time` = 0 AND `year` > 0 AND `post_type` = 1 [ RunTime:0.000140s ]
SELECT * FROM `cmf_car_model` WHERE `id` IN (2,3,4,9,10,11,12,14,15,1) [ RunTime:0.000176s ]
SELECT * FROM `cmf_portal_category` WHERE `id` IN ('11','12') [ RunTime:0.000127s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000158s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000109s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000077s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000116s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000110s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000113s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000077s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000075s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000076s ]
SELECT * FROM `cmf_portal_post_year` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000154s ]
SELECT * FROM `cmf_slide` WHERE `type` = 2 AND `delete_time` = 0 AND `id` = 26 [ RunTime:0.000212s ]
SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 26 ORDER BY `list_order` ASC [ RunTime:0.000144s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000093s ]