GET https://rynekconstructora.com/proyectos/21/detalle

Query Metrics

16 Database Queries
9 Different statements
16.70 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.resume AS resume_4, t0.date AS date_5, t0.principal_image AS principal_image_6, t0.top AS top_7, t0.user_id_id AS user_id_id_8 FROM projects t0 WHERE t0.id = ?
Parameters:
[
  "21"
]
2 1.50 ms
SELECT t0.id AS id_1, t0.page AS page_2, t0.type AS type_3, t0.content AS content_4, t0.image_id AS image_id_5 FROM pages t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "headerfooter"
]
3 1.42 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.created AS created_2, p0_.description AS description_3, p0_.resume AS resume_4, p0_.image AS image_5, p0_.date AS date_6, p0_.user_id_id AS user_id_id_7 FROM posts p0_ ORDER BY p0_.date ASC LIMIT 4
Parameters:
[]
4 2.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM tags t0 INNER JOIN projects_tags ON t0.id = projects_tags.tags_id WHERE projects_tags.projects_id = ?
Parameters:
[
  21
]
5 1.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM tags t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  6
]
6 1.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  6
]
7 0.52 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  7
]
8 1.00 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  8
]
9 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
10 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  10
]
11 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
12 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  10
]
13 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  3
]
14 1.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.type AS type_4, t0.project_id_id AS project_id_id_5 FROM photos t0 WHERE t0.project_id_id = ?
Parameters:
[
  21
]
15 0.65 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.resume AS resume_4, t0.date AS date_5, t0.principal_image AS principal_image_6, t0.top AS top_7, t0.user_id_id AS user_id_id_8 FROM projects t0 INNER JOIN projects_tags ON t0.id = projects_tags.projects_id WHERE projects_tags.tags_id = ?
Parameters:
[
  6
]
16 1.14 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5 FROM users t0 WHERE t0.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.

Entities Mapping

Class Mapping errors
App\Entity\Projects No errors.
App\Entity\Users No errors.
App\Entity\Tags No errors.
App\Entity\Photos No errors.
App\Entity\Pages No errors.
App\Entity\Posts No errors.
App\Entity\Btags No errors.
App\Entity\Fields No errors.