Query Metrics
7
Database Queries
7
Different statements
2.34 ms
Query time
1
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.54 ms (22.94%) |
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.35 ms (15.10%) |
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.34 ms (14.67%) |
1 |
SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.from_outlet_price AS from_outlet_price_2, a0_.from_normal_price AS from_normal_price_3, a0_.is_public AS is_public_4, a0_.date_from AS date_from_5, a0_.date_to AS date_to_6, a0_.public_date AS public_date_7, a0_.createts AS createts_8, a0_.editts AS editts_9, a0_.image AS image_10, a1_.locale AS locale_11, a1_.name AS name_12, a1_.title AS title_13, a1_.sub_title AS sub_title_14, a1_.description AS description_15, a1_.id AS id_16, a0_.store_id AS store_id_17, a0_.category_id AS category_id_18, a0_.top_category_id AS top_category_id_19, a0_.create_user_id AS create_user_id_20, a0_.edit_user_id AS edit_user_id_21, a1_.translatable_id AS translatable_id_22 FROM app_offer a0_ LEFT JOIN app_offer_translation a1_ ON a0_.id = a1_.translatable_id WHERE a0_.is_active = 1 AND a0_.is_public = 1 AND a0_.date_to >= ? ORDER BY a0_.editts DESC
Parameters:
[
"2026-10-26 00:10:00"
]
|
|
0.31 ms (13.39%) |
1 |
SELECT t0.image AS image_1, t0.locale AS locale_2, t0.text AS text_3, t0.createts AS createts_4, t0.editts AS editts_5, t0.id AS id_6, t0.create_user_id AS create_user_id_7, t0.edit_user_id AS edit_user_id_8, t0.translatable_id AS translatable_id_9 FROM app_information_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
|
0.29 ms (12.54%) |
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.27 ms (11.43%) |
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:
[] |
|
0.23 ms (9.93%) |
1 |
SELECT w0_.id AS id_0, w0_.order_by AS order_by_1, w0_.createts AS createts_2, w0_.editts AS editts_3, w0_.image AS image_4, w1_.name AS name_5, w1_.locale AS locale_6, w1_.slug AS slug_7, w1_.id AS id_8, w0_.create_user_id AS create_user_id_9, w0_.edit_user_id AS edit_user_id_10, w1_.translatable_id AS translatable_id_11 FROM web_category w0_ LEFT JOIN web_category_translations w1_ ON w0_.id = w1_.translatable_id ORDER BY w0_.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.