SHOW FULL COLUMNS FROM `sys_service_area` [ RunTime:0.000935s ]
SELECT `id` AS `id`,`code` AS `code`,`name` AS `name`,`grade` AS `grade`,`initial` AS `initial` FROM `sys_service_area` WHERE `hot` = 1 AND `deleted` = 0 [ RunTime:0.001909s ]
SELECT `id` AS `id`,`code` AS `code`,`name` AS `name`,`grade` AS `grade`,`initial` AS `initial` FROM `sys_service_area` WHERE `initial` <> 'null' AND `deleted` = 0 ORDER BY `initial` [ RunTime:0.002482s ]
SHOW FULL COLUMNS FROM `ccp_ad_content` [ RunTime:0.000943s ]
SELECT `id` AS `id`,`jump_url` AS `jumpurl`,`ad_name` AS `title` FROM `ccp_ad_content` WHERE `place_id` = 3 AND `is_show` = 1 [ RunTime:0.000560s ]
SELECT `id` AS `id`,`jump_url` AS `jumpurl`,`ad_name` AS `title` FROM `ccp_ad_content` WHERE `place_id` = 3 AND `is_show` = 1 [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `jrls_recommend_lawyer` [ RunTime:0.000743s ]
SELECT `lawyer_id` FROM `jrls_recommend_lawyer` WHERE `lawyer_sort` > 0 ORDER BY `lawyer_sort` DESC [ RunTime:0.000510s ]
SHOW FULL COLUMNS FROM `ccp_customer` [ RunTime:0.001200s ]
SELECT id as id,law_office_name as lawOfficeName,customer_name as customerName,valid_business_number as validBusinessNumber,answer_number as answerNumber,law_work_year as lawWorkYear,law_first_card as lawFirstCard,date_of_issue as dateOfIssue,province_name as provinceName,city_name as cityName,customer_code as customerCode,contact_person_img as contactPersonImg,law_good_area as lawGoodArea,business_scope as businessScope,level as level,business_number as businessNumber,contact_person as contactPerson,contact_person_phone as contactPersonPhone,switch_on_worktime as switchOnWorktime,easy_name as easyName,customer_license_number as customerLicenseNumber FROM `ccp_customer` WHERE ( id in ( SELECT `lawyer_id` FROM `jrls_recommend_lawyer` WHERE `lawyer_sort` > 0 ORDER BY `lawyer_sort` DESC ) ) ORDER BY field(`id`, 0,5898,6755,5301,1740,5531,5474,6170,5457,5826,4832,4782,3913,5481) LIMIT 6 [ RunTime:0.000983s ]