SHOW FULL COLUMNS FROM `ex_site` [ RunTime:0.044356s ]
SELECT * FROM `ex_site` WHERE ( `id` = 1 ) AND `ex_site`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.009570s ]
SHOW FULL COLUMNS FROM `ex_team` [ RunTime:0.004509s ]
SHOW FULL COLUMNS FROM `ex_case` [ RunTime:0.003422s ]
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` = 5 ) AND `ex_team`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.010794s ]
SHOW FULL COLUMNS FROM `ex_jb` [ RunTime:0.001425s ]
SELECT * FROM `ex_jb` WHERE ( `id` = 2 ) AND `ex_jb`.`delete_time` IS NULL [ RunTime:0.001061s ]
SHOW FULL COLUMNS FROM `ex_fg` [ RunTime:0.002571s ]
SHOW FULL COLUMNS FROM `ex_team_fg` [ RunTime:0.002109s ]
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` = '5' ) AND `ex_fg`.`delete_time` IS NULL [ RunTime:0.002246s ]
SELECT * FROM `ex_case` WHERE ( `tid` = 5 ) AND `ex_case`.`delete_time` IS NULL [ RunTime:0.000940s ]
SELECT * FROM `ex_case` WHERE ( `tid` = 5 ) AND `ex_case`.`delete_time` IS NULL LIMIT 12 [ RunTime:0.000579s ]