SHOW FULL COLUMNS FROM `ex_site` [ RunTime:0.005460s ]
SELECT * FROM `ex_site` WHERE ( `id` = 1 ) AND `ex_site`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000589s ]
SHOW FULL COLUMNS FROM `ex_team` [ RunTime:0.001185s ]
SHOW FULL COLUMNS FROM `ex_case` [ RunTime:0.000825s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `ex_case` `count_table` WHERE ( ( `count_table`.`tid` =ex_team.id ) ) AND `count_table`.`delete_time` IS NULL) AS `cases_count` FROM `ex_team` WHERE ( `id` = 6 ) AND `ex_team`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000716s ]
SHOW FULL COLUMNS FROM `ex_jb` [ RunTime:0.001238s ]
SELECT * FROM `ex_jb` WHERE ( `id` = 2 ) AND `ex_jb`.`delete_time` IS NULL [ RunTime:0.000547s ]
SHOW FULL COLUMNS FROM `ex_fg` [ RunTime:0.001720s ]
SHOW FULL COLUMNS FROM `ex_team_fg` [ RunTime:0.001718s ]
SELECT `ex_fg`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`team_id` AS `pivot__team_id`,`pivot`.`fg_id` AS `pivot__fg_id`,`pivot`.`create_time` AS `pivot__create_time`,`pivot`.`update_time` AS `pivot__update_time`,`pivot`.`delete_time` AS `pivot__delete_time` FROM `ex_fg` INNER JOIN `ex_team_fg` `pivot` ON `pivot`.`fg_id`=`ex_fg`.`id` WHERE ( `pivot`.`team_id` = '6' ) AND `ex_fg`.`delete_time` IS NULL [ RunTime:0.001030s ]
SELECT * FROM `ex_case` WHERE ( `tid` = 6 ) AND `ex_case`.`delete_time` IS NULL [ RunTime:0.000540s ]
SELECT * FROM `ex_case` WHERE ( `tid` = 6 ) AND `ex_case`.`delete_time` IS NULL LIMIT 12 [ RunTime:0.000487s ]