Symfony Profiler

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "192.168.11.14"
    "port" => 3306
    "user" => "webdev_r"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "futon_apps2"
    "serverVersion" => "10.11.13-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.host AS host_2, d0_.theme_name AS theme_name_3, d0_.locale AS locale_4, d0_.currency AS currency_5, d0_.active AS active_6, d0_.is_default AS is_default_7, d0_.created_at AS created_at_8, d0_.updated_at AS updated_at_9, d0_.eshop_id AS eshop_id_10, d0_.default_currency_id AS default_currency_id_11, d0_.default_country_id AS default_country_id_12 FROM domain d0_ WHERE d0_.host = ? AND d0_.active = ?"
  "params" => [
    1 => "futon-at.cuba.cube-studio.cz"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1354
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.host AS host_2, d0_.theme_name AS theme_name_3, d0_.locale AS locale_4, d0_.currency AS currency_5, d0_.active AS active_6, d0_.is_default AS is_default_7, d0_.created_at AS created_at_8, d0_.updated_at AS updated_at_9, d0_.eshop_id AS eshop_id_10, d0_.default_currency_id AS default_currency_id_11, d0_.default_country_id AS default_country_id_12 FROM domain d0_ WHERE d0_.is_default = ? AND d0_.active = ?"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1354
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1354}
  ]
]

[
  "route" => "app_product_detail"
  "route_parameters" => [
    "_route" => "app_product_detail"
    "_controller" => "App\Controller\ProductController::show"
    "slug" => "patrova-postel-sendy-90x200"
  ]
  "request_uri" => "http://futon-at.cuba.cube-studio.cz/produkt/patrova-postel-sendy-90x200"
  "method" => "GET"
]

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

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

[
  "sql" => "SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.type AS type_2, p0_.model_id AS model_id_3, p0_.default_item_id AS default_item_id_4, p0_.position AS position_5, p0_.is_active AS is_active_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.product_id LEFT JOIN product_domain p2_ ON p0_.id = p2_.product_id WHERE (p1_.slug = ? OR p0_.code = ?) AND (p2_.domain_id = ? AND p2_.is_active = 1) LIMIT 1"
  "params" => [
    1 => "patrova-postel-sendy-90x200"
    2 => "patrova-postel-sendy-90x200"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1262}
    3 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2, t0.is_default AS is_default_3, t0.position AS position_4, t0.product_id AS product_id_5, t0.item_id AS item_id_6 FROM product_item t0 WHERE t0.product_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.model_id AS model_id_4, t0.default_item_id AS default_item_id_5, t0.position AS position_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 INNER JOIN product_related ON t0.id = product_related.related_product_id WHERE product_related.product_id = ?"
  "params" => [
    1 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.kind AS kind_3, t0.model_id AS model_id_4, t0.packaging AS packaging_5, t0.name AS name_6, t0.width_cm AS width_cm_7, t0.length_cm AS length_cm_8, t0.height_cm AS height_cm_9, t0.weight_kg AS weight_kg_10, t0.manufacturer_id AS manufacturer_id_11, t0.supplier_id AS supplier_id_12, t0.purchase_price AS purchase_price_13, t0.purchase_currency AS purchase_currency_14, t0.shipping_coefficient AS shipping_coefficient_15, t0.purchase_price_shipped AS purchase_price_shipped_16, t0.production_cost_czk AS production_cost_czk_17, t0.production_cost_eur AS production_cost_eur_18, t0.production_cost_list AS production_cost_list_19, t0.ft AS ft_20, t0.work_rate AS work_rate_21, t0.work_hours AS work_hours_22, t0.min_stock AS min_stock_23, t0.has_parts_in_list AS has_parts_in_list_24, t0.competitor_prices AS competitor_prices_25, t0.exceptions AS exceptions_26, t0.source AS source_27, t0.note AS note_28, t0.carrier AS carrier_29, t0.group_name AS group_name_30, t0.is_sold_separately AS is_sold_separately_31, t0.manual_url AS manual_url_32, t0.image_url AS image_url_33, t0.pohoda_stock AS pohoda_stock_34, t0.pohoda_reserved AS pohoda_reserved_35, t0.stock AS stock_36, t0.reserved AS reserved_37, t0.position AS position_38, t0.is_active AS is_active_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41 FROM item t0 WHERE t0.id = ?"
  "params" => [
    1 => 465
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.original_price AS original_price_3, t0.new_price AS new_price_4, t0.price_coefficient AS price_coefficient_5, t0.repriced_at AS repriced_at_6, t0.text_in_stock AS text_in_stock_7, t0.text_out_of_stock AS text_out_of_stock_8, t0.item_id AS item_id_9, t0.domain_id AS domain_id_10 FROM item_domain t0 WHERE t0.item_id = ?"
  "params" => [
    1 => 465
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.symbol AS symbol_4, t0.exchange_rate AS exchange_rate_5, t0.symbol_position AS symbol_position_6, t0.decimal_places AS decimal_places_7, t0.is_default AS is_default_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM currency t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.type AS type_4, t0.is_required AS is_required_5, t0.position AS position_6, t0.product_id AS product_id_7 FROM config_group t0 WHERE t0.product_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2, t0.is_default AS is_default_3, t0.position AS position_4, t0.product_id AS product_id_5, t0.item_id AS item_id_6 FROM product_item t0 WHERE t0.item_id = ? AND t0.role = ? LIMIT 1"
  "params" => [
    1 => 465
    2 => "frame_color"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.type AS type_3, c0_.is_required AS is_required_4, c0_.position AS position_5, c1_.id AS id_6, c1_.locale AS locale_7, c1_.name AS name_8, c2_.id AS id_9, c2_.code AS code_10, c2_.is_default AS is_default_11, c2_.is_included AS is_included_12, c2_.position AS position_13, i3_.id AS id_14, i3_.code AS code_15, i3_.kind AS kind_16, i3_.model_id AS model_id_17, i3_.packaging AS packaging_18, i3_.name AS name_19, i3_.width_cm AS width_cm_20, i3_.length_cm AS length_cm_21, i3_.height_cm AS height_cm_22, i3_.weight_kg AS weight_kg_23, i3_.manufacturer_id AS manufacturer_id_24, i3_.supplier_id AS supplier_id_25, i3_.purchase_price AS purchase_price_26, i3_.purchase_currency AS purchase_currency_27, i3_.shipping_coefficient AS shipping_coefficient_28, i3_.purchase_price_shipped AS purchase_price_shipped_29, i3_.production_cost_czk AS production_cost_czk_30, i3_.production_cost_eur AS production_cost_eur_31, i3_.production_cost_list AS production_cost_list_32, i3_.ft AS ft_33, i3_.work_rate AS work_rate_34, i3_.work_hours AS work_hours_35, i3_.min_stock AS min_stock_36, i3_.has_parts_in_list AS has_parts_in_list_37, i3_.competitor_prices AS competitor_prices_38, i3_.exceptions AS exceptions_39, i3_.source AS source_40, i3_.note AS note_41, i3_.carrier AS carrier_42, i3_.group_name AS group_name_43, i3_.is_sold_separately AS is_sold_separately_44, i3_.manual_url AS manual_url_45, i3_.image_url AS image_url_46, i3_.pohoda_stock AS pohoda_stock_47, i3_.pohoda_reserved AS pohoda_reserved_48, i3_.stock AS stock_49, i3_.reserved AS reserved_50, i3_.position AS position_51, i3_.is_active AS is_active_52, i3_.created_at AS created_at_53, i3_.updated_at AS updated_at_54, c4_.id AS id_55, c4_.code AS code_56, c4_.color_group AS color_group_57, c4_.hex AS hex_58, c4_.image_url AS image_url_59, c4_.position AS position_60, c4_.is_active AS is_active_61, c5_.position AS position_62, c6_.id AS id_63, c6_.code AS code_64, c6_.color_group AS color_group_65, c6_.hex AS hex_66, c6_.image_url AS image_url_67, c6_.position AS position_68, c6_.is_active AS is_active_69, c7_.id AS id_70, c7_.bundle_code AS bundle_code_71, c7_.quantity AS quantity_72, i8_.id AS id_73, i8_.code AS code_74, i8_.kind AS kind_75, i8_.model_id AS model_id_76, i8_.packaging AS packaging_77, i8_.name AS name_78, i8_.width_cm AS width_cm_79, i8_.length_cm AS length_cm_80, i8_.height_cm AS height_cm_81, i8_.weight_kg AS weight_kg_82, i8_.manufacturer_id AS manufacturer_id_83, i8_.supplier_id AS supplier_id_84, i8_.purchase_price AS purchase_price_85, i8_.purchase_currency AS purchase_currency_86, i8_.shipping_coefficient AS shipping_coefficient_87, i8_.purchase_price_shipped AS purchase_price_shipped_88, i8_.production_cost_czk AS production_cost_czk_89, i8_.production_cost_eur AS production_cost_eur_90, i8_.production_cost_list AS production_cost_list_91, i8_.ft AS ft_92, i8_.work_rate AS work_rate_93, i8_.work_hours AS work_hours_94, i8_.min_stock AS min_stock_95, i8_.has_parts_in_list AS has_parts_in_list_96, i8_.competitor_prices AS competitor_prices_97, i8_.exceptions AS exceptions_98, i8_.source AS source_99, i8_.note AS note_100, i8_.carrier AS carrier_101, i8_.group_name AS group_name_102, i8_.is_sold_separately AS is_sold_separately_103, i8_.manual_url AS manual_url_104, i8_.image_url AS image_url_105, i8_.pohoda_stock AS pohoda_stock_106, i8_.pohoda_reserved AS pohoda_reserved_107, i8_.stock AS stock_108, i8_.reserved AS reserved_109, i8_.position AS position_110, i8_.is_active AS is_active_111, i8_.created_at AS created_at_112, i8_.updated_at AS updated_at_113, c9_.id AS id_114, c9_.group_code AS group_code_115, c9_.group_name AS group_name_116, c9_.code AS code_117, c9_.name AS name_118, c9_.position AS position_119, c0_.product_id AS product_id_120, c1_.config_group_id AS config_group_id_121, c2_.config_group_id AS config_group_id_122, c2_.item_id AS item_id_123, c2_.color_id AS color_id_124, c5_.config_option_id AS config_option_id_125, c5_.color_id AS color_id_126, c7_.config_option_id AS config_option_id_127, c7_.item_id AS item_id_128, c10_.config_option_id AS config_option_id_129, c10_.config_tag_id AS config_tag_id_130, c9_.product_id AS product_id_131 FROM config_group c0_ LEFT JOIN config_group_translation c1_ ON c0_.id = c1_.config_group_id LEFT JOIN config_option c2_ ON c0_.id = c2_.config_group_id LEFT JOIN item i3_ ON c2_.item_id = i3_.id LEFT JOIN color c4_ ON c2_.color_id = c4_.id LEFT JOIN config_option_color c5_ ON c2_.id = c5_.config_option_id LEFT JOIN color c6_ ON c5_.color_id = c6_.id LEFT JOIN config_option_bundle c7_ ON c2_.id = c7_.config_option_id LEFT JOIN item i8_ ON c7_.item_id = i8_.id LEFT JOIN config_option_tag c10_ ON c2_.id = c10_.config_option_id LEFT JOIN config_tag c9_ ON c10_.config_tag_id = c9_.id WHERE c0_.product_id = ? ORDER BY c0_.position ASC, c2_.position ASC, c5_.position ASC"
  "params" => [
    1 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2, t0.is_default AS is_default_3, t0.position AS position_4, t0.product_id AS product_id_5, t0.item_id AS item_id_6 FROM product_item t0 WHERE t0.product_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 180
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.kind AS kind_3, t0.model_id AS model_id_4, t0.packaging AS packaging_5, t0.name AS name_6, t0.width_cm AS width_cm_7, t0.length_cm AS length_cm_8, t0.height_cm AS height_cm_9, t0.weight_kg AS weight_kg_10, t0.manufacturer_id AS manufacturer_id_11, t0.supplier_id AS supplier_id_12, t0.purchase_price AS purchase_price_13, t0.purchase_currency AS purchase_currency_14, t0.shipping_coefficient AS shipping_coefficient_15, t0.purchase_price_shipped AS purchase_price_shipped_16, t0.production_cost_czk AS production_cost_czk_17, t0.production_cost_eur AS production_cost_eur_18, t0.production_cost_list AS production_cost_list_19, t0.ft AS ft_20, t0.work_rate AS work_rate_21, t0.work_hours AS work_hours_22, t0.min_stock AS min_stock_23, t0.has_parts_in_list AS has_parts_in_list_24, t0.competitor_prices AS competitor_prices_25, t0.exceptions AS exceptions_26, t0.source AS source_27, t0.note AS note_28, t0.carrier AS carrier_29, t0.group_name AS group_name_30, t0.is_sold_separately AS is_sold_separately_31, t0.manual_url AS manual_url_32, t0.image_url AS image_url_33, t0.pohoda_stock AS pohoda_stock_34, t0.pohoda_reserved AS pohoda_reserved_35, t0.stock AS stock_36, t0.reserved AS reserved_37, t0.position AS position_38, t0.is_active AS is_active_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41 FROM item t0 WHERE t0.id = ?"
  "params" => [
    1 => 130
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.original_price AS original_price_3, t0.new_price AS new_price_4, t0.price_coefficient AS price_coefficient_5, t0.repriced_at AS repriced_at_6, t0.text_in_stock AS text_in_stock_7, t0.text_out_of_stock AS text_out_of_stock_8, t0.item_id AS item_id_9, t0.domain_id AS domain_id_10 FROM item_domain t0 WHERE t0.item_id = ?"
  "params" => [
    1 => 130
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.slug AS slug_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.feed_name AS feed_name_10, t0.feed_description AS feed_description_11, t0.feed_labels AS feed_labels_12, t0.feed_zbozi_description AS feed_zbozi_description_13, t0.feed_heureka_description AS feed_heureka_description_14, t0.option_name AS option_name_15, t0.option_cart_name AS option_cart_name_16, t0.option_description AS option_description_17, t0.product_id AS product_id_18 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 180
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.role AS role_3, t0.filename AS filename_4, t0.external_url AS external_url_5, t0.thumbnail AS thumbnail_6, t0.layer_key AS layer_key_7, t0.inherits_mattress_overlay AS inherits_mattress_overlay_8, t0.is_main AS is_main_9, t0.position AS position_10, t0.created_at AS created_at_11, t0.product_id AS product_id_12, t0.domain_id AS domain_id_13, t0.layer_item_id AS layer_item_id_14, t0.layer_color_id AS layer_color_id_15 FROM product_media t0 WHERE t0.product_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 180
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.setting_key AS setting_key_2, s0_.setting_value AS setting_value_3, s0_.type AS type_4, s0_.group_name AS group_name_5, s0_.description AS description_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.domain_id AS domain_id_9 FROM shop_settings s0_ WHERE s0_.setting_key = ? AND s0_.domain_id = ?"
  "params" => [
    1 => "gtm_container_id"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.setting_key AS setting_key_2, s0_.setting_value AS setting_value_3, s0_.type AS type_4, s0_.group_name AS group_name_5, s0_.description AS description_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.domain_id AS domain_id_9 FROM shop_settings s0_ WHERE s0_.setting_key = ? AND s0_.domain_id IS NULL"
  "params" => [
    1 => "gtm_container_id"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.slug AS slug_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.feed_name AS feed_name_10, t0.feed_description AS feed_description_11, t0.feed_labels AS feed_labels_12, t0.feed_zbozi_description AS feed_zbozi_description_13, t0.feed_heureka_description AS feed_heureka_description_14, t0.option_name AS option_name_15, t0.option_cart_name AS option_cart_name_16, t0.option_description AS option_description_17, t0.product_id AS product_id_18 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.placement AS placement_2, b0_.sklad_karta_kod AS sklad_karta_kod_3, b0_.sklad_model_kod AS sklad_model_kod_4, b0_.grid_position AS grid_position_5, b0_.position AS position_6, b0_.title AS title_7, b0_.subtitle AS subtitle_8, b0_.badge_text AS badge_text_9, b0_.button_text AS button_text_10, b0_.link_url AS link_url_11, b0_.target_blank AS target_blank_12, b0_.image AS image_13, b0_.background_color AS background_color_14, b0_.text_color AS text_color_15, b0_.valid_from AS valid_from_16, b0_.valid_to AS valid_to_17, b0_.is_active AS is_active_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.domain_id AS domain_id_21, b0_.category_id AS category_id_22, b0_.product_id AS product_id_23 FROM banners b0_ WHERE b0_.placement = ? AND b0_.is_active = 1 AND ((b0_.valid_from IS NULL OR b0_.valid_from <= ?)) AND ((b0_.valid_to IS NULL OR b0_.valid_to >= ?)) AND ((b0_.domain_id = ? OR b0_.domain_id IS NULL)) ORDER BY b0_.position ASC, b0_.id ASC"
  "params" => [
    1 => "top_bar"
    2 => "2026-10-30 15:19:42"
    3 => "2026-10-30 15:19:42"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1262}
    3 => Doctrine\DBAL\ParameterType {#1262}
    4 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.image AS image_4, c0_.is_active AS is_active_5, c0_.position AS position_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.locale AS locale_10, c1_.name AS name_11, c1_.slug AS slug_12, c1_.description AS description_13, c0_.eshop_id AS eshop_id_14, c0_.parent_id AS parent_id_15, c1_.category_id AS category_id_16 FROM categories c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id WHERE c0_.eshop_id = ? AND c0_.parent_id IS NULL AND c0_.is_active = 1 ORDER BY c0_.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.eshop_id AS eshop_id_10, t0.parent_id AS parent_id_11 FROM categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.category_id AS category_id_6 FROM category_translation t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id = ? LIMIT 1"
  "params" => [
    1 => "main_menu"
    2 => "cs"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1262}
    3 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id IS NULL LIMIT 1"
  "params" => [
    1 => "main_menu"
    2 => "cs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1262}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? LIMIT 1"
  "params" => [
    1 => "main_menu"
    2 => "cs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1262}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id = ? LIMIT 1"
  "params" => [
    1 => "main_menu"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id IS NULL LIMIT 1"
  "params" => [
    1 => "main_menu"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 LIMIT 1"
  "params" => [
    1 => "main_menu"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.eshop_id AS eshop_id_10, t0.parent_id AS parent_id_11 FROM categories t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?"
  "params" => [
    1 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.placement AS placement_2, b0_.sklad_karta_kod AS sklad_karta_kod_3, b0_.sklad_model_kod AS sklad_model_kod_4, b0_.grid_position AS grid_position_5, b0_.position AS position_6, b0_.title AS title_7, b0_.subtitle AS subtitle_8, b0_.badge_text AS badge_text_9, b0_.button_text AS button_text_10, b0_.link_url AS link_url_11, b0_.target_blank AS target_blank_12, b0_.image AS image_13, b0_.background_color AS background_color_14, b0_.text_color AS text_color_15, b0_.valid_from AS valid_from_16, b0_.valid_to AS valid_to_17, b0_.is_active AS is_active_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.domain_id AS domain_id_21, b0_.category_id AS category_id_22, b0_.product_id AS product_id_23 FROM banners b0_ WHERE b0_.placement = ? AND b0_.is_active = 1 AND ((b0_.valid_from IS NULL OR b0_.valid_from <= ?)) AND ((b0_.valid_to IS NULL OR b0_.valid_to >= ?)) AND ((b0_.domain_id = ? OR b0_.domain_id IS NULL)) AND ((b0_.product_id = ? OR b0_.product_id IS NULL)) ORDER BY b0_.position ASC, b0_.id ASC"
  "params" => [
    1 => "product_top"
    2 => "2026-10-30 15:19:42"
    3 => "2026-10-30 15:19:42"
    4 => 1
    5 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1262}
    3 => Doctrine\DBAL\ParameterType {#1262}
    4 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
    5 => Doctrine\DBAL\ParameterType {#1355}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.role AS role_3, t0.filename AS filename_4, t0.external_url AS external_url_5, t0.thumbnail AS thumbnail_6, t0.layer_key AS layer_key_7, t0.inherits_mattress_overlay AS inherits_mattress_overlay_8, t0.is_main AS is_main_9, t0.position AS position_10, t0.created_at AS created_at_11, t0.product_id AS product_id_12, t0.domain_id AS domain_id_13, t0.layer_item_id AS layer_item_id_14, t0.layer_color_id AS layer_color_id_15 FROM product_media t0 WHERE t0.product_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.placement AS placement_2, b0_.sklad_karta_kod AS sklad_karta_kod_3, b0_.sklad_model_kod AS sklad_model_kod_4, b0_.grid_position AS grid_position_5, b0_.position AS position_6, b0_.title AS title_7, b0_.subtitle AS subtitle_8, b0_.badge_text AS badge_text_9, b0_.button_text AS button_text_10, b0_.link_url AS link_url_11, b0_.target_blank AS target_blank_12, b0_.image AS image_13, b0_.background_color AS background_color_14, b0_.text_color AS text_color_15, b0_.valid_from AS valid_from_16, b0_.valid_to AS valid_to_17, b0_.is_active AS is_active_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.domain_id AS domain_id_21, b0_.category_id AS category_id_22, b0_.product_id AS product_id_23 FROM banners b0_ WHERE b0_.placement = ? AND b0_.is_active = 1 AND ((b0_.valid_from IS NULL OR b0_.valid_from <= ?)) AND ((b0_.valid_to IS NULL OR b0_.valid_to >= ?)) AND ((b0_.domain_id = ? OR b0_.domain_id IS NULL)) AND ((b0_.product_id = ? OR b0_.product_id IS NULL)) ORDER BY b0_.position ASC, b0_.id ASC"
  "params" => [
    1 => "product_bottom"
    2 => "2026-10-30 15:19:42"
    3 => "2026-10-30 15:19:42"
    4 => 1
    5 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1262}
    3 => Doctrine\DBAL\ParameterType {#1262}
    4 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
    5 => Doctrine\DBAL\ParameterType {#1355}
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.icon AS icon_3, s0_.link_url AS link_url_4, s0_.position AS position_5, s0_.is_active AS is_active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.domain_id AS domain_id_9 FROM shop_benefits s0_ WHERE s0_.is_active = 1 AND (s0_.domain_id = ? OR s0_.domain_id IS NULL) ORDER BY s0_.position ASC, s0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id = ? LIMIT 1"
  "params" => [
    1 => "footer_help"
    2 => "cs"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1262}
    3 => Doctrine\DBAL\ParameterType {#1355
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id IS NULL LIMIT 1"
  "params" => [
    1 => "footer_help"
    2 => "cs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1262}
  ]
]