2 |
87.66 ms |
SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.updated_at AS updated_at_2, e0_.identifiant AS identifiant_3, e0_.name AS name_4, e0_.slug AS slug_5, e0_.day_at AS day_at_6, e0_.evapo_bac AS evapo_bac_7, e0_.eto AS eto_8, e0_.evapo_bac_prev AS evapo_bac_prev_9, e0_.eto_prev AS eto_prev_10, s1_.id AS id_11, s1_.created_at AS created_at_12, s1_.updated_at AS updated_at_13, s1_.identifiant AS identifiant_14, s1_.name AS name_15, s1_.slug AS slug_16, c2_.id AS id_17, c2_.created_at AS created_at_18, c2_.updated_at AS updated_at_19, c2_.identifiant AS identifiant_20, c2_.name AS name_21, c2_.slug AS slug_22, c2_.started_at AS started_at_23, c2_.ended_at AS ended_at_24, e0_.site_id AS site_id_25, e0_.campaign_id AS campaign_id_26, c2_.site_id AS site_id_27 FROM evapo_transpiration e0_ INNER JOIN site s1_ ON e0_.site_id = s1_.id LEFT JOIN campaign c2_ ON e0_.campaign_id = c2_.id WHERE e0_.id IN (SELECT e3_.id FROM evapo_transpiration e3_ INNER JOIN site s4_ ON e3_.site_id = s4_.id WHERE s4_.identifiant = ? AND e3_.day_at = ?) ORDER BY e0_.id ASC LIMIT 128
Parameters: [
"1"
"0008-03-09"
]
SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.updated_at AS updated_at_2, e0_.identifiant AS identifiant_3, e0_.name AS name_4, e0_.slug AS slug_5, e0_.day_at AS day_at_6, e0_.evapo_bac AS evapo_bac_7, e0_.eto AS eto_8, e0_.evapo_bac_prev AS evapo_bac_prev_9, e0_.eto_prev AS eto_prev_10, s1_.id AS id_11, s1_.created_at AS created_at_12, s1_.updated_at AS updated_at_13, s1_.identifiant AS identifiant_14, s1_.name AS name_15, s1_.slug AS slug_16, c2_.id AS id_17, c2_.created_at AS created_at_18, c2_.updated_at AS updated_at_19, c2_.identifiant AS identifiant_20, c2_.name AS name_21, c2_.slug AS slug_22, c2_.started_at AS started_at_23, c2_.ended_at AS ended_at_24, e0_.site_id AS site_id_25, e0_.campaign_id AS campaign_id_26, c2_.site_id AS site_id_27 FROM evapo_transpiration e0_ INNER JOIN site s1_ ON e0_.site_id = s1_.id LEFT JOIN campaign c2_ ON e0_.campaign_id = c2_.id WHERE e0_.id IN (SELECT e3_.id FROM evapo_transpiration e3_ INNER JOIN site s4_ ON e3_.site_id = s4_.id WHERE s4_.identifiant = '1' AND e3_.day_at = '0008-03-09') ORDER BY e0_.id ASC LIMIT 128;
|