SHOW FULL COLUMNS FROM `zy_firm_domains` [ RunTime:0.003821s ]
SHOW FULL COLUMNS FROM `zy_firms` [ RunTime:0.003604s ]
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.003555s ]
SHOW FULL COLUMNS FROM `zy_site_pages` [ RunTime:0.003773s ]
SELECT * FROM `zy_site_pages` WHERE `firm_id` = '4' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003657s ]
SHOW FULL COLUMNS FROM `zy_site_themes` [ RunTime:0.003635s ]
SELECT * FROM `zy_site_themes` WHERE `id` = '1' LIMIT 1 [ RunTime:0.003484s ]
SHOW FULL COLUMNS FROM `zy_system_configs` [ RunTime:0.003595s ]
SELECT * FROM `zy_system_configs` WHERE `status` = 1 AND `target_scope` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003476s ]
SHOW FULL COLUMNS FROM `zy_system_config_values` [ RunTime:0.003577s ]
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.003525s ]
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.003476s ]
SHOW FULL COLUMNS FROM `zy_site_menus` [ RunTime:0.003637s ]
SELECT * FROM `zy_site_menus` WHERE `firm_id` = '4' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003493s ]
SHOW FULL COLUMNS FROM `zy_site_theme_style_defs` [ RunTime:0.003573s ]
SELECT * FROM `zy_site_theme_style_defs` WHERE `theme_id` = '1' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003484s ]
SHOW FULL COLUMNS FROM `zy_site_theme_style_values` [ RunTime:0.003559s ]
SELECT `value`,`style_key` FROM `zy_site_theme_style_values` WHERE `firm_id` = '4' AND `theme_id` = '1' [ RunTime:0.003378s ]
SHOW FULL COLUMNS FROM `zy_site_theme_pages` [ RunTime:0.003657s ]
SELECT * FROM `zy_site_theme_pages` WHERE `theme_id` = '1' AND `page_key` = 'home' AND `status` = 1 LIMIT 1 [ RunTime:0.003416s ]
SHOW FULL COLUMNS FROM `zy_content_channels` [ RunTime:0.003607s ]
SELECT * FROM `zy_content_channels` WHERE `firm_id` = '4' AND `slug` = 'news' AND `status` = 1 LIMIT 1 [ RunTime:0.003425s ]
SHOW FULL COLUMNS FROM `zy_content_categories` [ RunTime:0.003608s ]
SELECT * FROM `zy_content_categories` WHERE `firm_id` = '4' AND `channel_id` = '1' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003433s ]
SHOW FULL COLUMNS FROM `zy_content_posts` [ RunTime:0.003610s ]
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.003567s ]
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.005557s ]
SELECT `theme_id` FROM `zy_firms` WHERE `id` = '4' LIMIT 1 [ RunTime:0.003380s ]
SHOW FULL COLUMNS FROM `zy_site_theme_templates` [ RunTime:0.003567s ]
SELECT * FROM `zy_site_theme_templates` WHERE `id` = '12' AND `theme_id` = '1' AND `scene` = 'channel_list' AND `status` = 1 LIMIT 1 [ RunTime:0.003431s ]
SELECT * FROM `zy_site_themes` WHERE `id` = '1' LIMIT 1 [ RunTime:0.003453s ]
SELECT * FROM `zy_site_theme_pages` WHERE `theme_id` = '1' AND `page_key` = 'article_list' AND `status` = 1 LIMIT 1 [ RunTime:0.003455s ]
