Symfony Profiler

[
  "route" => "index_forum"
  "route_parameters" => [
    "_route" => "index_forum"
    "_controller" => "App\Controller\Admin\SujetforumCrudController::listServices"
  ]
  "request_uri" => "http://cnfcpp1.abshore.com/list/forum/index/"
  "method" => "GET"
]

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

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

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

[
  "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" => "App\EventSubscriber\LocaleSubscriber::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" => "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" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "cnfcpp_base"
    "port" => 3306
    "user" => "cnfcpp"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "cnfcpp"
    "serverVersion" => "5.7"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.sujet AS sujet_1, s0_.description AS description_2, s0_.is_public AS is_public_3, s0_.date AS date_4, s0_.date_public AS date_public_5, s0_.user_id AS user_id_6 FROM sujetforum s0_ WHERE s0_.date_public IS NOT NULL AND s0_.is_public = 1 ORDER BY s0_.id DESC LIMIT 2"
]

[
  "sql" => "SELECT t0.id AS id_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.roles AS roles_12, t0.is_verified AS is_verified_13, t0.token_reset AS token_reset_14, t0.is_deleted AS is_deleted_15, t0.type, t1.nom AS nom_16, t1.prenom AS prenom_17, t1.tel AS tel_18, t1.fonction AS fonction_19, t1.autre AS autre_20, t1.fonctions AS fonctions_21, t1.gouvernorat_id AS gouvernorat_id_22, t2.type_partenaire AS type_partenaire_23, t2.nombre_entreprise AS nombre_entreprise_24, t2.cnsscnrps AS cnsscnrps_25, t2.code_cnss AS code_cnss_26, t2.secteur AS secteur_27, t2.branche AS branche_28, t2.fax AS fax_29, t2.tel AS tel_30, t2.nom_prenom_president AS nom_prenom_president_31, t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32, t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33, t2.nom AS nom_34, t2.file_name AS file_name_35, t2.original_file_name AS original_file_name_36, t2.gouvernorat_id AS gouvernorat_id_37, t2.delegation_id AS delegation_id_38, t3.matricule_fiscal AS matricule_fiscal_39, t3.nom_commercial AS nom_commercial_40, t3.fax AS fax_41, t3.code_cnss AS code_cnss_42, t3.cnsscnrps AS cnsscnrps_43, t3.secteur AS secteur_44, t3.branche AS branche_45, t3.produits_services_rendus AS produits_services_rendus_46, t3.statut AS statut_47, t3.exportatrice AS exportatrice_48, t3.off_shore AS off_shore_49, t3.taux_tfp AS taux_tfp_50, t3.regime_travail AS regime_travail_51, t3.tel AS tel_52, t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53, t3.raison_sociale AS raison_sociale_54, t3.montant AS montant_55, t3.adresse_siege_social AS adresse_siege_social_56, t3.adresse_site_production AS adresse_site_production_57, t3.gouvernorat_id AS gouvernorat_id_58, t3.delegation_id AS delegation_id_59, t4.tel AS tel_60, t4.nom AS nom_61, t4.prenom AS prenom_62, t4.ministere AS ministere_63, t4.direction AS direction_64, t4.gouvernorat_id AS gouvernorat_id_65, t5.nom AS nom_66, t5.prenom AS prenom_67, t5.tel AS tel_68, t5.unite_regional_id AS unite_regional_id_69, t6.nom AS nom_70, t6.prenom AS prenom_71, t6.tel AS tel_72, t6.nom_administration AS nom_administration_73, t6.regional AS regional_74, t6.unite AS unite_75, t6.fonction AS fonction_76, t7.nom AS nom_77, t7.prenom AS prenom_78, t7.tel AS tel_79, t7.gouvernorat_id AS gouvernorat_id_80 FROM user t0 LEFT JOIN particulier t1 ON t0.id = t1.id LEFT JOIN partenaire t2 ON t0.id = t2.id LEFT JOIN entreprise t3 ON t0.id = t3.id LEFT JOIN dae t4 ON t0.id = t4.id LEFT JOIN charge_assistance t5 ON t0.id = t5.id LEFT JOIN agent_interne t6 ON t0.id = t6.id LEFT JOIN autres t7 ON t0.id = t7.id WHERE t0.id = ?"
  "params" => [
    1 => 99
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.roles AS roles_12, t0.is_verified AS is_verified_13, t0.token_reset AS token_reset_14, t0.is_deleted AS is_deleted_15, t0.type, t1.nom AS nom_16, t1.prenom AS prenom_17, t1.tel AS tel_18, t1.fonction AS fonction_19, t1.autre AS autre_20, t1.fonctions AS fonctions_21, t1.gouvernorat_id AS gouvernorat_id_22, t2.type_partenaire AS type_partenaire_23, t2.nombre_entreprise AS nombre_entreprise_24, t2.cnsscnrps AS cnsscnrps_25, t2.code_cnss AS code_cnss_26, t2.secteur AS secteur_27, t2.branche AS branche_28, t2.fax AS fax_29, t2.tel AS tel_30, t2.nom_prenom_president AS nom_prenom_president_31, t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32, t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33, t2.nom AS nom_34, t2.file_name AS file_name_35, t2.original_file_name AS original_file_name_36, t2.gouvernorat_id AS gouvernorat_id_37, t2.delegation_id AS delegation_id_38, t3.matricule_fiscal AS matricule_fiscal_39, t3.nom_commercial AS nom_commercial_40, t3.fax AS fax_41, t3.code_cnss AS code_cnss_42, t3.cnsscnrps AS cnsscnrps_43, t3.secteur AS secteur_44, t3.branche AS branche_45, t3.produits_services_rendus AS produits_services_rendus_46, t3.statut AS statut_47, t3.exportatrice AS exportatrice_48, t3.off_shore AS off_shore_49, t3.taux_tfp AS taux_tfp_50, t3.regime_travail AS regime_travail_51, t3.tel AS tel_52, t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53, t3.raison_sociale AS raison_sociale_54, t3.montant AS montant_55, t3.adresse_siege_social AS adresse_siege_social_56, t3.adresse_site_production AS adresse_site_production_57, t3.gouvernorat_id AS gouvernorat_id_58, t3.delegation_id AS delegation_id_59, t4.tel AS tel_60, t4.nom AS nom_61, t4.prenom AS prenom_62, t4.ministere AS ministere_63, t4.direction AS direction_64, t4.gouvernorat_id AS gouvernorat_id_65, t5.nom AS nom_66, t5.prenom AS prenom_67, t5.tel AS tel_68, t5.unite_regional_id AS unite_regional_id_69, t6.nom AS nom_70, t6.prenom AS prenom_71, t6.tel AS tel_72, t6.nom_administration AS nom_administration_73, t6.regional AS regional_74, t6.unite AS unite_75, t6.fonction AS fonction_76, t7.nom AS nom_77, t7.prenom AS prenom_78, t7.tel AS tel_79, t7.gouvernorat_id AS gouvernorat_id_80 FROM user t0 LEFT JOIN particulier t1 ON t0.id = t1.id LEFT JOIN partenaire t2 ON t0.id = t2.id LEFT JOIN entreprise t3 ON t0.id = t3.id LEFT JOIN dae t4 ON t0.id = t4.id LEFT JOIN charge_assistance t5 ON t0.id = t5.id LEFT JOIN agent_interne t6 ON t0.id = t6.id LEFT JOIN autres t7 ON t0.id = t7.id WHERE t0.id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "cnfcpp"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "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\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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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

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