SHOW FULL COLUMNS FROM `shop_discount_config` [ RunTime:0.003917s ]
SHOW FULL COLUMNS FROM `shop_column` [ RunTime:0.003548s ]
SHOW FULL COLUMNS FROM `shop_column_page` [ RunTime:0.003549s ]
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.008823s ]
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.010712s ]
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.003167s ]
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.003249s ]
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.003368s ]
SHOW FULL COLUMNS FROM `shop_config` [ RunTime:0.004294s ]
SELECT `config_id`,`config_name` FROM `shop_config` WHERE ( `config_type` = 'DrawingStyle' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.003214s ]
SELECT `config_id`,`config_name` FROM `shop_config` WHERE ( `config_type` = 'FloorArea' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.003150s ]
SELECT `config_id`,`config_name` FROM `shop_config` WHERE ( `config_type` = 'OpenRoom' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.003132s ]
SELECT `config_id`,`config_name` FROM `shop_config` WHERE ( `config_type` = 'DepthSize' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.003168s ]
SELECT `config_id`,`config_name` FROM `shop_config` WHERE ( `config_type` = 'DrawingProperty' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.003198s ]
SELECT `config_id`,`config_name` FROM `shop_config` WHERE ( `config_type` = 'DrawingFrameStructure' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.003142s ]
SELECT `config_name`,`config_id` FROM `shop_config` WHERE ( `config_type` = 'DrawingStyle' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.003138s ]
SELECT `config_name`,`config_id` FROM `shop_config` WHERE ( `config_type` = 'DrawingFrameStructure' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.003123s ]
SHOW FULL COLUMNS FROM `shop_drawing` [ RunTime:0.003487s ]
SELECT COUNT(*) AS think_count FROM `shop_drawing` `a` WHERE ( ( `a`.`style` = '456' AND `a`.`layct` = '1' AND `a`.`struct` = '527' AND `a`.`attrs` LIKE '%[458]%' AND `a`.`attrs` NOT LIKE '%[541]%' AND `a`.`open` BETWEEN '6.0' AND '10.0' AND `a`.`depth` BETWEEN '13.0' AND '17.0' AND `a`.`zarea` >= '300' ) AND `a`.`is_shel` = '1' ) [ RunTime:0.003355s ]
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`.`style` = '456' AND `a`.`layct` = '1' AND `a`.`struct` = '527' AND `a`.`attrs` LIKE '%[458]%' AND `a`.`attrs` NOT LIKE '%[541]%' AND `a`.`open` BETWEEN '6.0' AND '10.0' AND `a`.`depth` BETWEEN '13.0' AND '17.0' AND `a`.`zarea` >= '300' ) AND `a`.`is_shel` = '1' ) ORDER BY a.drawing_id desc LIMIT 0,15 [ RunTime:0.003400s ]
SHOW FULL COLUMNS FROM `shop_case` [ RunTime:0.003575s ]
SELECT null addr_text,`a`.`classification_id`,`a`.`atlas`,`a`.`sheng`,`a`.`shi`,`b`.`zarea`,`b`.`jarea`,`b`.`no`,`a`.`case_id`,`a`.`title`,`a`.`thumbnail`,`b`.`cover`,`b`.`is_shel`,`b`.`layct`,`b`.`style`,`c`.`config_name`,`c`.`config_url`,`b`.`bprice1` FROM `shop_case` `a` LEFT JOIN `shop_drawing` `b` ON `a`.`drawing_id`=`b`.`drawing_id` LEFT JOIN `shop_config` `c` ON `b`.`style`=`c`.`config_id` WHERE `a`.`classification_id` = '12' AND `a`.`is_display` = '1' AND `a`.`substation_id` = '1' ORDER BY rand(),a.reading_number desc LIMIT 6 [ RunTime:0.011456s ]
SHOW FULL COLUMNS FROM `shop_information` [ RunTime:0.003522s ]
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.024757s ]
SELECT `a`.* FROM `shop_information` `a` WHERE ( ( `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL ORDER BY a.update_time desc LIMIT 0,6 [ RunTime:0.026671s ]
SHOW FULL COLUMNS FROM `shop_information_keyword` [ RunTime:0.006787s ]
SELECT * FROM `shop_information_keyword` WHERE ( `is_display` = '1' AND `substation_id` = 1 ) AND `shop_information_keyword`.`delete_time` IS NULL ORDER BY rand() LIMIT 20 [ RunTime:0.018395s ]