Symfony Profiler

[
  "route" => "app_member_profile"
  "route_parameters" => [
    "_route" => "app_member_profile"
    "_controller" => "App\User\Controller\MemberProfileController::show"
    "_locale" => "fr"
    "id" => "01M6KQHKNPWBGRH6JG74HAVZCB"
  ]
  "request_uri" => "https://trouvemoi.eu/membres/01M6KQHKNPWBGRH6JG74HAVZCB"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "loisir"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "admin_plaisir"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SET TIME ZONE 'Europe/Paris'"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1222
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1222
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1222
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1222
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1222
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1222
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1222
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
    2 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
    3 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1222
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1222}
    3 => Doctrine\DBAL\ParameterType {#1222}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1a778-ceb6-e2e1-889a-503922adfd8b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1222
      +name: "STRING"
    }
  ]
]