Symfony Profiler

[
  "route" => "product_category_show"
  "route_parameters" => [
    "_route" => "product_category_show"
    "subcategorySlug" => null
    "_controller" => "App\Controller\ProductCategoryController::aboutUs"
    "slug" => "dulces-y-desayuno"
  ]
  "request_uri" => "https://pre-app.triwuu.com/category/dulces-y-desayuno"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppGoogleAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppGoogleAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppFacebookAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppFacebookAuthenticator"
]

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

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

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

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

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\LocaleSubscriber::onKernelRequest"
]

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Stof\DoctrineExtensionsBundle\EventListener\BlameListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Stof\DoctrineExtensionsBundle\EventListener\LocaleListener::onKernelRequest"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_pgsql"
    "host" => "localhost"
    "port" => 5432
    "user" => "triwuu"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "preapp"
    "serverVersion" => "14"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.active AS active_3, t0.featured AS featured_4, t0.homepage_order AS homepage_order_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.icon_id AS icon_id_10 FROM category t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "dulces-y-desayuno"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.is_draft AS is_draft_2, p0_.is_blocked AS is_blocked_3, p0_.is_sold_out AS is_sold_out_4, p0_.weight AS weight_5, p0_.width AS width_6, p0_.length AS length_7, p0_.height AS height_8, p0_.volumetric_weight AS volumetric_weight_9, p0_.units_per_box AS units_per_box_10, p0_.units_per_box_grouped AS units_per_box_grouped_11, p0_.hide_discount AS hide_discount_12, p0_.ean AS ean_13, p0_.purchase_order_number AS purchase_order_number_14, p0_.is_mandatory_product_features AS is_mandatory_product_features_15, p0_.is_mandatory_producer AS is_mandatory_producer_16, p0_.is_mandatory_triweer_list AS is_mandatory_triweer_list_17, p0_.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_18, p0_.is_live_shopping AS is_live_shopping_19, p0_.has_blockchain_traceability AS has_blockchain_traceability_20, p0_.show_on_wall AS show_on_wall_21, p0_.allow_return AS allow_return_22, p0_.n_days_allowed_for_return AS n_days_allowed_for_return_23, p0_.send_notifications AS send_notifications_24, p0_.producer_purchase_order_number AS producer_purchase_order_number_25, p0_.limit_units_per_buyer AS limit_units_per_buyer_26, p0_.limit_units_to_sell AS limit_units_to_sell_27, p0_.coming_soon_date AS coming_soon_date_28, p0_.offer_launch_date AS offer_launch_date_29, p0_.countdown_date AS countdown_date_30, p0_.end_offer_date AS end_offer_date_31, p0_.shipping_date AS shipping_date_32, p0_.individual_shipping_duration AS individual_shipping_duration_33, p0_.shared_shipping_duration AS shared_shipping_duration_34, p0_.individual_package_format AS individual_package_format_35, p0_.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_36, p0_.max_coins_to_spent AS max_coins_to_spent_37, p0_.original_price AS original_price_38, p0_.individual_price AS individual_price_39, p0_.individual_disabled AS individual_disabled_40, p0_.fake_users AS fake_users_41, p0_.additional_info AS additional_info_42, p0_.shipping_cost AS shipping_cost_43, p0_.holded_id AS holded_id_44, p0_.only_adults AS only_adults_45, p0_.amount_for_free_shipping AS amount_for_free_shipping_46, p0_.better_price AS better_price_47, p0_.meta_title AS meta_title_48, p0_.meta_description AS meta_description_49, p0_.show_price AS show_price_50, p0_.created_by AS created_by_51, p0_.updated_by AS updated_by_52, p0_.created_at AS created_at_53, p0_.updated_at AS updated_at_54, p0_.type_id AS type_id_55, p0_.iva_id AS iva_id_56, p0_.brand_id AS brand_id_57, p0_.producer_id AS producer_id_58, p0_.unit_measurement_id AS unit_measurement_id_59, p0_.product_unique_id AS product_unique_id_60, p0_.shipping_id AS shipping_id_61 FROM product p0_ LEFT JOIN product_price_scale p1_ ON p0_.id = p1_.product_id LEFT JOIN product_translation p2_ ON p0_.id = p2_.translatable_id INNER JOIN product_category p4_ ON p0_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id WHERE p0_.show_on_wall = true AND p0_.is_draft = false AND p0_.is_blocked = false AND p0_.is_sold_out = false AND ((? BETWEEN p0_.offer_launch_date AND p0_.end_offer_date)) AND c3_.id IN (?) ORDER BY p0_.end_offer_date ASC"
  "params" => [
    1 => "2024-12-28 15:16:25"
    2 => 26
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.active AS active_2, c0_.featured AS featured_3, c0_.homepage_order AS homepage_order_4, c0_.created_by AS created_by_5, c0_.updated_by AS updated_by_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, s1_.id AS id_9, s1_.slug AS slug_10, s1_.active AS active_11, s1_.featured AS featured_12, s1_.homepage_order AS homepage_order_13, s1_.created_by AS created_by_14, s1_.updated_by AS updated_by_15, s1_.created_at AS created_at_16, s1_.updated_at AS updated_at_17, c0_.icon_id AS icon_id_18, s1_.category_id AS category_id_19, s1_.icon_id AS icon_id_20 FROM category c2_ LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id, category c0_ LEFT JOIN subcategory s1_ ON c0_.id = s1_.category_id WHERE c0_.active = true AND (s1_.active = true OR s1_.id IS NULL) ORDER BY c0_.homepage_order ASC, s1_.homepage_order ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 32
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 30
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 29
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.save_card AS save_card_1, o0_.shipping_cost AS shipping_cost_2, o0_.final_shipping_cost AS final_shipping_cost_3, o0_.shipping_address AS shipping_address_4, o0_.shared_address_order_id AS shared_address_order_id_5, o0_.shipping_postal_code AS shipping_postal_code_6, o0_.shipping_city AS shipping_city_7, o0_.shipping_country AS shipping_country_8, o0_.billing_address AS billing_address_9, o0_.billing_postal_code AS billing_postal_code_10, o0_.billing_city AS billing_city_11, o0_.billing_country AS billing_country_12, o0_.billing_country_iso_code2 AS billing_country_iso_code2_13, o0_.total_amount AS total_amount_14, o0_.holded_id AS holded_id_15, o0_.phone AS phone_16, o0_.need_bill AS need_bill_17, o0_.cif AS cif_18, o0_.shipping_province AS shipping_province_19, o0_.shipping_country_iso AS shipping_country_iso_20, o0_.delivery_method AS delivery_method_21, o0_.created_by AS created_by_22, o0_.updated_by AS updated_by_23, o0_.created_at AS created_at_24, o0_.updated_at AS updated_at_25, o1_.id AS id_26, o1_.quantity AS quantity_27, o1_.original_price AS original_price_28, o1_.final_price AS final_price_29, o1_.iva_percentage AS iva_percentage_30, o1_.buy_not_enought AS buy_not_enought_31, o1_.better_price AS better_price_32, o1_.is_individual_purchase AS is_individual_purchase_33, o1_.created_by AS created_by_34, o1_.updated_by AS updated_by_35, o1_.created_at AS created_at_36, o1_.updated_at AS updated_at_37, p2_.id AS id_38, p2_.slug AS slug_39, p2_.is_draft AS is_draft_40, p2_.is_blocked AS is_blocked_41, p2_.is_sold_out AS is_sold_out_42, p2_.weight AS weight_43, p2_.width AS width_44, p2_.length AS length_45, p2_.height AS height_46, p2_.volumetric_weight AS volumetric_weight_47, p2_.units_per_box AS units_per_box_48, p2_.units_per_box_grouped AS units_per_box_grouped_49, p2_.hide_discount AS hide_discount_50, p2_.ean AS ean_51, p2_.purchase_order_number AS purchase_order_number_52, p2_.is_mandatory_product_features AS is_mandatory_product_features_53, p2_.is_mandatory_producer AS is_mandatory_producer_54, p2_.is_mandatory_triweer_list AS is_mandatory_triweer_list_55, p2_.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_56, p2_.is_live_shopping AS is_live_shopping_57, p2_.has_blockchain_traceability AS has_blockchain_traceability_58, p2_.show_on_wall AS show_on_wall_59, p2_.allow_return AS allow_return_60, p2_.n_days_allowed_for_return AS n_days_allowed_for_return_61, p2_.send_notifications AS send_notifications_62, p2_.producer_purchase_order_number AS producer_purchase_order_number_63, p2_.limit_units_per_buyer AS limit_units_per_buyer_64, p2_.limit_units_to_sell AS limit_units_to_sell_65, p2_.coming_soon_date AS coming_soon_date_66, p2_.offer_launch_date AS offer_launch_date_67, p2_.countdown_date AS countdown_date_68, p2_.end_offer_date AS end_offer_date_69, p2_.shipping_date AS shipping_date_70, p2_.individual_shipping_duration AS individual_shipping_duration_71, p2_.shared_shipping_duration AS shared_shipping_duration_72, p2_.individual_package_format AS individual_package_format_73, p2_.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_74, p2_.max_coins_to_spent AS max_coins_to_spent_75, p2_.original_price AS original_price_76, p2_.individual_price AS individual_price_77, p2_.individual_disabled AS individual_disabled_78, p2_.fake_users AS fake_users_79, p2_.additional_info AS additional_info_80, p2_.shipping_cost AS shipping_cost_81, p2_.holded_id AS holded_id_82, p2_.only_adults AS only_adults_83, p2_.amount_for_free_shipping AS amount_for_free_shipping_84, p2_.better_price AS better_price_85, p2_.meta_title AS meta_title_86, p2_.meta_description AS meta_description_87, p2_.show_price AS show_price_88, p2_.created_by AS created_by_89, p2_.updated_by AS updated_by_90, p2_.created_at AS created_at_91, p2_.updated_at AS updated_at_92, b3_.id AS id_93, b3_.name AS name_94, b3_.is_corporate AS is_corporate_95, b3_.corporate_contact_name AS corporate_contact_name_96, b3_.corporate_contact_email AS corporate_contact_email_97, b3_.corporate_name AS corporate_name_98, b3_.corporate_vat_number AS corporate_vat_number_99, b3_.whitelisted_domains AS whitelisted_domains_100, b3_.description AS description_101, b3_.members_can_invite AS members_can_invite_102, b3_.free_shipping AS free_shipping_103, b3_.open_group AS open_group_104, b3_.created_by AS created_by_105, b3_.updated_by AS updated_by_106, b3_.created_at AS created_at_107, b3_.updated_at AS updated_at_108, m4_.id AS id_109, m4_.filename AS filename_110, m4_.size AS size_111, m4_.mimetype AS mimetype_112, m4_.original_name AS original_name_113, m4_.position AS position_114, m4_.directory AS directory_115, m4_.active AS active_116, m4_.created_at AS created_at_117, m4_.updated_at AS updated_at_118, m4_.created_by AS created_by_119, m4_.updated_by AS updated_by_120 FROM "order" o0_ INNER JOIN order_detail o1_ ON o0_.id = o1_.header_id INNER JOIN product p2_ ON o1_.product_id = p2_.id INNER JOIN buying_group b3_ ON o0_.buying_group_id = b3_.id INNER JOIN media m4_ ON b3_.image_id = m4_.id INNER JOIN order_status o5_ ON o0_.status_id = o5_.id WHERE p2_.is_draft = false AND p2_.is_blocked = false AND p2_.end_offer_date >= ? AND (o5_.key = ? OR o5_.key = ?) AND ((p2_.end_offer_date < ? AND (p2_.end_offer_date + (1 || ' HOUR')::interval) > ?) OR p2_.is_sold_out = false)"
  "params" => [
    1 => "2024-12-28 15:16:26"
    2 => "MONEY_WITHHELD"
    3 => "BANK_TRANSFER"
    4 => "2024-12-28 15:16:26"
    5 => "2024-12-28 15:16:26"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "KEY" => "meta_title_default"
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.description AS description_1, o0_.key AS key_2, o0_.value AS value_3, o0_.created_by AS created_by_4, o0_.updated_by AS updated_by_5, o0_.created_at AS created_at_6, o0_.updated_at AS updated_at_7 FROM option o0_ WHERE o0_.key = ?"
  "params" => [
    1 => "meta_title_default"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "KEY" => "meta_description_default"
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.description AS description_1, o0_.key AS key_2, o0_.value AS value_3, o0_.created_by AS created_by_4, o0_.updated_by AS updated_by_5, o0_.created_at AS created_at_6, o0_.updated_at AS updated_at_7 FROM option o0_ WHERE o0_.key = ?"
  "params" => [
    1 => "meta_description_default"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.active AS active_2, c0_.featured AS featured_3, c0_.homepage_order AS homepage_order_4, c0_.created_by AS created_by_5, c0_.updated_by AS updated_by_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.icon_id AS icon_id_9 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.translatable_id WHERE c0_.active = true ORDER BY c0_.homepage_order ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 28
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.visible AS visible_2, r0_.created_by AS created_by_3, r0_.updated_by AS updated_by_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.user_id AS user_id_7, r0_.product_id AS product_id_8 FROM review r0_ WHERE r0_.product_id IS NULL AND r0_.visible = ? ORDER BY r0_.created_at DESC LIMIT 10"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.nickname AS nickname_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6, t0.is_on_boarding AS is_on_boarding_7, t0.accepted_communications AS accepted_communications_8, t0.accepted_policies AS accepted_policies_9, t0.is_active AS is_active_10, t0.legal_age AS legal_age_11, t0.is_notifications_active AS is_notifications_active_12, t0.is_verified AS is_verified_13, t0.name AS name_14, t0.surname AS surname_15, t0.cif AS cif_16, t0.phone AS phone_17, t0.cpostal AS cpostal_18, t0.sex AS sex_19, t0.holded_id AS holded_id_20, t0.notification_whatsapp AS notification_whatsapp_21, t0.email_token AS email_token_22, t0.email_token_expires_at AS email_token_expires_at_23, t0.birthday AS birthday_24, t0.bank_transfer_active AS bank_transfer_active_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.avatar_id AS avatar_id_30, t31.id AS id_32, t31.save_card AS save_card_33, t31.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_34, t31.delivery_method AS delivery_method_35, t31.use_coins AS use_coins_36, t31.payment_method AS payment_method_37, t31.phone AS phone_38, t31.need_bill AS need_bill_39, t31.cif AS cif_40, t31.buy_not_enought AS buy_not_enought_41, t31.better_price AS better_price_42, t31.is_individual_purchase AS is_individual_purchase_43, t31.created_by AS created_by_44, t31.updated_by AS updated_by_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.buyer_id AS buyer_id_48, t31.card_id AS card_id_49, t31.shipping_address_entity_id AS shipping_address_entity_id_50, t31.buying_group_entity_id AS buying_group_entity_id_51, t31.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_52, t31.billing_address_entity_id AS billing_address_entity_id_53, t0.share_favourite_products_type_id AS share_favourite_products_type_id_54, t0.share_shopping_type_id AS share_shopping_type_id_55, t0.language_id AS language_id_56, t0.payment_method_id AS payment_method_id_57 FROM "user" t0 LEFT JOIN shopping_cart t31 ON t31.buyer_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 287
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.comment AS comment_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM review_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.nickname AS nickname_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6, t0.is_on_boarding AS is_on_boarding_7, t0.accepted_communications AS accepted_communications_8, t0.accepted_policies AS accepted_policies_9, t0.is_active AS is_active_10, t0.legal_age AS legal_age_11, t0.is_notifications_active AS is_notifications_active_12, t0.is_verified AS is_verified_13, t0.name AS name_14, t0.surname AS surname_15, t0.cif AS cif_16, t0.phone AS phone_17, t0.cpostal AS cpostal_18, t0.sex AS sex_19, t0.holded_id AS holded_id_20, t0.notification_whatsapp AS notification_whatsapp_21, t0.email_token AS email_token_22, t0.email_token_expires_at AS email_token_expires_at_23, t0.birthday AS birthday_24, t0.bank_transfer_active AS bank_transfer_active_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.avatar_id AS avatar_id_30, t31.id AS id_32, t31.save_card AS save_card_33, t31.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_34, t31.delivery_method AS delivery_method_35, t31.use_coins AS use_coins_36, t31.payment_method AS payment_method_37, t31.phone AS phone_38, t31.need_bill AS need_bill_39, t31.cif AS cif_40, t31.buy_not_enought AS buy_not_enought_41, t31.better_price AS better_price_42, t31.is_individual_purchase AS is_individual_purchase_43, t31.created_by AS created_by_44, t31.updated_by AS updated_by_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.buyer_id AS buyer_id_48, t31.card_id AS card_id_49, t31.shipping_address_entity_id AS shipping_address_entity_id_50, t31.buying_group_entity_id AS buying_group_entity_id_51, t31.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_52, t31.billing_address_entity_id AS billing_address_entity_id_53, t0.share_favourite_products_type_id AS share_favourite_products_type_id_54, t0.share_shopping_type_id AS share_shopping_type_id_55, t0.language_id AS language_id_56, t0.payment_method_id AS payment_method_id_57 FROM "user" t0 LEFT JOIN shopping_cart t31 ON t31.buyer_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.comment AS comment_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM review_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.nickname AS nickname_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6, t0.is_on_boarding AS is_on_boarding_7, t0.accepted_communications AS accepted_communications_8, t0.accepted_policies AS accepted_policies_9, t0.is_active AS is_active_10, t0.legal_age AS legal_age_11, t0.is_notifications_active AS is_notifications_active_12, t0.is_verified AS is_verified_13, t0.name AS name_14, t0.surname AS surname_15, t0.cif AS cif_16, t0.phone AS phone_17, t0.cpostal AS cpostal_18, t0.sex AS sex_19, t0.holded_id AS holded_id_20, t0.notification_whatsapp AS notification_whatsapp_21, t0.email_token AS email_token_22, t0.email_token_expires_at AS email_token_expires_at_23, t0.birthday AS birthday_24, t0.bank_transfer_active AS bank_transfer_active_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.avatar_id AS avatar_id_30, t31.id AS id_32, t31.save_card AS save_card_33, t31.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_34, t31.delivery_method AS delivery_method_35, t31.use_coins AS use_coins_36, t31.payment_method AS payment_method_37, t31.phone AS phone_38, t31.need_bill AS need_bill_39, t31.cif AS cif_40, t31.buy_not_enought AS buy_not_enought_41, t31.better_price AS better_price_42, t31.is_individual_purchase AS is_individual_purchase_43, t31.created_by AS created_by_44, t31.updated_by AS updated_by_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.buyer_id AS buyer_id_48, t31.card_id AS card_id_49, t31.shipping_address_entity_id AS shipping_address_entity_id_50, t31.buying_group_entity_id AS buying_group_entity_id_51, t31.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_52, t31.billing_address_entity_id AS billing_address_entity_id_53, t0.share_favourite_products_type_id AS share_favourite_products_type_id_54, t0.share_shopping_type_id AS share_shopping_type_id_55, t0.language_id AS language_id_56, t0.payment_method_id AS payment_method_id_57 FROM "user" t0 LEFT JOIN shopping_cart t31 ON t31.buyer_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.comment AS comment_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM review_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.nickname AS nickname_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6, t0.is_on_boarding AS is_on_boarding_7, t0.accepted_communications AS accepted_communications_8, t0.accepted_policies AS accepted_policies_9, t0.is_active AS is_active_10, t0.legal_age AS legal_age_11, t0.is_notifications_active AS is_notifications_active_12, t0.is_verified AS is_verified_13, t0.name AS name_14, t0.surname AS surname_15, t0.cif AS cif_16, t0.phone AS phone_17, t0.cpostal AS cpostal_18, t0.sex AS sex_19, t0.holded_id AS holded_id_20, t0.notification_whatsapp AS notification_whatsapp_21, t0.email_token AS email_token_22, t0.email_token_expires_at AS email_token_expires_at_23, t0.birthday AS birthday_24, t0.bank_transfer_active AS bank_transfer_active_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.avatar_id AS avatar_id_30, t31.id AS id_32, t31.save_card AS save_card_33, t31.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_34, t31.delivery_method AS delivery_method_35, t31.use_coins AS use_coins_36, t31.payment_method AS payment_method_37, t31.phone AS phone_38, t31.need_bill AS need_bill_39, t31.cif AS cif_40, t31.buy_not_enought AS buy_not_enought_41, t31.better_price AS better_price_42, t31.is_individual_purchase AS is_individual_purchase_43, t31.created_by AS created_by_44, t31.updated_by AS updated_by_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.buyer_id AS buyer_id_48, t31.card_id AS card_id_49, t31.shipping_address_entity_id AS shipping_address_entity_id_50, t31.buying_group_entity_id AS buying_group_entity_id_51, t31.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_52, t31.billing_address_entity_id AS billing_address_entity_id_53, t0.share_favourite_products_type_id AS share_favourite_products_type_id_54, t0.share_shopping_type_id AS share_shopping_type_id_55, t0.language_id AS language_id_56, t0.payment_method_id AS payment_method_id_57 FROM "user" t0 LEFT JOIN shopping_cart t31 ON t31.buyer_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.comment AS comment_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM review_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.nickname AS nickname_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6, t0.is_on_boarding AS is_on_boarding_7, t0.accepted_communications AS accepted_communications_8, t0.accepted_policies AS accepted_policies_9, t0.is_active AS is_active_10, t0.legal_age AS legal_age_11, t0.is_notifications_active AS is_notifications_active_12, t0.is_verified AS is_verified_13, t0.name AS name_14, t0.surname AS surname_15, t0.cif AS cif_16, t0.phone AS phone_17, t0.cpostal AS cpostal_18, t0.sex AS sex_19, t0.holded_id AS holded_id_20, t0.notification_whatsapp AS notification_whatsapp_21, t0.email_token AS email_token_22, t0.email_token_expires_at AS email_token_expires_at_23, t0.birthday AS birthday_24, t0.bank_transfer_active AS bank_transfer_active_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.avatar_id AS avatar_id_30, t31.id AS id_32, t31.save_card AS save_card_33, t31.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_34, t31.delivery_method AS delivery_method_35, t31.use_coins AS use_coins_36, t31.payment_method AS payment_method_37, t31.phone AS phone_38, t31.need_bill AS need_bill_39, t31.cif AS cif_40, t31.buy_not_enought AS buy_not_enought_41, t31.better_price AS better_price_42, t31.is_individual_purchase AS is_individual_purchase_43, t31.created_by AS created_by_44, t31.updated_by AS updated_by_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.buyer_id AS buyer_id_48, t31.card_id AS card_id_49, t31.shipping_address_entity_id AS shipping_address_entity_id_50, t31.buying_group_entity_id AS buying_group_entity_id_51, t31.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_52, t31.billing_address_entity_id AS billing_address_entity_id_53, t0.share_favourite_products_type_id AS share_favourite_products_type_id_54, t0.share_shopping_type_id AS share_shopping_type_id_55, t0.language_id AS language_id_56, t0.payment_method_id AS payment_method_id_57 FROM "user" t0 LEFT JOIN shopping_cart t31 ON t31.buyer_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.comment AS comment_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM review_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.nickname AS nickname_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6, t0.is_on_boarding AS is_on_boarding_7, t0.accepted_communications AS accepted_communications_8, t0.accepted_policies AS accepted_policies_9, t0.is_active AS is_active_10, t0.legal_age AS legal_age_11, t0.is_notifications_active AS is_notifications_active_12, t0.is_verified AS is_verified_13, t0.name AS name_14, t0.surname AS surname_15, t0.cif AS cif_16, t0.phone AS phone_17, t0.cpostal AS cpostal_18, t0.sex AS sex_19, t0.holded_id AS holded_id_20, t0.notification_whatsapp AS notification_whatsapp_21, t0.email_token AS email_token_22, t0.email_token_expires_at AS email_token_expires_at_23, t0.birthday AS birthday_24, t0.bank_transfer_active AS bank_transfer_active_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.avatar_id AS avatar_id_30, t31.id AS id_32, t31.save_card AS save_card_33, t31.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_34, t31.delivery_method AS delivery_method_35, t31.use_coins AS use_coins_36, t31.payment_method AS payment_method_37, t31.phone AS phone_38, t31.need_bill AS need_bill_39, t31.cif AS cif_40, t31.buy_not_enought AS buy_not_enought_41, t31.better_price AS better_price_42, t31.is_individual_purchase AS is_individual_purchase_43, t31.created_by AS created_by_44, t31.updated_by AS updated_by_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.buyer_id AS buyer_id_48, t31.card_id AS card_id_49, t31.shipping_address_entity_id AS shipping_address_entity_id_50, t31.buying_group_entity_id AS buying_group_entity_id_51, t31.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_52, t31.billing_address_entity_id AS billing_address_entity_id_53, t0.share_favourite_products_type_id AS share_favourite_products_type_id_54, t0.share_shopping_type_id AS share_shopping_type_id_55, t0.language_id AS language_id_56, t0.payment_method_id AS payment_method_id_57 FROM "user" t0 LEFT JOIN shopping_cart t31 ON t31.buyer_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 202
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.comment AS comment_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM review_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SurrogateListener::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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

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

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

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

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

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

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

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

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

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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