Symfony Profiler

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Controller\DashboardController::index"
  ]
  "request_uri" => "http://www.immybeauty.fr/admin/dashboard"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginAuthenticator"
]

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

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

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

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\RememberMeToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "host" => "85.215.240.39"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => [
      1001 => null
      "innodb_lock_wait_timeout" => 50
    ]
    "serverVersion" => "5.7"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "immybeauty"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.slug AS slug_8, t0.birthdate AS birthdate_9, t10.id AS id_11, t10.qr_code_image AS qr_code_image_12, t10.points AS points_13, t10.apple_wallet_token AS apple_wallet_token_14, t10.apple_wallet_push_token AS apple_wallet_push_token_15, t10.device_library_identifier AS device_library_identifier_16, t10.updated_at AS updated_at_17, t10.last_notification AS last_notification_18, t10.user_id AS user_id_19 FROM user t0 LEFT JOIN card t10 ON t10.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

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

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

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.is_winning AS is_winning_2, t0.is_scratched AS is_scratched_3, t0.created_at AS created_at_4, t0.scratched_at AS scratched_at_5, t0.slug AS slug_6, t0.qr_code_path AS qr_code_path_7, t0.active AS active_8, t0.date_used AS date_used_9, t0.user_id AS user_id_10, t0.offre_id AS offre_id_11 FROM ticket_gratter t0 WHERE t0.user_id = ? AND t0.is_scratched = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\TicketCheckListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT SUM(r0_.total) AS sclr_0 FROM recette r0_ WHERE r0_.date >= ? AND r0_.date <= ?"
  "params" => [
    1 => "2025-01-01 00:00:00"
    2 => "2025-12-31 00:00:00"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT SUM(r0_.total) AS sclr_0 FROM recette r0_ WHERE r0_.date >= ? AND r0_.date <= ?"
  "params" => [
    1 => "2025-04-01 00:00:00"
    2 => "2025-04-30 00:00:00"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(p0_.somme_payee), 0) AS sclr_0 FROM paiement_recette p0_ INNER JOIN recette r1_ ON p0_.recette_id = r1_.id INNER JOIN type_paiement t2_ ON p0_.type_paiement_id = t2_.id WHERE r1_.date >= ? AND r1_.date <= ? AND t2_.nom = ?"
  "params" => [
    1 => "2025-04-01 00:00:00"
    2 => "2025-04-30 00:00:00"
    3 => "Carte Bancaire"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(p0_.somme_payee), 0) AS sclr_0 FROM paiement_recette p0_ INNER JOIN recette r1_ ON p0_.recette_id = r1_.id INNER JOIN type_paiement t2_ ON p0_.type_paiement_id = t2_.id WHERE r1_.date >= ? AND r1_.date <= ? AND t2_.nom = ?"
  "params" => [
    1 => "2025-04-01 00:00:00"
    2 => "2025-04-30 00:00:00"
    3 => "Espèce"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(r0_.acompte), 0) AS sclr_0 FROM recette r0_ WHERE r0_.date >= ? AND r0_.date <= ? AND r0_.acompte > 0"
  "params" => [
    1 => "2025-04-01 00:00:00"
    2 => "2025-04-30 00:00:00"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    \n
                SELECT \n
                    EXTRACT(MONTH FROM date) as mois,\n
                    SUM(total) as total\n
                FROM recette\n
                WHERE EXTRACT(YEAR FROM date) = :year\n
                GROUP BY EXTRACT(MONTH FROM date)\n
                ORDER BY mois ASC\n
            
    """
  "params" => [
    "year" => 2025
  ]
  "types" => []
]

[
  "sql" => """
    \n
            WITH DateActuelle AS (\n
                SELECT \n
                    EXTRACT(YEAR FROM CURRENT_DATE) as annee,\n
                    EXTRACT(MONTH FROM CURRENT_DATE) as mois,\n
                    EXTRACT(DAY FROM CURRENT_DATE) as jour\n
            )\n
            SELECT \n
                COALESCE(SUM(CASE \n
                    WHEN EXTRACT(YEAR FROM date) = d.annee \n
                    AND EXTRACT(MONTH FROM date) = d.mois \n
                    AND EXTRACT(DAY FROM date) <= d.jour\n
                    THEN total END), 0) as mois_actuel,\n
                COALESCE(SUM(CASE \n
                    WHEN EXTRACT(YEAR FROM date) = CASE \n
                        WHEN d.mois = 1 THEN d.annee - 1 \n
                        ELSE d.annee END\n
                    AND EXTRACT(MONTH FROM date) = CASE \n
                        WHEN d.mois = 1 THEN 12 \n
                        ELSE d.mois - 1 END\n
                    AND EXTRACT(DAY FROM date) <= d.jour\n
                    THEN total END), 0) as mois_precedent\n
            FROM recette, DateActuelle d\n
        
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    \n
            SELECT \n
                DAYOFWEEK(date) as jour_semaine,\n
                COUNT(*) as nombre_recettes,\n
                SUM(total) as total_ca,\n
                AVG(total) as moyenne_jour,\n
                COUNT(DISTINCT date) as nombre_jours_ouvres\n
            FROM recette\n
            WHERE EXTRACT(YEAR FROM date) = :year \n
            AND EXTRACT(MONTH FROM date) = :month\n
            GROUP BY DAYOFWEEK(date)\n
            HAVING nombre_recettes > 0\n
            ORDER BY moyenne_jour DESC\n
        
    """
  "params" => [
    "year" => 2025
    "month" => 4
  ]
  "types" => []
]

[
  "sql" => """
    \n
            SELECT \n
                DATE(date) as jour,\n
                COUNT(*) as nombre_recettes,\n
                SUM(total) as total_ca\n
            FROM recette\n
            WHERE EXTRACT(YEAR FROM date) = :year \n
            AND EXTRACT(MONTH FROM date) = :month\n
            GROUP BY DATE(date)\n
            ORDER BY total_ca DESC\n
            LIMIT 1\n
        
    """
  "params" => [
    "year" => 2025
    "month" => 4
  ]
  "types" => []
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.is_winning AS is_winning_2, t0.is_scratched AS is_scratched_3, t0.created_at AS created_at_4, t0.scratched_at AS scratched_at_5, t0.slug AS slug_6, t0.qr_code_path AS qr_code_path_7, t0.active AS active_8, t0.date_used AS date_used_9, t0.user_id AS user_id_10, t0.offre_id AS offre_id_11 FROM ticket_gratter t0 WHERE t0.user_id = ? AND t0.is_scratched = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Flasher\Symfony\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Flasher\Symfony\EventListener\FlasherListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]