Query Metrics
30
Database Queries
14
Different statements
95.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
27.80 ms (29.19%) |
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, p0_.main_eshop_id AS main_eshop_id_8, p0_.create_user_id AS create_user_id_9, p0_.edit_user_id AS edit_user_id_10 FROM product p0_ WHERE p0_.code IN (?, ?, ?, ?)
Parameters:
[ "CB-CT029-037CHG-00M-2346" "CB-CT029-037CHG-00L-2346" "CB-CT029-037CHG-0XL-2346" "CB-CT029-037CHG-2XL-2346" ] |
|
13.36 ms (14.03%) |
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, p1_.main_eshop_id AS main_eshop_id_48, p1_.create_user_id AS create_user_id_49, p1_.edit_user_id AS edit_user_id_50, p2_.product_id AS product_id_51, p2_.price_level_id AS price_level_id_52, p2_.create_user_id AS create_user_id_53, p2_.edit_user_id AS edit_user_id_54, p3_.translatable_id AS translatable_id_55 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 = ?) 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-03-10 17:05:03" "2026-03-10 17:05:03" ] |
|
10.94 ms (11.49%) |
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-03-10 17:04:57" "m04r6in" 1 ] |
|
9.72 ms (10.21%) |
5 |
SELECT t0.id AS id_1, t0.pricelist_id AS pricelist_id_2, t0.currency AS currency_3, t0.price AS price_4, t0.vat AS vat_5, t0.action_price AS action_price_6, t0.standard_price AS standard_price_7, t0.createts AS createts_8, t0.editts AS editts_9, t0.eshop_id AS eshop_id_10, t0.product_id AS product_id_11, t0.create_user_id AS create_user_id_12, t0.edit_user_id AS edit_user_id_13 FROM price t0 WHERE t0.product_id = ?
Parameters:
[
2643
]
|
|
7.79 ms (8.19%) |
4 |
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_template AS loyalty_template_48, t0.loyalty_image AS loyalty_image_49, t0.createts AS createts_50, t0.editts AS editts_51, t0.create_user_id AS create_user_id_52, t0.edit_user_id AS edit_user_id_53 FROM eshop t0 INNER JOIN product_eshop ON t0.id = product_eshop.eshop_id WHERE product_eshop.product_id = ?
Parameters:
[
326
]
|
|
7.19 ms (7.55%) |
4 |
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:
[
326
]
|
|
5.22 ms (5.48%) |
1 |
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" "CB-CT029-037CHG-00M-2346" "{"flags":[{"code":"delivery-free","dateFrom":null,"dateTo":null},{"code":"gift","dateFrom":null,"dateTo":null}]}" 0 null "2026-03-10 17:05:03" null 1 null null ] |
|
2.62 ms (2.75%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
2.22 ms (2.33%) |
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_template AS loyalty_template_48, t0.loyalty_image AS loyalty_image_49, t0.createts AS createts_50, t0.editts AS editts_51, t0.create_user_id AS create_user_id_52, t0.edit_user_id AS edit_user_id_53 FROM eshop t0 WHERE t0.shoptet_id = ? LIMIT 1
Parameters:
[
456957
]
|
|
2.14 ms (2.24%) |
1 |
UPDATE webhook SET processed = ? WHERE id = ?
Parameters:
[ 1 89327 ] |
|
2.12 ms (2.23%) |
3 |
UPDATE product_translation SET guid = ?, flags = ? WHERE id = ?
Parameters:
[ "bb5670da-7ca4-11ee-9c96-9e5903748bbe" "{"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}}" 327 ] |
|
2.06 ms (2.16%) |
3 |
"COMMIT"
Parameters:
[] |
|
1.51 ms (1.59%) |
1 |
INSERT INTO webhook (createts, event, event_instance, processed, eshop_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2026-03-10 17:05:02" "job:finished" "m04r6in" 0 1 ] |
|
0.56 ms (0.58%) |
1 |
UPDATE product_translation SET guid = ? WHERE id = ?
Parameters:
[ "bb5670da-7ca4-11ee-9c96-9e5903748bbe" 326 ] |
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. |