Query Metrics

3 Database Queries
3 Different statements
1.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
0.43 ms
(43.31%)
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.34 ms
(34.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.22 ms
(22.29%)
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.

Entities Mapping