Query Metrics

3 Database Queries
3 Different statements
1.57 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
0.73 ms
(46.65%)
1
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:
[]
0.56 ms
(35.48%)
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.28 ms
(17.86%)
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"
]

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.