SHOW FULL COLUMNS FROM `zy_firm_domains` [ RunTime:0.003762s ]
SHOW FULL COLUMNS FROM `zy_firms` [ RunTime:0.003667s ]
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.003487s ]
SHOW FULL COLUMNS FROM `zy_site_pages` [ RunTime:0.003630s ]
SELECT * FROM `zy_site_pages` WHERE `firm_id` = '4' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003489s ]
SHOW FULL COLUMNS FROM `zy_site_themes` [ RunTime:0.003598s ]
SELECT * FROM `zy_site_themes` WHERE `id` = '1' LIMIT 1 [ RunTime:0.003390s ]
SHOW FULL COLUMNS FROM `zy_system_configs` [ RunTime:0.003565s ]
SELECT * FROM `zy_system_configs` WHERE `status` = 1 AND `target_scope` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003409s ]
SHOW FULL COLUMNS FROM `zy_system_config_values` [ RunTime:0.003558s ]
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.003456s ]
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.003457s ]
SHOW FULL COLUMNS FROM `zy_site_menus` [ RunTime:0.003584s ]
SELECT * FROM `zy_site_menus` WHERE `firm_id` = '4' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003467s ]
SHOW FULL COLUMNS FROM `zy_site_theme_style_defs` [ RunTime:0.003568s ]
SELECT * FROM `zy_site_theme_style_defs` WHERE `theme_id` = '1' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003455s ]
SHOW FULL COLUMNS FROM `zy_site_theme_style_values` [ RunTime:0.003526s ]
SELECT `value`,`style_key` FROM `zy_site_theme_style_values` WHERE `firm_id` = '4' AND `theme_id` = '1' [ RunTime:0.003360s ]
SHOW FULL COLUMNS FROM `zy_site_theme_pages` [ RunTime:0.003602s ]
SELECT * FROM `zy_site_theme_pages` WHERE `theme_id` = '1' AND `page_key` = 'home' AND `status` = 1 LIMIT 1 [ RunTime:0.003388s ]
SHOW FULL COLUMNS FROM `zy_content_channels` [ RunTime:0.003638s ]
SELECT * FROM `zy_content_channels` WHERE `firm_id` = '4' AND `slug` = 'team' AND `status` = 1 LIMIT 1 [ RunTime:0.003421s ]
SHOW FULL COLUMNS FROM `zy_lawyer_tags` [ RunTime:0.003479s ]
SELECT * FROM `zy_lawyer_tags` WHERE `firm_id` = '4' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003417s ]
SHOW FULL COLUMNS FROM `zy_lawyer_profiles` [ RunTime:0.003622s ]
SHOW FULL COLUMNS FROM `zy_firm_members` [ RunTime:0.003557s ]
SHOW FULL COLUMNS FROM `zy_lawyer_tag_rel` [ RunTime:0.003452s ]
SELECT COUNT(*) AS think_count FROM `zy_lawyer_profiles` `p` INNER JOIN `zy_firm_members` `m` ON `m`.`id`=`p`.`member_id` INNER JOIN `zy_lawyer_tag_rel` `tr` ON `tr`.`lawyer_profile_id`=p.id AND tr.firm_id = p.firm_id AND tr.tag_id = 2 WHERE `p`.`firm_id` = '4' AND `p`.`is_public` = '1' AND `m`.`status` = '1' [ RunTime:0.003448s ]
SELECT `p`.`id`,`p`.`title`,`p`.`banner_image`,`p`.`specialties`,`p`.`bio`,`p`.`license_no`,`p`.`sort`,`p`.`contact_phones_json`,`p`.`profile_meta_json`,`m`.`real_name`,`m`.`avatar` FROM `zy_lawyer_profiles` `p` INNER JOIN `zy_firm_members` `m` ON `m`.`id`=`p`.`member_id` INNER JOIN `zy_lawyer_tag_rel` `tr` ON `tr`.`lawyer_profile_id`=p.id AND tr.firm_id = p.firm_id AND tr.tag_id = 2 WHERE `p`.`firm_id` = '4' AND `p`.`is_public` = '1' AND `m`.`status` = '1' ORDER BY `p`.`sort` ASC,`p`.`id` ASC LIMIT 0,12 [ RunTime:0.003604s ]
SELECT `r`.`lawyer_profile_id`,`t`.`id`,`t`.`name`,`t`.`description`,`t`.`color`,`t`.`icon`,`t`.`sort`,`t`.`status` FROM `zy_lawyer_tag_rel` `r` INNER JOIN `zy_lawyer_tags` `t` ON `t`.`id`=`r`.`tag_id` WHERE `r`.`firm_id` = '4' AND `r`.`lawyer_profile_id` = '17' AND `t`.`status` = '1' ORDER BY `t`.`sort` ASC,`t`.`id` ASC [ RunTime:0.003428s ]
SELECT `theme_id` FROM `zy_firms` WHERE `id` = '4' LIMIT 1 [ RunTime:0.003308s ]
SHOW FULL COLUMNS FROM `zy_site_theme_templates` [ RunTime:0.003514s ]
SELECT * FROM `zy_site_theme_templates` WHERE `id` = '10' AND `theme_id` = '1' AND `scene` = 'channel_list' AND `status` = 1 LIMIT 1 [ RunTime:0.003390s ]
SELECT * FROM `zy_site_themes` WHERE `id` = '1' LIMIT 1 [ RunTime:0.003347s ]
SELECT * FROM `zy_site_theme_pages` WHERE `theme_id` = '1' AND `page_key` = 'team_list' AND `status` = 1 LIMIT 1 [ RunTime:0.003393s ]
