Query Metrics

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

Queries

Group similar statements

default connection

#▲ Time Info
1 0.32 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.64 ms
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_.description AS description_23, a1_.description_website AS description_website_24, a1_.action_description AS action_description_25, a1_.locale AS locale_26, a1_.id AS id_27, a0_.create_user_id AS create_user_id_28, a0_.edit_user_id AS edit_user_id_29, a1_.translatable_id AS translatable_id_30 FROM app_store a0_ LEFT JOIN app_store_translation a1_ ON a0_.id = a1_.translatable_id WHERE a0_.is_active = 1 AND a0_.vip = 1 ORDER BY a0_.name ASC
Parameters:
[]
3 0.57 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
]

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\Application\Store No errors.
App\Entity\Application\StoreTranslation No errors.
App\Entity\Dealer No errors.
App\Entity\Application\Category No errors.
App\Entity\Brand 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\VIPaccount 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\Application\CategoryTranslation No errors.
App\Entity\BrandTranslation 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\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.