SHOW FULL COLUMNS FROM `shop_discount_config` [ RunTime:0.003649s ]
SHOW FULL COLUMNS FROM `shop_column` [ RunTime:0.004401s ]
SHOW FULL COLUMNS FROM `shop_column_page` [ RunTime:0.003250s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 0 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.003041s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 18 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.002968s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 16 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.002921s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 22 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.002906s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 17 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.002901s ]
SHOW FULL COLUMNS FROM `shop_label` [ RunTime:0.003078s ]
SELECT `label_name` FROM `shop_label` WHERE `id` = 873 LIMIT 1 [ RunTime:0.003108s ]
SHOW FULL COLUMNS FROM `shop_config` [ RunTime:0.003102s ]
SELECT `config_name`,`config_id` FROM `shop_config` WHERE ( `config_type` = 'DrawingStyle' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.002961s ]
SELECT `config_name`,`config_id` FROM `shop_config` WHERE ( `config_type` = 'DrawingFrameStructure' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.002960s ]
SHOW FULL COLUMNS FROM `shop_drawing` [ RunTime:0.003274s ]
SELECT COUNT(*) AS think_count FROM `shop_drawing` `a` WHERE ( ( `a`.`no` LIKE '%重钢别墅和轻钢别墅有什么不同%' OR `a`.`topic` LIKE '%重钢别墅和轻钢别墅有什么不同%' AND `a`.`attrs` NOT LIKE '%[541]%' ) AND `a`.`is_shel` = '1' ) [ RunTime:0.003799s ]
SELECT null is_jg,`a`.`price`,`a`.`price2`,`a`.`price3`,`a`.`cate`,`a`.`is_top`,`a`.`attrs`,`a`.`is_wholesale`,`a`.`is_new`,`a`.`drawing_id`,`a`.`topic`,`a`.`layct`,`a`.`style`,`a`.`no`,`a`.`cover`,a.cover thumbnail,`a`.`zarea`,`a`.`jarea`,`a`.`bprice1`,`a`.`bprice2`,`a`.`depth`,`a`.`open`,`a`.`struct`,null style_text,null layct_text,null struct_text FROM `shop_drawing` `a` WHERE ( ( `a`.`no` LIKE '%重钢别墅和轻钢别墅有什么不同%' OR `a`.`topic` LIKE '%重钢别墅和轻钢别墅有什么不同%' AND `a`.`attrs` NOT LIKE '%[541]%' ) AND `a`.`is_shel` = '1' ) ORDER BY a.drawing_id desc LIMIT 0,15 [ RunTime:0.004171s ]
SHOW FULL COLUMNS FROM `shop_information` [ RunTime:0.003191s ]
SELECT COUNT(*) AS think_count FROM `shop_information` `a` WHERE ( ( ( `information_title` LIKE '%重钢别墅和轻钢别墅有什么不同%' OR `text_content` LIKE '%重钢别墅和轻钢别墅有什么不同%' ) AND `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL [ RunTime:0.118605s ]
SELECT `a`.* FROM `shop_information` `a` WHERE ( ( ( `information_title` LIKE '%重钢别墅和轻钢别墅有什么不同%' OR `text_content` LIKE '%重钢别墅和轻钢别墅有什么不同%' ) AND `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL ORDER BY a.update_time desc LIMIT 0,15 [ RunTime:0.103759s ]
SHOW FULL COLUMNS FROM `shop_case` [ RunTime:0.003483s ]
SELECT COUNT(*) AS think_count FROM `shop_case` `a` LEFT JOIN `shop_config` `c` ON `a`.`style`=`c`.`config_id` WHERE ( ( `a`.`draw_no` LIKE '%重钢别墅和轻钢别墅有什么不同%' OR `a`.`title` LIKE '%重钢别墅和轻钢别墅有什么不同%' AND `a`.`classification_id` = '12' ) AND `a`.`is_display` = '1' ) [ RunTime:0.006573s ]
SELECT `a`.*,`c`.`config_name`,null addr_text FROM `shop_case` `a` LEFT JOIN `shop_config` `c` ON `a`.`style`=`c`.`config_id` WHERE ( ( `a`.`draw_no` LIKE '%重钢别墅和轻钢别墅有什么不同%' OR `a`.`title` LIKE '%重钢别墅和轻钢别墅有什么不同%' AND `a`.`classification_id` = '12' ) AND `a`.`is_display` = '1' ) ORDER BY a.is_top desc,a.update_time desc LIMIT 0,15 [ RunTime:0.004896s ]
SELECT `config_name`,`config_id` FROM `shop_config` WHERE ( `config_type` = 'DrawingStyle' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.002997s ]
SELECT `config_name`,`config_id` FROM `shop_config` WHERE ( `config_type` = 'DrawingFrameStructure' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.003311s ]
SELECT COUNT(*) AS think_count FROM `shop_drawing` `a` WHERE ( ( `a`.`attrs` NOT LIKE '%[541]%' AND `a`.`is_hot` = '1' ) AND `a`.`is_shel` = '1' ) [ RunTime:0.004176s ]
SELECT null is_jg,`a`.`price`,`a`.`price2`,`a`.`price3`,`a`.`cate`,`a`.`is_top`,`a`.`attrs`,`a`.`is_wholesale`,`a`.`is_new`,`a`.`drawing_id`,`a`.`topic`,`a`.`layct`,`a`.`style`,`a`.`no`,`a`.`cover`,a.cover thumbnail,`a`.`zarea`,`a`.`jarea`,`a`.`bprice1`,`a`.`bprice2`,`a`.`depth`,`a`.`open`,`a`.`struct`,null style_text,null layct_text,null struct_text FROM `shop_drawing` `a` WHERE ( ( `a`.`attrs` NOT LIKE '%[541]%' AND `a`.`is_hot` = '1' ) AND `a`.`is_shel` = '1' ) ORDER BY a.drawing_id desc LIMIT 0,6 [ RunTime:0.003705s ]
SELECT COUNT(*) AS think_count FROM `shop_information` `a` WHERE ( ( `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL [ RunTime:0.020177s ]
SELECT `a`.* FROM `shop_information` `a` WHERE ( ( `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL ORDER BY create_time desc LIMIT 0,6 [ RunTime:0.024582s ]
SELECT COUNT(*) AS think_count FROM `shop_information` `a` WHERE ( ( `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL [ RunTime:0.027671s ]
SELECT `a`.* FROM `shop_information` `a` WHERE ( ( `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL ORDER BY reading_number desc LIMIT 0,6 [ RunTime:0.031233s ]