| 123456789101112131415 |
- TYPE=VIEW
- query=select `heatwatch`.`eventcount`.`name` AS `name`,`heatwatch`.`eventcount`.`total` AS `total`,`heatwatch`.`eventcount`.`intPastureId` AS `intPastureId`,`heatwatch`.`eventcount`.`created` AS `created` from `heatwatch`.`eventcount` where ((`heatwatch`.`eventcount`.`type` = \'牛群结构分析\') and (date_format(`heatwatch`.`eventcount`.`created`,\'%Y-%c-%d\') = date_format((select max(`heatwatch`.`eventcount`.`created`) from `heatwatch`.`eventcount` where (`heatwatch`.`eventcount`.`type` = \'牛群结构分析\')),\'%Y-%c-%d\')) and (`heatwatch`.`eventcount`.`intPastureId` = 1)) order by `heatwatch`.`eventcount`.`id`
- md5=0ff0d6998e24acead4dadf6f37bdd257
- updatable=0
- algorithm=0
- definer_user=roo
- definer_host=%
- suid=1
- with_check_option=0
- timestamp=2022-12-14 10:07:38
- create-version=1
- source=select `eventcount`.`name` AS `name`,`eventcount`.`total` AS `total`,`eventcount`.`intPastureId` AS `intPastureId`,`eventcount`.`created` AS `created` from `eventcount` where `eventcount`.`type` = \'牛群结构分析\' and date_format(`eventcount`.`created`,\'%Y-%c-%d\') = date_format((select max(`eventcount`.`created`) from `eventcount` where `eventcount`.`type` = \'牛群结构分析\'),\'%Y-%c-%d\') and `eventcount`.`intPastureId` = 1 order by `eventcount`.`id`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `heatwatch`.`eventcount`.`name` AS `name`,`heatwatch`.`eventcount`.`total` AS `total`,`heatwatch`.`eventcount`.`intPastureId` AS `intPastureId`,`heatwatch`.`eventcount`.`created` AS `created` from `heatwatch`.`eventcount` where ((`heatwatch`.`eventcount`.`type` = \'牛群结构分析\') and (date_format(`heatwatch`.`eventcount`.`created`,\'%Y-%c-%d\') = date_format((select max(`heatwatch`.`eventcount`.`created`) from `heatwatch`.`eventcount` where (`heatwatch`.`eventcount`.`type` = \'牛群结构分析\')),\'%Y-%c-%d\')) and (`heatwatch`.`eventcount`.`intPastureId` = 1)) order by `heatwatch`.`eventcount`.`id`
|
