Query Metrics
99
Database Queries
14
Different statements
190.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
41.09 ms (21.53%) |
19 |
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:
[
69
]
|
|
35.90 ms (18.81%) |
19 |
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.use_compari_ro AS use_compari_ro_23, t0.use_second_quality AS use_second_quality_24, t0.last_reload_reviews AS last_reload_reviews_25, t0.last_reload_stocks AS last_reload_stocks_26, t0.holidays AS holidays_27, t0.flag_action AS flag_action_28, t0.flag_limited AS flag_limited_29, t0.flag_zasilkovna AS flag_zasilkovna_30, t0.flag_delivery_free AS flag_delivery_free_31, t0.carousel_slide AS carousel_slide_32, t0.carousel_timer AS carousel_timer_33, t0.pikito_api_key AS pikito_api_key_34, t0.pikito_address AS pikito_address_35, t0.pikito_city AS pikito_city_36, t0.pikito_country AS pikito_country_37, t0.pikito_partner AS pikito_partner_38, t0.pikito_branche AS pikito_branche_39, t0.pikito_shipping AS pikito_shipping_40, t0.loyalty_coefficient AS loyalty_coefficient_41, t0.loyalty_reserved_amounts AS loyalty_reserved_amounts_42, t0.loyalty_success_statuses AS loyalty_success_statuses_43, t0.loyalty_storno_statuses AS loyalty_storno_statuses_44, t0.loyalty_program_from_date AS loyalty_program_from_date_45, t0.loyalty_registration_fee AS loyalty_registration_fee_46, t0.loyalty_template AS loyalty_template_47, t0.loyalty_image AS loyalty_image_48, t0.createts AS createts_49, t0.editts AS editts_50, t0.create_user_id AS create_user_id_51, t0.edit_user_id AS edit_user_id_52 FROM eshop t0 INNER JOIN product_eshop ON t0.id = product_eshop.eshop_id WHERE product_eshop.product_id = ?
Parameters:
[
69
]
|
|
32.00 ms (16.76%) |
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:
[ "ST-CALMBALLS-BOXERS-M" "ST-CALMBALLS-BOXERS-L" "ST-CALMBALLS-BOXERS-XL" "ST-CALMBALLS-BOXERS-XXL" "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" "OT-RING-SIMPLE-22W45-9" "OT-RING-SIMPLE-22W45-10" "OT-RING-SIMPLE-22W45-11" "OT-RING-SIMPLE-22W45-12" "CB-CT029-037CHG-00M-2346" "CB-CT029-037CHG-00L-2346" "CB-CT029-037CHG-0XL-2346" "CB-CT029-037CHG-2XL-2346" ] |
|
24.24 ms (12.70%) |
21 |
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:
[
331
]
|
|
14.32 ms (7.50%) |
9 |
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" "ST-CALMBALLS-BOXERS-M" "{"flags":[{"code":"gift","dateFrom":null,"dateTo":null}]}" 0 null "2025-12-06 08:00:03" null 1 null null ] |
|
10.32 ms (5.41%) |
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" "2025-12-06 08:00:03" "2025-12-06 08:00:03" ] |
|
7.05 ms (3.69%) |
9 |
UPDATE product_translation SET guid = ?, flags = ? WHERE id = ?
Parameters:
[ "6bd53a44-3e3c-11ec-ab1e-0cc47a6c9370" "{"gift":{"code":"gift","title":"D\u00e1rek","dateFrom":null,"dateTo":null},"limited":{"code":"limited","title":"Limited","dateFrom":null,"dateTo":null}}" 70 ] |
|
6.83 ms (3.58%) |
10 |
UPDATE product_translation SET guid = ? WHERE id = ?
Parameters:
[ "6bd53a44-3e3c-11ec-ab1e-0cc47a6c9370" 69 ] |
|
6.38 ms (3.34%) |
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:
[ "2025-12-06 07:59:57" "rylkohl" 1 ] |
|
3.58 ms (1.87%) |
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.use_compari_ro AS use_compari_ro_23, t0.use_second_quality AS use_second_quality_24, t0.last_reload_reviews AS last_reload_reviews_25, t0.last_reload_stocks AS last_reload_stocks_26, t0.holidays AS holidays_27, t0.flag_action AS flag_action_28, t0.flag_limited AS flag_limited_29, t0.flag_zasilkovna AS flag_zasilkovna_30, t0.flag_delivery_free AS flag_delivery_free_31, t0.carousel_slide AS carousel_slide_32, t0.carousel_timer AS carousel_timer_33, t0.pikito_api_key AS pikito_api_key_34, t0.pikito_address AS pikito_address_35, t0.pikito_city AS pikito_city_36, t0.pikito_country AS pikito_country_37, t0.pikito_partner AS pikito_partner_38, t0.pikito_branche AS pikito_branche_39, t0.pikito_shipping AS pikito_shipping_40, t0.loyalty_coefficient AS loyalty_coefficient_41, t0.loyalty_reserved_amounts AS loyalty_reserved_amounts_42, t0.loyalty_success_statuses AS loyalty_success_statuses_43, t0.loyalty_storno_statuses AS loyalty_storno_statuses_44, t0.loyalty_program_from_date AS loyalty_program_from_date_45, t0.loyalty_registration_fee AS loyalty_registration_fee_46, t0.loyalty_template AS loyalty_template_47, t0.loyalty_image AS loyalty_image_48, t0.createts AS createts_49, t0.editts AS editts_50, t0.create_user_id AS create_user_id_51, t0.edit_user_id AS edit_user_id_52 FROM eshop t0 WHERE t0.shoptet_id = ? LIMIT 1
Parameters:
[
456957
]
|
|
3.56 ms (1.86%) |
3 |
"COMMIT"
Parameters:
[] |
|
2.14 ms (1.12%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
1.98 ms (1.04%) |
1 |
INSERT INTO webhook (createts, event, event_instance, processed, eshop_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-12-06 08:00:02" "job:finished" "rylkohl" 0 1 ] |
|
1.50 ms (0.79%) |
1 |
UPDATE webhook SET processed = ? WHERE id = ?
Parameters:
[ 1 6919 ] |
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. |