Query Metrics

8 Database Queries
8 Different statements
30.33 ms Query time
0 Invalid entities
25 Managed entities

Queries

Group similar statements

# Time Info
1 27.57 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.updated_at AS updated_at_4, t0.is_published AS is_published_5, t0.video AS video_6, t0.main_image_id AS main_image_id_7 FROM page t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "offers_index"
]
2 0.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.introduction AS introduction_5, t0.page_id AS page_id_6, t0.language_id AS language_id_7, t0.seo_id AS seo_id_8 FROM page_content t0 WHERE t0.page_id = ?
Parameters:
[
  10
]
3 0.42 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.updated_at AS updated_at_3, t0.is_published AS is_published_4, t0.is_gift_voucher AS is_gift_voucher_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.main_image_id AS main_image_id_8 FROM offer t0 WHERE t0.is_published = ?
Parameters:
[
  1
]
5 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.button AS button_7, t0.link AS link_8, t0.offer_id AS offer_id_9, t0.language_id AS language_id_10, t0.seo_id AS seo_id_11 FROM offer_content t0 WHERE t0.offer_id = ?
Parameters:
[
  1
]
6 0.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.is_published = ?
Parameters:
[
  1
]
7 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  1
  "ca"
]
8 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Seo 6
App\Entity\Language 4
App\Entity\OfferContent 4
App\Entity\RoomContent 4
App\Entity\Image 3
App\Entity\Page 1
App\Entity\PageContent 1
App\Entity\Offer 1
App\Entity\Room 1

Entities Mapping

Class Mapping errors
App\Entity\Page No errors.
App\Entity\Image No errors.
App\Entity\PageContent No errors.
App\Entity\Language No errors.
App\Entity\Seo No errors.
App\Entity\ArticleContent No errors.
App\Entity\ArticleCategoryContent No errors.
App\Entity\Banner No errors.
App\Entity\OfferContent No errors.
App\Entity\Offer No errors.
App\Entity\Room No errors.
App\Entity\RoomContent No errors.
App\Entity\RoomService No errors.