Symfony Profiler

[
  "params" => [
    "dbname" => "smart-core"
    "driver" => "pdo_pgsql"
    "host" => "postgres-smart-core"
    "password" => "<redacted>"
    "port" => "5432"
    "user" => "smart-core"
    "idle_connection_ttl" => 600
    "driverOptions" => []
    "serverVersion" => "15.1"
    "defaultTableOptions" => []
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT s0_.deleted_at AS deleted_at_0, s0_.hidden AS hidden_1, s0_.position AS position_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.id AS id_5, s0_.name AS name_6, s0_.domain AS domain_7, s0_.recaptcha_public_key AS recaptcha_public_key_8, s0_.recaptcha_secret_key AS recaptcha_secret_key_9, s0_.owner AS owner_10, s0_.siret AS siret_11, s0_.intracommunity_vat AS intracommunity_vat_12, s0_.rcs AS rcs_13, s0_.capital AS capital_14, s0_.registered_office AS registered_office_15, s0_.cmp AS cmp_16, s0_.map_embed AS map_embed_17, s0_.meta_title AS meta_title_18, s0_.meta_description AS meta_description_19, s0_.theme_slug AS theme_slug_20, s0_.custom_css AS custom_css_21, s0_.enabled AS enabled_22, s0_.created_by_id AS created_by_id_23, s0_.updated_by_id AS updated_by_id_24, s0_.default_language_id AS default_language_id_25, s0_.license_id AS license_id_26 FROM site s0_ WHERE (s0_.domain = ?) AND (s0_.deleted_at IS NULL)"
  "params" => [
    1 => "preprod.apop-france.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.id AS id_2 FROM document_site_extension t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.id AS id_2 FROM gallery_site_extension t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.id AS id_2 FROM faq_site_extension t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.id AS id_2 FROM team_site_extension t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.fields AS fields_3, c0_.enabled AS enabled_4, c0_.send_confirmation_email AS send_confirmation_email_5, c0_.send_notification_email AS send_notification_email_6, c0_.notification_email AS notification_email_7, c0_.success_message AS success_message_8, c0_.intro_text AS intro_text_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.site_id AS site_id_12 FROM contact_form c0_ WHERE c0_.slug = ? AND c0_.site_id = ? AND c0_.enabled = ?"
  "params" => [
    1 => "contact"
    2 => 5
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1245
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#2364
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.fields AS fields_3, c0_.enabled AS enabled_4, c0_.send_confirmation_email AS send_confirmation_email_5, c0_.send_notification_email AS send_notification_email_6, c0_.notification_email AS notification_email_7, c0_.success_message AS success_message_8, c0_.intro_text AS intro_text_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.site_id AS site_id_12 FROM contact_form c0_ WHERE c0_.site_id = ? AND c0_.enabled = ? ORDER BY c0_.id ASC LIMIT 1"
  "params" => [
    1 => 5
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1245
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2364
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM zone t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1245
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.title AS title_8, t0.menu_id AS menu_id_9, t0.zone_id AS zone_id_10 FROM menu_zone t0 WHERE t0.zone_id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1245
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.site_id AS site_id_8 FROM menu t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.site_id AS site_id_8 FROM menu t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.site_id AS site_id_8 FROM menu t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.address AS address_6, t0.address2 AS address2_7, t0.city AS city_8, t0.fax AS fax_9, t0.id AS id_10, t0.name AS name_11, t0.phone AS phone_12, t0.portable AS portable_13, t0.type AS type_14, t0.zipcode AS zipcode_15, t0.country AS country_16, t0.company AS company_17, t0.contact_mail AS contact_mail_18, t0.mail_tester AS mail_tester_19, t0.schedules AS schedules_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22, t0.site_id AS site_id_23 FROM site_address t0 WHERE t0.site_id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1245
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM zone t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1245
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.title AS title_8, t0.menu_id AS menu_id_9, t0.zone_id AS zone_id_10 FROM menu_zone t0 WHERE t0.zone_id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1245
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.site_id AS site_id_8 FROM menu t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.site_id AS site_id_10, t0.social_media_id AS social_media_id_11 FROM site_social_media t0 WHERE t0.site_id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1245
      +name: "INTEGER"
    }
  ]
]

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

[
  "event" => "kernel.request"
  "listener" => "Koredge\CoreBundle\EventListener\HttpMetricsListener::onKernelRequest"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Koredge\ContentBundle\EventListener\TranslationRequestStackListener::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" => "Koredge\SiteBundle\EventListener\SiteContextListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Koredge\SiteBundle\EventListener\SiteContextListener::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" => "Koredge\CoreBundle\EventListener\Localization\LocaleListener::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" => "Koredge\CoreBundle\EventListener\Security\AccessListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Koredge\CoreBundle\EventListener\UI\ListingListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Koredge\CoreBundle\EventListener\File\SecureFilesListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest"
]

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

[
  "sql" => """
    SELECT quote_ident(table_name) AS table_name,\n
           table_schema AS schema_name\n
    FROM information_schema.tables\n
    WHERE table_catalog = ?\n
      AND table_schema NOT LIKE 'pg\_%'\n
      AND table_schema != 'information_schema'\n
      AND table_name != 'geometry_columns'\n
      AND table_name != 'spatial_ref_sys'\n
      AND table_type = 'BASE TABLE'\n
    ORDER BY\n
      quote_ident(table_name)
    """
  "params" => [
    1 => "smart-core"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1160
      +name: "STRING"
    }
  ]
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Koredge\CoreBundle\EventListener\UI\ListingListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Koredge\CoreBundle\EventListener\Mercure\MercureListener::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\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveUrlSubscriber::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" => "Koredge\CoreBundle\EventListener\Security\SecurityHeadersListener::__invoke"
]

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

[
  "event" => "kernel.response"
  "listener" => "Koredge\CoreBundle\EventListener\HttpMetricsListener::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"
]