SHOW FULL COLUMNS FROM `zx_sq_problem` [ RunTime:0.000819s ]
SHOW FULL COLUMNS FROM `zx_sq_problem_type` [ RunTime:0.000392s ]
SELECT `type_name`,`id` FROM `zx_sq_problem_type` [ RunTime:0.000240s ]
SELECT * FROM `zx_sq_problem` WHERE `id` = 438 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000284s ]
SELECT `type_name`,`id` FROM `zx_sq_problem_type` [ RunTime:0.000168s ]
SELECT `sq_problem`.*,(case when sq_user_corp1.id is null then "" else group_concat(distinct concat(sq_user1.real_name,"|",sq_district1.district_name,"|",sq_organization1.organization_name,"|",sq_user1.phone)) end) as duty_user_data,(case when sq_user_corp0.id is null then "" else group_concat(distinct concat(sq_user0.real_name,"|",sq_user0.phone)) end) as corp_user_data,(case when create_user.id is null then "" else concat(create_user.real_name,"|",create_user.phone) end) as create_user_data,(case when corp_name is null then "" else corp_name end) as corp_name,(case when sq_district.district_name is null then "" else sq_district.district_name end) as problem_district_name FROM `zx_sq_problem` `sq_problem` LEFT JOIN `zx_corp` `corp` ON `sq_problem`.`corp_id`=`corp`.`id` LEFT JOIN `zx_sq_corp` `sq_corp` ON `corp`.`id`=`sq_corp`.`corp_id` LEFT JOIN `zx_sq_district` `sq_district` ON `sq_problem`.`district_id`=`sq_district`.`id` LEFT JOIN `zx_user_corp` `sq_user_corp1` ON `sq_problem`.`corp_id`=sq_user_corp1.corp_id and sq_user_corp1.uc_type=1 LEFT JOIN `zx_user` `sq_user1` ON `sq_user_corp1`.`user_id`=`sq_user1`.`id` LEFT JOIN `zx_sq_organization` `sq_organization1` ON `sq_user1`.`organization_id`=`sq_organization1`.`id` LEFT JOIN `zx_sq_district` `sq_district1` ON `sq_organization1`.`district_id`=`sq_district1`.`id` LEFT JOIN `zx_user_corp` `sq_user_corp0` ON `sq_problem`.`corp_id`=sq_user_corp0.corp_id and sq_user_corp0.uc_type=0 LEFT JOIN `zx_user` `sq_user0` ON `sq_user_corp0`.`user_id`=`sq_user0`.`id` LEFT JOIN `zx_sq_district` `sq_district0` ON `sq_user0`.`district_id`=`sq_district0`.`id` LEFT JOIN `zx_user` `create_user` ON `sq_problem`.`create_uid`=`create_user`.`id` WHERE `sq_problem`.`id` = '438' ORDER BY `sq_problem`.`id` DESC LIMIT 1 [ RunTime:0.002043s ]
SELECT `type_name`,`id` FROM `zx_sq_problem_type` [ RunTime:0.000262s ]
SHOW FULL COLUMNS FROM `zx_sq_problem_running` [ RunTime:0.000430s ]
SELECT `sq_problem_running`.*,(case when sq_user.real_name is null then "" else sq_user.real_name end) as real_name,(case when sq_user.phone is null then "" else sq_user.phone end) as phone,(case when corp_name is null then "" else corp_name end) as corp_name,(case when sq_organization.organization_name is null then "" else concat(sq_district.district_name,"-",sq_organization.organization_name) end) as organization_name,(case when admin.nickname is null then "" else admin.nickname end) as admin_real_name FROM `zx_sq_problem_running` `sq_problem_running` LEFT JOIN `zx_user` `sq_user` ON `sq_problem_running`.`create_uid`=`sq_user`.`id` LEFT JOIN `zx_sq_organization` `sq_organization` ON `sq_user`.`organization_id`=`sq_organization`.`id` LEFT JOIN `zx_sq_district` `sq_district` ON `sq_organization`.`district_id`=`sq_district`.`id` LEFT JOIN `zx_admin` `admin` ON `sq_problem_running`.`admin_uid`=`admin`.`id` LEFT JOIN `zx_corp` `corp` ON `sq_user`.`corp_id`=`corp`.`id` WHERE `sq_problem_running`.`is_del` = '0' AND `sq_problem_running`.`problem_id` = '438' ORDER BY `sq_problem_running`.`id` ASC [ RunTime:0.001216s ]
