Symfony Profiler

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

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

[
  "sql" => "SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?"
  "params" => [
    1 => "maintenance_mode"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?"
  "params" => [
    1 => "maintenance_resume_at"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "route" => "billing-customer-detail"
  "route_parameters" => [
    "_route" => "billing-customer-detail"
    "_controller" => "App\Controller\AdminPlatform\BillingController::enseigneDetail"
    "id" => "64"
  ]
  "request_uri" => "https://magmaerp-n2a.myn2a.online/admin/billing/enseigne/64"
  "method" => "GET"
]

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

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

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

[
  "sql" => "SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.type_compte AS type_compte_9, t0.created_at AS created_at_10, t0.last_login_at AS last_login_at_11, t0.bpay_account AS bpay_account_12, t0.business_pay_account AS business_pay_account_13, t0.care_concept_account AS care_concept_account_14, t0.cashline_account AS cashline_account_15 FROM users t0 WHERE t0.uuid = ?"
  "params" => [
    1 => "6a3d3a8b-05d5-45f4-a790-0eaa2ef0523d"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "superadmin@magmaerp.online"
]

[
  "sql" => "SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.type_compte AS type_compte_9, t0.created_at AS created_at_10, t0.last_login_at AS last_login_at_11, t0.bpay_account AS bpay_account_12, t0.business_pay_account AS business_pay_account_13, t0.care_concept_account AS care_concept_account_14, t0.cashline_account AS cashline_account_15 FROM users t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "superadmin@magmaerp.online"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#926
    -user: App\Entity\Users {#938 …}
    -roleNames: [
      "ROLE_SUPER_ADMIN"
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "main"
  }
  "authenticator" => "App\Security\MagmaAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\SessionStrategyListener::onSuccessfulLogin"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "authenticator" => "App\Security\MagmaAuthenticator"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::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" => "App\EventSubscriber\MaintenanceSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\AccessCacheWarmerSubscriber::warmupCache"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\UserActivitySubscriber::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" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\AccessTrackingSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\UsageTrackingSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

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

[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\PrivilegeSubscriber::onController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container7kdEfI6\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.enseigne_id AS enseigne_id_2, t0.enseigne_nom AS enseigne_nom_3, t0.code_enseigne AS code_enseigne_4, t0.last_business_sync_at AS last_business_sync_at_5, t0.formule_nom AS formule_nom_6, t0.active AS active_7, t0.billing_mode AS billing_mode_8, t0.premium_users_limit AS premium_users_limit_9, t0.max_collaborateurs AS max_collaborateurs_10, t0.total_connexion_minutes AS total_connexion_minutes_11, t0.usage_billing_enabled AS usage_billing_enabled_12, t0.temporary_start_at AS temporary_start_at_13, t0.temporary_end_at AS temporary_end_at_14, t0.hours_purchased AS hours_purchased_15, t0.days_purchased AS days_purchased_16, t0.custom_price AS custom_price_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.subscribed_at AS subscribed_at_20, t0.last_renewal_at AS last_renewal_at_21, t0.next_renewal_at AS next_renewal_at_22, t0.auto_renew AS auto_renew_23, t0.renewal_attempts AS renewal_attempts_24, t0.grace_period_end_at AS grace_period_end_at_25, t0.suspended_at AS suspended_at_26, t0.suspension_reason AS suspension_reason_27, t0.cancelled_at AS cancelled_at_28, t0.enseigne_id AS enseigne_id_29, t0.formule_id AS formule_id_30, t0.billing_plan_id AS billing_plan_id_31 FROM formule_enseigne t0 WHERE t0.id = ?"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.enseigne_id AS enseigne_id_1, b0_.enseigne_label AS enseigne_label_2, b0_.enseigne_code AS enseigne_code_3, b0_.user_uuid AS user_uuid_4, b0_.user_email AS user_email_5, b0_.user_full_name AS user_full_name_6, b0_.module_id AS module_id_7, b0_.module_label AS module_label_8, b0_.section_id AS section_id_9, b0_.section_label AS section_label_10, b0_.privilege_id AS privilege_id_11, b0_.privilege_label AS privilege_label_12, b0_.billing_type AS billing_type_13, b0_.unit_price AS unit_price_14, b0_.quantity AS quantity_15, b0_.total_price AS total_price_16, b0_.currency AS currency_17, b0_.billing_status AS billing_status_18, b0_.billing_date AS billing_date_19, b0_.route AS route_20, b0_.ip AS ip_21, b0_.context AS context_22, b0_.created_at AS created_at_23 FROM billing_usage b0_ WHERE b0_.enseigne_id = ? AND b0_.billing_date >= ? AND b0_.billing_date < ? ORDER BY b0_.billing_date DESC"
  "params" => [
    1 => 33
    2 => "2026-09-12"
    3 => "2026-09-13"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.enseigne_id AS enseigne_id_1, b0_.enseigne_label AS enseigne_label_2, b0_.enseigne_code AS enseigne_code_3, b0_.user_uuid AS user_uuid_4, b0_.user_email AS user_email_5, b0_.user_full_name AS user_full_name_6, b0_.module_id AS module_id_7, b0_.module_label AS module_label_8, b0_.section_id AS section_id_9, b0_.section_label AS section_label_10, b0_.privilege_id AS privilege_id_11, b0_.privilege_label AS privilege_label_12, b0_.billing_type AS billing_type_13, b0_.unit_price AS unit_price_14, b0_.quantity AS quantity_15, b0_.total_price AS total_price_16, b0_.currency AS currency_17, b0_.billing_status AS billing_status_18, b0_.billing_date AS billing_date_19, b0_.route AS route_20, b0_.ip AS ip_21, b0_.context AS context_22, b0_.created_at AS created_at_23 FROM billing_usage b0_ WHERE b0_.enseigne_id = ? AND b0_.billing_date >= ? AND b0_.billing_date < ? ORDER BY b0_.billing_date DESC"
  "params" => [
    1 => 33
    2 => "2026-09-01"
    3 => "2026-10-01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT b0_.billing_date AS billing_date_0, COUNT(b0_.id) AS sclr_1, SUM(b0_.quantity) AS sclr_2, SUM(b0_.total_price) AS sclr_3 FROM billing_usage b0_ WHERE b0_.billing_date >= ? AND b0_.billing_date < ? GROUP BY b0_.billing_date ORDER BY b0_.billing_date ASC"
  "params" => [
    1 => "2026-09-01"
    2 => "2026-10-01"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        DATE_FORMAT(billing_date, '%Y-%m') AS month,\n
                        COUNT(id) AS usage_count,\n
                        SUM(quantity) AS quantity,\n
                        SUM(total_price) AS total_amount\n
                    FROM billing_usage\n
                    WHERE billing_date >= ?\n
                      AND billing_date < ?\n
                    GROUP BY DATE_FORMAT(billing_date, '%Y-%m')\n
                    ORDER BY month ASC\n
                
    """
  "params" => [
    1 => "2026-04-01"
    2 => "2026-10-01"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount AS amount_3, t0.status AS status_4, t0.details AS details_5, t0.created_at AS created_at_6, t0.paid_at AS paid_at_7, t0.formule_enseigne_id AS formule_enseigne_id_8 FROM formule_enseigne_invoice t0 WHERE t0.formule_enseigne_id = ?"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_url_root AS main_url_root_5, t0.main_document_root AS main_document_root_6, t0.main_url_root_alt AS main_url_root_alt_7, t0.main_document_root_alt AS main_document_root_alt_8, t0.main_data_root AS main_data_root_9, t0.main_db_host AS main_db_host_10, t0.main_db_port AS main_db_port_11, t0.main_db_name AS main_db_name_12, t0.main_db_prefix AS main_db_prefix_13, t0.main_db_user AS main_db_user_14, t0.main_db_pass AS main_db_pass_15, t0.main_db_type AS main_db_type_16, t0.main_db_character_set AS main_db_character_set_17, t0.main_db_collation AS main_db_collation_18, t0.main_authentication AS main_authentication_19, t0.main_prod AS main_prod_20, t0.main_force_https AS main_force_https_21, t0.main_restrict_os_commands AS main_restrict_os_commands_22, t0.nocsrfcheck AS nocsrfcheck_23, t0.main_instance_unique_id AS main_instance_unique_id_24, t0.mailing_limit_sendbyweb AS mailing_limit_sendbyweb_25, t0.main_distrib AS main_distrib_26, t0.environnement AS environnement_27, t0.statut AS statut_28, t0.etat_instance AS etat_instance_29, t0.version_courante AS version_courante_30, t0.health AS health_31, t0.base_url AS base_url_32, t0.api_key AS api_key_33, t0.dgi_token AS dgi_token_34, t0.last_heartbeat_at AS last_heartbeat_at_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.active AS active_38 FROM enseignes t0 WHERE t0.id = ?"
  "params" => [
    1 => 33
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.active AS active_4, t0.prix AS prix_5, t0.photo AS photo_6, t0.max_simultaneous_connections AS max_simultaneous_connections_7, t0.price_per_hour AS price_per_hour_8, t0.billable_by_time AS billable_by_time_9 FROM formule t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.billing_type AS billing_type_3, t0.billing_unit AS billing_unit_4, t0.duration AS duration_5, t0.price AS price_6, t0.active AS active_7, t0.allow_overage AS allow_overage_8, t0.overage_multiplier AS overage_multiplier_9, t0.metadata AS metadata_10, t0.grace_period AS grace_period_11, t0.grace_unit AS grace_unit_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.formule_id AS formule_id_15 FROM billing_plan t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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\Mercure\EventSubscriber\SetCookieSubscriber::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "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" => "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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]