Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0_.training_name AS training_name_0, SUM(i1_.effective) AS sclr_1 FROM training t0_ LEFT JOIN intern_training i2_ ON t0_.id = i2_.training_id LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id GROUP BY t0_.id

[]

SELECT
  t0_.training_name AS training_name_0,
  SUM(i1_.effective) AS sclr_1
FROM
  training t0_
  LEFT JOIN intern_training i2_ ON t0_.id = i2_.training_id
  LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id
GROUP BY
  t0_.id

SELECT t0_.training_name AS training_name_0, SUM(i1_.effective) AS sclr_1 FROM training t0_ LEFT JOIN intern_training i2_ ON t0_.id = i2_.training_id LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id GROUP BY t0_.id;

SELECT f0_.origin_of_financing AS origin_of_financing_0, SUM(i1_.effective) AS sclr_1 FROM funding f0_ LEFT JOIN intern_funding i2_ ON f0_.id = i2_.funding_id LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id GROUP BY f0_.id

[]

SELECT
  f0_.origin_of_financing AS origin_of_financing_0,
  SUM(i1_.effective) AS sclr_1
FROM
  funding f0_
  LEFT JOIN intern_funding i2_ ON f0_.id = i2_.funding_id
  LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id
GROUP BY
  f0_.id

SELECT f0_.origin_of_financing AS origin_of_financing_0, SUM(i1_.effective) AS sclr_1 FROM funding f0_ LEFT JOIN intern_funding i2_ ON f0_.id = i2_.funding_id LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id GROUP BY f0_.id;

SELECT l0_.education_level AS education_level_0, SUM(i1_.effective) AS sclr_1 FROM levels_education l0_ LEFT JOIN intern i1_ ON l0_.id = i1_.education_level_id GROUP BY l0_.id

[]

SELECT
  l0_.education_level AS education_level_0,
  SUM(i1_.effective) AS sclr_1
FROM
  levels_education l0_
  LEFT JOIN intern i1_ ON l0_.id = i1_.education_level_id
GROUP BY
  l0_.id

SELECT l0_.education_level AS education_level_0, SUM(i1_.effective) AS sclr_1 FROM levels_education l0_ LEFT JOIN intern i1_ ON l0_.id = i1_.education_level_id GROUP BY l0_.id;

SELECT p0_.qualification AS qualification_0, SUM(i1_.effective) AS sclr_1 FROM professional_qualification p0_ LEFT JOIN intern_professional_qualification i2_ ON p0_.id = i2_.professional_qualification_id LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id GROUP BY p0_.id

[]

SELECT
  p0_.qualification AS qualification_0,
  SUM(i1_.effective) AS sclr_1
FROM
  professional_qualification p0_
  LEFT JOIN intern_professional_qualification i2_ ON p0_.id = i2_.professional_qualification_id
  LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id
GROUP BY
  p0_.id

SELECT p0_.qualification AS qualification_0, SUM(i1_.effective) AS sclr_1 FROM professional_qualification p0_ LEFT JOIN intern_professional_qualification i2_ ON p0_.id = i2_.professional_qualification_id LEFT JOIN intern i1_ ON i1_.id = i2_.intern_id GROUP BY p0_.id;

SELECT t0.id AS id_1, t0.name AS name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.city AS city_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.mail AS mail_8, t0.family_situation AS family_situation_9, t0.last_employed AS last_employed_10, t0.seniority AS seniority_11, t0.sector_of_employment AS sector_of_employment_12, t0.mission AS mission_13, t0.strong_point_skill AS strong_point_skill_14, t0.other_job_held AS other_job_held_15, t0.cost_of_training AS cost_of_training_16, t0.commentary AS commentary_17, t0.created_at AS created_at_18, t0.effective AS effective_19, t0.time_formation AS time_formation_20, t0.last_degree AS last_degree_21, t0.type_of_intern AS type_of_intern_22, t0.general_objectif_of_the_services AS general_objectif_of_the_services_23, t0.contracted_activity_of_the_organization AS contracted_activity_of_the_organization_24, t0.started_at AS started_at_25, t0.level_certification AS level_certification_26, t0.education_level_id AS education_level_id_27, t0.training_site_id AS training_site_id_28 FROM intern t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.first_name AS first_name_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.zip_code AS zip_code_6,
  t0.phone AS phone_7,
  t0.mail AS mail_8,
  t0.family_situation AS family_situation_9,
  t0.last_employed AS last_employed_10,
  t0.seniority AS seniority_11,
  t0.sector_of_employment AS sector_of_employment_12,
  t0.mission AS mission_13,
  t0.strong_point_skill AS strong_point_skill_14,
  t0.other_job_held AS other_job_held_15,
  t0.cost_of_training AS cost_of_training_16,
  t0.commentary AS commentary_17,
  t0.created_at AS created_at_18,
  t0.effective AS effective_19,
  t0.time_formation AS time_formation_20,
  t0.last_degree AS last_degree_21,
  t0.type_of_intern AS type_of_intern_22,
  t0.general_objectif_of_the_services AS general_objectif_of_the_services_23,
  t0.contracted_activity_of_the_organization AS contracted_activity_of_the_organization_24,
  t0.started_at AS started_at_25,
  t0.level_certification AS level_certification_26,
  t0.education_level_id AS education_level_id_27,
  t0.training_site_id AS training_site_id_28
FROM
  intern t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.city AS city_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.mail AS mail_8, t0.family_situation AS family_situation_9, t0.last_employed AS last_employed_10, t0.seniority AS seniority_11, t0.sector_of_employment AS sector_of_employment_12, t0.mission AS mission_13, t0.strong_point_skill AS strong_point_skill_14, t0.other_job_held AS other_job_held_15, t0.cost_of_training AS cost_of_training_16, t0.commentary AS commentary_17, t0.created_at AS created_at_18, t0.effective AS effective_19, t0.time_formation AS time_formation_20, t0.last_degree AS last_degree_21, t0.type_of_intern AS type_of_intern_22, t0.general_objectif_of_the_services AS general_objectif_of_the_services_23, t0.contracted_activity_of_the_organization AS contracted_activity_of_the_organization_24, t0.started_at AS started_at_25, t0.level_certification AS level_certification_26, t0.education_level_id AS education_level_id_27, t0.training_site_id AS training_site_id_28 FROM intern t0;

SELECT t0.id AS id_1, t0.turnover_of_month AS turnover_of_month_2, t0.current_turnover AS current_turnover_3, t0.turnover_year_nminus_one AS turnover_year_nminus_one_4, t0.average_year AS average_year_5, t0.achievment_nminus_one_percentage AS achievment_nminus_one_percentage_6 FROM economic_balance_sheet t0

[]

SELECT
  t0.id AS id_1,
  t0.turnover_of_month AS turnover_of_month_2,
  t0.current_turnover AS current_turnover_3,
  t0.turnover_year_nminus_one AS turnover_year_nminus_one_4,
  t0.average_year AS average_year_5,
  t0.achievment_nminus_one_percentage AS achievment_nminus_one_percentage_6
FROM
  economic_balance_sheet t0

SELECT t0.id AS id_1, t0.turnover_of_month AS turnover_of_month_2, t0.current_turnover AS current_turnover_3, t0.turnover_year_nminus_one AS turnover_year_nminus_one_4, t0.average_year AS average_year_5, t0.achievment_nminus_one_percentage AS achievment_nminus_one_percentage_6 FROM economic_balance_sheet t0;