Symfony Profiler

[
  "route" => "stats_get_documents_filter"
  "route_parameters" => [
    "_route" => "stats_get_documents_filter"
    "_format" => "json"
    "_controller" => "App\Controller\NewStats\NewStatsController::getDocumentsFilter"
  ]
  "request_uri" => "https://rd.interactiv-doc.fr/stats/getDocumentsFilter"
  "method" => "POST"
]

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "UTF8"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "rdmanager"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "it2_it_manager"
  ]
]

[
  "sql" => "SELECT t0.use_id AS use_id_1, t0.use_login AS use_login_2, t0.use_password AS use_password_3, t0.roles AS roles_4, t0.use_first_name AS use_first_name_5, t0.use_last_name AS use_last_name_6, t0.use_email AS use_email_7, t0.use_id_parent AS use_id_parent_8, t0.last_connection AS last_connection_9, t0.count_connection AS count_connection_10, t0.password_last_changed AS password_last_changed_11, t0.require_password_change AS require_password_change_12, t0.two_factor_secret AS two_factor_secret_13, t0.two_factor_method AS two_factor_method_14, t0.two_factor_enabled AS two_factor_enabled_15, t0.two_factor_email_code AS two_factor_email_code_16, t0.two_factor_email_code_expiry AS two_factor_email_code_expiry_17, t0.failed_login_attempts AS failed_login_attempts_18, t0.locked_until AS locked_until_19, t0.cust_id AS cust_id_20, t0.priv_id AS priv_id_21 FROM itm_user t0 WHERE t0.use_id = ?"
  "params" => [
    1 => 369
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "managerIT2-1"
]

[
  "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\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" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::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\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

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

[
  "sql" => "SELECT i0_.sub_id AS sub_id_0, i0_.sub_name AS sub_name_1, i0_.sub_creation_date AS sub_creation_date_2, i0_.sub_expiration_date AS sub_expiration_date_3, i0_.sub_archive AS sub_archive_4, i0_.sub_temporary AS sub_temporary_5, i0_.sub_document_number AS sub_document_number_6, i0_.sub_page_number AS sub_page_number_7, i0_.sub_download_number AS sub_download_number_8, i0_.sub_download_done AS sub_download_done_9, i0_.sub_validate AS sub_validate_10, COUNT(i1_.cat_id) AS sclr_11, MAX(i1_.cat_page_number) AS sclr_12, i0_.feat_id AS sclr_13 FROM itm_subscription i0_ LEFT JOIN itm_catalog i1_ ON (i1_.sub_id = i0_.sub_id) WHERE i0_.cust_id = ? GROUP BY i0_.sub_id ORDER BY i0_.sub_id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC"
  "params" => [
    1 => 417
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC"
  "params" => [
    1 => 742
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC"
  "params" => [
    1 => 1560
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC"
  "params" => [
    1 => 1570
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC"
  "params" => [
    1 => 1701
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC"
  "params" => [
    1 => 1837
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC"
  "params" => [
    1 => 1975
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC"
  "params" => [
    1 => 2035
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#656
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]

[
  "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" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::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\CacheAttributeListener::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" => "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"
]