Query Metrics

30 Database Queries
4 Different statements
138.83 ms Query time
0 Invalid entities
203 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
60.33 ms
(43.46%)
14
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  10
]
40.35 ms
(29.06%)
14
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  10
]
30.93 ms
(22.28%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.orderPosition AS orderPosition_2, s0_.isActive AS isActive_3, s0_.parent AS parent_4, s0_.image AS image_5 FROM schedule_categories s0_ INNER JOIN schedule_categories_contents s1_ ON s0_.id = s1_.scheduleCategory INNER JOIN languages l2_ ON s1_.language = l2_.id WHERE l2_.id = ? AND s0_.isActive = 1 ORDER BY s1_.name ASC
Parameters:
[
  "ca"
]
7.21 ms
(5.19%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.isPublished AS isPublished_3, t0.isOld AS isOld_4, t0.date AS date_5, t0.startDate AS startDate_6, t0.endDate AS endDate_7, t0.startPublishDate AS startPublishDate_8, t0.title AS title_9, t0.author AS author_10, t0.introduction AS introduction_11, t0.body AS body_12, t0.source AS source_13, t0.link AS link_14, t0.linkText AS linkText_15, t0.url AS url_16, t0.category AS category_17, t0.mainImage AS mainImage_18, t0.language AS language_19 FROM schedule t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "10"
]

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\PageContent 81
App\Entity\Page 81
App\Entity\PageCategoryContent 14
App\Entity\PageCategory 14
App\Entity\ScheduleCategory 10
App\Entity\Schedule 1
App\Entity\Image 1
App\Entity\Language 1

Entities Mapping