Query Metrics

5 Database Queries
5 Different statements
2.17 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.28 ms
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"
]
2 0.73 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.image AS image_3, b0_.group_brands AS group_brands_4, b0_.createts AS createts_5, b0_.editts AS editts_6, b0_.at_home_page AS at_home_page_7, a1_.id AS id_8, a1_.hash AS hash_9, a1_.logo AS logo_10, a1_.map AS map_11, a1_.offer_image AS offer_image_12, a1_.email AS email_13, a1_.web AS web_14, a1_.shop_number AS shop_number_15, a1_.vip AS vip_16, a1_.vip_discount AS vip_discount_17, a1_.vip_end_date AS vip_end_date_18, a1_.points AS points_19, a1_.image AS image_20, a1_.phone AS phone_21, a1_.first_name AS first_name_22, a1_.last_name AS last_name_23, a1_.open_hours AS open_hours_24, a1_.name AS name_25, a1_.is_active AS is_active_26, a1_.createts AS createts_27, a1_.editts AS editts_28, a1_.qr AS qr_29, a1_.slug AS slug_30, b0_.create_user_id AS create_user_id_31, b0_.edit_user_id AS edit_user_id_32, a1_.create_user_id AS create_user_id_33, a1_.edit_user_id AS edit_user_id_34 FROM brand b0_ INNER JOIN app_store_brands a2_ ON b0_.id = a2_.brand_id INNER JOIN app_store a1_ ON a1_.id = a2_.store_id AND (a1_.is_active = 1) ORDER BY b0_.name ASC
Parameters:
[]
3 0.56 ms
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
]
4 0.33 ms
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:
[
  "cs"
  "2026-10-26 23:00:00"
  "2026-10-26 02:00:00"
]
5 0.27 ms
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

Class Mapping errors
App\Entity\Domain No errors.
App\Entity\User No errors.
App\Entity\Brand No errors.
App\Entity\Application\Store No errors.
App\Entity\Dealer No errors.
App\Entity\Product No errors.
App\Entity\BrandTranslation No errors.
App\Entity\Application\Category No errors.
App\Entity\Application\Offer No errors.
App\Entity\Web\Career No errors.
App\Entity\Application\Points No errors.
App\Entity\Application\StoreImage No errors.
App\Entity\Application\StoreTranslation No errors.
App\Entity\Newsletter No errors.
App\Entity\OrderItem No errors.
App\Entity\Order No errors.
App\Entity\ClickAndCollectItem No errors.
App\Entity\LogImport No errors.
App\Entity\Application\AppProduct No errors.
App\Entity\DealerBank No errors.
App\Entity\Reclamation No errors.
App\Entity\DealerTranslation No errors.
App\Entity\ProductImage No errors.
App\Entity\Variant No errors.
App\Entity\Pricelist No errors.
App\Entity\Category No errors.
App\Entity\ProductTranslation No errors.
App\Entity\Application\CategoryTranslation No errors.
App\Entity\Web\TopCategory No errors.
App\Entity\Application\OfferTranslation No errors.
App\Entity\Web\CareerTranslation No errors.
App\Entity\Client No errors.
App\Entity\Application\Bonus No errors.
App\Entity\VIPaccount No errors.
App\Entity\Transport No errors.
App\Entity\ClickAndCollect No errors.
App\Entity\Slide No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\Payment No errors.
App\Entity\ClientAddress No errors.
App\Entity\EmailLog No errors.
App\Entity\SlideTranslation No errors.
App\Entity\OrderLog No errors.
App\Entity\RecentlyProduct No errors.
App\Entity\CartAddress No errors.
App\Entity\CartItem No errors.
App\Entity\PaymentTranslation No errors.
App\Entity\TransportTranslation No errors.
App\Entity\ClientToken No errors.
App\Entity\Web\SlideShow No errors.
App\Entity\Web\SlideShowTranslation No errors.
App\Entity\Web\NewsStore No errors.
App\Entity\Web\NewsStoreTranslation No errors.
App\Entity\Web\News No errors.
App\Entity\Web\NewsTranslation No errors.
App\Entity\Web\Site No errors.
App\Entity\Web\TopCategoryTranslation No errors.
App\Entity\Web\Modal No errors.
App\Entity\Web\ModalTranslation No errors.
App\Entity\Web\SiteTranslation No errors.
App\Entity\Cart No errors.
App\Entity\Application\Notification No errors.
App\Entity\Application\Information No errors.
App\Entity\Application\InformationTranslation No errors.
App\Entity\Application\BonusTranslation No errors.
App\Entity\Application\NotificationTranslation No errors.
App\Entity\Application\NotificationSeen No errors.
App\Entity\Application\Banner No errors.
App\Entity\Application\BannerTranslation No errors.
App\Entity\Application\DeviceToken
  • The association App\Entity\Application\DeviceToken#client refers to the inverse side field App\Entity\Client#deviceTokens which does not exist.
App\Entity\OrderAddress No errors.
Cron\CronBundle\Entity\CronJob No errors.
Cron\CronBundle\Entity\CronReport No errors.
Vich\UploaderBundle\Entity\File No errors.
Lexik\Bundle\TranslationBundle\Model\Translation No errors.
Lexik\Bundle\TranslationBundle\Entity\Translation No errors.
Lexik\Bundle\TranslationBundle\Model\TransUnit No errors.
Lexik\Bundle\TranslationBundle\Entity\TransUnit No errors.
Lexik\Bundle\TranslationBundle\Model\File No errors.
Lexik\Bundle\TranslationBundle\Entity\File No errors.
Dukecity\CommandSchedulerBundle\Entity\ScheduledCommand No errors.