Symfony Profiler

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
WHERE
  t0.slug = ?
LIMIT
  1

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 WHERE t0.slug = '13-thomas' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.firstname AS firstname_1,
  t0_.lastname AS lastname_2,
  t0_.email AS email_3,
  t0_.comment AS comment_4,
  t0_.first_question_rating AS first_question_rating_5,
  t0_.second_question_rating AS second_question_rating_6,
  t0_.third_question_rating AS third_question_rating_7,
  t0_.rating AS rating_8,
  t0_.status AS status_9,
  t0_.created_at AS created_at_10,
  t0_.trainer_id AS trainer_id_11
FROM
  trainer_review t0_
WHERE
  t0_.trainer_id = ?
  AND t0_.status = ?
ORDER BY
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.firstname AS firstname_1, t0_.lastname AS lastname_2, t0_.email AS email_3, t0_.comment AS comment_4, t0_.first_question_rating AS first_question_rating_5, t0_.second_question_rating AS second_question_rating_6, t0_.third_question_rating AS third_question_rating_7, t0_.rating AS rating_8, t0_.status AS status_9, t0_.created_at AS created_at_10, t0_.trainer_id AS trainer_id_11 FROM trainer_review t0_ WHERE t0_.trainer_id = 13 AND t0_.status = 'APPROVED' ORDER BY t0_.created_at DESC;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  trainer_review t0_
WHERE
  t0_.trainer_id = ?
  AND t0_.status = ?

SELECT COUNT(t0_.id) AS sclr_0 FROM trainer_review t0_ WHERE t0_.trainer_id = 13 AND t0_.status = 'APPROVED';

SELECT
  AVG(t0_.rating) AS sclr_0
FROM
  trainer_review t0_
WHERE
  t0_.trainer_id = ?
  AND t0_.status = ?

SELECT AVG(t0_.rating) AS sclr_0 FROM trainer_review t0_ WHERE t0_.trainer_id = 13 AND t0_.status = 'APPROVED';

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.comment AS comment_5,
  t0.first_question_rating AS first_question_rating_6,
  t0.second_question_rating AS second_question_rating_7,
  t0.third_question_rating AS third_question_rating_8,
  t0.rating AS rating_9,
  t0.status AS status_10,
  t0.created_at AS created_at_11,
  t0.trainer_id AS trainer_id_12
FROM
  trainer_review t0
WHERE
  t0.trainer_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.comment AS comment_5, t0.first_question_rating AS first_question_rating_6, t0.second_question_rating AS second_question_rating_7, t0.third_question_rating AS third_question_rating_8, t0.rating AS rating_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.trainer_id AS trainer_id_12 FROM trainer_review t0 WHERE t0.trainer_id = 13;

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.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.sub_title AS sub_title_18,
  t0.show_on_home_page AS show_on_home_page_19,
  t0.format AS format_20,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_21,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_22,
  t0.individual_videoconference_hours AS individual_videoconference_hours_23,
  t0.collective_videoconference_hours AS collective_videoconference_hours_24,
  t0.elearning_hours AS elearning_hours_25,
  t0.face_to_face_hours_text AS face_to_face_hours_text_26,
  t0.min_period AS min_period_27,
  t0.max_period AS max_period_28,
  t0.public AS public_29,
  t0.prerequisites AS prerequisites_30,
  t0.cpf AS cpf_31,
  t0.cpf_link AS cpf_link_32,
  t0.pdf_name AS pdf_name_33,
  t0.pdf_mime_type AS pdf_mime_type_34,
  t0.created_by_id AS created_by_id_35,
  t0.category_id AS category_id_36,
  t0.certification_id AS certification_id_37,
  t0.type
FROM
  training t0
  INNER JOIN training_trainer ON t0.id = training_trainer.training_id
WHERE
  training_trainer.trainer_id = ?
  AND t0.type IN ('professional')

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.sub_title AS sub_title_18, t0.show_on_home_page AS show_on_home_page_19, t0.format AS format_20, t0.collective_face_to_face_hours AS collective_face_to_face_hours_21, t0.individual_face_to_face_hours AS individual_face_to_face_hours_22, t0.individual_videoconference_hours AS individual_videoconference_hours_23, t0.collective_videoconference_hours AS collective_videoconference_hours_24, t0.elearning_hours AS elearning_hours_25, t0.face_to_face_hours_text AS face_to_face_hours_text_26, t0.min_period AS min_period_27, t0.max_period AS max_period_28, t0.public AS public_29, t0.prerequisites AS prerequisites_30, t0.cpf AS cpf_31, t0.cpf_link AS cpf_link_32, t0.pdf_name AS pdf_name_33, t0.pdf_mime_type AS pdf_mime_type_34, t0.created_by_id AS created_by_id_35, t0.category_id AS category_id_36, t0.certification_id AS certification_id_37, t0.type FROM training t0 INNER JOIN training_trainer ON t0.id = training_trainer.training_id WHERE training_trainer.trainer_id = 13 AND t0.type IN ('professional');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.training_category_id AS training_category_id_3
FROM
  trainer_skill t0
  INNER JOIN trainer_trainer_skill ON t0.id = trainer_trainer_skill.trainer_skill_id
WHERE
  trainer_trainer_skill.trainer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.training_category_id AS training_category_id_3 FROM trainer_skill t0 INNER JOIN trainer_trainer_skill ON t0.id = trainer_trainer_skill.trainer_skill_id WHERE trainer_trainer_skill.trainer_id = 13;

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
  INNER JOIN trainer_training_category ON t0.id = trainer_training_category.training_category_id
WHERE
  trainer_training_category.trainer_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 INNER JOIN trainer_training_category ON t0.id = trainer_training_category.training_category_id WHERE trainer_training_category.trainer_id = 13;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.start AS start_4,
  t0.end AS end_5,
  t0.trainer_id AS trainer_id_6
FROM
  trainer_experience t0
WHERE
  t0.trainer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.start AS start_4, t0.end AS end_5, t0.trainer_id AS trainer_id_6 FROM trainer_experience t0 WHERE t0.trainer_id = 13;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.institution AS institution_3,
  t0.year AS year_4,
  t0.trainer_id AS trainer_id_5
FROM
  trainer_diploma t0
WHERE
  t0.trainer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.institution AS institution_3, t0.year AS year_4, t0.trainer_id AS trainer_id_5 FROM trainer_diploma t0 WHERE t0.trainer_id = 13;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.address AS address_3,
  t0.zip_code AS zip_code_4,
  t0.city AS city_5,
  t0.image_name AS image_name_6,
  t0.updated_at AS updated_at_7,
  t0.phone_number AS phone_number_8,
  t0.information AS information_9,
  t0.amenities AS amenities_10,
  t0.google_map_link AS google_map_link_11
FROM
  place t0
  INNER JOIN trainer_place ON t0.id = trainer_place.place_id
WHERE
  trainer_place.trainer_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.information AS information_9, t0.amenities AS amenities_10, t0.google_map_link AS google_map_link_11 FROM place t0 INNER JOIN trainer_place ON t0.id = trainer_place.place_id WHERE trainer_place.trainer_id = 13;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.place_id AS place_id_4
FROM
  place_picture t0
WHERE
  t0.place_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.place_id AS place_id_4 FROM place_picture t0 WHERE t0.place_id = 3;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.place_id AS place_id_4
FROM
  place_picture t0
WHERE
  t0.place_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.place_id AS place_id_4 FROM place_picture t0 WHERE t0.place_id = 6;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.place_id AS place_id_4
FROM
  place_picture t0
WHERE
  t0.place_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.place_id AS place_id_4 FROM place_picture t0 WHERE t0.place_id = 10;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.place_id AS place_id_4
FROM
  place_picture t0
WHERE
  t0.place_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.place_id AS place_id_4 FROM place_picture t0 WHERE t0.place_id = 40;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.place_id AS place_id_4
FROM
  place_picture t0
WHERE
  t0.place_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.place_id AS place_id_4 FROM place_picture t0 WHERE t0.place_id = 44;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.place_id AS place_id_4
FROM
  place_picture t0
WHERE
  t0.place_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.place_id AS place_id_4 FROM place_picture t0 WHERE t0.place_id = 46;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.place_id AS place_id_4
FROM
  place_picture t0
WHERE
  t0.place_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.place_id AS place_id_4 FROM place_picture t0 WHERE t0.place_id = 51;