Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Migrations
• Debug
• Emails
• Notifications
• VichUploader
• EasyAdmin
• Configuration

Query Metrics

SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.tempsalloue AS tempsalloue_3, r1_.id AS id_4, r1_.daterv AS daterv_5, r1_.com AS com_6, r1_.duree AS duree_7, r1_.address AS address_8, r1_.cp AS cp_9, r1_.town AS town_10, r1_.libre AS libre_11, r1_.tempseffectif AS tempseffectif_12, r1_.datevoulueclientde AS datevoulueclientde_13, r1_.datevoulueclienta AS datevoulueclienta_14, r1_.precisionsvouluesclient AS precisionsvouluesclient_15, r1_.dispos AS dispos_16, r1_.tempsfacture AS tempsfacture_17, r1_.statusrv AS statusrv_18, r1_.label AS label_19, r1_.gps AS gps_20, r1_.drive AS drive_21, r1_.nb_intervenants AS nb_intervenants_22, r1_.nb_intervenants_mandatory AS nb_intervenants_mandatory_23, r1_.datervfin AS datervfin_24, r1_.allday AS allday_25, r1_.sum_rafs AS sum_rafs_26, r1_.date_validated_with_client AS date_validated_with_client_27, r1_.modified_by_solver AS modified_by_solver_28, r1_.date_proposed_to_client AS date_proposed_to_client_29, r1_.updated_at AS updated_at_30, r1_.created_at AS created_at_31, t2_.nom AS nom_32, t2_.id AS id_33, t2_.created_at AS created_at_34, t2_.updated_at AS updated_at_35, u3_.id AS id_36, u3_.email AS email_37, u3_.roles AS roles_38, u3_.password AS password_39, u3_.username AS username_40, u3_.color AS color_41, u3_.tel AS tel_42, u3_.status AS status_43, u3_.ref_tech AS ref_tech_44, u3_.updated_at AS updated_at_45, u3_.created_at AS created_at_46, c0_.chantier_id AS chantier_id_47, c0_.user_id AS user_id_48, r1_.chantier_id AS chantier_id_49, r1_.lieu_id AS lieu_id_50, r1_.typeintervention_id AS typeintervention_id_51, r1_.control_id AS control_id_52, r1_.access_ask_id AS access_ask_id_53, r1_.criticity_id AS criticity_id_54, r1_.meteo_id AS meteo_id_55, r1_.parking_id AS parking_id_56, r1_.last_user_modified_id AS last_user_modified_id_57, u3_.typeuser_id AS typeuser_id_58 FROM chantier_raf c0_ INNER JOIN chantier c4_ ON c0_.chantier_id = c4_.id LEFT JOIN chantier_raf_rvintervention c5_ ON c0_.id = c5_.chantier_raf_id LEFT JOIN rvintervention r1_ ON r1_.id = c5_.rvintervention_id LEFT JOIN typeintervention t2_ ON r1_.typeintervention_id = t2_.id INNER JOIN user u3_ ON c0_.user_id = u3_.id WHERE c0_.id IN (SELECT c6_.id FROM chantier_raf c6_ INNER JOIN chantier c7_ ON c6_.chantier_id = c7_.id WHERE c7_.id = ?) ORDER BY c0_.id ASC

[
  "7260"
]

SELECT
  c0_.id AS id_0,
  c0_.status AS status_1,
  c0_.content AS content_2,
  c0_.tempsalloue AS tempsalloue_3,
  r1_.id AS id_4,
  r1_.daterv AS daterv_5,
  r1_.com AS com_6,
  r1_.duree AS duree_7,
  r1_.address AS address_8,
  r1_.cp AS cp_9,
  r1_.town AS town_10,
  r1_.libre AS libre_11,
  r1_.tempseffectif AS tempseffectif_12,
  r1_.datevoulueclientde AS datevoulueclientde_13,
  r1_.datevoulueclienta AS datevoulueclienta_14,
  r1_.precisionsvouluesclient AS precisionsvouluesclient_15,
  r1_.dispos AS dispos_16,
  r1_.tempsfacture AS tempsfacture_17,
  r1_.statusrv AS statusrv_18,
  r1_.label AS label_19,
  r1_.gps AS gps_20,
  r1_.drive AS drive_21,
  r1_.nb_intervenants AS nb_intervenants_22,
  r1_.nb_intervenants_mandatory AS nb_intervenants_mandatory_23,
  r1_.datervfin AS datervfin_24,
  r1_.allday AS allday_25,
  r1_.sum_rafs AS sum_rafs_26,
  r1_.date_validated_with_client AS date_validated_with_client_27,
  r1_.modified_by_solver AS modified_by_solver_28,
  r1_.date_proposed_to_client AS date_proposed_to_client_29,
  r1_.updated_at AS updated_at_30,
  r1_.created_at AS created_at_31,
  t2_.nom AS nom_32,
  t2_.id AS id_33,
  t2_.created_at AS created_at_34,
  t2_.updated_at AS updated_at_35,
  u3_.id AS id_36,
  u3_.email AS email_37,
  u3_.roles AS roles_38,
  u3_.password AS password_39,
  u3_.username AS username_40,
  u3_.color AS color_41,
  u3_.tel AS tel_42,
  u3_.status AS status_43,
  u3_.ref_tech AS ref_tech_44,
  u3_.updated_at AS updated_at_45,
  u3_.created_at AS created_at_46,
  c0_.chantier_id AS chantier_id_47,
  c0_.user_id AS user_id_48,
  r1_.chantier_id AS chantier_id_49,
  r1_.lieu_id AS lieu_id_50,
  r1_.typeintervention_id AS typeintervention_id_51,
  r1_.control_id AS control_id_52,
  r1_.access_ask_id AS access_ask_id_53,
  r1_.criticity_id AS criticity_id_54,
  r1_.meteo_id AS meteo_id_55,
  r1_.parking_id AS parking_id_56,
  r1_.last_user_modified_id AS last_user_modified_id_57,
  u3_.typeuser_id AS typeuser_id_58
FROM
  chantier_raf c0_
  INNER JOIN chantier c4_ ON c0_.chantier_id = c4_.id
  LEFT JOIN chantier_raf_rvintervention c5_ ON c0_.id = c5_.chantier_raf_id
  LEFT JOIN rvintervention r1_ ON r1_.id = c5_.rvintervention_id
  LEFT JOIN typeintervention t2_ ON r1_.typeintervention_id = t2_.id
  INNER JOIN user u3_ ON c0_.user_id = u3_.id
WHERE
  c0_.id IN (
    SELECT
      c6_.id
    FROM
      chantier_raf c6_
      INNER JOIN chantier c7_ ON c6_.chantier_id = c7_.id
    WHERE
      c7_.id = ?
  )
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.tempsalloue AS tempsalloue_3, r1_.id AS id_4, r1_.daterv AS daterv_5, r1_.com AS com_6, r1_.duree AS duree_7, r1_.address AS address_8, r1_.cp AS cp_9, r1_.town AS town_10, r1_.libre AS libre_11, r1_.tempseffectif AS tempseffectif_12, r1_.datevoulueclientde AS datevoulueclientde_13, r1_.datevoulueclienta AS datevoulueclienta_14, r1_.precisionsvouluesclient AS precisionsvouluesclient_15, r1_.dispos AS dispos_16, r1_.tempsfacture AS tempsfacture_17, r1_.statusrv AS statusrv_18, r1_.label AS label_19, r1_.gps AS gps_20, r1_.drive AS drive_21, r1_.nb_intervenants AS nb_intervenants_22, r1_.nb_intervenants_mandatory AS nb_intervenants_mandatory_23, r1_.datervfin AS datervfin_24, r1_.allday AS allday_25, r1_.sum_rafs AS sum_rafs_26, r1_.date_validated_with_client AS date_validated_with_client_27, r1_.modified_by_solver AS modified_by_solver_28, r1_.date_proposed_to_client AS date_proposed_to_client_29, r1_.updated_at AS updated_at_30, r1_.created_at AS created_at_31, t2_.nom AS nom_32, t2_.id AS id_33, t2_.created_at AS created_at_34, t2_.updated_at AS updated_at_35, u3_.id AS id_36, u3_.email AS email_37, u3_.roles AS roles_38, u3_.password AS password_39, u3_.username AS username_40, u3_.color AS color_41, u3_.tel AS tel_42, u3_.status AS status_43, u3_.ref_tech AS ref_tech_44, u3_.updated_at AS updated_at_45, u3_.created_at AS created_at_46, c0_.chantier_id AS chantier_id_47, c0_.user_id AS user_id_48, r1_.chantier_id AS chantier_id_49, r1_.lieu_id AS lieu_id_50, r1_.typeintervention_id AS typeintervention_id_51, r1_.control_id AS control_id_52, r1_.access_ask_id AS access_ask_id_53, r1_.criticity_id AS criticity_id_54, r1_.meteo_id AS meteo_id_55, r1_.parking_id AS parking_id_56, r1_.last_user_modified_id AS last_user_modified_id_57, u3_.typeuser_id AS typeuser_id_58 FROM chantier_raf c0_ INNER JOIN chantier c4_ ON c0_.chantier_id = c4_.id LEFT JOIN chantier_raf_rvintervention c5_ ON c0_.id = c5_.chantier_raf_id LEFT JOIN rvintervention r1_ ON r1_.id = c5_.rvintervention_id LEFT JOIN typeintervention t2_ ON r1_.typeintervention_id = t2_.id INNER JOIN user u3_ ON c0_.user_id = u3_.id WHERE c0_.id IN (SELECT c6_.id FROM chantier_raf c6_ INNER JOIN chantier c7_ ON c6_.chantier_id = c7_.id WHERE c7_.id = '7260') ORDER BY c0_.id ASC;