https://freeport.docker.internal.ablevyvoj.cz/novinky

Query Metrics

6 Database Queries
6 Different statements
2.09 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.29 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.74 ms
SELECT w0_.id AS id_0, w0_.date_public AS date_public_1, w0_.date_from AS date_from_2, w0_.date_to AS date_to_3, w0_.is_active AS is_active_4, w0_.is_popup AS is_popup_5, w0_.createts AS createts_6, w0_.editts AS editts_7, w1_.locale AS locale_8, w1_.title AS title_9, w1_.slug AS slug_10, w1_.description AS description_11, w1_.image AS image_12, w1_.createts AS createts_13, w1_.editts AS editts_14, w1_.id AS id_15, w0_.create_user_id AS create_user_id_16, w0_.edit_user_id AS edit_user_id_17, w1_.create_user_id AS create_user_id_18, w1_.edit_user_id AS edit_user_id_19, w1_.translatable_id AS translatable_id_20 FROM web_news w0_ INNER JOIN web_news_translation w1_ ON w0_.id = w1_.translatable_id AND (w1_.locale = ?) WHERE w0_.is_active = 1 AND (w0_.date_from IS NULL OR (? BETWEEN w0_.date_from AND w0_.date_to)) ORDER BY w0_.date_public DESC LIMIT 3
Parameters:
[
  "cs"
  "2026-10-26 14:19:14"
]
3 0.30 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.28 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.24 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:
[]
6 0.25 ms
SELECT t0.image AS image_1, t0.locale AS locale_2, t0.text AS text_3, t0.createts AS createts_4, t0.editts AS editts_5, t0.id AS id_6, t0.create_user_id AS create_user_id_7, t0.edit_user_id AS edit_user_id_8, t0.translatable_id AS translatable_id_9 FROM app_information_translation t0 WHERE t0.translatable_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\Web\News No errors.
App\Entity\Web\NewsTranslation No errors.
App\Entity\Dealer No errors.
App\Entity\Application\Store No errors.
App\Entity\Web\NewsStore 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\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\Application\StoreTranslation No errors.
App\Entity\Web\NewsStoreTranslation 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\BrandTranslation 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\TopCategory No errors.
App\Entity\Web\CareerTranslation 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\Client 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\CategoryTranslation No errors.
App\Entity\Application\Bonus No errors.
App\Entity\Application\BonusTranslation No errors.
App\Entity\Application\NotificationTranslation No errors.
App\Entity\Application\NotificationSeen No errors.
App\Entity\Application\OfferTranslation 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.