Symfony Profiler

[
  "route" => "app_category_show"
  "route_parameters" => [
    "_route" => "app_category_show"
    "_controller" => "App\Controller\CategoryController::show"
    "slug" => "torty"
  ]
  "request_uri" => "http://rm.local.besmartandpro.ngrok.dev/kategoria/torty"
  "method" => "GET"
]

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

[
  "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" => "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\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" => "App\EventListener\Supplier\SupplierStorefrontHostRedirectListener::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.request"
  "listener" => "App\EventListener\DeliveryFilterEnablerListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\ForcedSessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\Product\ProductAddListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\User\ZipCodeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\Supplier\SupplierBanRequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\LegalAcceptanceRequestListener::__invoke"
]

[
  "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" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "database"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "app"
    "serverVersion" => "11.2.2-MariaDb"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.active AS active_4, t0.slug AS slug_5, t0.promoted AS promoted_6, t0.image_path AS image_path_7, t0.active_product_count AS active_product_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "torty"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
  ]
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "App\EventListener\Audit\HttpAuditListener::onController"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.active AS active_4, t0.slug AS slug_5, t0.promoted AS promoted_6, t0.image_path AS image_path_7, t0.active_product_count AS active_product_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT MIN((CASE WHEN p0_.promo_brutto_amount > 0 THEN p0_.promo_brutto_amount ELSE p0_.brutto_price_amount END) + 0) AS sclr_0, MAX((CASE WHEN p0_.promo_brutto_amount > 0 THEN p0_.promo_brutto_amount ELSE p0_.brutto_price_amount END) + 0) AS sclr_1, p0_.brutto_price_currency_code AS brutto_price_currency_code_2 FROM product p0_ INNER JOIN supplier s1_ ON p0_.supplier_id = s1_.id INNER JOIN tax t2_ ON p0_.tax_id = t2_.id WHERE p0_.status = ? AND s1_.active = 1 AND s1_.terms_suspended = 0 AND p0_.banned = 0 AND p0_.accepted = 1 AND p0_.category_id IN (?)"
  "params" => [
    1 => "active"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#517
      -unwrapped: null
      -uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
      uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#659}
  ]
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before"
]

[
  "sql" => "SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN supplier s1_ ON p0_.supplier_id = s1_.id INNER JOIN tax t2_ ON p0_.tax_id = t2_.id WHERE p0_.status = ? AND s1_.active = 1 AND s1_.terms_suspended = 0 AND p0_.banned = 0 AND p0_.accepted = 1 AND p0_.category_id IN (?)"
  "params" => [
    1 => "active"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#517
      -unwrapped: null
      -uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
      uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#659}
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM product p0_ INNER JOIN supplier s1_ ON p0_.supplier_id = s1_.id INNER JOIN tax t2_ ON p0_.tax_id = t2_.id WHERE p0_.status = ? AND s1_.active = 1 AND s1_.terms_suspended = 0 AND p0_.banned = 0 AND p0_.accepted = 1 AND p0_.category_id IN (?) ORDER BY p0_.name ASC LIMIT 12"
  "params" => [
    1 => "active"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#517
      -unwrapped: null
      -uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
      uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#659}
  ]
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.active AS active_3, s0_.terms_suspended AS terms_suspended_4, s0_.banned AS banned_5, s0_.ban_reason AS ban_reason_6, s0_.banned_at AS banned_at_7, s0_.average_rate_review AS average_rate_review_8, s0_.description AS description_9, s0_.storefront_headline AS storefront_headline_10, s0_.storefront_intro AS storefront_intro_11, s0_.storefront_accent_color AS storefront_accent_color_12, s0_.store_subdomain AS store_subdomain_13, s0_.store_subdomain_active AS store_subdomain_active_14, s0_.logo_name AS logo_name_15, s0_.logo_size AS logo_size_16, s0_.cover_name AS cover_name_17, s0_.cover_size AS cover_size_18, s0_.storefront_banner_name AS storefront_banner_name_19, s0_.storefront_banner_size AS storefront_banner_size_20, s0_.storefront_banner_title AS storefront_banner_title_21, s0_.storefront_banner_text AS storefront_banner_text_22, s0_.storefront_banner_link_label AS storefront_banner_link_label_23, s0_.storefront_banner_link_url AS storefront_banner_link_url_24, s0_.default_margin_percent AS default_margin_percent_25, s0_.storefront_show_featured_products AS storefront_show_featured_products_26, s0_.storefront_show_branches AS storefront_show_branches_27, s0_.storefront_show_reviews AS storefront_show_reviews_28, s0_.storefront_show_certificates AS storefront_show_certificates_29, s0_.storefront_show_blog AS storefront_show_blog_30, s0_.flat_rate_farmer AS flat_rate_farmer_31, s0_.vat_rr_account_number AS vat_rr_account_number_32, s0_.scheduled_default_margin_percent AS scheduled_default_margin_percent_33, s0_.scheduled_default_margin_effective_at AS scheduled_default_margin_effective_at_34, s0_.scheduled_default_margin_notification_sent_at AS scheduled_default_margin_notification_sent_at_35, s0_.created_at AS created_at_36, s0_.updated_at AS updated_at_37, s0_.profile_id AS profile_id_38, s0_.account_manager_id AS account_manager_id_39 FROM supplier s0_ INNER JOIN product p1_ ON s0_.id = p1_.supplier_id WHERE p1_.supplier_id = s0_.id AND s0_.active = 1 AND s0_.terms_suspended = 0 AND p1_.category_id IN (?) AND p1_.status = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#517
      -unwrapped: null
      -uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
      uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
    }
    2 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#659}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.icon AS icon_1, p0_.background_color AS background_color_2, p0_.tag AS tag_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, COUNT(p0_.id) AS sclr_6 FROM product_tag p0_ INNER JOIN product_product_tag p2_ ON p0_.id = p2_.product_tag_id INNER JOIN product p1_ ON p1_.id = p2_.product_id WHERE p1_.category_id IN (?) GROUP BY p0_.id, p0_.icon, p0_.background_color, p0_.tag, p0_.created_at, p0_.updated_at ORDER BY sclr_6 DESC LIMIT 14"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#517
      -unwrapped: null
      -uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
      uuid: "a5ee80fd-4413-4b3f-9f85-2af89a6f001b"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.target_url AS target_url_2, s0_.notes AS notes_3, s0_.status AS status_4, s0_.ordered_units AS ordered_units_5, s0_.starts_at AS starts_at_6, s0_.ends_at AS ends_at_7, s0_.impressions_limit AS impressions_limit_8, s0_.impressions_count AS impressions_count_9, s0_.clicks_count AS clicks_count_10, s0_.admin_notes AS admin_notes_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.quoted_price_amount AS quoted_price_amount_14, s0_.quoted_price_currency_code AS quoted_price_currency_code_15, s0_.agreed_unit_price_amount AS agreed_unit_price_amount_16, s0_.agreed_unit_price_currency_code AS agreed_unit_price_currency_code_17, s1_.id AS id_18, s1_.name AS name_19, s1_.slug AS slug_20, s1_.active AS active_21, s1_.terms_suspended AS terms_suspended_22, s1_.banned AS banned_23, s1_.ban_reason AS ban_reason_24, s1_.banned_at AS banned_at_25, s1_.average_rate_review AS average_rate_review_26, s1_.description AS description_27, s1_.storefront_headline AS storefront_headline_28, s1_.storefront_intro AS storefront_intro_29, s1_.storefront_accent_color AS storefront_accent_color_30, s1_.store_subdomain AS store_subdomain_31, s1_.store_subdomain_active AS store_subdomain_active_32, s1_.logo_name AS logo_name_33, s1_.logo_size AS logo_size_34, s1_.cover_name AS cover_name_35, s1_.cover_size AS cover_size_36, s1_.storefront_banner_name AS storefront_banner_name_37, s1_.storefront_banner_size AS storefront_banner_size_38, s1_.storefront_banner_title AS storefront_banner_title_39, s1_.storefront_banner_text AS storefront_banner_text_40, s1_.storefront_banner_link_label AS storefront_banner_link_label_41, s1_.storefront_banner_link_url AS storefront_banner_link_url_42, s1_.default_margin_percent AS default_margin_percent_43, s1_.storefront_show_featured_products AS storefront_show_featured_products_44, s1_.storefront_show_branches AS storefront_show_branches_45, s1_.storefront_show_reviews AS storefront_show_reviews_46, s1_.storefront_show_certificates AS storefront_show_certificates_47, s1_.storefront_show_blog AS storefront_show_blog_48, s1_.flat_rate_farmer AS flat_rate_farmer_49, s1_.vat_rr_account_number AS vat_rr_account_number_50, s1_.scheduled_default_margin_percent AS scheduled_default_margin_percent_51, s1_.scheduled_default_margin_effective_at AS scheduled_default_margin_effective_at_52, s1_.scheduled_default_margin_notification_sent_at AS scheduled_default_margin_notification_sent_at_53, s1_.created_at AS created_at_54, s1_.updated_at AS updated_at_55, a2_.id AS id_56, a2_.name AS name_57, a2_.code AS code_58, a2_.type AS type_59, a2_.billing_model AS billing_model_60, a2_.description AS description_61, a2_.asset_guidelines AS asset_guidelines_62, a2_.active AS active_63, a2_.sort_order AS sort_order_64, a2_.minimum_units AS minimum_units_65, a2_.default_units AS default_units_66, a2_.created_at AS created_at_67, a2_.updated_at AS updated_at_68, a2_.unit_price_amount AS unit_price_amount_69, a2_.unit_price_currency_code AS unit_price_currency_code_70, p3_.id AS id_71, p3_.name AS name_72, p3_.slug AS slug_73, p3_.ean AS ean_74, p3_.description AS description_75, p3_.composition AS composition_76, p3_.status AS status_77, p3_.product_code AS product_code_78, p3_.flags AS flags_79, p3_.weight AS weight_80, p3_.average_rate_review AS average_rate_review_81, p3_.bought AS bought_82, p3_.availability_in_days AS availability_in_days_83, p3_.availability_mode AS availability_mode_84, p3_.available_from_date AS available_from_date_85, p3_.availability_delivery_weekdays_mask AS availability_delivery_weekdays_mask_86, p3_.can_send AS can_send_87, p3_.can_send_ue AS can_send_ue_88, p3_.can_send_outside_ue AS can_send_outside_ue_89, p3_.energy_kcal AS energy_kcal_90, p3_.fat AS fat_91, p3_.saturated_fat AS saturated_fat_92, p3_.carbohydrates AS carbohydrates_93, p3_.sugars AS sugars_94, p3_.protein AS protein_95, p3_.salt AS salt_96, p3_.origin_country_code AS origin_country_code_97, p3_.on_promotion AS on_promotion_98, p3_.banned AS banned_99, p3_.ban_reason AS ban_reason_100, p3_.accepted AS accepted_101, p3_.created_at AS created_at_102, p3_.updated_at AS updated_at_103, p3_.supplier_netto_amount AS supplier_netto_amount_104, p3_.supplier_netto_currency_code AS supplier_netto_currency_code_105, p3_.supplier_brutto_amount AS supplier_brutto_amount_106, p3_.supplier_brutto_currency_code AS supplier_brutto_currency_code_107, p3_.promo_brutto_amount AS promo_brutto_amount_108, p3_.promo_brutto_currency_code AS promo_brutto_currency_code_109, p3_.promo_netto_amount AS promo_netto_amount_110, p3_.promo_netto_currency_code AS promo_netto_currency_code_111, p3_.netto_price_amount AS netto_price_amount_112, p3_.netto_price_currency_code AS netto_price_currency_code_113, p3_.brutto_price_amount AS brutto_price_amount_114, p3_.brutto_price_currency_code AS brutto_price_currency_code_115, c4_.id AS id_116, c4_.position AS position_117, c4_.name AS name_118, c4_.active AS active_119, c4_.slug AS slug_120, c4_.promoted AS promoted_121, c4_.image_path AS image_path_122, c4_.active_product_count AS active_product_count_123, c4_.created_at AS created_at_124, c4_.updated_at AS updated_at_125, s0_.supplier_id AS supplier_id_126, s0_.placement_id AS placement_id_127, s0_.requested_by_id AS requested_by_id_128, s0_.target_product_id AS target_product_id_129, s0_.target_category_id AS target_category_id_130, s1_.profile_id AS profile_id_131, s1_.account_manager_id AS account_manager_id_132, p3_.category_id AS category_id_133, p3_.supplier_id AS supplier_id_134, p3_.tax_id AS tax_id_135, c4_.parent_id AS parent_id_136 FROM supplier_advertising_campaign s0_ LEFT JOIN supplier s1_ ON s0_.supplier_id = s1_.id LEFT JOIN advertising_placement a2_ ON s0_.placement_id = a2_.id LEFT JOIN product p3_ ON s0_.target_product_id = p3_.id LEFT JOIN category c4_ ON s0_.target_category_id = c4_.id WHERE s0_.status = ? AND ((s0_.starts_at IS NULL OR s0_.starts_at <= ?)) AND ((s0_.ends_at IS NULL OR s0_.ends_at >= ?)) AND a2_.type = ? ORDER BY s0_.created_at DESC"
  "params" => [
    1 => "active"
    2 => "2026-10-19 14:52:45"
    3 => "2026-10-19 14:52:45"
    4 => "category_top_banner"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#659}
    3 => Doctrine\DBAL\ParameterType {#659}
    4 => Doctrine\DBAL\ParameterType {#659}
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.target_url AS target_url_2, s0_.notes AS notes_3, s0_.status AS status_4, s0_.ordered_units AS ordered_units_5, s0_.starts_at AS starts_at_6, s0_.ends_at AS ends_at_7, s0_.impressions_limit AS impressions_limit_8, s0_.impressions_count AS impressions_count_9, s0_.clicks_count AS clicks_count_10, s0_.admin_notes AS admin_notes_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.quoted_price_amount AS quoted_price_amount_14, s0_.quoted_price_currency_code AS quoted_price_currency_code_15, s0_.agreed_unit_price_amount AS agreed_unit_price_amount_16, s0_.agreed_unit_price_currency_code AS agreed_unit_price_currency_code_17, s1_.id AS id_18, s1_.name AS name_19, s1_.slug AS slug_20, s1_.active AS active_21, s1_.terms_suspended AS terms_suspended_22, s1_.banned AS banned_23, s1_.ban_reason AS ban_reason_24, s1_.banned_at AS banned_at_25, s1_.average_rate_review AS average_rate_review_26, s1_.description AS description_27, s1_.storefront_headline AS storefront_headline_28, s1_.storefront_intro AS storefront_intro_29, s1_.storefront_accent_color AS storefront_accent_color_30, s1_.store_subdomain AS store_subdomain_31, s1_.store_subdomain_active AS store_subdomain_active_32, s1_.logo_name AS logo_name_33, s1_.logo_size AS logo_size_34, s1_.cover_name AS cover_name_35, s1_.cover_size AS cover_size_36, s1_.storefront_banner_name AS storefront_banner_name_37, s1_.storefront_banner_size AS storefront_banner_size_38, s1_.storefront_banner_title AS storefront_banner_title_39, s1_.storefront_banner_text AS storefront_banner_text_40, s1_.storefront_banner_link_label AS storefront_banner_link_label_41, s1_.storefront_banner_link_url AS storefront_banner_link_url_42, s1_.default_margin_percent AS default_margin_percent_43, s1_.storefront_show_featured_products AS storefront_show_featured_products_44, s1_.storefront_show_branches AS storefront_show_branches_45, s1_.storefront_show_reviews AS storefront_show_reviews_46, s1_.storefront_show_certificates AS storefront_show_certificates_47, s1_.storefront_show_blog AS storefront_show_blog_48, s1_.flat_rate_farmer AS flat_rate_farmer_49, s1_.vat_rr_account_number AS vat_rr_account_number_50, s1_.scheduled_default_margin_percent AS scheduled_default_margin_percent_51, s1_.scheduled_default_margin_effective_at AS scheduled_default_margin_effective_at_52, s1_.scheduled_default_margin_notification_sent_at AS scheduled_default_margin_notification_sent_at_53, s1_.created_at AS created_at_54, s1_.updated_at AS updated_at_55, a2_.id AS id_56, a2_.name AS name_57, a2_.code AS code_58, a2_.type AS type_59, a2_.billing_model AS billing_model_60, a2_.description AS description_61, a2_.asset_guidelines AS asset_guidelines_62, a2_.active AS active_63, a2_.sort_order AS sort_order_64, a2_.minimum_units AS minimum_units_65, a2_.default_units AS default_units_66, a2_.created_at AS created_at_67, a2_.updated_at AS updated_at_68, a2_.unit_price_amount AS unit_price_amount_69, a2_.unit_price_currency_code AS unit_price_currency_code_70, p3_.id AS id_71, p3_.name AS name_72, p3_.slug AS slug_73, p3_.ean AS ean_74, p3_.description AS description_75, p3_.composition AS composition_76, p3_.status AS status_77, p3_.product_code AS product_code_78, p3_.flags AS flags_79, p3_.weight AS weight_80, p3_.average_rate_review AS average_rate_review_81, p3_.bought AS bought_82, p3_.availability_in_days AS availability_in_days_83, p3_.availability_mode AS availability_mode_84, p3_.available_from_date AS available_from_date_85, p3_.availability_delivery_weekdays_mask AS availability_delivery_weekdays_mask_86, p3_.can_send AS can_send_87, p3_.can_send_ue AS can_send_ue_88, p3_.can_send_outside_ue AS can_send_outside_ue_89, p3_.energy_kcal AS energy_kcal_90, p3_.fat AS fat_91, p3_.saturated_fat AS saturated_fat_92, p3_.carbohydrates AS carbohydrates_93, p3_.sugars AS sugars_94, p3_.protein AS protein_95, p3_.salt AS salt_96, p3_.origin_country_code AS origin_country_code_97, p3_.on_promotion AS on_promotion_98, p3_.banned AS banned_99, p3_.ban_reason AS ban_reason_100, p3_.accepted AS accepted_101, p3_.created_at AS created_at_102, p3_.updated_at AS updated_at_103, p3_.supplier_netto_amount AS supplier_netto_amount_104, p3_.supplier_netto_currency_code AS supplier_netto_currency_code_105, p3_.supplier_brutto_amount AS supplier_brutto_amount_106, p3_.supplier_brutto_currency_code AS supplier_brutto_currency_code_107, p3_.promo_brutto_amount AS promo_brutto_amount_108, p3_.promo_brutto_currency_code AS promo_brutto_currency_code_109, p3_.promo_netto_amount AS promo_netto_amount_110, p3_.promo_netto_currency_code AS promo_netto_currency_code_111, p3_.netto_price_amount AS netto_price_amount_112, p3_.netto_price_currency_code AS netto_price_currency_code_113, p3_.brutto_price_amount AS brutto_price_amount_114, p3_.brutto_price_currency_code AS brutto_price_currency_code_115, c4_.id AS id_116, c4_.position AS position_117, c4_.name AS name_118, c4_.active AS active_119, c4_.slug AS slug_120, c4_.promoted AS promoted_121, c4_.image_path AS image_path_122, c4_.active_product_count AS active_product_count_123, c4_.created_at AS created_at_124, c4_.updated_at AS updated_at_125, s0_.supplier_id AS supplier_id_126, s0_.placement_id AS placement_id_127, s0_.requested_by_id AS requested_by_id_128, s0_.target_product_id AS target_product_id_129, s0_.target_category_id AS target_category_id_130, s1_.profile_id AS profile_id_131, s1_.account_manager_id AS account_manager_id_132, p3_.category_id AS category_id_133, p3_.supplier_id AS supplier_id_134, p3_.tax_id AS tax_id_135, c4_.parent_id AS parent_id_136 FROM supplier_advertising_campaign s0_ LEFT JOIN supplier s1_ ON s0_.supplier_id = s1_.id LEFT JOIN advertising_placement a2_ ON s0_.placement_id = a2_.id LEFT JOIN product p3_ ON s0_.target_product_id = p3_.id LEFT JOIN category c4_ ON s0_.target_category_id = c4_.id WHERE s0_.status = ? AND ((s0_.starts_at IS NULL OR s0_.starts_at <= ?)) AND ((s0_.ends_at IS NULL OR s0_.ends_at >= ?)) AND a2_.type = ? ORDER BY s0_.created_at DESC"
  "params" => [
    1 => "active"
    2 => "2026-10-19 14:52:45"
    3 => "2026-10-19 14:52:45"
    4 => "category_featured_product"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#659}
    3 => Doctrine\DBAL\ParameterType {#659}
    4 => Doctrine\DBAL\ParameterType {#659}
  ]
]

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

[
  "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\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" => "App\EventListener\Supplier\SupplierStorefrontHostRedirectListener::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.request"
  "listener" => "App\EventListener\DeliveryFilterEnablerListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\ForcedSessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\Product\ProductAddListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\User\ZipCodeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\Supplier\SupplierBanRequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\LegalAcceptanceRequestListener::__invoke"
]

[
  "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\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "App\EventListener\Audit\HttpAuditListener::onController"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.name AS name_2, c0_.active AS active_3, c0_.slug AS slug_4, c0_.promoted AS promoted_5, c0_.image_path AS image_path_6, c0_.active_product_count AS active_product_count_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.parent_id AS parent_id_10 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.active = ? ORDER BY c0_.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2361
      +name: "BOOLEAN"
    }
  ]
]

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

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\Audit\HttpAuditListener::onResponse"
]

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

[
  "sql" => "SELECT COUNT(c0_.id) AS sclr_0 FROM cart c1_ LEFT JOIN cart_item c0_ ON c1_.id = c0_.cart_id WHERE c1_.session_id = ?"
  "params" => [
    1 => "b8f141fbd981ed5090092347c529036f"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#659
      +name: "STRING"
    }
  ]
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::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" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\Audit\HttpAuditListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

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

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

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

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