Query Metrics

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

Grouped Statements

Show all queries

default connection

Time▼ Count Info
0.42 ms
(24.63%)
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.53%)
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
(20.32%)
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
(18.20%)
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.25 ms
(14.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.

Entities Mapping

Class Mapping errors
App\Entity\Domain No errors.
App\Entity\User No errors.
App\Entity\Web\Career No errors.
App\Entity\Web\CareerTranslation No errors.
App\Entity\Application\Store No errors.
App\Entity\Application\Category No errors.
App\Entity\Application\CategoryTranslation No errors.
App\Entity\Dealer No errors.
App\Entity\Brand No errors.
App\Entity\Application\Offer 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\Product 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\BrandTranslation No errors.
App\Entity\Web\TopCategory No errors.
App\Entity\Application\OfferTranslation 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\Category No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\Payment No errors.
App\Entity\Pricelist 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\ProductImage No errors.
App\Entity\PaymentTranslation No errors.
App\Entity\Variant 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.
App\Entity\ProductTranslation 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.