Symfony Profiler

SELECT
  COUNT(DISTINCT u.id) AS total
FROM
  user u
  INNER JOIN user_user_role r ON u.id = r.user_id
  AND r.user_role_id = ?
WHERE
  u.status = 1

SELECT COUNT(DISTINCT u.id) AS total FROM user u INNER JOIN user_user_role r ON u.id = r.user_id AND r.user_role_id = 4 WHERE u.status = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  region t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.speciality_parent_id AS speciality_parent_id_3
FROM
  speciality t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.speciality_parent_id AS speciality_parent_id_3 FROM speciality t0;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.logo AS logo_2
FROM
  partenaire_logo p0_
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.logo AS logo_2 FROM partenaire_logo p0_ ORDER BY p0_.id DESC;

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.status AS status_2,
  r0_.started_at AS started_at_3,
  r0_.show_end_at AS show_end_at_4,
  r0_.end_at AS end_at_5,
  r0_.last_sent_at AS last_sent_at_6,
  r0_.request_type AS request_type_7,
  r0_.remuneration AS remuneration_8,
  r0_.comment AS comment_9,
  r0_.position_count AS position_count_10,
  r0_.accomodation_included AS accomodation_included_11,
  r0_.transport_cost_refunded AS transport_cost_refunded_12,
  r0_.retrocession AS retrocession_13,
  r0_.replacement_type AS replacement_type_14,
  r0_.created_at AS created_at_15,
  r0_.response_count AS response_count_16,
  r0_.applicant_id AS applicant_id_17,
  r0_.region_id AS region_id_18,
  r0_.speciality_id AS speciality_id_19
FROM
  request r0_
  LEFT JOIN speciality s1_ ON r0_.speciality_id = s1_.id
  LEFT JOIN user u2_ ON r0_.applicant_id = u2_.id
WHERE
  r0_.status = ?
  AND r0_.request_type = ?
ORDER BY
  r0_.created_at DESC
LIMIT
  4

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.status AS status_2, r0_.started_at AS started_at_3, r0_.show_end_at AS show_end_at_4, r0_.end_at AS end_at_5, r0_.last_sent_at AS last_sent_at_6, r0_.request_type AS request_type_7, r0_.remuneration AS remuneration_8, r0_.comment AS comment_9, r0_.position_count AS position_count_10, r0_.accomodation_included AS accomodation_included_11, r0_.transport_cost_refunded AS transport_cost_refunded_12, r0_.retrocession AS retrocession_13, r0_.replacement_type AS replacement_type_14, r0_.created_at AS created_at_15, r0_.response_count AS response_count_16, r0_.applicant_id AS applicant_id_17, r0_.region_id AS region_id_18, r0_.speciality_id AS speciality_id_19 FROM request r0_ LEFT JOIN speciality s1_ ON r0_.speciality_id = s1_.id LEFT JOIN user u2_ ON r0_.applicant_id = u2_.id WHERE r0_.status = 1 AND r0_.request_type = 'replacement' ORDER BY r0_.created_at DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.ordinary_number AS ordinary_number_2,
  t0.civility AS civility_3,
  t0.surname AS surname_4,
  t0.name AS name_5,
  t0.year_of_birth AS year_of_birth_6,
  t0.nationality AS nationality_7,
  t0.email AS email_8,
  t0.password AS password_9,
  t0.status AS status_10,
  t0.telephone AS telephone_11,
  t0.telephone2 AS telephone2_12,
  t0.fax AS fax_13,
  t0.position AS position_14,
  t0.organism AS organism_15,
  t0.year_of_alternance AS year_of_alternance_16,
  t0.current_speciality AS current_speciality_17,
  t0.comment AS comment_18,
  t0.create_at AS create_at_19,
  t0.user_comment AS user_comment_20,
  t0.cv AS cv_21,
  t0.diplom AS diplom_22,
  t0.licence AS licence_23,
  t0.address_id AS address_id_24,
  t0.speciality_id AS speciality_id_25,
  t0.establishment_id AS establishment_id_26,
  t0.subscription_id AS subscription_id_27
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ordinary_number AS ordinary_number_2, t0.civility AS civility_3, t0.surname AS surname_4, t0.name AS name_5, t0.year_of_birth AS year_of_birth_6, t0.nationality AS nationality_7, t0.email AS email_8, t0.password AS password_9, t0.status AS status_10, t0.telephone AS telephone_11, t0.telephone2 AS telephone2_12, t0.fax AS fax_13, t0.position AS position_14, t0.organism AS organism_15, t0.year_of_alternance AS year_of_alternance_16, t0.current_speciality AS current_speciality_17, t0.comment AS comment_18, t0.create_at AS create_at_19, t0.user_comment AS user_comment_20, t0.cv AS cv_21, t0.diplom AS diplom_22, t0.licence AS licence_23, t0.address_id AS address_id_24, t0.speciality_id AS speciality_id_25, t0.establishment_id AS establishment_id_26, t0.subscription_id AS subscription_id_27 FROM user t0 WHERE t0.id = 70237;

SELECT
  t0.id AS id_1,
  t0.role AS role_2
FROM
  user_role t0
  INNER JOIN user_user_role ON t0.id = user_user_role.user_role_id
WHERE
  user_user_role.user_id = ?

SELECT t0.id AS id_1, t0.role AS role_2 FROM user_role t0 INNER JOIN user_user_role ON t0.id = user_user_role.user_role_id WHERE user_user_role.user_id = 70237;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.beds_count AS beds_count_3,
  t0.site_web AS site_web_4,
  t0.consultation_count AS consultation_count_5,
  t0.per AS per_6,
  t0.service_name AS service_name_7,
  t0.chief_service_name AS chief_service_name_8
FROM
  user_establishment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.beds_count AS beds_count_3, t0.site_web AS site_web_4, t0.consultation_count AS consultation_count_5, t0.per AS per_6, t0.service_name AS service_name_7, t0.chief_service_name AS chief_service_name_8 FROM user_establishment t0 WHERE t0.id = 70231;

SELECT
  t0.id AS id_1,
  t0.ordinary_number AS ordinary_number_2,
  t0.civility AS civility_3,
  t0.surname AS surname_4,
  t0.name AS name_5,
  t0.year_of_birth AS year_of_birth_6,
  t0.nationality AS nationality_7,
  t0.email AS email_8,
  t0.password AS password_9,
  t0.status AS status_10,
  t0.telephone AS telephone_11,
  t0.telephone2 AS telephone2_12,
  t0.fax AS fax_13,
  t0.position AS position_14,
  t0.organism AS organism_15,
  t0.year_of_alternance AS year_of_alternance_16,
  t0.current_speciality AS current_speciality_17,
  t0.comment AS comment_18,
  t0.create_at AS create_at_19,
  t0.user_comment AS user_comment_20,
  t0.cv AS cv_21,
  t0.diplom AS diplom_22,
  t0.licence AS licence_23,
  t0.address_id AS address_id_24,
  t0.speciality_id AS speciality_id_25,
  t0.establishment_id AS establishment_id_26,
  t0.subscription_id AS subscription_id_27
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ordinary_number AS ordinary_number_2, t0.civility AS civility_3, t0.surname AS surname_4, t0.name AS name_5, t0.year_of_birth AS year_of_birth_6, t0.nationality AS nationality_7, t0.email AS email_8, t0.password AS password_9, t0.status AS status_10, t0.telephone AS telephone_11, t0.telephone2 AS telephone2_12, t0.fax AS fax_13, t0.position AS position_14, t0.organism AS organism_15, t0.year_of_alternance AS year_of_alternance_16, t0.current_speciality AS current_speciality_17, t0.comment AS comment_18, t0.create_at AS create_at_19, t0.user_comment AS user_comment_20, t0.cv AS cv_21, t0.diplom AS diplom_22, t0.licence AS licence_23, t0.address_id AS address_id_24, t0.speciality_id AS speciality_id_25, t0.establishment_id AS establishment_id_26, t0.subscription_id AS subscription_id_27 FROM user t0 WHERE t0.id = 6922;

SELECT
  t0.id AS id_1,
  t0.role AS role_2
FROM
  user_role t0
  INNER JOIN user_user_role ON t0.id = user_user_role.user_role_id
WHERE
  user_user_role.user_id = ?

SELECT t0.id AS id_1, t0.role AS role_2 FROM user_role t0 INNER JOIN user_user_role ON t0.id = user_user_role.user_role_id WHERE user_user_role.user_id = 6922;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.beds_count AS beds_count_3,
  t0.site_web AS site_web_4,
  t0.consultation_count AS consultation_count_5,
  t0.per AS per_6,
  t0.service_name AS service_name_7,
  t0.chief_service_name AS chief_service_name_8
FROM
  user_establishment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.beds_count AS beds_count_3, t0.site_web AS site_web_4, t0.consultation_count AS consultation_count_5, t0.per AS per_6, t0.service_name AS service_name_7, t0.chief_service_name AS chief_service_name_8 FROM user_establishment t0 WHERE t0.id = 6922;

SELECT
  t0.id AS id_1,
  t0.ordinary_number AS ordinary_number_2,
  t0.civility AS civility_3,
  t0.surname AS surname_4,
  t0.name AS name_5,
  t0.year_of_birth AS year_of_birth_6,
  t0.nationality AS nationality_7,
  t0.email AS email_8,
  t0.password AS password_9,
  t0.status AS status_10,
  t0.telephone AS telephone_11,
  t0.telephone2 AS telephone2_12,
  t0.fax AS fax_13,
  t0.position AS position_14,
  t0.organism AS organism_15,
  t0.year_of_alternance AS year_of_alternance_16,
  t0.current_speciality AS current_speciality_17,
  t0.comment AS comment_18,
  t0.create_at AS create_at_19,
  t0.user_comment AS user_comment_20,
  t0.cv AS cv_21,
  t0.diplom AS diplom_22,
  t0.licence AS licence_23,
  t0.address_id AS address_id_24,
  t0.speciality_id AS speciality_id_25,
  t0.establishment_id AS establishment_id_26,
  t0.subscription_id AS subscription_id_27
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ordinary_number AS ordinary_number_2, t0.civility AS civility_3, t0.surname AS surname_4, t0.name AS name_5, t0.year_of_birth AS year_of_birth_6, t0.nationality AS nationality_7, t0.email AS email_8, t0.password AS password_9, t0.status AS status_10, t0.telephone AS telephone_11, t0.telephone2 AS telephone2_12, t0.fax AS fax_13, t0.position AS position_14, t0.organism AS organism_15, t0.year_of_alternance AS year_of_alternance_16, t0.current_speciality AS current_speciality_17, t0.comment AS comment_18, t0.create_at AS create_at_19, t0.user_comment AS user_comment_20, t0.cv AS cv_21, t0.diplom AS diplom_22, t0.licence AS licence_23, t0.address_id AS address_id_24, t0.speciality_id AS speciality_id_25, t0.establishment_id AS establishment_id_26, t0.subscription_id AS subscription_id_27 FROM user t0 WHERE t0.id = 64951;

SELECT
  t0.id AS id_1,
  t0.role AS role_2
FROM
  user_role t0
  INNER JOIN user_user_role ON t0.id = user_user_role.user_role_id
WHERE
  user_user_role.user_id = ?

SELECT t0.id AS id_1, t0.role AS role_2 FROM user_role t0 INNER JOIN user_user_role ON t0.id = user_user_role.user_role_id WHERE user_user_role.user_id = 64951;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.beds_count AS beds_count_3,
  t0.site_web AS site_web_4,
  t0.consultation_count AS consultation_count_5,
  t0.per AS per_6,
  t0.service_name AS service_name_7,
  t0.chief_service_name AS chief_service_name_8
FROM
  user_establishment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.beds_count AS beds_count_3, t0.site_web AS site_web_4, t0.consultation_count AS consultation_count_5, t0.per AS per_6, t0.service_name AS service_name_7, t0.chief_service_name AS chief_service_name_8 FROM user_establishment t0 WHERE t0.id = 64951;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.speciality_name AS speciality_name_2,
  e0_.clinic_name AS clinic_name_3,
  e0_.body AS body_4
FROM
  evidence e0_
ORDER BY
  e0_.id DESC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.speciality_name AS speciality_name_2, e0_.clinic_name AS clinic_name_3, e0_.body AS body_4 FROM evidence e0_ ORDER BY e0_.id DESC;

SELECT
  u0_.id AS id_0,
  u0_.ordinary_number AS ordinary_number_1,
  u0_.civility AS civility_2,
  u0_.surname AS surname_3,
  u0_.name AS name_4,
  u0_.year_of_birth AS year_of_birth_5,
  u0_.nationality AS nationality_6,
  u0_.email AS email_7,
  u0_.password AS password_8,
  u0_.status AS status_9,
  u0_.telephone AS telephone_10,
  u0_.telephone2 AS telephone2_11,
  u0_.fax AS fax_12,
  u0_.position AS position_13,
  u0_.organism AS organism_14,
  u0_.year_of_alternance AS year_of_alternance_15,
  u0_.current_speciality AS current_speciality_16,
  u0_.comment AS comment_17,
  u0_.create_at AS create_at_18,
  u0_.user_comment AS user_comment_19,
  u0_.cv AS cv_20,
  u0_.diplom AS diplom_21,
  u0_.licence AS licence_22,
  u0_.address_id AS address_id_23,
  u0_.speciality_id AS speciality_id_24,
  u0_.establishment_id AS establishment_id_25,
  u0_.subscription_id AS subscription_id_26
FROM
  user u0_
  INNER JOIN speciality s1_ ON u0_.speciality_id = s1_.id
  INNER JOIN user_user_role u3_ ON u0_.id = u3_.user_id
  INNER JOIN user_role u2_ ON u2_.id = u3_.user_role_id
  AND (u2_.id = ?)
WHERE
  u0_.status = ?
ORDER BY
  u0_.create_at DESC
LIMIT
  7

SELECT u0_.id AS id_0, u0_.ordinary_number AS ordinary_number_1, u0_.civility AS civility_2, u0_.surname AS surname_3, u0_.name AS name_4, u0_.year_of_birth AS year_of_birth_5, u0_.nationality AS nationality_6, u0_.email AS email_7, u0_.password AS password_8, u0_.status AS status_9, u0_.telephone AS telephone_10, u0_.telephone2 AS telephone2_11, u0_.fax AS fax_12, u0_.position AS position_13, u0_.organism AS organism_14, u0_.year_of_alternance AS year_of_alternance_15, u0_.current_speciality AS current_speciality_16, u0_.comment AS comment_17, u0_.create_at AS create_at_18, u0_.user_comment AS user_comment_19, u0_.cv AS cv_20, u0_.diplom AS diplom_21, u0_.licence AS licence_22, u0_.address_id AS address_id_23, u0_.speciality_id AS speciality_id_24, u0_.establishment_id AS establishment_id_25, u0_.subscription_id AS subscription_id_26 FROM user u0_ INNER JOIN speciality s1_ ON u0_.speciality_id = s1_.id INNER JOIN user_user_role u3_ ON u0_.id = u3_.user_id INNER JOIN user_role u2_ ON u2_.id = u3_.user_role_id AND (u2_.id = 4) WHERE u0_.status = 1 ORDER BY u0_.create_at DESC LIMIT 7;