Symfony Profiler

[
  "route" => "app_recipe_show"
  "route_parameters" => [
    "_route" => "app_recipe_show"
    "_controller" => "App\Controller\RecipeController::show"
    "slug" => "chicken-wings"
  ]
  "request_uri" => "https://foodan.app/recettes/chicken-wings"
  "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" => "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" => "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.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_vegetarian AS is_vegetarian_5, t0.is_vegan AS is_vegan_6, t0.is_gluten_free AS is_gluten_free_7, t0.image_name AS image_name_8, t0.average_price AS average_price_9, t0.global_rating AS global_rating_10, t0.restaurant_count AS restaurant_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.category_id AS category_id_14 FROM recipe t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "chicken-wings"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1099
      +name: "STRING"
    }
  ]
]

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

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

[
  "sql" => "SELECT r0_.id AS id_0, r0_.price AS price_1, r0_.currency AS currency_2, r0_.is_available AS is_available_3, r0_.display_order AS display_order_4, r0_.average_rating AS average_rating_5, r0_.ratings_count AS ratings_count_6, r0_.chef_note AS chef_note_7, r0_.image_name AS image_name_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.contribution_status AS contribution_status_11, r0_.is_image_ai_generated AS is_image_ai_generated_12, r0_.image_ai_provider AS image_ai_provider_13, r0_.image_generated_at AS image_generated_at_14, r0_.unavailable_reports_count AS unavailable_reports_count_15, r0_.archived_at AS archived_at_16, r1_.id AS id_17, r1_.name AS name_18, r1_.slug AS slug_19, r1_.description AS description_20, r1_.address AS address_21, r1_.city AS city_22, r1_.postal_code AS postal_code_23, r1_.country AS country_24, r1_.latitude AS latitude_25, r1_.longitude AS longitude_26, r1_.phone AS phone_27, r1_.email AS email_28, r1_.website AS website_29, r1_.logo AS logo_30, r1_.cover_image AS cover_image_31, r1_.opening_hours AS opening_hours_32, r1_.is_active AS is_active_33, r1_.is_verified AS is_verified_34, r1_.subscription_type AS subscription_type_35, r1_.subscription_expires_at AS subscription_expires_at_36, r1_.created_at AS created_at_37, r1_.updated_at AS updated_at_38, r1_.source_provider AS source_provider_39, r1_.source_external_id AS source_external_id_40, r1_.imported_at AS imported_at_41, r1_.contribution_status AS contribution_status_42, r2_.id AS id_43, r2_.name AS name_44, r2_.slug AS slug_45, r2_.description AS description_46, r2_.is_vegetarian AS is_vegetarian_47, r2_.is_vegan AS is_vegan_48, r2_.is_gluten_free AS is_gluten_free_49, r2_.image_name AS image_name_50, r2_.average_price AS average_price_51, r2_.global_rating AS global_rating_52, r2_.restaurant_count AS restaurant_count_53, r2_.created_at AS created_at_54, r2_.updated_at AS updated_at_55, r0_.restaurant_id AS restaurant_id_56, r0_.menu_id AS menu_id_57, r0_.recipe_id AS recipe_id_58, r1_.owner_id AS owner_id_59, r1_.contributed_by_id AS contributed_by_id_60, r2_.category_id AS category_id_61 FROM restaurant_dish r0_ INNER JOIN restaurant r1_ ON r0_.restaurant_id = r1_.id INNER JOIN recipe r2_ ON r0_.recipe_id = r2_.id WHERE r0_.recipe_id = ? AND r0_.is_available = ? ORDER BY r0_.average_rating DESC"
  "params" => [
    1 => b"¬éYÎ\x03Lq„Ž?mêL#O"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1099
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1295
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT r0_.city AS city_0 FROM restaurant_dish r1_ INNER JOIN restaurant r0_ ON r1_.restaurant_id = r0_.id WHERE r1_.recipe_id = ? AND r1_.is_available = ? ORDER BY r0_.city ASC"
  "params" => [
    1 => b"¬éYÎ\x03Lq„Ž?mêL#O"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1099
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1295
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.display_order AS display_order_5 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1086
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.is_allergen AS is_allergen_5, t0.allergen_type AS allergen_type_6, t0.created_at AS created_at_7 FROM ingredient t0 INNER JOIN recipe_ingredient ON t0.id = recipe_ingredient.ingredient_id WHERE recipe_ingredient.recipe_id = ?"
  "params" => [
    1 => b"¬éYÎ\x03Lq„Ž?mêL#O"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1099
      +name: "STRING"
    }
  ]
]

[
  "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" => "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" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

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