Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://en.serv-kompixel.fr/"
  "method" => "GET"
]

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

[
  "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" => "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" => "App\EventSubscriber\AdminTemplateSubscriber::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" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "enconciergerie"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "enconciergerie"
    "serverVersion" => "8.0.32"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.address AS address_3, p0_.postal_code AS postal_code_4, p0_.city AS city_5, p0_.price AS price_6, p0_.surface AS surface_7, p0_.rooms AS rooms_8, p0_.bedrooms AS bedrooms_9, p0_.bathrooms AS bathrooms_10, p0_.type AS type_11, p0_.status AS status_12, p0_.is_active AS is_active_13, p0_.has_parking AS has_parking_14, p0_.has_garden AS has_garden_15, p0_.has_balcony AS has_balcony_16, p0_.has_elevator AS has_elevator_17, p0_.has_air_conditioning AS has_air_conditioning_18, p0_.has_heating AS has_heating_19, p0_.has_wifi AS has_wifi_20, p0_.has_kitchen AS has_kitchen_21, p0_.has_tv AS has_tv_22, p0_.has_washing_machine AS has_washing_machine_23, p0_.has_dishwasher AS has_dishwasher_24, p0_.has_pet_friendly AS has_pet_friendly_25, p0_.has_smoking_allowed AS has_smoking_allowed_26, p0_.max_guests AS max_guests_27, p0_.min_stay AS min_stay_28, p0_.max_stay AS max_stay_29, p0_.amenities AS amenities_30, p0_.images AS images_31, p0_.house_rules AS house_rules_32, p0_.pricing AS pricing_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.latitude AS latitude_36, p0_.longitude AS longitude_37, p0_.reference AS reference_38, p0_.notes AS notes_39, p0_.check_in_time AS check_in_time_40, p0_.check_out_time AS check_out_time_41, p0_.instant_booking AS instant_booking_42, p0_.self_check_in AS self_check_in_43, p0_.check_in_instructions AS check_in_instructions_44, p0_.cleaning_fee AS cleaning_fee_45, p0_.service_fee AS service_fee_46, p0_.ical_url_airbnb AS ical_url_airbnb_47, p0_.ical_url_booking AS ical_url_booking_48, p0_.ical_secret AS ical_secret_49, p0_.ical_enabled AS ical_enabled_50, p0_.last_ical_sync AS last_ical_sync_51, p0_.external_bookings AS external_bookings_52, p0_.owner_id AS owner_id_53 FROM property p0_ WHERE p0_.is_active = ? AND p0_.status IN (?, ?) AND LOWER(p0_.title) NOT LIKE ? AND LOWER(p0_.title) NOT LIKE ? AND LOWER(p0_.title) NOT LIKE ? AND LOWER(p0_.description) NOT LIKE ? AND LOWER(p0_.description) NOT LIKE ? AND LOWER(p0_.description) NOT LIKE ? ORDER BY p0_.created_at DESC LIMIT 6"
  "params" => [
    1 => 1
    2 => "disponible"
    3 => "occupé"
    4 => "%test%"
    5 => "%demo%"
    6 => "%sample%"
    7 => "%test%"
    8 => "%demo%"
    9 => "%sample%"
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20, b0_.author_id AS author_id_21, b0_.category_id AS category_id_22 FROM blog_post b0_ WHERE b0_.status = ? AND b0_.published_at IS NOT NULL AND b0_.published_at <= ? AND LOWER(b0_.title) NOT LIKE ? AND LOWER(b0_.title) NOT LIKE ? AND LOWER(b0_.title) NOT LIKE ? AND LOWER(b0_.content) NOT LIKE ? AND LOWER(b0_.content) NOT LIKE ? AND LOWER(b0_.content) NOT LIKE ? ORDER BY b0_.published_at DESC LIMIT 3"
  "params" => [
    1 => "published"
    2 => "2025-12-14 07:00:49"
    3 => "%test%"
    4 => "%demo%"
    5 => "%sample%"
    6 => "%test%"
    7 => "%demo%"
    8 => "%sample%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.icon AS icon_6, t0.image AS image_7, t0.is_active AS is_active_8, t0.sort_order AS sort_order_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14 FROM blog_category t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.icon AS icon_6, t0.image AS image_7, t0.is_active AS is_active_8, t0.sort_order AS sort_order_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14 FROM blog_category t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.icon AS icon_6, t0.image AS image_7, t0.is_active AS is_active_8, t0.sort_order AS sort_order_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14 FROM blog_category t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "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"
]