https://cud.devecomputer.com/

Query Metrics

16 Database Queries
5 Different statements
388.57 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 90.96 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.creation_date AS creation_date_3, t0.slug AS slug_4, t0.is_private AS is_private_5 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "index"
]
2 37.23 ms
SELECT t0.id AS id_1, t0.src AS src_2, t0.custom_type AS custom_type_3, t0.footer AS footer_4, t0.description AS description_5, t0.custom_order AS custom_order_6, t0.data AS data_7, t0.content AS content_8, t0.publish_date AS publish_date_9, t0.page_id AS page_id_10, t0.media_object_id AS media_object_id_11 FROM section t0 WHERE t0.page_id = ? ORDER BY t0.custom_order ASC
Parameters:
[
  16
]
3 9.14 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t4.id AS id_5, t4.src AS src_6, t4.custom_type AS custom_type_7, t4.footer AS footer_8, t4.description AS description_9, t4.custom_order AS custom_order_10, t4.data AS data_11, t4.content AS content_12, t4.publish_date AS publish_date_13, t4.page_id AS page_id_14, t4.media_object_id AS media_object_id_15 FROM media_object t0 LEFT JOIN section t4 ON t4.media_object_id = t0.id WHERE t0.id = ?
Parameters:
[
  55
]
4 24.32 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t4.id AS id_5, t4.src AS src_6, t4.custom_type AS custom_type_7, t4.footer AS footer_8, t4.description AS description_9, t4.custom_order AS custom_order_10, t4.data AS data_11, t4.content AS content_12, t4.publish_date AS publish_date_13, t4.page_id AS page_id_14, t4.media_object_id AS media_object_id_15 FROM media_object t0 LEFT JOIN section t4 ON t4.media_object_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
5 3.58 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t4.id AS id_5, t4.src AS src_6, t4.custom_type AS custom_type_7, t4.footer AS footer_8, t4.description AS description_9, t4.custom_order AS custom_order_10, t4.data AS data_11, t4.content AS content_12, t4.publish_date AS publish_date_13, t4.page_id AS page_id_14, t4.media_object_id AS media_object_id_15 FROM media_object t0 LEFT JOIN section t4 ON t4.media_object_id = t0.id WHERE t0.id = ?
Parameters:
[
  5
]
6 9.54 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t4.id AS id_5, t4.src AS src_6, t4.custom_type AS custom_type_7, t4.footer AS footer_8, t4.description AS description_9, t4.custom_order AS custom_order_10, t4.data AS data_11, t4.content AS content_12, t4.publish_date AS publish_date_13, t4.page_id AS page_id_14, t4.media_object_id AS media_object_id_15 FROM media_object t0 LEFT JOIN section t4 ON t4.media_object_id = t0.id WHERE t0.id = ?
Parameters:
[
  6
]
7 7.03 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t4.id AS id_5, t4.src AS src_6, t4.custom_type AS custom_type_7, t4.footer AS footer_8, t4.description AS description_9, t4.custom_order AS custom_order_10, t4.data AS data_11, t4.content AS content_12, t4.publish_date AS publish_date_13, t4.page_id AS page_id_14, t4.media_object_id AS media_object_id_15 FROM media_object t0 LEFT JOIN section t4 ON t4.media_object_id = t0.id WHERE t0.id = ?
Parameters:
[
  7
]
8 16.90 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t4.id AS id_5, t4.src AS src_6, t4.custom_type AS custom_type_7, t4.footer AS footer_8, t4.description AS description_9, t4.custom_order AS custom_order_10, t4.data AS data_11, t4.content AS content_12, t4.publish_date AS publish_date_13, t4.page_id AS page_id_14, t4.media_object_id AS media_object_id_15 FROM media_object t0 LEFT JOIN section t4 ON t4.media_object_id = t0.id WHERE t0.id = ?
Parameters:
[
  8
]
9 7.35 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t4.id AS id_5, t4.src AS src_6, t4.custom_type AS custom_type_7, t4.footer AS footer_8, t4.description AS description_9, t4.custom_order AS custom_order_10, t4.data AS data_11, t4.content AS content_12, t4.publish_date AS publish_date_13, t4.page_id AS page_id_14, t4.media_object_id AS media_object_id_15 FROM media_object t0 LEFT JOIN section t4 ON t4.media_object_id = t0.id WHERE t0.id = ?
Parameters:
[
  9
]
10 2.85 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t4.id AS id_5, t4.src AS src_6, t4.custom_type AS custom_type_7, t4.footer AS footer_8, t4.description AS description_9, t4.custom_order AS custom_order_10, t4.data AS data_11, t4.content AS content_12, t4.publish_date AS publish_date_13, t4.page_id AS page_id_14, t4.media_object_id AS media_object_id_15 FROM media_object t0 LEFT JOIN section t4 ON t4.media_object_id = t0.id WHERE t0.id = ?
Parameters:
[
  10
]
11 40.71 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.creation_date AS creation_date_3, n0_.publish_date AS publish_date_4, n0_.is_event AS is_event_5, n0_.image_path AS image_path_6, n0_.content_resume AS content_resume_7, n0_.contest_place AS contest_place_8, n0_.category_id AS category_id_9 FROM news_item n0_ WHERE n0_.category_id = ? OR n0_.category_id = ? ORDER BY n0_.publish_date DESC LIMIT 2
Parameters:
[
  "2"
  "5"
]
12 15.52 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.creation_date AS creation_date_3, n0_.publish_date AS publish_date_4, n0_.is_event AS is_event_5, n0_.image_path AS image_path_6, n0_.content_resume AS content_resume_7, n0_.contest_place AS contest_place_8, n0_.category_id AS category_id_9 FROM news_item n0_ WHERE n0_.category_id = ? OR n0_.category_id = ? ORDER BY n0_.publish_date DESC LIMIT 2
Parameters:
[
  "3"
  "4"
]
13 91.12 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t0.file_key AS file_key_4, t0.news_item_id AS news_item_id_5 FROM media_object_news_item t0 WHERE t0.news_item_id = ?
Parameters:
[
  17
]
14 24.49 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t0.file_key AS file_key_4, t0.news_item_id AS news_item_id_5 FROM media_object_news_item t0 WHERE t0.news_item_id = ?
Parameters:
[
  16
]
15 4.25 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t0.file_key AS file_key_4, t0.news_item_id AS news_item_id_5 FROM media_object_news_item t0 WHERE t0.news_item_id = ?
Parameters:
[
  20
]
16 3.59 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.creation_date AS creation_date_3, t0.file_key AS file_key_4, t0.news_item_id AS news_item_id_5 FROM media_object_news_item t0 WHERE t0.news_item_id = ?
Parameters:
[
  11
]

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\Page No errors.
App\Entity\Section No errors.
App\Entity\NewsItem No errors.
App\Entity\MediaObject No errors.
App\Entity\NewsItemCategory No errors.
App\Entity\MediaObjectNewsItem No errors.
App\Entity\NewsItemUser No errors.