Symfony Profiler

[
  "route" => "app_master"
  "route_parameters" => [
    "_route" => "app_master"
    "_controller" => "Greendot\EshopBundle\Controller\MasterController::index"
    "_locale" => "cs"
    "slug" => "krytky"
  ]
  "request_uri" => "http://proklima.greendot.cz/krytky"
  "method" => "GET"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "greendot"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "proklima_eshop"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = ? LIMIT 1"
  "params" => [
    1 => "cs"
  ]
  "types" => [
    1 => 2
  ]
]

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

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

[
  "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\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Greendot\EshopBundle\I18n\ApiLocaleListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "Greendot\EshopBundle\EventSubscriber\Decorated\LocaleAwareListenerDecorator::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" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Nzo\UrlEncryptorBundle\Annotations\AnnotationResolver::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Greendot\EshopBundle\EventSubscriber\BeforeControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Greendot\EshopBundle\EventSubscriber\DisableListenersSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Greendot\EshopBundle\EventSubscriber\AnonymousClientLogoutListener::onKernelController"
]

[
  "sql" => "SELECT e0_.foreign_key AS foreign_key_0 FROM ext_translations e0_ WHERE e0_.locale = ? AND e0_.object_class = ? AND e0_.field = ? AND e0_.content = ? LIMIT 1"
  "params" => [
    1 => "cs"
    2 => "Greendot\EshopBundle\Entity\Project\Category"
    3 => "slug"
    4 => "krytky"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "krytky"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ WHERE p0_.id = ?"
  "params" => [
    1 => 461
  ]
  "types" => [
    1 => 1
  ]
]

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.slug_prefix AS slug_prefix_4, t0.controller_name AS controller_name_5 FROM category_type t0 WHERE t0.id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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" => "Greendot\EshopBundle\I18n\ApiLocaleListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "Greendot\EshopBundle\EventSubscriber\Decorated\LocaleAwareListenerDecorator::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" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Nzo\UrlEncryptorBundle\Annotations\AnnotationResolver::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Greendot\EshopBundle\EventSubscriber\BeforeControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Greendot\EshopBundle\EventSubscriber\DisableListenersSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Greendot\EshopBundle\EventSubscriber\AnonymousClientLogoutListener::onKernelController"
]

[
  "sql" => "SELECT e0_.foreign_key AS foreign_key_0 FROM ext_translations e0_ WHERE e0_.locale = ? AND e0_.object_class = ? AND e0_.field = ? AND e0_.content = ? LIMIT 1"
  "params" => [
    1 => "cs"
    2 => "Greendot\EshopBundle\Entity\Project\Category"
    3 => "slug"
    4 => "krytky"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "krytky"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ WHERE p0_.id = ?"
  "params" => [
    1 => 461
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = ? ORDER BY s0_.name ASC LIMIT 1"
  "params" => [
    1 => "after_registration_discount"
  ]
  "types" => [
    1 => 2
  ]
]

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

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

[
  "sql" => """
    \n
            WITH RECURSIVE category_tree AS (\n
                -- Anchor member: start with the requested parent\n
                SELECT CAST(? AS UNSIGNED) AS id\n
                UNION ALL\n
                -- Recursive member: join the mapping table to the tree\n
                SELECT cc.category_sub_id\n
                FROM p_category_category cc\n
                INNER JOIN category_tree ct ON cc.category_super_id = ct.id\n
            )\n
            SELECT id FROM category_tree\n
            
    """
  "params" => [
    1 => 461
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id WHERE (p0_.is_visible = ? AND c1_.category_id IN (?) AND p0_.product_view_type_id IN (?)) AND (p0_.is_active = true)"
  "params" => [
    1 => 1
    2 => 461
    3 => 2
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => """
    \n
            WITH RECURSIVE category_tree AS (\n
                -- Anchor member: start with the requested parent\n
                SELECT CAST(? AS UNSIGNED) AS id\n
                UNION ALL\n
                -- Recursive member: join the mapping table to the tree\n
                SELECT cc.category_sub_id\n
                FROM p_category_category cc\n
                INNER JOIN category_tree ct ON cc.category_super_id = ct.id\n
            )\n
            SELECT id FROM category_tree\n
            
    """
  "params" => [
    1 => 461
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM product p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id WHERE (p0_.is_visible = ? AND c1_.category_id IN (?) AND p0_.product_view_type_id IN (?)) AND (p0_.is_active = true) ORDER BY c1_.sequence ASC, p0_.id DESC LIMIT 40"
  "params" => [
    1 => 1
    2 => 461
    3 => 2
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))"
  "params" => [
    1 => 116
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1"
  "params" => [
    1 => 116
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?"
  "params" => [
    1 => 116
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1"
  "params" => [
    1 => 116
    2 => "2026-07-04 14:04:38"
    3 => "2026-07-04 14:04:38"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1"
  "params" => [
    1 => 1
    2 => "2026-07-04 14:04:38"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p1_.id IS NULL AND c2_.menu_type_id = ? AND p0_.category_type_id IN (?) ORDER BY c2_.sequence ASC"
  "params" => [
    1 => 1
    2 => 2
    3 => 2
    4 => 17
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC"
  "params" => [
    1 => 452
    2 => 18
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC"
  "params" => [
    1 => 453
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC"
  "params" => [
    1 => 454
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC"
  "params" => [
    1 => 455
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC"
  "params" => [
    1 => 461
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = ?"
  "params" => [
    1 => 461
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC"
  "params" => [
    1 => 456
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = ?"
  "params" => [
    1 => 456
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC"
  "params" => [
    1 => 453
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = ?"
  "params" => [
    1 => 453
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC"
  "params" => [
    1 => 452
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 AND p0_.id > 10 ORDER BY p1_.sequence ASC, p0_.sequence ASC"
  "params" => [
    1 => 461
    2 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "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\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" => "Greendot\EshopBundle\Affiliate\AffiliateOrderEventSubscriber::setAffiliateCookies"
]

[
  "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" => "Greendot\EshopBundle\EventSubscriber\Decorated\LocaleAwareListenerDecorator::onKernelFinishRequest"
]

[
  "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\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" => "Greendot\EshopBundle\Affiliate\AffiliateOrderEventSubscriber::setAffiliateCookies"
]

[
  "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" => "Greendot\EshopBundle\EventSubscriber\Decorated\LocaleAwareListenerDecorator::onKernelFinishRequest"
]