Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.banner AS banner_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.type AS type_8, t0.description AS description_9, t0.siret AS siret_10, t0.email AS email_11, t0.phone AS phone_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.address AS address_16, t0.complement AS complement_17, t0.city AS city_18, t0.zipcode AS zipcode_19, t0.short_description AS short_description_20, t0.website AS website_21, t0.instagram AS instagram_22, t0.facebook AS facebook_23, t0.linkedin AS linkedin_24, t0.rna_id AS rna_id_25, t0.founded_at AS founded_at_26, t0.signatory_name AS signatory_name_27, t0.signatory_job_title AS signatory_job_title_28, t0.category_id AS category_id_29 FROM association t0 WHERE t0.is_active = ? ORDER BY t0.name ASC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.logo AS logo_4,
  t0.banner AS banner_5,
  t0.primary_color AS primary_color_6,
  t0.secondary_color AS secondary_color_7,
  t0.type AS type_8,
  t0.description AS description_9,
  t0.siret AS siret_10,
  t0.email AS email_11,
  t0.phone AS phone_12,
  t0.is_active AS is_active_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.address AS address_16,
  t0.complement AS complement_17,
  t0.city AS city_18,
  t0.zipcode AS zipcode_19,
  t0.short_description AS short_description_20,
  t0.website AS website_21,
  t0.instagram AS instagram_22,
  t0.facebook AS facebook_23,
  t0.linkedin AS linkedin_24,
  t0.rna_id AS rna_id_25,
  t0.founded_at AS founded_at_26,
  t0.signatory_name AS signatory_name_27,
  t0.signatory_job_title AS signatory_job_title_28,
  t0.category_id AS category_id_29
FROM
  association t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.banner AS banner_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.type AS type_8, t0.description AS description_9, t0.siret AS siret_10, t0.email AS email_11, t0.phone AS phone_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.address AS address_16, t0.complement AS complement_17, t0.city AS city_18, t0.zipcode AS zipcode_19, t0.short_description AS short_description_20, t0.website AS website_21, t0.instagram AS instagram_22, t0.facebook AS facebook_23, t0.linkedin AS linkedin_24, t0.rna_id AS rna_id_25, t0.founded_at AS founded_at_26, t0.signatory_name AS signatory_name_27, t0.signatory_job_title AS signatory_job_title_28, t0.category_id AS category_id_29 FROM association t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

SELECT AVG(m0_.score) AS sclr_0, COUNT(m0_.id) AS sclr_1 FROM mission_rating m0_ INNER JOIN recruitment_request r1_ ON m0_.recruitment_request_id = r1_.id INNER JOIN announcement a2_ ON r1_.announcement_id = a2_.id INNER JOIN recruite_event r3_ ON a2_.event_id = r3_.id WHERE r3_.association_id = ? AND m0_.author_type = ?

[
  1
  "volunteer"
]

SELECT
  AVG(m0_.score) AS sclr_0,
  COUNT(m0_.id) AS sclr_1
FROM
  mission_rating m0_
  INNER JOIN recruitment_request r1_ ON m0_.recruitment_request_id = r1_.id
  INNER JOIN announcement a2_ ON r1_.announcement_id = a2_.id
  INNER JOIN recruite_event r3_ ON a2_.event_id = r3_.id
WHERE
  r3_.association_id = ?
  AND m0_.author_type = ?

SELECT AVG(m0_.score) AS sclr_0, COUNT(m0_.id) AS sclr_1 FROM mission_rating m0_ INNER JOIN recruitment_request r1_ ON m0_.recruitment_request_id = r1_.id INNER JOIN announcement a2_ ON r1_.announcement_id = a2_.id INNER JOIN recruite_event r3_ ON a2_.event_id = r3_.id WHERE r3_.association_id = 1 AND m0_.author_type = 'volunteer';

SELECT t0.id AS id_1, t0.name AS name_2 FROM association_category t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  association_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM association_category t0 WHERE t0.id = 1;

SELECT AVG(m0_.score) AS sclr_0, COUNT(m0_.id) AS sclr_1 FROM mission_rating m0_ INNER JOIN recruitment_request r1_ ON m0_.recruitment_request_id = r1_.id INNER JOIN announcement a2_ ON r1_.announcement_id = a2_.id INNER JOIN recruite_event r3_ ON a2_.event_id = r3_.id WHERE r3_.association_id = ? AND m0_.author_type = ?

[
  5
  "volunteer"
]

SELECT
  AVG(m0_.score) AS sclr_0,
  COUNT(m0_.id) AS sclr_1
FROM
  mission_rating m0_
  INNER JOIN recruitment_request r1_ ON m0_.recruitment_request_id = r1_.id
  INNER JOIN announcement a2_ ON r1_.announcement_id = a2_.id
  INNER JOIN recruite_event r3_ ON a2_.event_id = r3_.id
WHERE
  r3_.association_id = ?
  AND m0_.author_type = ?

SELECT AVG(m0_.score) AS sclr_0, COUNT(m0_.id) AS sclr_1 FROM mission_rating m0_ INNER JOIN recruitment_request r1_ ON m0_.recruitment_request_id = r1_.id INNER JOIN announcement a2_ ON r1_.announcement_id = a2_.id INNER JOIN recruite_event r3_ ON a2_.event_id = r3_.id WHERE r3_.association_id = 5 AND m0_.author_type = 'volunteer';

SELECT AVG(m0_.score) AS sclr_0, COUNT(m0_.id) AS sclr_1 FROM mission_rating m0_ INNER JOIN recruitment_request r1_ ON m0_.recruitment_request_id = r1_.id INNER JOIN announcement a2_ ON r1_.announcement_id = a2_.id INNER JOIN recruite_event r3_ ON a2_.event_id = r3_.id WHERE r3_.association_id = ? AND m0_.author_type = ?

[
  11
  "volunteer"
]

SELECT
  AVG(m0_.score) AS sclr_0,
  COUNT(m0_.id) AS sclr_1
FROM
  mission_rating m0_
  INNER JOIN recruitment_request r1_ ON m0_.recruitment_request_id = r1_.id
  INNER JOIN announcement a2_ ON r1_.announcement_id = a2_.id
  INNER JOIN recruite_event r3_ ON a2_.event_id = r3_.id
WHERE
  r3_.association_id = ?
  AND m0_.author_type = ?

SELECT AVG(m0_.score) AS sclr_0, COUNT(m0_.id) AS sclr_1 FROM mission_rating m0_ INNER JOIN recruitment_request r1_ ON m0_.recruitment_request_id = r1_.id INNER JOIN announcement a2_ ON r1_.announcement_id = a2_.id INNER JOIN recruite_event r3_ ON a2_.event_id = r3_.id WHERE r3_.association_id = 11 AND m0_.author_type = 'volunteer';