Query Metrics
5
Database Queries
5
Different statements
1.71 ms
Query time
1
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.42 ms (24.90%) |
1 |
SELECT w0_.id AS id_0, w0_.is_active AS is_active_1, w0_.date_from AS date_from_2, w0_.date_to AS date_to_3, w0_.createts AS createts_4, w0_.editts AS editts_5, w0_.create_user_id AS create_user_id_6, w0_.edit_user_id AS edit_user_id_7 FROM web_modal w0_ INNER JOIN web_modal_translation w1_ ON w0_.id = w1_.translatable_id AND (w1_.locale = ?) WHERE w0_.is_active = 1 AND w0_.date_from < ? AND w0_.date_to > ? LIMIT 1
Parameters:
[ "en" "2026-10-26 23:00:00" "2026-10-26 02:00:00" ] |
|
0.40 ms (23.67%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.second_name AS second_name_3, t0.phone AS phone_4, t0.email AS email_5, t0.gps AS gps_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.b2b AS b2b_9, t0.address AS address_10, t0.zip AS zip_11, t0.logo AS logo_12, t0.createts AS createts_13, t0.editts AS editts_14, t0.image1 AS image1_15, t0.image2 AS image2_16, t0.image3 AS image3_17, t0.image4 AS image4_18, t0.image5 AS image5_19, t0.image6 AS image6_20, t0.open_from AS open_from_21, t0.open_to AS open_to_22, t0.opening AS opening_23, t0.create_user_id AS create_user_id_24, t0.edit_user_id AS edit_user_id_25 FROM app_information t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.39 ms (22.73%) |
1 |
SELECT a0_.id AS id_0, a0_.hash AS hash_1, a0_.logo AS logo_2, a0_.map AS map_3, a0_.offer_image AS offer_image_4, a0_.email AS email_5, a0_.web AS web_6, a0_.shop_number AS shop_number_7, a0_.vip AS vip_8, a0_.vip_discount AS vip_discount_9, a0_.vip_end_date AS vip_end_date_10, a0_.points AS points_11, a0_.image AS image_12, a0_.phone AS phone_13, a0_.first_name AS first_name_14, a0_.last_name AS last_name_15, a0_.open_hours AS open_hours_16, a0_.name AS name_17, a0_.is_active AS is_active_18, a0_.createts AS createts_19, a0_.editts AS editts_20, a0_.qr AS qr_21, a0_.slug AS slug_22, a1_.id AS id_23, a1_.order_by AS order_by_24, a1_.createts AS createts_25, a1_.editts AS editts_26, a1_.image AS image_27, a0_.create_user_id AS create_user_id_28, a0_.edit_user_id AS edit_user_id_29, a1_.create_user_id AS create_user_id_30, a1_.edit_user_id AS edit_user_id_31 FROM app_store a0_ LEFT JOIN app_store_category a2_ ON a0_.id = a2_.store_id LEFT JOIN app_category a1_ ON a1_.id = a2_.category_id WHERE a0_.is_active = 1 ORDER BY a0_.name ASC
Parameters:
[] |
|
0.28 ms (16.40%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.host AS host_4, t0.createts AS createts_5, t0.locale AS locale_6, t0.currencies AS currencies_7, t0.editts AS editts_8, t0.create_user_id AS create_user_id_9, t0.edit_user_id AS edit_user_id_10 FROM domain t0 WHERE t0.host = ? LIMIT 1
Parameters:
[
"freeport.docker.internal.ablevyvoj.cz"
]
|
|
0.21 ms (12.31%) |
1 |
SELECT a0_.id AS id_0, a0_.order_by AS order_by_1, a0_.createts AS createts_2, a0_.editts AS editts_3, a0_.image AS image_4, a1_.name AS name_5, a1_.locale AS locale_6, a1_.slug AS slug_7, a1_.id AS id_8, a0_.create_user_id AS create_user_id_9, a0_.edit_user_id AS edit_user_id_10, a1_.translatable_id AS translatable_id_11 FROM app_category a0_ LEFT JOIN app_category_translations a1_ ON a0_.id = a1_.translatable_id ORDER BY a0_.order_by ASC
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| prodes | doctrine.dbal.prodes_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.