Symfony Profiler

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

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

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

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

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.prix AS prix_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_.prestataire_id AS prestataire_id_13,
  p0_.activity_domain_id AS activity_domain_id_14
FROM
  prestation 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_.prix AS prix_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_.prestataire_id AS prestataire_id_13, p0_.activity_domain_id AS activity_domain_id_14 FROM prestation p0_ WHERE p0_.status = 1 AND p0_.id IN (29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 20, 21, 22, 23, 24, 25, 12, 13, 14, 15, 16, 17) ORDER BY p0_.created_at 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 = ?
  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
  p0_.url_alias AS url_alias_0,
  p0_.id AS id_1
FROM
  prestation 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 prestation 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 = 40 LIMIT 1;

SELECT
  p0_.url_alias AS url_alias_0,
  p0_.id AS id_1
FROM
  prestation 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 prestation 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 = 40 LIMIT 1;

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
  INNER JOIN prestation_files ON t0.id = prestation_files.files_id
WHERE
  prestation_files.image_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 INNER JOIN prestation_files ON t0.id = prestation_files.files_id WHERE prestation_files.image_id = 40;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.qualites AS qualites_4,
  t0.abonnement_status AS abonnement_status_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.url_alias AS url_alias_8,
  t0.auto_generate_alias AS auto_generate_alias_9,
  t0.uuid AS uuid_10,
  t0.approval_status AS approval_status_11,
  t0.approved_at AS approved_at_12,
  t0.status AS status_13,
  t0.user_id AS user_id_14,
  t0.localisation_id AS localisation_id_15,
  t0.profile_image_id AS profile_image_id_16,
  t17.id AS id_18,
  t17.total_orders AS total_orders_19,
  t17.completed_orders AS completed_orders_20,
  t17.in_progress_orders AS in_progress_orders_21,
  t17.cancel_orders AS cancel_orders_22,
  t17.total_reviews AS total_reviews_23,
  t17.average_rating AS average_rating_24,
  t17.positive_reviews AS positive_reviews_25,
  t17.negative_reviews AS negative_reviews_26,
  t17.average_response_time AS average_response_time_27,
  t17.total_earnings AS total_earnings_28,
  t17.completion_rate AS completion_rate_29,
  t17.last_updated AS last_updated_30,
  t17.uuid AS uuid_31,
  t17.prestataire_id AS prestataire_id_32
FROM
  prestataire t0
  LEFT JOIN prestataire_stats t17 ON t17.prestataire_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.qualites AS qualites_4, t0.abonnement_status AS abonnement_status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.url_alias AS url_alias_8, t0.auto_generate_alias AS auto_generate_alias_9, t0.uuid AS uuid_10, t0.approval_status AS approval_status_11, t0.approved_at AS approved_at_12, t0.status AS status_13, t0.user_id AS user_id_14, t0.localisation_id AS localisation_id_15, t0.profile_image_id AS profile_image_id_16, t17.id AS id_18, t17.total_orders AS total_orders_19, t17.completed_orders AS completed_orders_20, t17.in_progress_orders AS in_progress_orders_21, t17.cancel_orders AS cancel_orders_22, t17.total_reviews AS total_reviews_23, t17.average_rating AS average_rating_24, t17.positive_reviews AS positive_reviews_25, t17.negative_reviews AS negative_reviews_26, t17.average_response_time AS average_response_time_27, t17.total_earnings AS total_earnings_28, t17.completion_rate AS completion_rate_29, t17.last_updated AS last_updated_30, t17.uuid AS uuid_31, t17.prestataire_id AS prestataire_id_32 FROM prestataire t0 LEFT JOIN prestataire_stats t17 ON t17.prestataire_id = t0.id WHERE t0.id = 4;

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 = 2;

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 = 16;

SELECT
  p0_.url_alias AS url_alias_0,
  p0_.id AS id_1
FROM
  prestation 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 prestation 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 = 29 LIMIT 1;

SELECT
  p0_.url_alias AS url_alias_0,
  p0_.id AS id_1
FROM
  prestation 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 prestation 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 = 29 LIMIT 1;

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
  INNER JOIN prestation_files ON t0.id = prestation_files.files_id
WHERE
  prestation_files.image_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 INNER JOIN prestation_files ON t0.id = prestation_files.files_id WHERE prestation_files.image_id = 29;

SELECT
  p0_.url_alias AS url_alias_0,
  p0_.id AS id_1
FROM
  prestation 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 prestation 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 = 31 LIMIT 1;

SELECT
  p0_.url_alias AS url_alias_0,
  p0_.id AS id_1
FROM
  prestation 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 prestation 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 = 31 LIMIT 1;