GET https://new.tossa.cat/ca/schedule/factura-electrnica-40

Query Metrics

6 Database Queries
6 Different statements
44.82 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

#▲ Time Info
1 9.71 ms
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:
[
  "40"
]
2 15.99 ms
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"
]
3 0.81 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.scheduleCategory AS scheduleCategory_4, t0.language AS language_5 FROM schedule_categories_contents t0 WHERE t0.scheduleCategory = ?
Parameters:
[
  8
]
4 2.47 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.fieldOrder AS fieldOrder_3 FROM images t0 WHERE t0.id = ?
Parameters:
[
  799
]
5 7.73 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.fieldOrder AS fieldOrder_3 FROM images t0 INNER JOIN schedule_images ON t0.id = schedule_images.image_id WHERE schedule_images.schedule_id = ? ORDER BY t0.fieldOrder ASC
Parameters:
[
  40
]
6 8.10 ms
SELECT t0.id AS id_1, t0.token AS token_2, t0.date AS date_3, t0.name AS name_4, t0.file AS file_5, t0.fieldOrder AS fieldOrder_6, t0.verified AS verified_7 FROM attacheds t0 INNER JOIN schedule_attacheds ON t0.id = schedule_attacheds.attached_id WHERE schedule_attacheds.news_id = ?
Parameters:
[
  40
]

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\ScheduleCategory 10
App\Entity\Language 2
App\Entity\ScheduleCategoryContent 2
App\Entity\Schedule 1
App\Entity\Image 1