Symfony Profiler

[
  "route" => "app_shop_view"
  "route_parameters" => [
    "_route" => "app_shop_view"
    "_controller" => "App\Controller\ShopController"
  ]
  "request_uri" => "http://89.171.139.90:7774/sklep"
  "method" => "GET"
]

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

[
  "firewall_name" => "secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

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

[
  "firewall_name" => "secured_area"
  "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\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\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" => "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_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" => "ContainerLOhvocm\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mysql"
    "port" => null
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "falkon"
    "serverVersion" => "8.0.31"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.primary_category AS primary_category_4 FROM shop_item_category t0 WHERE t0.active = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.image AS image_3, s0_.summary AS summary_4, s0_.description AS description_5, COALESCE(MIN(s1_.count), s2_.count) AS sclr_6 FROM shop_item s0_ LEFT JOIN shop_item_shop_item s4_ ON s0_.id = s4_.shop_item_source LEFT JOIN shop_item s3_ ON s3_.id = s4_.shop_item_target LEFT JOIN shop_stock s2_ ON s0_.id = s2_.item_id LEFT JOIN shop_stock s1_ ON s3_.id = s1_.item_id WHERE s0_.category_id = ? AND s0_.public = 1 GROUP BY s0_.id, s0_.name, s0_.price, s0_.image, s0_.summary, s0_.description, s2_.count"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = ? AND s0_.updated_at >= ?"
  "params" => [
    1 => 1
    2 => "2024-10-25 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = ? AND s0_.start_at <= ? AND s0_.expired_at >= ?"
  "params" => [
    1 => 1
    2 => "2024-11-24 14:25:06"
    3 => "2024-11-24 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = ? AND s0_.updated_at >= ?"
  "params" => [
    1 => 2
    2 => "2024-10-25 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = ? AND s0_.start_at <= ? AND s0_.expired_at >= ?"
  "params" => [
    1 => 2
    2 => "2024-11-24 14:25:06"
    3 => "2024-11-24 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = ? AND s0_.updated_at >= ?"
  "params" => [
    1 => 3
    2 => "2024-10-25 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = ? AND s0_.start_at <= ? AND s0_.expired_at >= ?"
  "params" => [
    1 => 3
    2 => "2024-11-24 14:25:06"
    3 => "2024-11-24 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = ? AND s0_.updated_at >= ?"
  "params" => [
    1 => 4
    2 => "2024-10-25 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = ? AND s0_.start_at <= ? AND s0_.expired_at >= ?"
  "params" => [
    1 => 4
    2 => "2024-11-24 14:25:06"
    3 => "2024-11-24 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = ? AND s0_.updated_at >= ?"
  "params" => [
    1 => 5
    2 => "2024-10-25 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = ? AND s0_.start_at <= ? AND s0_.expired_at >= ?"
  "params" => [
    1 => 5
    2 => "2024-11-24 14:25:06"
    3 => "2024-11-24 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = ? AND s0_.updated_at >= ?"
  "params" => [
    1 => 6
    2 => "2024-10-25 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = ? AND s0_.start_at <= ? AND s0_.expired_at >= ?"
  "params" => [
    1 => 6
    2 => "2024-11-24 14:25:06"
    3 => "2024-11-24 14:25:06"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.edition AS edition_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.current AS current_5, t0.main_graphic AS main_graphic_6, t0.short_description AS short_description_7, t0.public AS public_8, t9.id AS id_10, t9.address AS address_11, t9.city AS city_12, t9.map_link AS map_link_13, t9.public_transport AS public_transport_14, t9.parking_info AS parking_info_15, t9.train_station AS train_station_16, t9.additional_info AS additional_info_17, t9.festival_id AS festival_id_18 FROM festival t0 LEFT JOIN festival_location t9 ON t9.festival_id = t0.id WHERE t0.current = ? AND t0.public = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 5
    2 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.index_position AS index_position_3, t0.route AS route_4, t0.type AS type_5, t0.slug AS slug_6, t0.in_footer AS in_footer_7, t0.parent_id AS parent_id_8 FROM menu_item t0 ORDER BY t0.index_position ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.additional_text AS additional_text_2, t0.active AS active_3 FROM footer t0 WHERE t0.active = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.index_position AS index_position_3, t0.route AS route_4, t0.type AS type_5, t0.slug AS slug_6, t0.in_footer AS in_footer_7, t0.parent_id AS parent_id_8 FROM menu_item t0 WHERE t0.in_footer = ? ORDER BY t0.index_position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::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\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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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