GET https://dev.slave.forga.cz/cs/kabelky/5105-bulk-produkt-814

Response
200 OK
IP
216.73.216.117
Profiled on
Token
46ec6a

Query Metrics

30 Database Queries
18 Different statements
28.93 ms Query time
8 Invalid entities
26 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.90 ms 
SELECT e0_.id AS id_0, e0_.exchange_rate AS exchange_rate_1, e0_.last_automatic_update AS last_automatic_update_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.currency_from_id AS currency_from_id_5, e0_.currency_to_id AS currency_to_id_6 FROM exchange_rate e0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.72 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.50 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.60 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id ORDER BY c0_.is_default DESC, c0_.code ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 2.50 ms 
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.payment_method AS payment_method_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.address_street AS address_street_17, c0_.address_descriptive_number AS address_descriptive_number_18, c0_.address_city AS address_city_19, c0_.address_country AS address_country_20, c0_.address_zip_code AS address_zip_code_21, c0_.invoice_street AS invoice_street_22, c0_.invoice_descriptive_number AS invoice_descriptive_number_23, c0_.invoice_city AS invoice_city_24, c0_.invoice_country AS invoice_country_25, c0_.invoice_zip_code AS invoice_zip_code_26, c1_.id AS id_27, c1_.quantity AS quantity_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, p2_.id AS id_31, p2_.code AS code_32, p2_.is_default AS is_default_33, p2_.weight_modification AS weight_modification_34, p2_.price_modification_amount AS price_modification_amount_35, p2_.price_modification_currency AS price_modification_currency_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p3_.id AS id_39, p3_.public_id AS public_id_40, p3_.name AS name_41, p3_.description AS description_42, p3_.short_description AS short_description_43, p3_.code AS code_44, p3_.ean AS ean_45, p3_.unit AS unit_46, p3_.active AS active_47, p3_.can_be_bought AS can_be_bought_48, p3_.searchable AS searchable_49, p3_.show_price AS show_price_50, p3_.in_stock_text AS in_stock_text_51, p3_.out_of_stock_text AS out_of_stock_text_52, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_53, p3_.filter_variant_value_ids AS filter_variant_value_ids_54, p3_.search_vector_cs AS search_vector_cs_55, p3_.search_vector_en AS search_vector_en_56, p3_.seo_title AS seo_title_57, p3_.seo_description AS seo_description_58, p3_.seo_url AS seo_url_59, p3_.stock_stock AS stock_stock_60, p3_.stock_reserved AS stock_reserved_61, p3_.logistic_weight AS logistic_weight_62, p3_.logistic_size_width AS logistic_size_width_63, p3_.logistic_size_height AS logistic_size_height_64, p3_.logistic_size_length AS logistic_size_length_65, p3_.price_amount AS price_amount_66, p3_.price_currency AS price_currency_67, p3_.purchase_price_amount AS purchase_price_amount_68, p3_.purchase_price_currency AS purchase_price_currency_69, c0_.customer_id AS customer_id_70, c0_.shipping_method_id AS shipping_method_id_71, c0_.discount_code_id AS discount_code_id_72, c1_.cart_id AS cart_id_73, c1_.product_variant_id AS product_variant_id_74, p2_.product_id AS product_id_75, p3_.vat_id AS vat_id_76, p3_.main_category_id AS main_category_id_77 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = ? AND c0_.status = ? ORDER BY c1_.id ASC
Parameters: 
[
  "b91f73b3cd4ef7c355539527b1a326be"
  "active"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.43 ms 
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.code AS code_6, t0.ean AS ean_7, t0.unit AS unit_8, t0.active AS active_9, t0.can_be_bought AS can_be_bought_10, t0.searchable AS searchable_11, t0.show_price AS show_price_12, t0.in_stock_text AS in_stock_text_13, t0.out_of_stock_text AS out_of_stock_text_14, t0.filter_parameter_value_ids AS filter_parameter_value_ids_15, t0.filter_variant_value_ids AS filter_variant_value_ids_16, t0.search_vector_cs AS search_vector_cs_17, t0.search_vector_en AS search_vector_en_18, t0.seo_title AS seo_title_19, t0.seo_description AS seo_description_20, t0.seo_url AS seo_url_21, t0.stock_stock AS stock_stock_22, t0.stock_reserved AS stock_reserved_23, t0.logistic_weight AS logistic_weight_24, t0.logistic_size_width AS logistic_size_width_25, t0.logistic_size_height AS logistic_size_height_26, t0.logistic_size_length AS logistic_size_length_27, t0.price_amount AS price_amount_28, t0.price_currency AS price_currency_29, t0.purchase_price_amount AS purchase_price_amount_30, t0.purchase_price_currency AS purchase_price_currency_31, t0.vat_id AS vat_id_32, t0.main_category_id AS main_category_id_33 FROM product t0 WHERE t0.public_id = ? LIMIT 1
Parameters: 
[
  "5105"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.71 ms 
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.image_id AS image_id_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.id = ?
Parameters: 
[
  "2b0d8c4f-6e3a-4f7b-8d1c-0a5e7f2b3d4c"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 1.01 ms 
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.payment_method AS payment_method_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.address_street AS address_street_17, c0_.address_descriptive_number AS address_descriptive_number_18, c0_.address_city AS address_city_19, c0_.address_country AS address_country_20, c0_.address_zip_code AS address_zip_code_21, c0_.invoice_street AS invoice_street_22, c0_.invoice_descriptive_number AS invoice_descriptive_number_23, c0_.invoice_city AS invoice_city_24, c0_.invoice_country AS invoice_country_25, c0_.invoice_zip_code AS invoice_zip_code_26, c1_.id AS id_27, c1_.quantity AS quantity_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, p2_.id AS id_31, p2_.code AS code_32, p2_.is_default AS is_default_33, p2_.weight_modification AS weight_modification_34, p2_.price_modification_amount AS price_modification_amount_35, p2_.price_modification_currency AS price_modification_currency_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p3_.id AS id_39, p3_.public_id AS public_id_40, p3_.name AS name_41, p3_.description AS description_42, p3_.short_description AS short_description_43, p3_.code AS code_44, p3_.ean AS ean_45, p3_.unit AS unit_46, p3_.active AS active_47, p3_.can_be_bought AS can_be_bought_48, p3_.searchable AS searchable_49, p3_.show_price AS show_price_50, p3_.in_stock_text AS in_stock_text_51, p3_.out_of_stock_text AS out_of_stock_text_52, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_53, p3_.filter_variant_value_ids AS filter_variant_value_ids_54, p3_.search_vector_cs AS search_vector_cs_55, p3_.search_vector_en AS search_vector_en_56, p3_.seo_title AS seo_title_57, p3_.seo_description AS seo_description_58, p3_.seo_url AS seo_url_59, p3_.stock_stock AS stock_stock_60, p3_.stock_reserved AS stock_reserved_61, p3_.logistic_weight AS logistic_weight_62, p3_.logistic_size_width AS logistic_size_width_63, p3_.logistic_size_height AS logistic_size_height_64, p3_.logistic_size_length AS logistic_size_length_65, p3_.price_amount AS price_amount_66, p3_.price_currency AS price_currency_67, p3_.purchase_price_amount AS purchase_price_amount_68, p3_.purchase_price_currency AS purchase_price_currency_69, c0_.customer_id AS customer_id_70, c0_.shipping_method_id AS shipping_method_id_71, c0_.discount_code_id AS discount_code_id_72, c1_.cart_id AS cart_id_73, c1_.product_variant_id AS product_variant_id_74, p2_.product_id AS product_id_75, p3_.vat_id AS vat_id_76, p3_.main_category_id AS main_category_id_77 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = ? AND c0_.status = ? ORDER BY c1_.id ASC
Parameters: 
[
  "b91f73b3cd4ef7c355539527b1a326be"
  "active"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.50 ms 
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
Parameters: 
[
  "4b1aa67b-1348-4648-a14f-0d358255c58a"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.50 ms 
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.image_id AS image_id_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.id = ?
Parameters: 
[
  "6d4f2e8b-0a7c-4b1d-2f5e-4c9a1b6d7f8e"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.53 ms 
SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8 FROM category c0_ ORDER BY c0_.tree_root ASC, c0_.lft ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.88 ms 
SELECT s0_.id AS id_0, s0_.public_id AS public_id_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.content AS content_4, s0_.show_contact_form AS show_contact_form_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.seo_title AS seo_title_9, s0_.seo_description AS seo_description_10, s0_.seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_.active = true ORDER BY s0_.created_at ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
13 5.24 ms 
SELECT p0_.id AS id_0, p0_.public_id AS public_id_1, p0_.name AS name_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.code AS code_5, p0_.ean AS ean_6, p0_.unit AS unit_7, p0_.active AS active_8, p0_.can_be_bought AS can_be_bought_9, p0_.searchable AS searchable_10, p0_.show_price AS show_price_11, p0_.in_stock_text AS in_stock_text_12, p0_.out_of_stock_text AS out_of_stock_text_13, p0_.filter_parameter_value_ids AS filter_parameter_value_ids_14, p0_.filter_variant_value_ids AS filter_variant_value_ids_15, p0_.search_vector_cs AS search_vector_cs_16, p0_.search_vector_en AS search_vector_en_17, p0_.seo_title AS seo_title_18, p0_.seo_description AS seo_description_19, p0_.seo_url AS seo_url_20, p0_.stock_stock AS stock_stock_21, p0_.stock_reserved AS stock_reserved_22, p0_.logistic_weight AS logistic_weight_23, p0_.logistic_size_width AS logistic_size_width_24, p0_.logistic_size_height AS logistic_size_height_25, p0_.logistic_size_length AS logistic_size_length_26, p0_.price_amount AS price_amount_27, p0_.price_currency AS price_currency_28, p0_.purchase_price_amount AS purchase_price_amount_29, p0_.purchase_price_currency AS purchase_price_currency_30, p1_.id AS id_31, p1_.code AS code_32, p1_.is_default AS is_default_33, p1_.weight_modification AS weight_modification_34, p1_.price_modification_amount AS price_modification_amount_35, p1_.price_modification_currency AS price_modification_currency_36, p1_.stock_stock AS stock_stock_37, p1_.stock_reserved AS stock_reserved_38, v2_.id AS id_39, v2_.name AS name_40, v2_.slug AS slug_41, v2_.color AS color_42, v2_.position AS position_43, v3_.id AS id_44, v3_.name AS name_45, v3_.slug AS slug_46, v3_.type AS type_47, v3_.position AS position_48, p4_.id AS id_49, p4_.custom_value AS custom_value_50, p5_.id AS id_51, p5_.name AS name_52, p5_.slug AS slug_53, p5_.position AS position_54, p6_.id AS id_55, p6_.name AS name_56, p6_.slug AS slug_57, p6_.position AS position_58, c7_.id AS id_59, c7_.public_id AS public_id_60, c7_.name AS name_61, c7_.slug AS slug_62, c7_.description AS description_63, c7_.lft AS lft_64, c7_.lvl AS lvl_65, c7_.rgt AS rgt_66, c7_.position AS position_67, p8_.id AS id_68, p8_.amount AS amount_69, p8_.type AS type_70, p8_.created_at AS created_at_71, p8_.updated_at AS updated_at_72, c9_.code AS code_73, c9_.is_default AS is_default_74, c9_.is_active AS is_active_75, c9_.decimal_places AS decimal_places_76, p0_.vat_id AS vat_id_77, p0_.main_category_id AS main_category_id_78, p1_.product_id AS product_id_79, v2_.variant_id AS variant_id_80, p4_.product_id AS product_id_81, p4_.parameter_id AS parameter_id_82, p4_.parameter_value_id AS parameter_value_id_83, p6_.parameter_id AS parameter_id_84, c7_.image_id AS image_id_85, c7_.tree_root AS tree_root_86, c7_.parent_id AS parent_id_87, p8_.product_id AS product_id_88, p8_.currency_code AS currency_code_89 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant_variant_value p10_ ON p1_.id = p10_.product_variant_id LEFT JOIN variant_value v2_ ON v2_.id = p10_.variant_value_id LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id LEFT JOIN category c7_ ON p0_.main_category_id = c7_.id LEFT JOIN product_price p8_ ON p0_.id = p8_.product_id LEFT JOIN currency c9_ ON p8_.currency_code = c9_.code WHERE p0_.public_id = ?
Parameters: 
[
  5105
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.67 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.53 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id ORDER BY c0_.is_default DESC, c0_.code ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.54 ms 
SELECT s0_.id AS id_0, s0_.public_id AS public_id_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.content AS content_4, s0_.show_contact_form AS show_contact_form_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.seo_title AS seo_title_9, s0_.seo_description AS seo_description_10, s0_.seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_.active = true ORDER BY s0_.created_at ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
17 3.08 ms 
SELECT p0_.id AS id_0, p0_.public_id AS public_id_1, p0_.name AS name_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.code AS code_5, p0_.ean AS ean_6, p0_.unit AS unit_7, p0_.active AS active_8, p0_.can_be_bought AS can_be_bought_9, p0_.searchable AS searchable_10, p0_.show_price AS show_price_11, p0_.in_stock_text AS in_stock_text_12, p0_.out_of_stock_text AS out_of_stock_text_13, p0_.filter_parameter_value_ids AS filter_parameter_value_ids_14, p0_.filter_variant_value_ids AS filter_variant_value_ids_15, p0_.search_vector_cs AS search_vector_cs_16, p0_.search_vector_en AS search_vector_en_17, p0_.seo_title AS seo_title_18, p0_.seo_description AS seo_description_19, p0_.seo_url AS seo_url_20, p0_.stock_stock AS stock_stock_21, p0_.stock_reserved AS stock_reserved_22, p0_.logistic_weight AS logistic_weight_23, p0_.logistic_size_width AS logistic_size_width_24, p0_.logistic_size_height AS logistic_size_height_25, p0_.logistic_size_length AS logistic_size_length_26, p0_.price_amount AS price_amount_27, p0_.price_currency AS price_currency_28, p0_.purchase_price_amount AS purchase_price_amount_29, p0_.purchase_price_currency AS purchase_price_currency_30, p1_.id AS id_31, p1_.code AS code_32, p1_.is_default AS is_default_33, p1_.weight_modification AS weight_modification_34, p1_.price_modification_amount AS price_modification_amount_35, p1_.price_modification_currency AS price_modification_currency_36, p1_.stock_stock AS stock_stock_37, p1_.stock_reserved AS stock_reserved_38, v2_.id AS id_39, v2_.name AS name_40, v2_.slug AS slug_41, v2_.color AS color_42, v2_.position AS position_43, v3_.id AS id_44, v3_.name AS name_45, v3_.slug AS slug_46, v3_.type AS type_47, v3_.position AS position_48, p4_.id AS id_49, p4_.custom_value AS custom_value_50, p5_.id AS id_51, p5_.name AS name_52, p5_.slug AS slug_53, p5_.position AS position_54, p6_.id AS id_55, p6_.name AS name_56, p6_.slug AS slug_57, p6_.position AS position_58, c7_.id AS id_59, c7_.public_id AS public_id_60, c7_.name AS name_61, c7_.slug AS slug_62, c7_.description AS description_63, c7_.lft AS lft_64, c7_.lvl AS lvl_65, c7_.rgt AS rgt_66, c7_.position AS position_67, p8_.id AS id_68, p8_.amount AS amount_69, p8_.type AS type_70, p8_.created_at AS created_at_71, p8_.updated_at AS updated_at_72, c9_.code AS code_73, c9_.is_default AS is_default_74, c9_.is_active AS is_active_75, c9_.decimal_places AS decimal_places_76, p0_.vat_id AS vat_id_77, p0_.main_category_id AS main_category_id_78, p1_.product_id AS product_id_79, v2_.variant_id AS variant_id_80, p4_.product_id AS product_id_81, p4_.parameter_id AS parameter_id_82, p4_.parameter_value_id AS parameter_value_id_83, p6_.parameter_id AS parameter_id_84, c7_.image_id AS image_id_85, c7_.tree_root AS tree_root_86, c7_.parent_id AS parent_id_87, p8_.product_id AS product_id_88, p8_.currency_code AS currency_code_89 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant_variant_value p10_ ON p1_.id = p10_.product_variant_id LEFT JOIN variant_value v2_ ON v2_.id = p10_.variant_value_id LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id LEFT JOIN category c7_ ON p0_.main_category_id = c7_.id LEFT JOIN product_price p8_ ON p0_.id = p8_.product_id LEFT JOIN currency c9_ ON p8_.currency_code = c9_.code WHERE p0_.public_id = ?
Parameters: 
[
  5105
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.50 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.50 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id ORDER BY c0_.is_default DESC, c0_.code ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.55 ms 
SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8 FROM category c0_ ORDER BY c0_.tree_root ASC, c0_.lft ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.86 ms 
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.title AS title_2, s0_.content AS content_3, s0_.link_url AS link_url_4, s0_.link_label AS link_label_5, s0_.is_active AS is_active_6, f1_.id AS id_7, f1_.size AS size_8, f1_.mime_type AS mime_type_9, s0_.image_id AS image_id_10 FROM sidebar_block s0_ LEFT JOIN file f1_ ON s0_.image_id = f1_.id WHERE s0_.is_active = true ORDER BY s0_.position ASC, s0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.44 ms 
SELECT t0.id AS id_1, t0.rate AS rate_2 FROM tax_rate t0 WHERE t0.id = ?
Parameters: 
[
  "d4cbf291-83a9-4c10-97a6-39675f525c02"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 1.06 ms 
SELECT v0_.id AS id_0, (v0_.name ->> ?) AS sclr_1, v1_.id AS id_2, (v1_.name ->> ?) AS sclr_3, v0_.type AS type_4, v1_.color AS color_5, MAX(CASE WHEN (p2_.stock_stock - p2_.stock_reserved) > 0 THEN 1 ELSE 0 END) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_.id = p3_.product_variant_id INNER JOIN variant_value v1_ ON v1_.id = p3_.variant_value_id INNER JOIN variant v0_ ON v1_.variant_id = v0_.id WHERE p2_.product_id = ? GROUP BY v0_.id, v1_.id ORDER BY v0_.position ASC, v1_.position ASC
Parameters: 
[
  "cs"
  "cs"
  Symfony\Component\Uid\UuidV4 {#2095
    __toString(): "4b1aa67b-1348-4648-a14f-0d358255c58a"
  }
]
View formatted query    View runnable query    View query backtrace
24 0.80 ms 
SELECT v0_.id AS id_0, (v0_.name ->> ?) AS sclr_1, v1_.id AS id_2, (v1_.name ->> ?) AS sclr_3, v0_.type AS type_4, v1_.color AS color_5, MAX(CASE WHEN (p2_.stock_stock - p2_.stock_reserved) > 0 THEN 1 ELSE 0 END) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_.id = p3_.product_variant_id INNER JOIN variant_value v1_ ON v1_.id = p3_.variant_value_id INNER JOIN variant v0_ ON v1_.variant_id = v0_.id WHERE p2_.product_id = ? GROUP BY v0_.id, v1_.id ORDER BY v0_.position ASC, v1_.position ASC
Parameters: 
[
  "cs"
  "cs"
  Symfony\Component\Uid\UuidV4 {#2095
    __toString(): "4b1aa67b-1348-4648-a14f-0d358255c58a"
  }
]
View formatted query    View runnable query    View query backtrace
25 0.75 ms 
SELECT v0_.id AS id_0, (v0_.name ->> ?) AS sclr_1, v1_.id AS id_2, (v1_.name ->> ?) AS sclr_3, v0_.type AS type_4, v1_.color AS color_5, MAX(CASE WHEN (p2_.stock_stock - p2_.stock_reserved) > 0 THEN 1 ELSE 0 END) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_.id = p3_.product_variant_id INNER JOIN variant_value v1_ ON v1_.id = p3_.variant_value_id INNER JOIN variant v0_ ON v1_.variant_id = v0_.id WHERE p2_.product_id = ? GROUP BY v0_.id, v1_.id ORDER BY v0_.position ASC, v1_.position ASC
Parameters: 
[
  "cs"
  "cs"
  Symfony\Component\Uid\UuidV4 {#2095
    __toString(): "4b1aa67b-1348-4648-a14f-0d358255c58a"
  }
]
View formatted query    View runnable query    View query backtrace
26 0.83 ms 
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.code AS code_6, t0.ean AS ean_7, t0.unit AS unit_8, t0.active AS active_9, t0.can_be_bought AS can_be_bought_10, t0.searchable AS searchable_11, t0.show_price AS show_price_12, t0.in_stock_text AS in_stock_text_13, t0.out_of_stock_text AS out_of_stock_text_14, t0.filter_parameter_value_ids AS filter_parameter_value_ids_15, t0.filter_variant_value_ids AS filter_variant_value_ids_16, t0.search_vector_cs AS search_vector_cs_17, t0.search_vector_en AS search_vector_en_18, t0.seo_title AS seo_title_19, t0.seo_description AS seo_description_20, t0.seo_url AS seo_url_21, t0.stock_stock AS stock_stock_22, t0.stock_reserved AS stock_reserved_23, t0.logistic_weight AS logistic_weight_24, t0.logistic_size_width AS logistic_size_width_25, t0.logistic_size_height AS logistic_size_height_26, t0.logistic_size_length AS logistic_size_length_27, t0.price_amount AS price_amount_28, t0.price_currency AS price_currency_29, t0.purchase_price_amount AS purchase_price_amount_30, t0.purchase_price_currency AS purchase_price_currency_31, t0.vat_id AS vat_id_32, t0.main_category_id AS main_category_id_33 FROM product t0 INNER JOIN product_related ON t0.id = product_related.product_target WHERE product_related.product_source = ?
Parameters: 
[
  "4b1aa67b-1348-4648-a14f-0d358255c58a"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.49 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.position AS position_4, t0.product_id AS product_id_5 FROM product_video t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters: 
[
  "4b1aa67b-1348-4648-a14f-0d358255c58a"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.47 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_file t0 WHERE t0.product_id = ?
Parameters: 
[
  "4b1aa67b-1348-4648-a14f-0d358255c58a"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.51 ms 
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.label AS label_2, f0_.url AS url_3, f0_.is_active AS is_active_4 FROM footer_link f0_ WHERE f0_.is_active = true ORDER BY f0_.position ASC, f0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.34 ms 
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.network AS network_2, s0_.url AS url_3, s0_.is_active AS is_active_4 FROM social_link s0_ WHERE s0_.is_active = true ORDER BY s0_.position ASC, s0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Frontoffice\Domain\Entity\FooterLink 5
App\Frontoffice\Domain\Entity\SocialLink 4
App\Configuration\Domain\Entity\Currency 3
App\PageBuilder\Domain\Entity\StaticPage 3
App\Configuration\Domain\Entity\ExchangeRate 2
App\Product\Domain\Entity\Category 2
App\Frontoffice\Domain\Entity\SidebarBlock 2
App\Frontoffice\Domain\Entity\Cart 1
App\Product\Domain\Entity\Product 1
App\Accounting\Domain\Entity\TaxRate 1
App\Product\Domain\Entity\ProductVariant 1
App\File\Domain\Entity\File 1

Entities Mapping

Class Mapping errors
App\Configuration\Domain\Entity\Configuration No errors.
App\Localization\Domain\Entity\Language No errors.
App\SEO\Domain\Entity\SEO No errors.
App\Product\Domain\Entity\Stock No errors.
App\Logistic\Domain\Entity\Size No errors.
App\Logistic\Domain\Entity\Logistic No errors.
App\Shared\Domain\Entity\Price No errors.
App\Product\Domain\Entity\Product No errors.
App\Product\Domain\Entity\Category No errors.
App\PageBuilder\Domain\Entity\StaticPage No errors.
App\Configuration\Domain\Entity\Currency No errors.
App\Configuration\Domain\Entity\ExchangeRate No errors.
App\Routing\Domain\Entity\RedirectRoute No errors.
App\Payment\Domain\Entity\PaymentMethodConfiguration
  • The field App\Payment\Domain\Entity\PaymentMethodConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute.
App\Shared\Domain\Entity\Address No errors.
App\Frontoffice\Domain\Entity\Cart No errors.
App\Frontoffice\Domain\Entity\CartItem No errors.
App\Shared\Domain\Entity\NullablePrice No errors.
App\Product\Domain\Entity\ProductVariant No errors.
App\Customer\Domain\Entity\Customer No errors.
App\Shipping\Domain\Entity\ShippingMethod
  • The field App\Shipping\Domain\Entity\ShippingMethod#fees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Shipping\Domain\Entity\ShippingMethodFee#shippingMethod does not contain the required 'inversedBy: "fees"' attribute.
App\Discount\Domain\Entity\Discount No errors.
App\Accounting\Domain\Entity\TaxRate No errors.
App\Product\Domain\Entity\ProductPrice No errors.
App\Product\Domain\Entity\ProductImage No errors.
App\Product\Domain\Entity\ProductFile No errors.
App\Product\Domain\Entity\ProductVideo No errors.
App\Product\Domain\Entity\ProductParameter No errors.
App\PaymentGate\Domain\Entity\PaymentGateConfiguration No errors.
App\Shared\Domain\Entity\ServerSideEvent No errors.
App\ProductInquiry\Domain\Entity\ProductInquiry No errors.
App\Help\Domain\Entity\HelpEntry No errors.
App\Invoice\Domain\Entity\InvoiceNumberSeries No errors.
App\Invoice\Domain\Entity\Invoice No errors.
App\CarrierExport\Domain\Entity\ExportProcess No errors.
App\Shipping\Domain\Entity\CarrierConfiguration No errors.
App\Shipping\Domain\Entity\CarrierShippingOption No errors.
App\Shipping\Domain\Entity\ShippingMethodFee No errors.
App\Product\Domain\Entity\CategoryProductPosition No errors.
App\Product\Domain\Entity\Parameter No errors.
App\Product\Domain\Entity\ParameterValue No errors.
App\Product\Domain\Entity\Variant No errors.
App\Product\Domain\Entity\VariantValue No errors.
App\Filter\Domain\Entity\FilterConfiguration No errors.
App\Filter\Domain\Entity\ParameterFilterConfiguration No errors.
App\Filter\Domain\Entity\VariantFilterConfiguration No errors.
App\ReturnRequest\Domain\Entity\ReturnRequest No errors.
App\Payment\Domain\Entity\PaymentMethodBankTransferConfiguration
  • The field App\Payment\Domain\Entity\PaymentMethodBankTransferConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute.
  • The field App\Payment\Domain\Entity\PaymentMethodBankTransferConfiguration#currencyConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodBankTransferCurrencyConfiguration#paymentMethodBankTransferConfiguration does not contain the required 'inversedBy: "currencyConfigurations"' attribute.
App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryConfiguration
  • The field App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute.
  • The field App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryConfiguration#countryFees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryCountryConfiguration#paymentMethodCashOnDeliveryConfiguration does not contain the required 'inversedBy: "countryFees"' attribute.
App\Payment\Domain\Entity\PaymentMethodFee No errors.
App\Payment\Domain\Entity\PaymentMethodPayAtStoreConfiguration
  • The field App\Payment\Domain\Entity\PaymentMethodPayAtStoreConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute.
App\Payment\Domain\Entity\PaymentMethodPaymentCardConfiguration
  • The field App\Payment\Domain\Entity\PaymentMethodPaymentCardConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute.
App\Import\Domain\Entity\ExternalIdMapping No errors.
App\Import\Domain\Entity\ImportLog No errors.
App\Import\Domain\Entity\ImportSession No errors.
App\Homepage\Domain\Entity\Homepage No errors.
App\Homepage\Domain\Entity\HomepageSelectedProduct No errors.
App\Homepage\Domain\Entity\HomepageSlide No errors.
App\Order\Domain\Entity\OrderItem No errors.
App\Order\Domain\Entity\OrderPayment No errors.
App\Order\Domain\Entity\Order
  • The field App\Order\Domain\Entity\Order#history is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Order\Domain\Entity\OrderHistory#order does not contain the required 'inversedBy: "history"' attribute.
  • The field App\Order\Domain\Entity\Order#invoice is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Invoice\Domain\Entity\Invoice#order does not contain the required 'inversedBy: "invoice"' attribute.
  • The field App\Order\Domain\Entity\Order#shipment is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Order\Domain\Entity\OrderShipment#order does not contain the required 'inversedBy: "shipment"' attribute.
App\Order\Domain\Entity\OrderStatus
  • The field App\Order\Domain\Entity\OrderStatus#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Order\Domain\Entity\Order#status does not contain the required 'inversedBy: "orders"' attribute.
App\Configuration\Domain\Entity\Country No errors.
App\User\Domain\Entity\PasswordResetToken No errors.
App\User\Domain\Entity\User No errors.
App\User\Domain\Entity\UserRole No errors.
App\Frontoffice\Domain\Entity\CartSidebarBlock No errors.
App\Frontoffice\Domain\Entity\FooterLink No errors.
App\Frontoffice\Domain\Entity\HamburgerLink No errors.
App\Frontoffice\Domain\Entity\SidebarBlock No errors.
App\Frontoffice\Domain\Entity\SocialLink No errors.
App\File\Domain\Entity\File No errors.