Symfony Profiler

SELECT
  b.`etr_prod_id` as `etr`,
  mip.mois as `mois`,
  mip.annee as `annee`,
  SUM(b.`montant`) as `montant`
FROM
  `bpu_prod` b
  INNER JOIN `intervention_production` i on b.intervention_production_id = i.`id`
  INNER JOIN `mois_interventions_prod` mip on mip.id = i.mois_interventions_prod_id
WHERE
  i.removed = 0
GROUP BY
  `etr`,
  `mois`,
  `annee`
HAVING
  `etr` = 263
  AND `mois` = 4
  AND `annee` = 2025

SELECT b.`etr_prod_id` as `etr`, mip.mois  as `mois`, mip.annee as `annee`, 
        SUM(b.`montant`) as `montant` FROM `bpu_prod` b 
        INNER JOIN `intervention_production` i on b.intervention_production_id = i.`id` 
        INNER JOIN `mois_interventions_prod` mip on mip.id = i.mois_interventions_prod_id 
        WHERE i.removed=0  
        GROUP BY `etr`,`mois`,`annee` HAVING `etr`=263 AND `mois`=4 AND `annee`=2025;

SELECT
  p.tech_id as "techId",
  sum(b.montant) as "montant"
FROM
  `bpu_prod` b
  INNER JOIN `intervention_production` i on i.`id` = b.`intervention_production_id`
  INNER JOIN `planning_etr_prod` p on i.planning_etr_prod_id = p.id
  INNER JOIN `mois_interventions_prod` mip on mip.id = i.mois_interventions_prod_id
WHERE
  i.removed = 0
  AND p.etr_prod_id = :etr
  and mip.mois = :mois
  AND mip.annee = :annee
GROUP BY
  techId

SELECT p.tech_id as "techId", sum(b.montant) as "montant" FROM `bpu_prod` b INNER JOIN `intervention_production` i 
            on i.`id` = b.`intervention_production_id` INNER JOIN `planning_etr_prod` p on i.planning_etr_prod_id = p.id 
            INNER JOIN `mois_interventions_prod` mip on mip.id = i.mois_interventions_prod_id 
            WHERE i.removed = 0 AND p.etr_prod_id = 263 and mip.mois = 4 AND mip.annee = 2025 GROUP BY techId;

SELECT
  i.`jeton_rc`,
  i.`code_du_departement_abonne`,
  i.`nom_du_departement_abonne`,
  i.`code_de_la_commune_abonne`,
  i.`nom_de_la_commune_abonne`,
  i.`zone`,
  i.`technologie`,
  i.`nom_du_nro`,
  i.`operateur_immeuble`,
  i.`type_de_pbo`,
  i.`type_de_pto`,
  i.`intevention_id`,
  i.`type_intervention`,
  i.`date_intervention`,
  i.`nom_du_prestataire`,
  p.`login_technicien`,
  p.`tech_id`,
  i.`code_du_debriefing`,
  i.`libelle_du_debriefing`,
  i.`reference_de_article`,
  i.`pu`,
  i.`qte`,
  i.`montant`,
  i.`commentaire`,
  e.`raison_sociale`,
  b.`article_etr`,
  b.`pu`,
  b.`montant`,
  b.`pv_type`,
  s.`raison_sociale`
FROM
  `intervention_production` i
  INNER JOIN `planning_etr_prod` p ON i.`planning_etr_prod_id` = p.`id`
  INNER JOIN `etr_prod` e on e.`id` = p.`etr_prod_id`
  INNER JOIN `bpu_prod` b on b.`intervention_production_id` = i.`id`
  INNER JOIN `article_prod` a ON a.`id` = b.`article_prod_id`
  INNER JOIN `societe` s ON s.`id` = e.`societe_id`
  INNER JOIN `mois_interventions_prod` mip on mip.id = i.mois_interventions_prod_id
WHERE
  i.removed = 0
  and mip.mois = 4
  and mip.annee = 2025
  and e.`id` = 263

SELECT i.`jeton_rc`, i.`code_du_departement_abonne`, i.`nom_du_departement_abonne`, i.`code_de_la_commune_abonne`, 
        i.`nom_de_la_commune_abonne`, i.`zone`, i.`technologie`, i.`nom_du_nro`, i.`operateur_immeuble`, i.`type_de_pbo`, 
        i.`type_de_pto`, i.`intevention_id`, i.`type_intervention`, i.`date_intervention`, i.`nom_du_prestataire`, p.`login_technicien`, 
        p.`tech_id`, i.`code_du_debriefing`, i.`libelle_du_debriefing`, i.`reference_de_article`, i.`pu`, i.`qte`, i.`montant`, 
        i.`commentaire`, e.`raison_sociale`,b.`article_etr`,b.`pu`,b.`montant`,b.`pv_type`,s.`raison_sociale` 
        FROM `intervention_production` i INNER JOIN `planning_etr_prod` p ON i.`planning_etr_prod_id` = p.`id` 
        INNER JOIN `etr_prod` e on e.`id` = p.`etr_prod_id` INNER JOIN `bpu_prod` b on b.`intervention_production_id` = i.`id` 
        INNER JOIN `article_prod` a ON a.`id` = b.`article_prod_id` INNER JOIN `societe` s ON s.`id` = e.`societe_id` 
        INNER JOIN `mois_interventions_prod` mip on mip.id = i.mois_interventions_prod_id  
        WHERE i.removed=0 and mip.mois = 4 and mip.annee = 2025 and e.`id` = 263;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.mode AS mode_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.mode AS mode_6 FROM user t0 WHERE t0.id = 4;

SELECT
  p2.login_technicien,
  p2.tech_id,
  p1.`rc`,
  p1.`anomalie`,
  p1.`date_rdv`,
  p1.`penalite`,
  p1.`mois`,
  p1.`annee`
FROM
  `penalite` p1
  INNER JOIN `planning_etr_prod` p2 on p1.`planning_etr_prod_id` = p2.`id`
WHERE
  p1.`etr_prod_id` = 263
  and p1.`mois` = 4
  and p1.`annee` = 2025

SELECT p2.login_technicien, p2.tech_id, p1.`rc`, p1.`anomalie`, p1.`date_rdv`, p1.`penalite`,p1.`mois`,  p1.`annee` FROM `penalite` p1
        INNER JOIN `planning_etr_prod` p2 on p1.`planning_etr_prod_id`=p2.`id` 
        WHERE p1.`etr_prod_id` = 263 and p1.`mois`=4 and p1.`annee`=2025;

SELECT
  t0.id AS id_1,
  t0.raison_sociale AS raison_sociale_2,
  t0.voie AS voie_3,
  t0.adresse AS adresse_4,
  t0.siret AS siret_5,
  t0.prenom AS prenom_6,
  t0.nom AS nom_7,
  t0.email AS email_8,
  t0.entreprise_fact AS entreprise_fact_9,
  t0.tva AS tva_10,
  t0.contrat AS contrat_11,
  t0.reduction AS reduction_12,
  t0.societe_id AS societe_id_13
FROM
  etr_prod t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.voie AS voie_3, t0.adresse AS adresse_4, t0.siret AS siret_5, t0.prenom AS prenom_6, t0.nom AS nom_7, t0.email AS email_8, t0.entreprise_fact AS entreprise_fact_9, t0.tva AS tva_10, t0.contrat AS contrat_11, t0.reduction AS reduction_12, t0.societe_id AS societe_id_13 FROM etr_prod t0 WHERE t0.id = 263 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.rc AS rc_2,
  t0.anomalie AS anomalie_3,
  t0.date_rdv AS date_rdv_4,
  t0.mois AS mois_5,
  t0.penalite AS penalite_6,
  t0.annee AS annee_7,
  t0.nom_penalite AS nom_penalite_8,
  t0.etr_prod_id AS etr_prod_id_9,
  t0.planning_etr_prod_id AS planning_etr_prod_id_10,
  t0.fichier_penalites_id AS fichier_penalites_id_11
FROM
  penalite t0
WHERE
  t0.etr_prod_id = ?
  AND t0.mois = ?
  AND t0.annee = ?

SELECT t0.id AS id_1, t0.rc AS rc_2, t0.anomalie AS anomalie_3, t0.date_rdv AS date_rdv_4, t0.mois AS mois_5, t0.penalite AS penalite_6, t0.annee AS annee_7, t0.nom_penalite AS nom_penalite_8, t0.etr_prod_id AS etr_prod_id_9, t0.planning_etr_prod_id AS planning_etr_prod_id_10, t0.fichier_penalites_id AS fichier_penalites_id_11 FROM penalite t0 WHERE t0.etr_prod_id = 263 AND t0.mois = '04' AND t0.annee = 2025;

SELECT
  t0.id AS id_1,
  t0.raison_sociale AS raison_sociale_2,
  t0.voie AS voie_3,
  t0.adresse AS adresse_4,
  t0.icon AS icon_5
FROM
  societe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.voie AS voie_3, t0.adresse AS adresse_4, t0.icon AS icon_5 FROM societe t0 WHERE t0.id = 3;