Symfony Profiler

[
  "route" => "app_home_detail_emploie_slug"
  "route_parameters" => [
    "_route" => "app_home_detail_emploie_slug"
    "_controller" => "App\Controller\HomeController::detail_emploie_slug"
    "slug" => "ASSISTANT-E-SOCIAL-E"
  ]
  "request_uri" => "https://dev.manalti.com/liste-des-emplois/detail-emploie/ASSISTANT-E-SOCIAL-E"
  "method" => "GET"
]

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

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

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

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

[
  "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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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.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\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" => "ContainerDiqTNem\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "ucpg0854_manalti"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "ucpg0854_manalti"
    "serverVersion" => "10.6.17-MariaDB-cll-lve"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date_limite_candidature AS date_limite_candidature_4, t0.voie_application AS voie_application_5, t0.type_voie_application AS type_voie_application_6, t0.genre AS genre_7, t0.fichier AS fichier_8, t0.etat AS etat_9, t0.code_postal AS code_postal_10, t0.adresse AS adresse_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.zoom AS zoom_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.reference AS reference_18, t0.competence AS competence_19, t0.is_valid AS is_valid_20, t0.is_urgent AS is_urgent_21, t0.is_vedette AS is_vedette_22, t0.type_emploie_id AS type_emploie_id_23, t0.experience_id AS experience_id_24, t0.metier_id AS metier_id_25, t0.niveau_id AS niveau_id_26, t0.secteur_id AS secteur_id_27, t0.expertise_id AS expertise_id_28, t0.user_id AS user_id_29 FROM emploie t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "ASSISTANT-E-SOCIAL-E"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6 FROM manage_cv t0 WHERE t0.user_id IS NULL"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6 FROM lettre_motivation t0 WHERE t0.user_id IS NULL"
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.description AS description_1 FROM metier m0_"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.descripption AS descripption_1 FROM secteur_entreprise s0_"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.username AS username_7, t0.telephone AS telephone_8, t0.organisation AS organisation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.description AS description_12, t0.avatar AS avatar_13, t0.logo AS logo_14, t0.age AS age_15, t0.date_naissance AS date_naissance_16, t0.is_approuved AS is_approuved_17, t0.titre_emploie AS titre_emploie_18, t0.other_metier AS other_metier_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.linkedin AS linkedin_22, t0.etat AS etat_23, t0.code_postal AS code_postal_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.zoom AS zoom_27, t0.image_couverture AS image_couverture_28, t0.slug AS slug_29, t0.website AS website_30, t0.date_creation AS date_creation_31, t0.adresse AS adresse_32, t0.tags AS tags_33, t0.is_valid AS is_valid_34, t0.is_urgent AS is_urgent_35, t0.google_id AS google_id_36, t0.is_notification AS is_notification_37, t0.is_hidden_email AS is_hidden_email_38, t0.metier_id AS metier_id_39, t0.expertise_id AS expertise_id_40, t0.niveau_id AS niveau_id_41, t0.secteur_id AS secteur_id_42, t0.genre_id AS genre_id_43 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 114
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.description AS description_2 FROM expertise t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.description AS description_2 FROM genre t0 INNER JOIN emploie_genre ON t0.id = emploie_genre.genre_id WHERE emploie_genre.emploie_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.description AS description_2 FROM niveau t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.description AS description_2 FROM type_emploie t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

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