SHOW FULL COLUMNS FROM `zy_firm_domains` [ RunTime:0.004202s ]
SHOW FULL COLUMNS FROM `zy_firms` [ RunTime:0.004037s ]
SELECT `f`.* FROM `zy_firm_domains` `d` INNER JOIN `zy_firms` `f` ON `f`.`id`=`d`.`firm_id` WHERE `d`.`domain` = 'www.fenghaolawyer.com' AND `d`.`status` = '1' AND `f`.`status` = '1' LIMIT 1 [ RunTime:0.003840s ]
SHOW FULL COLUMNS FROM `zy_site_pages` [ RunTime:0.003967s ]
SELECT * FROM `zy_site_pages` WHERE `firm_id` = '4' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003893s ]
SHOW FULL COLUMNS FROM `zy_site_themes` [ RunTime:0.003950s ]
SELECT * FROM `zy_site_themes` WHERE `id` = '1' LIMIT 1 [ RunTime:0.003703s ]
SHOW FULL COLUMNS FROM `zy_system_configs` [ RunTime:0.003921s ]
SELECT * FROM `zy_system_configs` WHERE `status` = 1 AND `target_scope` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003803s ]
SHOW FULL COLUMNS FROM `zy_system_config_values` [ RunTime:0.003891s ]
SELECT `value`,`config_id` FROM `zy_system_config_values` WHERE `firm_id` = '0' AND `config_id` IN ('11','1','2','3','4','5','6','7','8','9','10') [ RunTime:0.003771s ]
SELECT `value`,`config_id` FROM `zy_system_config_values` WHERE `firm_id` = '4' AND `config_id` IN ('11','1','2','3','4','5','6','7','8','9','10') [ RunTime:0.003815s ]
SHOW FULL COLUMNS FROM `zy_site_menus` [ RunTime:0.004047s ]
SELECT * FROM `zy_site_menus` WHERE `firm_id` = '4' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003820s ]
SHOW FULL COLUMNS FROM `zy_site_theme_style_defs` [ RunTime:0.003892s ]
SELECT * FROM `zy_site_theme_style_defs` WHERE `theme_id` = '1' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003776s ]
SHOW FULL COLUMNS FROM `zy_site_theme_style_values` [ RunTime:0.003910s ]
SELECT `value`,`style_key` FROM `zy_site_theme_style_values` WHERE `firm_id` = '4' AND `theme_id` = '1' [ RunTime:0.003748s ]
SHOW FULL COLUMNS FROM `zy_site_theme_pages` [ RunTime:0.003931s ]
SELECT * FROM `zy_site_theme_pages` WHERE `theme_id` = '1' AND `page_key` = 'home' AND `status` = 1 LIMIT 1 [ RunTime:0.003702s ]
SHOW FULL COLUMNS FROM `zy_content_channels` [ RunTime:0.003907s ]
SELECT * FROM `zy_content_channels` WHERE `firm_id` = '4' AND `slug` = 'news' AND `status` = 1 LIMIT 1 [ RunTime:0.003724s ]
SHOW FULL COLUMNS FROM `zy_content_categories` [ RunTime:0.003872s ]
SELECT * FROM `zy_content_categories` WHERE `firm_id` = '4' AND `channel_id` = '1' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003728s ]
SHOW FULL COLUMNS FROM `zy_content_posts` [ RunTime:0.003962s ]
SELECT COUNT(*) AS think_count FROM `zy_content_posts` `p` LEFT JOIN `zy_content_channels` `ch` ON `ch`.`id`=`p`.`channel_id` LEFT JOIN `zy_content_categories` `c` ON `c`.`id`=`p`.`category_id` WHERE `p`.`firm_id` = '4' AND `p`.`channel_id` = '1' AND `p`.`type` = 'news' AND `p`.`status` = 'published' [ RunTime:0.003909s ]
SELECT `p`.*,c.name as category_name,ch.slug as channel_slug,ch.name as channel_name,ch.template_key as channel_template_key FROM `zy_content_posts` `p` LEFT JOIN `zy_content_channels` `ch` ON `ch`.`id`=`p`.`channel_id` LEFT JOIN `zy_content_categories` `c` ON `c`.`id`=`p`.`category_id` WHERE `p`.`firm_id` = '4' AND `p`.`channel_id` = '1' AND `p`.`type` = 'news' AND `p`.`status` = 'published' ORDER BY `p`.`published_at` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.007851s ]
SELECT `theme_id` FROM `zy_firms` WHERE `id` = '4' LIMIT 1 [ RunTime:0.003764s ]
SHOW FULL COLUMNS FROM `zy_site_theme_templates` [ RunTime:0.003883s ]
SELECT * FROM `zy_site_theme_templates` WHERE `id` = '12' AND `theme_id` = '1' AND `scene` = 'channel_list' AND `status` = 1 LIMIT 1 [ RunTime:0.003779s ]
SELECT * FROM `zy_site_themes` WHERE `id` = '1' LIMIT 1 [ RunTime:0.003757s ]
SELECT * FROM `zy_site_theme_pages` WHERE `theme_id` = '1' AND `page_key` = 'article_list' AND `status` = 1 LIMIT 1 [ RunTime:0.003996s ]
