Symfony Profiler

[
  "route" => "app_admin_verifications"
  "route_parameters" => [
    "_route" => "app_admin_verifications"
    "_controller" => "App\Controller\AdminController::verifications"
  ]
  "request_uri" => "https://www.feetfans.fr/admin/verifications"
  "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"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "secret"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.is_verified AS is_verified_6, t0.is_banned AS is_banned_7, t0.welcome_seen AS welcome_seen_8, t0.phone_verified AS phone_verified_9, t0.email_verification_token AS email_verification_token_10, t0.email_verification_token_expires_at AS email_verification_token_expires_at_11, t0.registration_ip AS registration_ip_12, t0.registration_country AS registration_country_13, t0.registration_city AS registration_city_14, t0.registration_region AS registration_region_15, t0.registration_latitude AS registration_latitude_16, t0.registration_longitude AS registration_longitude_17, t0.user_type AS user_type_18, t19.id AS id_20, t19.pseudo AS pseudo_21, t19.first_name AS first_name_22, t19.last_name AS last_name_23, t19.date_of_birth AS date_of_birth_24, t19.phone AS phone_25, t19.profile_picture AS profile_picture_26, t19.gender AS gender_27, t19.country AS country_28, t19.bio AS bio_29, t19.created_at AS created_at_30, t19.user_id AS user_id_31, t32.id AS id_33, t32.pseudo AS pseudo_34, t32.first_name AS first_name_35, t32.last_name AS last_name_36, t32.date_of_birth AS date_of_birth_37, t32.country AS country_38, t32.bio AS bio_39, t32.profile_picture AS profile_picture_40, t32.cover_picture AS cover_picture_41, t32.height AS height_42, t32.weight AS weight_43, t32.shoe_size AS shoe_size_44, t32.has_tattoo AS has_tattoo_45, t32.tattoo_description AS tattoo_description_46, t32.has_piercing AS has_piercing_47, t32.piercing_description AS piercing_description_48, t32.gender AS gender_49, t32.phone AS phone_50, t32.website AS website_51, t32.instagram AS instagram_52, t32.snapchat AS snapchat_53, t32.show_subscribers_count AS show_subscribers_count_54, t32.show_posts_count AS show_posts_count_55, t32.origin AS origin_56, t32.has_pedicure AS has_pedicure_57, t32.sexual_orientation AS sexual_orientation_58, t32.hair_color AS hair_color_59, t32.created_at AS created_at_60, t32.subscription_price AS subscription_price_61, t32.id_document_path AS id_document_path_62, t32.selfie_document_path AS selfie_document_path_63, t32.is_certified AS is_certified_64, t32.auto_message_enabled AS auto_message_enabled_65, t32.auto_message_content AS auto_message_content_66, t32.notif_new_subscriber AS notif_new_subscriber_67, t32.notif_new_message AS notif_new_message_68, t32.notif_new_like AS notif_new_like_69, t32.iban AS iban_70, t32.bic AS bic_71, t32.bank_account_name AS bank_account_name_72, t32.user_id AS user_id_73 FROM `user` t0 LEFT JOIN fan_profile t19 ON t19.user_id = t0.id LEFT JOIN creator_profile t32 ON t32.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1006
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "dorianclerbout@gmail.com"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.status AS status_1, v0_.full_name AS full_name_2, v0_.document_type AS document_type_3, v0_.document_note AS document_note_4, v0_.submitted_at AS submitted_at_5, v0_.reviewed_at AS reviewed_at_6, v0_.admin_note AS admin_note_7, v0_.creator_id AS creator_id_8 FROM verification_request v0_ WHERE v0_.status = ? ORDER BY v0_.submitted_at ASC"
  "params" => [
    1 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1158
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.status AS status_1, v0_.full_name AS full_name_2, v0_.document_type AS document_type_3, v0_.document_note AS document_note_4, v0_.submitted_at AS submitted_at_5, v0_.reviewed_at AS reviewed_at_6, v0_.admin_note AS admin_note_7, v0_.creator_id AS creator_id_8 FROM verification_request v0_ ORDER BY v0_.submitted_at DESC"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.reason AS reason_1, p0_.created_at AS created_at_2, p0_.post_id AS post_id_3, p0_.user_id AS user_id_4 FROM post_report p0_ ORDER BY p0_.created_at DESC LIMIT 999"
]

[
  "sql" => "SELECT COUNT(s0_.id) AS sclr_0 FROM support_ticket s0_ WHERE s0_.status = ?"
  "params" => [
    1 => "open"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1158
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.status AS status_1, v0_.full_name AS full_name_2, v0_.document_type AS document_type_3, v0_.document_note AS document_note_4, v0_.submitted_at AS submitted_at_5, v0_.reviewed_at AS reviewed_at_6, v0_.admin_note AS admin_note_7, v0_.creator_id AS creator_id_8 FROM verification_request v0_ WHERE v0_.status = ? ORDER BY v0_.submitted_at ASC"
  "params" => [
    1 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1158
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.date_of_birth AS date_of_birth_5, t0.country AS country_6, t0.bio AS bio_7, t0.profile_picture AS profile_picture_8, t0.cover_picture AS cover_picture_9, t0.height AS height_10, t0.weight AS weight_11, t0.shoe_size AS shoe_size_12, t0.has_tattoo AS has_tattoo_13, t0.tattoo_description AS tattoo_description_14, t0.has_piercing AS has_piercing_15, t0.piercing_description AS piercing_description_16, t0.gender AS gender_17, t0.phone AS phone_18, t0.website AS website_19, t0.instagram AS instagram_20, t0.snapchat AS snapchat_21, t0.show_subscribers_count AS show_subscribers_count_22, t0.show_posts_count AS show_posts_count_23, t0.origin AS origin_24, t0.has_pedicure AS has_pedicure_25, t0.sexual_orientation AS sexual_orientation_26, t0.hair_color AS hair_color_27, t0.created_at AS created_at_28, t0.subscription_price AS subscription_price_29, t0.id_document_path AS id_document_path_30, t0.selfie_document_path AS selfie_document_path_31, t0.is_certified AS is_certified_32, t0.auto_message_enabled AS auto_message_enabled_33, t0.auto_message_content AS auto_message_content_34, t0.notif_new_subscriber AS notif_new_subscriber_35, t0.notif_new_message AS notif_new_message_36, t0.notif_new_like AS notif_new_like_37, t0.iban AS iban_38, t0.bic AS bic_39, t0.bank_account_name AS bank_account_name_40, t0.user_id AS user_id_41 FROM creator_profile t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1006
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]