Symfony Profiler

SET
  TIME ZONE 'Europe/Paris'

SET TIME ZONE 'Europe/Paris';

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.status AS status_7,
  t0.reset_code_hash AS reset_code_hash_8,
  t0.reset_code_expires_at AS reset_code_expires_at_9,
  t0.reset_code_attempts AS reset_code_attempts_10,
  t0.email_verification_code_hash AS email_verification_code_hash_11,
  t0.email_verification_expires_at AS email_verification_expires_at_12,
  t0.email_verification_attempts AS email_verification_attempts_13,
  t0.avatar_path AS avatar_path_14,
  t0.birth_date AS birth_date_15,
  t0.gender AS gender_16,
  t0.preferred_locale AS preferred_locale_17,
  t0.country AS country_18,
  t0.bio AS bio_19,
  t0.city AS city_20,
  t0.interests AS interests_21,
  t0.id AS id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.deleted_at AS deleted_at_25
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.status AS status_7, t0.reset_code_hash AS reset_code_hash_8, t0.reset_code_expires_at AS reset_code_expires_at_9, t0.reset_code_attempts AS reset_code_attempts_10, t0.email_verification_code_hash AS email_verification_code_hash_11, t0.email_verification_expires_at AS email_verification_expires_at_12, t0.email_verification_attempts AS email_verification_attempts_13, t0.avatar_path AS avatar_path_14, t0.birth_date AS birth_date_15, t0.gender AS gender_16, t0.preferred_locale AS preferred_locale_17, t0.country AS country_18, t0.bio AS bio_19, t0.city AS city_20, t0.interests AS interests_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.deleted_at AS deleted_at_25 FROM "user" t0 WHERE t0.id = '01a1a778-ceb6-e2e1-889a-503922adfd8b';

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.scheduled_at AS scheduled_at_3,
  t0.city AS city_4,
  t0.location AS location_5,
  t0.show_exact_address AS show_exact_address_6,
  t0.ends_at AS ends_at_7,
  t0.postal_code AS postal_code_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.meeting_point AS meeting_point_11,
  t0.to_bring AS to_bring_12,
  t0.cover_image AS cover_image_13,
  t0.visibility AS visibility_14,
  t0.participation_mode AS participation_mode_15,
  t0.status AS status_16,
  t0.level AS level_17,
  t0.min_participants AS min_participants_18,
  t0.max_participants AS max_participants_19,
  t0.views_count AS views_count_20,
  t0.id AS id_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.organizer_id AS organizer_id_24,
  t0.category_id AS category_id_25,
  t0.category_suggestion_id AS category_suggestion_id_26,
  t0.service_id AS service_id_27
FROM
  private_activity t0
WHERE
  t0.organizer_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.title AS title_1, t0.description AS description_2, t0.scheduled_at AS scheduled_at_3, t0.city AS city_4, t0.location AS location_5, t0.show_exact_address AS show_exact_address_6, t0.ends_at AS ends_at_7, t0.postal_code AS postal_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.meeting_point AS meeting_point_11, t0.to_bring AS to_bring_12, t0.cover_image AS cover_image_13, t0.visibility AS visibility_14, t0.participation_mode AS participation_mode_15, t0.status AS status_16, t0.level AS level_17, t0.min_participants AS min_participants_18, t0.max_participants AS max_participants_19, t0.views_count AS views_count_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.organizer_id AS organizer_id_24, t0.category_id AS category_id_25, t0.category_suggestion_id AS category_suggestion_id_26, t0.service_id AS service_id_27 FROM private_activity t0 WHERE t0.organizer_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b' ORDER BY t0.created_at DESC;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.private_activity_id AS private_activity_id_5,
  t0.participant_id AS participant_id_6
FROM
  participation t0
WHERE
  t0.participant_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.status AS status_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.private_activity_id AS private_activity_id_5, t0.participant_id AS participant_id_6 FROM participation t0 WHERE t0.participant_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b' ORDER BY t0.created_at DESC;

SELECT
  t0.path AS path_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.album_id AS album_id_5,
  t0.author_id AS author_id_6
FROM
  photo t0
WHERE
  t0.author_id = ?
ORDER BY
  t0.created_at DESC
LIMIT
  40

SELECT t0.path AS path_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.album_id AS album_id_5, t0.author_id AS author_id_6 FROM photo t0 WHERE t0.author_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b' ORDER BY t0.created_at DESC LIMIT 40;

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.scheduled_at AS scheduled_at_3,
  t0.city AS city_4,
  t0.location AS location_5,
  t0.show_exact_address AS show_exact_address_6,
  t0.ends_at AS ends_at_7,
  t0.postal_code AS postal_code_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.meeting_point AS meeting_point_11,
  t0.to_bring AS to_bring_12,
  t0.cover_image AS cover_image_13,
  t0.visibility AS visibility_14,
  t0.participation_mode AS participation_mode_15,
  t0.status AS status_16,
  t0.level AS level_17,
  t0.min_participants AS min_participants_18,
  t0.max_participants AS max_participants_19,
  t0.views_count AS views_count_20,
  t0.id AS id_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.organizer_id AS organizer_id_24,
  t0.category_id AS category_id_25,
  t0.category_suggestion_id AS category_suggestion_id_26,
  t0.service_id AS service_id_27
FROM
  private_activity t0
WHERE
  t0.organizer_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.title AS title_1, t0.description AS description_2, t0.scheduled_at AS scheduled_at_3, t0.city AS city_4, t0.location AS location_5, t0.show_exact_address AS show_exact_address_6, t0.ends_at AS ends_at_7, t0.postal_code AS postal_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.meeting_point AS meeting_point_11, t0.to_bring AS to_bring_12, t0.cover_image AS cover_image_13, t0.visibility AS visibility_14, t0.participation_mode AS participation_mode_15, t0.status AS status_16, t0.level AS level_17, t0.min_participants AS min_participants_18, t0.max_participants AS max_participants_19, t0.views_count AS views_count_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.organizer_id AS organizer_id_24, t0.category_id AS category_id_25, t0.category_suggestion_id AS category_suggestion_id_26, t0.service_id AS service_id_27 FROM private_activity t0 WHERE t0.organizer_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b' ORDER BY t0.created_at DESC;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.private_activity_id AS private_activity_id_5,
  t0.participant_id AS participant_id_6
FROM
  participation t0
WHERE
  t0.participant_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.status AS status_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.private_activity_id AS private_activity_id_5, t0.participant_id AS participant_id_6 FROM participation t0 WHERE t0.participant_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b' ORDER BY t0.created_at DESC;

SELECT
  m0_.rating AS rating_0,
  m0_.conviviality AS conviviality_1,
  m0_.organisation AS organisation_2,
  m0_.punctuality AS punctuality_3,
  m0_.communication AS communication_4,
  m0_.comment AS comment_5,
  m0_.id AS id_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.private_activity_id AS private_activity_id_9,
  m0_.author_id AS author_id_10,
  m0_.organizer_id AS organizer_id_11
FROM
  member_review m0_
WHERE
  m0_.organizer_id = ?
ORDER BY
  m0_.created_at DESC

SELECT m0_.rating AS rating_0, m0_.conviviality AS conviviality_1, m0_.organisation AS organisation_2, m0_.punctuality AS punctuality_3, m0_.communication AS communication_4, m0_.comment AS comment_5, m0_.id AS id_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.private_activity_id AS private_activity_id_9, m0_.author_id AS author_id_10, m0_.organizer_id AS organizer_id_11 FROM member_review m0_ WHERE m0_.organizer_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b' ORDER BY m0_.created_at DESC;

SELECT
  c0_.archived_by_provider AS archived_by_provider_0,
  c0_.id AS id_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  p1_.display_name AS display_name_4,
  p1_.slug AS slug_5,
  p1_.bio AS bio_6,
  p1_.company_name AS company_name_7,
  p1_.city AS city_8,
  p1_.status AS status_9,
  p1_.facebook_url AS facebook_url_10,
  p1_.instagram_url AS instagram_url_11,
  p1_.linkedin_url AS linkedin_url_12,
  p1_.website_url AS website_url_13,
  p1_.address AS address_14,
  p1_.cover_path AS cover_path_15,
  p1_.intervention_zone AS intervention_zone_16,
  p1_.youtube_url AS youtube_url_17,
  p1_.timezone AS timezone_18,
  p1_.availability_label AS availability_label_19,
  p1_.payment_link_url AS payment_link_url_20,
  p1_.payment_paypal AS payment_paypal_21,
  p1_.payment_iban AS payment_iban_22,
  p1_.payment_iban_holder AS payment_iban_holder_23,
  p1_.payment_on_site AS payment_on_site_24,
  p1_.payment_instructions AS payment_instructions_25,
  p1_.online_payment_enabled AS online_payment_enabled_26,
  p1_.accepts_stripe AS accepts_stripe_27,
  p1_.accepts_paypal AS accepts_paypal_28,
  p1_.accepts_cash AS accepts_cash_29,
  p1_.stripe_account_id AS stripe_account_id_30,
  p1_.stripe_charges_enabled AS stripe_charges_enabled_31,
  p1_.paypal_merchant_id AS paypal_merchant_id_32,
  p1_.paypal_tracking_id AS paypal_tracking_id_33,
  p1_.paypal_payments_enabled AS paypal_payments_enabled_34,
  p1_.id AS id_35,
  p1_.created_at AS created_at_36,
  p1_.updated_at AS updated_at_37,
  p1_.deleted_at AS deleted_at_38,
  c0_.client_id AS client_id_39,
  c0_.provider_id AS provider_id_40,
  c0_.member_id AS member_id_41,
  c0_.service_id AS service_id_42,
  p1_.user_id AS user_id_43,
  p1_.main_category_id AS main_category_id_44
FROM
  conversation c0_
  LEFT JOIN provider_profile p1_ ON c0_.provider_id = p1_.id
WHERE
  c0_.client_id = ?
  OR p1_.user_id = ?
  OR c0_.member_id = ?

SELECT c0_.archived_by_provider AS archived_by_provider_0, c0_.id AS id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, p1_.display_name AS display_name_4, p1_.slug AS slug_5, p1_.bio AS bio_6, p1_.company_name AS company_name_7, p1_.city AS city_8, p1_.status AS status_9, p1_.facebook_url AS facebook_url_10, p1_.instagram_url AS instagram_url_11, p1_.linkedin_url AS linkedin_url_12, p1_.website_url AS website_url_13, p1_.address AS address_14, p1_.cover_path AS cover_path_15, p1_.intervention_zone AS intervention_zone_16, p1_.youtube_url AS youtube_url_17, p1_.timezone AS timezone_18, p1_.availability_label AS availability_label_19, p1_.payment_link_url AS payment_link_url_20, p1_.payment_paypal AS payment_paypal_21, p1_.payment_iban AS payment_iban_22, p1_.payment_iban_holder AS payment_iban_holder_23, p1_.payment_on_site AS payment_on_site_24, p1_.payment_instructions AS payment_instructions_25, p1_.online_payment_enabled AS online_payment_enabled_26, p1_.accepts_stripe AS accepts_stripe_27, p1_.accepts_paypal AS accepts_paypal_28, p1_.accepts_cash AS accepts_cash_29, p1_.stripe_account_id AS stripe_account_id_30, p1_.stripe_charges_enabled AS stripe_charges_enabled_31, p1_.paypal_merchant_id AS paypal_merchant_id_32, p1_.paypal_tracking_id AS paypal_tracking_id_33, p1_.paypal_payments_enabled AS paypal_payments_enabled_34, p1_.id AS id_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.deleted_at AS deleted_at_38, c0_.client_id AS client_id_39, c0_.provider_id AS provider_id_40, c0_.member_id AS member_id_41, c0_.service_id AS service_id_42, p1_.user_id AS user_id_43, p1_.main_category_id AS main_category_id_44 FROM conversation c0_ LEFT JOIN provider_profile p1_ ON c0_.provider_id = p1_.id WHERE c0_.client_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b' OR p1_.user_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b' OR c0_.member_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b';

SELECT
  m0_.rating AS rating_0,
  m0_.conviviality AS conviviality_1,
  m0_.organisation AS organisation_2,
  m0_.punctuality AS punctuality_3,
  m0_.communication AS communication_4,
  m0_.comment AS comment_5,
  m0_.id AS id_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.private_activity_id AS private_activity_id_9,
  m0_.author_id AS author_id_10,
  m0_.organizer_id AS organizer_id_11
FROM
  member_review m0_
WHERE
  m0_.organizer_id = ?
ORDER BY
  m0_.created_at DESC
LIMIT
  20

SELECT m0_.rating AS rating_0, m0_.conviviality AS conviviality_1, m0_.organisation AS organisation_2, m0_.punctuality AS punctuality_3, m0_.communication AS communication_4, m0_.comment AS comment_5, m0_.id AS id_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.private_activity_id AS private_activity_id_9, m0_.author_id AS author_id_10, m0_.organizer_id AS organizer_id_11 FROM member_review m0_ WHERE m0_.organizer_id = '01a1a778-ceb6-e2e1-889a-503922adfd8b' ORDER BY m0_.created_at DESC LIMIT 20;