Query Metrics
43
Database Queries
13
Different statements
164.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
36.29 ms (22.13%) |
1 |
SELECT p0_.id AS id_0, p0_.is_variant AS is_variant_1, p0_.code AS code_2, p0_.brand AS brand_3, p0_.image AS image_4, p0_.all_availability_flags AS all_availability_flags_5, p0_.createts AS createts_6, p0_.editts AS editts_7, p1_.id AS id_8, p1_.pricelist_id AS pricelist_id_9, p1_.currency AS currency_10, p1_.price AS price_11, p1_.vat AS vat_12, p1_.action_price AS action_price_13, p1_.standard_price AS standard_price_14, p1_.createts AS createts_15, p1_.editts AS editts_16, p0_.main_eshop_id AS main_eshop_id_17, p0_.create_user_id AS create_user_id_18, p0_.edit_user_id AS edit_user_id_19, p1_.eshop_id AS eshop_id_20, p1_.product_id AS product_id_21, p1_.create_user_id AS create_user_id_22, p1_.edit_user_id AS edit_user_id_23 FROM product p0_ LEFT JOIN price p1_ ON p0_.id = p1_.product_id WHERE p0_.code IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "OT-BELT-LEATHER-22W45-90" "OT-BELT-LEATHER-22W45-125" "OT-BELT-LEATHER-22W45-115" "OT-BELT-LEATHER-22W45-105" "OT-BELT-LEATHER-22W45-100" "OT-BELT-LEATHER-22W45-95" "OT-BELT-LEATHER-22W45-110" "AB-HR021-019SS-100-2328" "AB-HR021-019SS-500-2328" ] |
|
31.77 ms (19.37%) |
9 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.api_key AS api_key_4, t0.shoptet_id AS shoptet_id_5, t0.locales AS locales_6, t0.availibility AS availibility_7, t0.main_locale AS main_locale_8, t0.currency AS currency_9, t0.url AS url_10, t0.heureka_url AS heureka_url_11, t0.instagram_angry AS instagram_angry_12, t0.instagram_calm_b AS instagram_calm_b_13, t0.instagram_busy_b AS instagram_busy_b_14, t0.instagram_bio AS instagram_bio_15, t0.instagram_reloadts AS instagram_reloadts_16, t0.logo AS logo_17, t0.last_reload_products AS last_reload_products_18, t0.last_reload_customers AS last_reload_customers_19, t0.language_switcher AS language_switcher_20, t0.reload_stocks AS reload_stocks_21, t0.analyze_orders AS analyze_orders_22, t0.statuses_for_analyze_orders AS statuses_for_analyze_orders_23, t0.use_compari_ro AS use_compari_ro_24, t0.use_second_quality AS use_second_quality_25, t0.last_reload_reviews AS last_reload_reviews_26, t0.last_reload_stocks AS last_reload_stocks_27, t0.holidays AS holidays_28, t0.flag_action AS flag_action_29, t0.flag_limited AS flag_limited_30, t0.flag_zasilkovna AS flag_zasilkovna_31, t0.flag_delivery_free AS flag_delivery_free_32, t0.carousel_slide AS carousel_slide_33, t0.carousel_timer AS carousel_timer_34, t0.pikito_api_key AS pikito_api_key_35, t0.pikito_address AS pikito_address_36, t0.pikito_city AS pikito_city_37, t0.pikito_country AS pikito_country_38, t0.pikito_partner AS pikito_partner_39, t0.pikito_branche AS pikito_branche_40, t0.pikito_shipping AS pikito_shipping_41, t0.loyalty_coefficient AS loyalty_coefficient_42, t0.loyalty_reserved_amounts AS loyalty_reserved_amounts_43, t0.loyalty_success_statuses AS loyalty_success_statuses_44, t0.loyalty_storno_statuses AS loyalty_storno_statuses_45, t0.loyalty_program_from_date AS loyalty_program_from_date_46, t0.loyalty_registration_fee AS loyalty_registration_fee_47, t0.loyalty_default_expiration AS loyalty_default_expiration_48, t0.loyalty_template AS loyalty_template_49, t0.loyalty_image AS loyalty_image_50, t0.createts AS createts_51, t0.editts AS editts_52, t0.create_user_id AS create_user_id_53, t0.edit_user_id AS edit_user_id_54 FROM eshop t0 INNER JOIN product_eshop ON t0.id = product_eshop.eshop_id WHERE product_eshop.product_id = ?
Parameters:
[
155
]
|
|
26.97 ms (16.44%) |
9 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.guid AS guid_3, t0.negative_stock_allowed AS negative_stock_allowed_4, t0.stock AS stock_5, t0.visibility AS visibility_6, t0.allowed_for_sale AS allowed_for_sale_7, t0.atypical_shipping AS atypical_shipping_8, t0.allowed_for_sale_message AS allowed_for_sale_message_9, t0.name AS name_10, t0.variant_name AS variant_name_11, t0.variant_group AS variant_group_12, t0.variant_color AS variant_color_13, t0.url AS url_14, t0.vote_count AS vote_count_15, t0.vote_averange AS vote_averange_16, t0.join_vote_count AS join_vote_count_17, t0.join_vote_averange AS join_vote_averange_18, t0.price AS price_19, t0.min_price AS min_price_20, t0.max_price AS max_price_21, t0.availability AS availability_22, t0.availability_when_sold_out AS availability_when_sold_out_23, t0.availability_when_sold_out_id AS availability_when_sold_out_id_24, t0.default_category AS default_category_25, t0.categories AS categories_26, t0.action_price AS action_price_27, t0.action_price_to AS action_price_to_28, t0.action_price_from AS action_price_from_29, t0.flags AS flags_30, t0.is_voucher AS is_voucher_31, t0.loyalty_coefficient AS loyalty_coefficient_32, t0.translatable_id AS translatable_id_33 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
155
]
|
|
17.27 ms (10.53%) |
1 |
SELECT p0_.price_czk AS price_czk_0, p1_.id AS id_1, p1_.is_variant AS is_variant_2, p1_.code AS code_3, p1_.brand AS brand_4, p1_.image AS image_5, p1_.all_availability_flags AS all_availability_flags_6, p1_.createts AS createts_7, p1_.editts AS editts_8, p2_.id AS id_9, p2_.only_registered AS only_registered_10, p2_.is_primary AS is_primary_11, p2_.priority AS priority_12, p2_.count_selected AS count_selected_13, p2_.createts AS createts_14, p2_.editts AS editts_15, p3_.id AS id_16, p3_.locale AS locale_17, p3_.guid AS guid_18, p3_.negative_stock_allowed AS negative_stock_allowed_19, p3_.stock AS stock_20, p3_.visibility AS visibility_21, p3_.allowed_for_sale AS allowed_for_sale_22, p3_.atypical_shipping AS atypical_shipping_23, p3_.allowed_for_sale_message AS allowed_for_sale_message_24, p3_.name AS name_25, p3_.variant_name AS variant_name_26, p3_.variant_group AS variant_group_27, p3_.variant_color AS variant_color_28, p3_.url AS url_29, p3_.vote_count AS vote_count_30, p3_.vote_averange AS vote_averange_31, p3_.join_vote_count AS join_vote_count_32, p3_.join_vote_averange AS join_vote_averange_33, p3_.price AS price_34, p3_.min_price AS min_price_35, p3_.max_price AS max_price_36, p3_.availability AS availability_37, p3_.availability_when_sold_out AS availability_when_sold_out_38, p3_.availability_when_sold_out_id AS availability_when_sold_out_id_39, p3_.default_category AS default_category_40, p3_.categories AS categories_41, p3_.action_price AS action_price_42, p3_.action_price_to AS action_price_to_43, p3_.action_price_from AS action_price_from_44, p3_.flags AS flags_45, p3_.is_voucher AS is_voucher_46, p3_.loyalty_coefficient AS loyalty_coefficient_47, p4_.id AS id_48, p4_.pricelist_id AS pricelist_id_49, p4_.currency AS currency_50, p4_.price AS price_51, p4_.vat AS vat_52, p4_.action_price AS action_price_53, p4_.standard_price AS standard_price_54, p4_.createts AS createts_55, p4_.editts AS editts_56, p1_.main_eshop_id AS main_eshop_id_57, p1_.create_user_id AS create_user_id_58, p1_.edit_user_id AS edit_user_id_59, p2_.product_id AS product_id_60, p2_.price_level_id AS price_level_id_61, p2_.create_user_id AS create_user_id_62, p2_.edit_user_id AS edit_user_id_63, p3_.translatable_id AS translatable_id_64, p4_.eshop_id AS eshop_id_65, p4_.product_id AS product_id_66, p4_.create_user_id AS create_user_id_67, p4_.edit_user_id AS edit_user_id_68 FROM product p1_ INNER JOIN price_level_item p2_ ON p1_.id = p2_.product_id INNER JOIN price_level p0_ ON p2_.price_level_id = p0_.id INNER JOIN product_translation p3_ ON p1_.id = p3_.translatable_id AND (p3_.locale = ?) LEFT JOIN price p4_ ON p1_.id = p4_.product_id WHERE p3_.allowed_for_sale = 1 AND (p0_.is_archive = 0 AND p0_.is_active = 1 AND p0_.price_czk IS NOT NULL) AND (p0_.date_from IS NULL OR (p0_.date_from <= ? AND p0_.date_to >= ?)) ORDER BY p0_.price_czk ASC, p2_.priority ASC
Parameters:
[ "cs" "2026-08-07 08:05:02" "2026-08-07 08:05:02" ] |
|
12.88 ms (7.85%) |
4 |
INSERT INTO api_request (type, priority, event, parameter, data, completed, errors, createts, editts, eshop_id, create_user_id, edit_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "PRODUCT" 5 "UPDATE" "OT-BELT-LEATHER-22W45-115" "{"flags":[{"code":"delivery-free","dateFrom":null,"dateTo":null},{"code":"gift","dateFrom":null,"dateTo":null}]}" 0 null "2026-08-07 08:05:03" null 1 null null ] |
|
10.89 ms (6.64%) |
1 |
SELECT w0_.id AS id_0, w0_.createts AS createts_1, w0_.event AS event_2, w0_.event_instance AS event_instance_3, w0_.processed AS processed_4, w0_.eshop_id AS eshop_id_5 FROM webhook w0_ WHERE w0_.createts >= ? AND w0_.event_instance = ? AND w0_.eshop_id = ? LIMIT 1
Parameters:
[ "2026-08-07 08:04:57" "y17cl00" 1 ] |
|
6.14 ms (3.75%) |
4 |
UPDATE product_translation SET guid = ? WHERE id = ?
Parameters:
[ "fa2da598-5e83-11ed-80f6-0cc47a6c9370" 157 ] |
|
6.10 ms (3.72%) |
5 |
UPDATE product_translation SET guid = ?, flags = ? WHERE id = ?
Parameters:
[ "fa2da598-5e83-11ed-80f6-0cc47a6c9370" "{"delivery-free":{"code":"delivery-free","title":"Doprava zdarma","dateFrom":null,"dateTo":null},"gift":{"code":"gift","title":"D\u00e1rek","dateFrom":null,"dateTo":null},"limited":{"code":"limited","title":"Limited","dateFrom":null,"dateTo":null}}" 155 ] |
|
4.96 ms (3.02%) |
3 |
"COMMIT"
Parameters:
[] |
|
3.89 ms (2.37%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.api_key AS api_key_4, t0.shoptet_id AS shoptet_id_5, t0.locales AS locales_6, t0.availibility AS availibility_7, t0.main_locale AS main_locale_8, t0.currency AS currency_9, t0.url AS url_10, t0.heureka_url AS heureka_url_11, t0.instagram_angry AS instagram_angry_12, t0.instagram_calm_b AS instagram_calm_b_13, t0.instagram_busy_b AS instagram_busy_b_14, t0.instagram_bio AS instagram_bio_15, t0.instagram_reloadts AS instagram_reloadts_16, t0.logo AS logo_17, t0.last_reload_products AS last_reload_products_18, t0.last_reload_customers AS last_reload_customers_19, t0.language_switcher AS language_switcher_20, t0.reload_stocks AS reload_stocks_21, t0.analyze_orders AS analyze_orders_22, t0.statuses_for_analyze_orders AS statuses_for_analyze_orders_23, t0.use_compari_ro AS use_compari_ro_24, t0.use_second_quality AS use_second_quality_25, t0.last_reload_reviews AS last_reload_reviews_26, t0.last_reload_stocks AS last_reload_stocks_27, t0.holidays AS holidays_28, t0.flag_action AS flag_action_29, t0.flag_limited AS flag_limited_30, t0.flag_zasilkovna AS flag_zasilkovna_31, t0.flag_delivery_free AS flag_delivery_free_32, t0.carousel_slide AS carousel_slide_33, t0.carousel_timer AS carousel_timer_34, t0.pikito_api_key AS pikito_api_key_35, t0.pikito_address AS pikito_address_36, t0.pikito_city AS pikito_city_37, t0.pikito_country AS pikito_country_38, t0.pikito_partner AS pikito_partner_39, t0.pikito_branche AS pikito_branche_40, t0.pikito_shipping AS pikito_shipping_41, t0.loyalty_coefficient AS loyalty_coefficient_42, t0.loyalty_reserved_amounts AS loyalty_reserved_amounts_43, t0.loyalty_success_statuses AS loyalty_success_statuses_44, t0.loyalty_storno_statuses AS loyalty_storno_statuses_45, t0.loyalty_program_from_date AS loyalty_program_from_date_46, t0.loyalty_registration_fee AS loyalty_registration_fee_47, t0.loyalty_default_expiration AS loyalty_default_expiration_48, t0.loyalty_template AS loyalty_template_49, t0.loyalty_image AS loyalty_image_50, t0.createts AS createts_51, t0.editts AS editts_52, t0.create_user_id AS create_user_id_53, t0.edit_user_id AS edit_user_id_54 FROM eshop t0 WHERE t0.shoptet_id = ? LIMIT 1
Parameters:
[
456957
]
|
|
3.05 ms (1.86%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
2.03 ms (1.24%) |
1 |
INSERT INTO webhook (createts, event, event_instance, processed, eshop_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2026-08-07 08:05:02" "job:finished" "y17cl00" 0 1 ] |
|
1.80 ms (1.10%) |
1 |
UPDATE webhook SET processed = ? WHERE id = ?
Parameters:
[ 1 219761 ] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Eshop | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Webhook | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ApiRequest | No errors. |
| App\Entity\Survey | No errors. |
| App\Entity\Gift | No errors. |
| App\Entity\JoinReviews | No errors. |
| App\Entity\Heureka | No errors. |
| App\Entity\Flag | No errors. |
| App\Entity\Drop | No errors. |
| App\Entity\Banner | No errors. |
| App\Entity\Announcement | No errors. |
| App\Entity\Pikito | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\LoyaltyCoupon | No errors. |
| App\Entity\PriceLevelItem | No errors. |
| App\Entity\PriceLevel | No errors. |
| App\Entity\ProductTranslation | No errors. |
| App\Entity\Price | No errors. |
| App\Entity\Coupon | No errors. |
| App\Entity\Qr | No errors. |
| App\Entity\QrTranslation | No errors. |