Symfony Profiler

SELECT
  p0_.url_alias AS url_alias_0,
  p0_.id AS id_1
FROM
  prestataire p0_
  INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id)
  INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id)
WHERE
  p0_.id = ?
LIMIT
  1

SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = 26 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.is_verified AS is_verified_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.phone AS phone_8,
  t0.address AS address_9,
  t0.gender AS gender_10,
  t0.birth_date AS birth_date_11,
  t0.last_login AS last_login_12,
  t0.login_type AS login_type_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.uuid AS uuid_16,
  t17.id AS id_18,
  t17.name AS name_19,
  t17.description AS description_20,
  t17.created_at AS created_at_21,
  t17.updated_at AS updated_at_22,
  t17.uuid AS uuid_23,
  t17.user_id AS user_id_24,
  t17.profile_image_id AS profile_image_id_25,
  t17.localisation_id AS localisation_id_26,
  t27.id AS id_28,
  t27.name AS name_29,
  t27.description AS description_30,
  t27.qualites AS qualites_31,
  t27.abonnement_status AS abonnement_status_32,
  t27.created_at AS created_at_33,
  t27.updated_at AS updated_at_34,
  t27.url_alias AS url_alias_35,
  t27.auto_generate_alias AS auto_generate_alias_36,
  t27.uuid AS uuid_37,
  t27.approval_status AS approval_status_38,
  t27.approved_at AS approved_at_39,
  t27.status AS status_40,
  t27.user_id AS user_id_41,
  t27.localisation_id AS localisation_id_42,
  t27.profile_image_id AS profile_image_id_43,
  t44.id AS id_45,
  t44.access_token AS access_token_46,
  t44.token_type AS token_type_47,
  t44.expires_in AS expires_in_48,
  t44.scope AS scope_49,
  t44.linkedin_user_id AS linkedin_user_id_50,
  t44.expires_at AS expires_at_51,
  t44.is_active AS is_active_52,
  t44.created_at AS created_at_53,
  t44.updated_at AS updated_at_54,
  t44.user_id AS user_id_55
FROM
  "user" t0
  LEFT JOIN client t17 ON t17.user_id = t0.id
  LEFT JOIN prestataire t27 ON t27.user_id = t0.id
  LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = 38;

SELECT
  a0_.url_alias AS url_alias_0,
  a0_.id AS id_1
FROM
  activity_domain a0_
  INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id)
  INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id)
WHERE
  a0_.id = ?
LIMIT
  1

SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.total_orders AS total_orders_2,
  t0.completed_orders AS completed_orders_3,
  t0.in_progress_orders AS in_progress_orders_4,
  t0.cancel_orders AS cancel_orders_5,
  t0.total_reviews AS total_reviews_6,
  t0.average_rating AS average_rating_7,
  t0.positive_reviews AS positive_reviews_8,
  t0.negative_reviews AS negative_reviews_9,
  t0.average_response_time AS average_response_time_10,
  t0.total_earnings AS total_earnings_11,
  t0.completion_rate AS completion_rate_12,
  t0.last_updated AS last_updated_13,
  t0.uuid AS uuid_14,
  t0.prestataire_id AS prestataire_id_15
FROM
  prestataire_stats t0
WHERE
  t0.prestataire_id = ?

SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = 26;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.original_name AS original_name_3,
  t0.file_size AS file_size_4,
  t0.mime_type AS mime_type_5,
  t0.type AS type_6,
  t0.description AS description_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.user_id AS user_id_10
FROM
  files t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = 11;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.region AS region_2,
  m0_.link AS link_3,
  m0_.weight AS weight_4,
  m0_.created_at AS created_at_5,
  m0_.updated_at AS updated_at_6,
  m0_.uuid AS uuid_7,
  m0_.status AS status_8,
  m0_.user_id AS user_id_9
FROM
  menu_link m0_
WHERE
  m0_.status = ?
  AND m0_.region = ?
ORDER BY
  m0_.id ASC,
  m0_.weight DESC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.region AS region_2, m0_.link AS link_3, m0_.weight AS weight_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.uuid AS uuid_7, m0_.status AS status_8, m0_.user_id AS user_id_9 FROM menu_link m0_ WHERE m0_.status = 1 AND m0_.region = 'header' ORDER BY m0_.id ASC, m0_.weight DESC;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  prestataire p0_
WHERE
  p0_.status = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prestataire p0_ WHERE p0_.status = 1;

SELECT
  a0_.id AS id_0,
  a0_.uuid AS uuid_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_.icon AS icon_4,
  a0_.level AS level_5,
  a0_.url_alias AS url_alias_6,
  a0_.auto_generate_alias AS auto_generate_alias_7,
  a0_.status AS status_8,
  a0_.parent_id AS parent_id_9
FROM
  activity_domain a0_
WHERE
  a0_.status = ?
  AND a0_.parent_id IS NULL
ORDER BY
  a0_.name ASC
LIMIT
  9

SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.name AS name_2, a0_.description AS description_3, a0_.icon AS icon_4, a0_.level AS level_5, a0_.url_alias AS url_alias_6, a0_.auto_generate_alias AS auto_generate_alias_7, a0_.status AS status_8, a0_.parent_id AS parent_id_9 FROM activity_domain a0_ WHERE a0_.status = 1 AND a0_.parent_id IS NULL ORDER BY a0_.name ASC LIMIT 9;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.qualites AS qualites_3,
  p0_.abonnement_status AS abonnement_status_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  p0_.url_alias AS url_alias_7,
  p0_.auto_generate_alias AS auto_generate_alias_8,
  p0_.uuid AS uuid_9,
  p0_.approval_status AS approval_status_10,
  p0_.approved_at AS approved_at_11,
  p0_.status AS status_12,
  p0_.user_id AS user_id_13,
  p0_.localisation_id AS localisation_id_14,
  p0_.profile_image_id AS profile_image_id_15
FROM
  prestataire p0_
WHERE
  p0_.status = ?
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.qualites AS qualites_3, p0_.abonnement_status AS abonnement_status_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.url_alias AS url_alias_7, p0_.auto_generate_alias AS auto_generate_alias_8, p0_.uuid AS uuid_9, p0_.approval_status AS approval_status_10, p0_.approved_at AS approved_at_11, p0_.status AS status_12, p0_.user_id AS user_id_13, p0_.localisation_id AS localisation_id_14, p0_.profile_image_id AS profile_image_id_15 FROM prestataire p0_ WHERE p0_.status = 1 AND p0_.id IN (25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40) ORDER BY p0_.created_at DESC;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created_at AS created_at_1
FROM
  prestataire p0_
WHERE
  p0_.status = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  24
OFFSET
  24

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM prestataire p0_ WHERE p0_.status = 1 ORDER BY p0_.created_at DESC LIMIT 24 OFFSET 24;