Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.slug AS slug_17, t0.level AS level_18, t0.language AS language_19, t0.hours AS hours_20, t0.additional_students AS additional_students_21, t0.listing_image_name AS listing_image_name_22, t0.show_image_name AS show_image_name_23, t0.created_by_id AS created_by_id_24, t0.category_id AS category_id_25, t0.type FROM training t0 WHERE t0.slug = ? AND t0.type IN ('elearning') LIMIT 1

[
  "eerefef"
]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.code AS code_3,
  t0.slug_history AS slug_history_4,
  t0.description AS description_5,
  t0.price AS price_6,
  t0.status AS status_7,
  t0.satisfaction_rate AS satisfaction_rate_8,
  t0.completion_rate AS completion_rate_9,
  t0.featured_on_search AS featured_on_search_10,
  t0.pixels AS pixels_11,
  t0.updated_at AS updated_at_12,
  t0.seo_title AS seo_title_13,
  t0.seo_description AS seo_description_14,
  t0.seo_canonical AS seo_canonical_15,
  t0.seo_indexed AS seo_indexed_16,
  t0.slug AS slug_17,
  t0.level AS level_18,
  t0.language AS language_19,
  t0.hours AS hours_20,
  t0.additional_students AS additional_students_21,
  t0.listing_image_name AS listing_image_name_22,
  t0.show_image_name AS show_image_name_23,
  t0.created_by_id AS created_by_id_24,
  t0.category_id AS category_id_25,
  t0.type
FROM
  training t0
WHERE
  t0.slug = ?
  AND t0.type IN ('elearning')
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.slug AS slug_17, t0.level AS level_18, t0.language AS language_19, t0.hours AS hours_20, t0.additional_students AS additional_students_21, t0.listing_image_name AS listing_image_name_22, t0.show_image_name AS show_image_name_23, t0.created_by_id AS created_by_id_24, t0.category_id AS category_id_25, t0.type FROM training t0 WHERE t0.slug = 'eerefef' AND t0.type IN ('elearning') LIMIT 1;

SELECT f.id, f.question, f.answer, f.category_id, c.label AS category_label
                FROM faq f
                LEFT JOIN faqcategory c ON f.category_id = c.id
                WHERE (f.training_id = ? OR f.training_id IS NULL)
                AND (
                    c.type IS NULL -- For specific questions not linked to a category
                    OR c.type = ? 
                    OR c.type = ?
                )
                ORDER BY c.id, f.question

[
  384
  "BOTH"
  "E_LEARNING"
]

SELECT
  f.id,
  f.question,
  f.answer,
  f.category_id,
  c.label AS category_label
FROM
  faq f
  LEFT JOIN faqcategory c ON f.category_id = c.id
WHERE
  (
    f.training_id = ?
    OR f.training_id IS NULL
  )
  AND (
    c.type IS NULL -- For specific questions not linked to a category
    OR c.type = ?
    OR c.type = ?
  )
ORDER BY
  c.id,
  f.question

SELECT f.id, f.question, f.answer, f.category_id, c.label AS category_label
                FROM faq f
                LEFT JOIN faqcategory c ON f.category_id = c.id
                WHERE (f.training_id = 384 OR f.training_id IS NULL)
                AND (
                    c.type IS NULL -- For specific questions not linked to a category
                    OR c.type = 'BOTH' 
                    OR c.type = 'E_LEARNING'
                )
                ORDER BY c.id, f.question;

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enable AS enable_4,
  t0.updated_at AS updated_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_canonical AS seo_canonical_8,
  t0.seo_indexed AS seo_indexed_9
FROM
  cms_page t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.total_trainings AS total_trainings_5
FROM
  training_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.slug AS slug_4, t0.description AS description_5, t0.certifications AS certifications_6, t0.status AS status_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.available AS available_10, t0.nda_status AS nda_status_11, t0.joined_at AS joined_at_12, t0.is_senza_trainer AS is_senza_trainer_13, t0.data_gouv_link AS data_gouv_link_14, t0.level AS level_15, t0.languages AS languages_16, t0.total_trainings AS total_trainings_17, t0.quality_chart_signed AS quality_chart_signed_18, t0.senza_training_validated AS senza_training_validated_19, t0.expert AS expert_20, t0.siret AS siret_21, t0.nda_number AS nda_number_22, t0.email_hash AS email_hash_23, t0.user_id AS user_id_24 FROM trainer t0 INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id WHERE training_trainer.training_id = ?

[
  384
]

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.certifications AS certifications_6,
  t0.status AS status_7,
  t0.image_name AS image_name_8,
  t0.updated_at AS updated_at_9,
  t0.available AS available_10,
  t0.nda_status AS nda_status_11,
  t0.joined_at AS joined_at_12,
  t0.is_senza_trainer AS is_senza_trainer_13,
  t0.data_gouv_link AS data_gouv_link_14,
  t0.level AS level_15,
  t0.languages AS languages_16,
  t0.total_trainings AS total_trainings_17,
  t0.quality_chart_signed AS quality_chart_signed_18,
  t0.senza_training_validated AS senza_training_validated_19,
  t0.expert AS expert_20,
  t0.siret AS siret_21,
  t0.nda_number AS nda_number_22,
  t0.email_hash AS email_hash_23,
  t0.user_id AS user_id_24
FROM
  trainer t0
  INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id
WHERE
  training_trainer.training_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.slug AS slug_4, t0.description AS description_5, t0.certifications AS certifications_6, t0.status AS status_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.available AS available_10, t0.nda_status AS nda_status_11, t0.joined_at AS joined_at_12, t0.is_senza_trainer AS is_senza_trainer_13, t0.data_gouv_link AS data_gouv_link_14, t0.level AS level_15, t0.languages AS languages_16, t0.total_trainings AS total_trainings_17, t0.quality_chart_signed AS quality_chart_signed_18, t0.senza_training_validated AS senza_training_validated_19, t0.expert AS expert_20, t0.siret AS siret_21, t0.nda_number AS nda_number_22, t0.email_hash AS email_hash_23, t0.user_id AS user_id_24 FROM trainer t0 INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id WHERE training_trainer.training_id = 384;

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.training_elearning_id AS training_elearning_id_4 FROM elearning_module t0 WHERE t0.training_elearning_id = ? ORDER BY t0.position ASC

[
  384
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.position AS position_3,
  t0.training_elearning_id AS training_elearning_id_4
FROM
  elearning_module t0
WHERE
  t0.training_elearning_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.training_elearning_id AS training_elearning_id_4 FROM elearning_module t0 WHERE t0.training_elearning_id = 384 ORDER BY t0.position ASC;

SELECT t0.id AS id_1, t0.label AS label_2, t0.training_id AS training_id_3 FROM training_objective t0 WHERE t0.training_id = ?

[
  384
]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.training_id AS training_id_3
FROM
  training_objective t0
WHERE
  t0.training_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.training_id AS training_id_3 FROM training_objective t0 WHERE t0.training_id = 384;