Symfony Profiler

SELECT
  e0_.url AS url_0,
  e0_.entity_id AS entity_id_1,
  e1_.entity_class AS entity_class_2
FROM
  entity_url_alias e0_
  INNER JOIN entity_type_alias e1_ ON e0_.type_alias_id = e1_.id
WHERE
  e0_.url = ?

SELECT e0_.url AS url_0, e0_.entity_id AS entity_id_1, e1_.entity_class AS entity_class_2 FROM entity_url_alias e0_ INNER JOIN entity_type_alias e1_ ON e0_.type_alias_id = e1_.id WHERE e0_.url = 'prestataire/maitre-artisan-des-ouvrages-qualifies';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.prix AS prix_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.prestataire_id AS prestataire_id_14,
  t0.activity_domain_id AS activity_domain_id_15
FROM
  prestation t0
WHERE
  t0.prestataire_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.prix AS prix_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.prestataire_id AS prestataire_id_14, t0.activity_domain_id AS activity_domain_id_15 FROM prestation t0 WHERE t0.prestataire_id = 3;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.comment AS comment_2,
  r0_.response AS response_3,
  r0_.response_at AS response_at_4,
  r0_.approval_status AS approval_status_5,
  r0_.approved_at AS approved_at_6,
  r0_.status AS status_7,
  r0_.created_at AS created_at_8,
  r0_.updated_at AS updated_at_9,
  r0_.service_request_id AS service_request_id_10
FROM
  review r0_
  INNER JOIN service_request s1_ ON r0_.service_request_id = s1_.id
  INNER JOIN prestataire p2_ ON s1_.prestataire_id = p2_.id
WHERE
  p2_.id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.comment AS comment_2, r0_.response AS response_3, r0_.response_at AS response_at_4, r0_.approval_status AS approval_status_5, r0_.approved_at AS approved_at_6, r0_.status AS status_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9, r0_.service_request_id AS service_request_id_10 FROM review r0_ INNER JOIN service_request s1_ ON r0_.service_request_id = s1_.id INNER JOIN prestataire p2_ ON s1_.prestataire_id = p2_.id WHERE p2_.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.osm_id AS osm_id_6,
  t0.code_ivoire AS code_ivoire_7,
  t0.uuid AS uuid_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.url_alias AS url_alias_11,
  t0.auto_generate_alias AS auto_generate_alias_12
FROM
  localisation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.osm_id AS osm_id_6, t0.code_ivoire AS code_ivoire_7, t0.uuid AS uuid_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.url_alias AS url_alias_11, t0.auto_generate_alias AS auto_generate_alias_12 FROM localisation t0 WHERE t0.id = 6;

SELECT
  t0.niveau AS niveau_1,
  t0.parent_id AS parent_id_2,
  t0.child_id AS child_id_3
FROM
  localisation_hierarchie t0
WHERE
  t0.child_id = ?

SELECT t0.niveau AS niveau_1, t0.parent_id AS parent_id_2, t0.child_id AS child_id_3 FROM localisation_hierarchie t0 WHERE t0.child_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.osm_id AS osm_id_6,
  t0.code_ivoire AS code_ivoire_7,
  t0.uuid AS uuid_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.url_alias AS url_alias_11,
  t0.auto_generate_alias AS auto_generate_alias_12
FROM
  localisation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.osm_id AS osm_id_6, t0.code_ivoire AS code_ivoire_7, t0.uuid AS uuid_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.url_alias AS url_alias_11, t0.auto_generate_alias AS auto_generate_alias_12 FROM localisation t0 WHERE t0.id = 3;

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

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

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.level AS level_6,
  t0.url_alias AS url_alias_7,
  t0.auto_generate_alias AS auto_generate_alias_8,
  t0.status AS status_9,
  t0.parent_id AS parent_id_10
FROM
  activity_domain t0
  INNER JOIN prestataire_activity_domain ON t0.id = prestataire_activity_domain.activity_domain_id
WHERE
  prestataire_activity_domain.prestataire_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5, t0.level AS level_6, t0.url_alias AS url_alias_7, t0.auto_generate_alias AS auto_generate_alias_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM activity_domain t0 INNER JOIN prestataire_activity_domain ON t0.id = prestataire_activity_domain.activity_domain_id WHERE prestataire_activity_domain.prestataire_id = 3;

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 = 5 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 = ?
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 = 5 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 = ?
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 = 1 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 = ?
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 = 1 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 = 21 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 = 21 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 = ?