Query Metrics
7
Database Queries
6
Different statements
2.29 ms
Query time
1
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.55 ms (24.11%) |
2 |
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.42 ms (18.43%) |
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 (16.85%) |
1 |
SELECT w0_.id AS id_0, w0_.date_public AS date_public_1, w0_.type AS type_2, w0_.contact_name AS contact_name_3, w0_.email AS email_4, w0_.phone AS phone_5, w0_.is_active AS is_active_6, w0_.createts AS createts_7, w0_.editts AS editts_8, w1_.locale AS locale_9, w1_.name AS name_10, w1_.contact_time AS contact_time_11, w1_.randomint AS randomint_12, w1_.about AS about_13, w1_.description AS description_14, w1_.description_need AS description_need_15, w1_.description_offer AS description_offer_16, w1_.slug AS slug_17, w1_.createts AS createts_18, w1_.editts AS editts_19, w1_.id AS id_20, w0_.create_user_id AS create_user_id_21, w0_.edit_user_id AS edit_user_id_22, w0_.store_id AS store_id_23, w1_.create_user_id AS create_user_id_24, w1_.edit_user_id AS edit_user_id_25, w1_.translatable_id AS translatable_id_26 FROM web_career w0_ LEFT JOIN web_career_translation w1_ ON w0_.id = w1_.translatable_id WHERE w0_.is_active = 1 ORDER BY w0_.date_public DESC
Parameters:
[] |
|
0.35 ms (15.20%) |
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.31 ms (13.62%) |
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.79%) |
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
]
|
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.