SHOW FULL COLUMNS FROM `zy_firm_domains` [ RunTime:0.003893s ]
SHOW FULL COLUMNS FROM `zy_firms` [ RunTime:0.003869s ]
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.003726s ]
SHOW FULL COLUMNS FROM `zy_site_pages` [ RunTime:0.003886s ]
SELECT * FROM `zy_site_pages` WHERE `firm_id` = '4' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003714s ]
SHOW FULL COLUMNS FROM `zy_site_themes` [ RunTime:0.003836s ]
SELECT * FROM `zy_site_themes` WHERE `id` = '1' LIMIT 1 [ RunTime:0.003625s ]
SHOW FULL COLUMNS FROM `zy_system_configs` [ RunTime:0.003806s ]
SELECT * FROM `zy_system_configs` WHERE `status` = 1 AND `target_scope` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003611s ]
SHOW FULL COLUMNS FROM `zy_system_config_values` [ RunTime:0.003699s ]
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.003750s ]
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.003651s ]
SHOW FULL COLUMNS FROM `zy_site_menus` [ RunTime:0.003775s ]
SELECT * FROM `zy_site_menus` WHERE `firm_id` = '4' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003674s ]
SHOW FULL COLUMNS FROM `zy_site_theme_style_defs` [ RunTime:0.003837s ]
SELECT * FROM `zy_site_theme_style_defs` WHERE `theme_id` = '1' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003630s ]
SHOW FULL COLUMNS FROM `zy_site_theme_style_values` [ RunTime:0.003721s ]
SELECT `value`,`style_key` FROM `zy_site_theme_style_values` WHERE `firm_id` = '4' AND `theme_id` = '1' [ RunTime:0.003634s ]
SHOW FULL COLUMNS FROM `zy_site_theme_pages` [ RunTime:0.003783s ]
SELECT * FROM `zy_site_theme_pages` WHERE `theme_id` = '1' AND `page_key` = 'home' AND `status` = 1 LIMIT 1 [ RunTime:0.003826s ]
SHOW FULL COLUMNS FROM `zy_content_channels` [ RunTime:0.003903s ]
SELECT * FROM `zy_content_channels` WHERE `firm_id` = '4' AND `slug` = 'news' AND `status` = 1 LIMIT 1 [ RunTime:0.003658s ]
SHOW FULL COLUMNS FROM `zy_content_categories` [ RunTime:0.003745s ]
SELECT * FROM `zy_content_categories` WHERE `firm_id` = '4' AND `channel_id` = '1' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003614s ]
SHOW FULL COLUMNS FROM `zy_content_posts` [ RunTime:0.003751s ]
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.003728s ]
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 10,10 [ RunTime:0.005931s ]
SELECT `theme_id` FROM `zy_firms` WHERE `id` = '4' LIMIT 1 [ RunTime:0.003572s ]
SHOW FULL COLUMNS FROM `zy_site_theme_templates` [ RunTime:0.003735s ]
SELECT * FROM `zy_site_theme_templates` WHERE `id` = '12' AND `theme_id` = '1' AND `scene` = 'channel_list' AND `status` = 1 LIMIT 1 [ RunTime:0.003661s ]
SELECT * FROM `zy_site_themes` WHERE `id` = '1' LIMIT 1 [ RunTime:0.003666s ]
SELECT * FROM `zy_site_theme_pages` WHERE `theme_id` = '1' AND `page_key` = 'article_list' AND `status` = 1 LIMIT 1 [ RunTime:0.003600s ]
