Symfony Profiler

[
  "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 => "en"
    2 => "Greendot\EshopBundle\Entity\Project\Category"
    3 => "slug"
    4 => "pevne-pergoly"
  ]
  "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 => "pevne-pergoly"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, 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 ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.id = ?"
  "params" => [
    1 => 431
  ]
  "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" => "ContainerLxPKEOH\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

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

[
  "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_.title AS title_4, p0_.slug AS slug_5, p0_.is_active AS is_active_6, p0_.is_visible AS is_visible_7, p0_.sequence AS sequence_8, p0_.javascript AS javascript_9, p0_.text_general AS text_general_10, p0_.state AS state_11, p0_.external_id AS external_id_12, p0_.is_indexable AS is_indexable_13, p0_.meta_description AS meta_description_14, p0_.has_variant_picture AS has_variant_picture_15, p0_.sold_amount AS sold_amount_16, p0_.additional_data AS additional_data_17, p0_.is_deleted AS is_deleted_18, p0_.producer_id AS producer_id_19, p0_.upload_id AS upload_id_20, p0_.product_type_id AS product_type_id_21, p0_.product_view_type_id AS product_view_type_id_22 FROM product p0_ INNER JOIN category_product c1_ ON p0_.id = c1_.product_id WHERE (c1_.category_id = ? AND p0_.is_active = 1) AND (p0_.is_active = true) ORDER BY c1_.sequence ASC"
  "params" => [
    1 => 431
  ]
  "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 => 103
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "1"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Availability"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "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 => 103
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "103"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Product"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "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 => 104
  ]
  "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 => 104
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "104"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Product"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "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 => 107
  ]
  "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 => 107
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "107"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Product"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?"
  "params" => [
    1 => 5185
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "5185"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Upload"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_id = ? AND u0_.type = ?"
  "params" => [
    1 => 103
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (?) AND u0_.id <> ? AND u0_.upload_type_id = ?"
  "params" => [
    1 => 457
    2 => 5185
    3 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "5186"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Upload"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_id = ? AND u0_.type = ?"
  "params" => [
    1 => 103
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (?) AND u0_.id <> ? AND u0_.upload_type_id = ?"
  "params" => [
    1 => 457
    2 => 5185
    3 => 3
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 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 category_product c1_ ON p0_.id = c1_.category_id WHERE c1_.product_id = ? AND p0_.is_active = ? AND p0_.category_type_id = ? AND p0_.id > 10 ORDER BY p0_.sequence ASC"
  "params" => [
    1 => 103
    2 => 1
    3 => 10
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.expected_restock_date AS expected_restock_date_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.product_id AS product_id_9, t0.availability_id AS availability_id_10, t0.upload_id AS upload_id_11 FROM product_variant t0 WHERE t0.product_id = ? AND ((t0.is_active = true))"
  "params" => [
    1 => 103
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "110"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\ProductVariant"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.id = ? AND p0_.product_variant_id IN (?)"
  "params" => [
    1 => 3
    2 => 110
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.class AS class_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6, t0.parameter_group_filter_type_id AS parameter_group_filter_type_id_7, t0.parameter_group_format_id AS parameter_group_format_id_8 FROM parameter_group t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "3"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\ParameterGroup"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "269"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Parameter"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.id = ? AND p0_.product_variant_id IN (?)"
  "params" => [
    1 => 2
    2 => 110
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?"
  "params" => [
    1 => 5199
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "5199"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Upload"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_id = ? AND u0_.type = ?"
  "params" => [
    1 => 104
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (?) AND u0_.id <> ? AND u0_.upload_type_id = ?"
  "params" => [
    1 => 459
    2 => 5199
    3 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "5200"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Upload"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_id = ? AND u0_.type = ?"
  "params" => [
    1 => 104
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (?) AND u0_.id <> ? AND u0_.upload_type_id = ?"
  "params" => [
    1 => 459
    2 => 5199
    3 => 3
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 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 category_product c1_ ON p0_.id = c1_.category_id WHERE c1_.product_id = ? AND p0_.is_active = ? AND p0_.category_type_id = ? AND p0_.id > 10 ORDER BY p0_.sequence ASC"
  "params" => [
    1 => 104
    2 => 1
    3 => 10
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.expected_restock_date AS expected_restock_date_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.product_id AS product_id_9, t0.availability_id AS availability_id_10, t0.upload_id AS upload_id_11 FROM product_variant t0 WHERE t0.product_id = ? AND ((t0.is_active = true))"
  "params" => [
    1 => 104
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "111"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\ProductVariant"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.id = ? AND p0_.product_variant_id IN (?)"
  "params" => [
    1 => 3
    2 => 111
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "259"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Parameter"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.id = ? AND p0_.product_variant_id IN (?)"
  "params" => [
    1 => 2
    2 => 111
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?"
  "params" => [
    1 => 5227
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "5227"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Upload"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_id = ? AND u0_.type = ?"
  "params" => [
    1 => 107
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (?) AND u0_.id <> ? AND u0_.upload_type_id = ?"
  "params" => [
    1 => 464
    2 => 5227
    3 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "5228"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Upload"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_id = ? AND u0_.type = ?"
  "params" => [
    1 => 107
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (?) AND u0_.id <> ? AND u0_.upload_type_id = ?"
  "params" => [
    1 => 464
    2 => 5227
    3 => 3
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 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 category_product c1_ ON p0_.id = c1_.category_id WHERE c1_.product_id = ? AND p0_.is_active = ? AND p0_.category_type_id = ? AND p0_.id > 10 ORDER BY p0_.sequence ASC"
  "params" => [
    1 => 107
    2 => 1
    3 => 10
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.expected_restock_date AS expected_restock_date_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.product_id AS product_id_9, t0.availability_id AS availability_id_10, t0.upload_id AS upload_id_11 FROM product_variant t0 WHERE t0.product_id = ? AND ((t0.is_active = true))"
  "params" => [
    1 => 107
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "114"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\ProductVariant"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.id = ? AND p0_.product_variant_id IN (?)"
  "params" => [
    1 => 3
    2 => 114
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "264"
    2 => "en"
    3 => "Greendot\EshopBundle\Entity\Project\Parameter"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.id = ? AND p0_.product_variant_id IN (?)"
  "params" => [
    1 => 2
    2 => 114
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ LEFT JOIN upload_group u1_ ON u0_.upload_group_id = u1_.id LEFT JOIN category_upload_group c2_ ON u1_.id = c2_.upload_group_id WHERE u1_.type = ? AND c2_.category_id = ?"
  "params" => [
    1 => 1
    2 => 431
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7, i0_.upload_id AS upload_id_8 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id WHERE i0_.is_active = ? AND i1_.id = ? AND c2_.category_id = ? ORDER BY c2_.sequence ASC"
  "params" => [
    1 => 1
    2 => 6
    3 => 431
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7, i0_.upload_id AS upload_id_8 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id WHERE i0_.is_active = ? AND i1_.id = ? AND c2_.category_id = ? ORDER BY c2_.sequence ASC"
  "params" => [
    1 => 1
    2 => 7
    3 => 431
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7, i0_.upload_id AS upload_id_8 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id WHERE i0_.is_active = ? AND i1_.id = ? AND c2_.category_id = ? ORDER BY c2_.sequence ASC"
  "params" => [
    1 => 1
    2 => 7
    3 => 431
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7, i0_.upload_id AS upload_id_8 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id WHERE i0_.is_active = ? AND i1_.id = ? AND c2_.category_id = ? ORDER BY c2_.sequence ASC"
  "params" => [
    1 => 1
    2 => 2
    3 => 431
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7, i0_.upload_id AS upload_id_8 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id WHERE i0_.is_active = ? AND i1_.id = ? AND c2_.category_id = ? ORDER BY c2_.sequence ASC"
  "params" => [
    1 => 1
    2 => 8
    3 => 431
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7, i0_.upload_id AS upload_id_8 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id WHERE i0_.is_active = ? AND i1_.id = ? AND c2_.category_id = ? ORDER BY c2_.sequence ASC"
  "params" => [
    1 => 1
    2 => 9
    3 => 431
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 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"
]