Symfony Profiler

[
  "route" => "app_admin_dashboard"
  "route_parameters" => [
    "_route" => "app_admin_dashboard"
    "_controller" => "App\Controller\AdminController::dashboard"
  ]
  "request_uri" => "https://feetfans.fr/admin"
  "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.user_type AS user_type_15, t16.id AS id_17, t16.pseudo AS pseudo_18, t16.first_name AS first_name_19, t16.last_name AS last_name_20, t16.date_of_birth AS date_of_birth_21, t16.phone AS phone_22, t16.profile_picture AS profile_picture_23, t16.gender AS gender_24, t16.country AS country_25, t16.bio AS bio_26, t16.created_at AS created_at_27, t16.user_id AS user_id_28, t29.id AS id_30, t29.pseudo AS pseudo_31, t29.first_name AS first_name_32, t29.last_name AS last_name_33, t29.date_of_birth AS date_of_birth_34, t29.country AS country_35, t29.bio AS bio_36, t29.profile_picture AS profile_picture_37, t29.cover_picture AS cover_picture_38, t29.height AS height_39, t29.weight AS weight_40, t29.shoe_size AS shoe_size_41, t29.has_tattoo AS has_tattoo_42, t29.tattoo_description AS tattoo_description_43, t29.has_piercing AS has_piercing_44, t29.piercing_description AS piercing_description_45, t29.gender AS gender_46, t29.phone AS phone_47, t29.website AS website_48, t29.instagram AS instagram_49, t29.snapchat AS snapchat_50, t29.show_subscribers_count AS show_subscribers_count_51, t29.show_posts_count AS show_posts_count_52, t29.origin AS origin_53, t29.has_pedicure AS has_pedicure_54, t29.sexual_orientation AS sexual_orientation_55, t29.hair_color AS hair_color_56, t29.created_at AS created_at_57, t29.subscription_price AS subscription_price_58, t29.id_document_path AS id_document_path_59, t29.selfie_document_path AS selfie_document_path_60, t29.is_certified AS is_certified_61, t29.auto_message_enabled AS auto_message_enabled_62, t29.auto_message_content AS auto_message_content_63, t29.notif_new_subscriber AS notif_new_subscriber_64, t29.notif_new_message AS notif_new_message_65, t29.notif_new_like AS notif_new_like_66, t29.iban AS iban_67, t29.bic AS bic_68, t29.bank_account_name AS bank_account_name_69, t29.user_id AS user_id_70 FROM `user` t0 LEFT JOIN fan_profile t16 ON t16.user_id = t0.id LEFT JOIN creator_profile t29 ON t29.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
  ]
]

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

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

[
  "sql" => """
    SELECT DATE(created_at) AS day, COUNT(id) AS cnt\n
                 FROM `user`\n
                 WHERE created_at >= ?\n
                 GROUP BY day\n
                 ORDER BY day ASC
    """
  "params" => [
    1 => "2026-03-28 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.created_at AS created_at_0, c0_.gross_amount AS gross_amount_1 FROM creator_earning c0_ WHERE c0_.created_at >= ? ORDER BY c0_.created_at ASC"
  "params" => [
    1 => "2025-05-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.user_type = ?"
  "params" => [
    1 => "fan"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.user_type = ?"
  "params" => [
    1 => "creator"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.post_id AS post_id_4, t0.user_id AS user_id_5 FROM post_report t0"
]

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

[
  "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 5"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.email AS email_2, s0_.subject AS subject_3, s0_.message AS message_4, s0_.status AS status_5, s0_.admin_note AS admin_note_6, s0_.created_at AS created_at_7, s0_.closed_at AS closed_at_8, s0_.user_id AS user_id_9 FROM support_ticket s0_ ORDER BY s0_.created_at DESC LIMIT 5"
]

[
  "sql" => "SELECT COALESCE(SUM(c0_.gross_amount), 0) AS sclr_0 FROM creator_earning c0_"
]

[
  "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 {#1082
      +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 {#1082
      +name: "STRING"
    }
  ]
]

[
  "key" => "_security_main"
]