Query Metrics

7 Database Queries
4 Different statements
7.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.63 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.second_title AS second_title_4, t0.description AS description_5, t0.active AS active_6, t0.sort AS sort_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.date_created AS date_created_10, t0.date_modified AS date_modified_11 FROM section t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "events"
]
2 0.88 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.event_date AS event_date_4, t0.shortdescription AS shortdescription_5, t0.description AS description_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.active AS active_9, t0.sort AS sort_10, t0.date_created AS date_created_11, t0.date_modified AS date_modified_12, t0.link AS link_13 FROM news t0 WHERE t0.active = ? ORDER BY t0.sort ASC
Parameters:
[
  1
]
3 1.02 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "3"
  "ca"
  "App\Entity\News"
]
4 0.69 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "4"
  "ca"
  "App\Entity\News"
]
5 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = ? AND t0.section = ? AND t0.type = ? ORDER BY t0.sort ASC LIMIT 1
Parameters:
[
  3
  "news"
  "mainImage"
]
6 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = ? AND t0.section = ? AND t0.type = ? ORDER BY t0.sort ASC LIMIT 1
Parameters:
[
  4
  "news"
  "mainImage"
]
7 1.23 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.second_title AS second_title_4, t0.description AS description_5, t0.active AS active_6, t0.sort AS sort_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.date_created AS date_created_10, t0.date_modified AS date_modified_11 FROM section t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "footer"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Section No errors.
App\Entity\News No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
App\Entity\File No errors.