Query Metrics
129
Database Queries
9
Different statements
33.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
17.69 ms (52.63%) |
59 |
SELECT t0.name AS name_1, t0.locale AS locale_2, t0.pos AS pos_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.text_value AS text_value_8, t0.date_time_value AS date_time_value_9, t0.node_id AS node_id_10, t0.file_value AS file_value_11, t12.id AS id_13, t12.path AS path_14, t12.repository AS repository_15, t12.mime AS mime_16, t12.size AS size_17, t12.meta AS meta_18, t0.node_value AS node_value_19, t20.id AS id_21, t20.service AS service_22, t20.pos AS pos_23, t20.type AS type_24, t20.locale AS locale_25, t20.external_id AS external_id_26, t20.meta AS meta_27, t20.parent_id AS parent_id_28 FROM node_variable t0 LEFT JOIN file t12 ON t0.file_value = t12.id LEFT JOIN node t20 ON t0.node_value = t20.id WHERE t0.node_id = ? ORDER BY t0.pos ASC
Parameters:
[
"97"
]
|
|
6.20 ms (18.45%) |
31 |
SELECT t0.id AS id_1, t0.service AS service_2, t0.locale AS locale_3, t0.slug AS slug_4, t0.path AS path_5, t0.type AS type_6, t0.target AS target_7 FROM url t0 INNER JOIN node_urls ON t0.id = node_urls.url_id WHERE node_urls.node_id = ?
Parameters:
[
"97"
]
|
|
4.19 ms (12.48%) |
30 |
SELECT t0.id AS id_1, t0.service AS service_2, t0.pos AS pos_3, t0.type AS type_4, t0.locale AS locale_5, t0.external_id AS external_id_6, t0.meta AS meta_7, t0.parent_id AS parent_id_8 FROM node t0 WHERE t0.parent_id = ? ORDER BY t0.pos ASC
Parameters:
[
"51"
]
|
|
2.44 ms (7.26%) |
4 |
SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6, n1_.name AS name_7, n1_.locale AS locale_8, n1_.pos AS pos_9, n1_.type AS type_10, n1_.string_value AS string_value_11, n1_.int_value AS int_value_12, n1_.float_value AS float_value_13, n1_.text_value AS text_value_14, n1_.date_time_value AS date_time_value_15, f2_.id AS id_16, f2_.path AS path_17, f2_.repository AS repository_18, f2_.mime AS mime_19, f2_.size AS size_20, f2_.meta AS meta_21, n3_.id AS id_22, n3_.service AS service_23, n3_.pos AS pos_24, n3_.type AS type_25, n3_.locale AS locale_26, n3_.external_id AS external_id_27, n3_.meta AS meta_28, n0_.parent_id AS parent_id_29, n1_.node_id AS node_id_30, n1_.file_value AS file_value_31, n1_.node_value AS node_value_32, n3_.parent_id AS parent_id_33 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id LEFT JOIN file f2_ ON n1_.file_value = f2_.id LEFT JOIN node n3_ ON n1_.node_value = n3_.id WHERE n0_.type = ? AND n0_.service = ? AND n0_.locale = ? AND n0_.parent_id IS NULL ORDER BY n0_.pos ASC, n0_.pos ASC, n0_.id ASC, n1_.pos asc
Parameters:
[ "menu" 0 "pl" ] |
|
1.17 ms (3.48%) |
1 |
SELECT u0_.target AS target_0, u0_.type AS type_1 FROM url u0_ WHERE u0_.service = ? AND ((u0_.locale = ? AND u0_.path = ?) OR (u0_.type = ? AND u0_.locale = ? AND u0_.path = ?)) LIMIT 1
Parameters:
[ 0 "pl" "rozbudowa-gospodarki-wodno-sciekowej-na-terenie-aglomeracji-siechnice" "redirect" "xx" "/rozbudowa-gospodarki-wodno-sciekowej-na-terenie-aglomeracji-siechnice" ] |
|
0.84 ms (2.50%) |
1 |
SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6, n1_.name AS name_7, n1_.locale AS locale_8, n1_.pos AS pos_9, n1_.type AS type_10, n1_.string_value AS string_value_11, n1_.int_value AS int_value_12, n1_.float_value AS float_value_13, n1_.text_value AS text_value_14, n1_.date_time_value AS date_time_value_15, f2_.id AS id_16, f2_.path AS path_17, f2_.repository AS repository_18, f2_.mime AS mime_19, f2_.size AS size_20, f2_.meta AS meta_21, n3_.id AS id_22, n3_.service AS service_23, n3_.pos AS pos_24, n3_.type AS type_25, n3_.locale AS locale_26, n3_.external_id AS external_id_27, n3_.meta AS meta_28, n0_.parent_id AS parent_id_29, n1_.node_id AS node_id_30, n1_.file_value AS file_value_31, n1_.node_value AS node_value_32, n3_.parent_id AS parent_id_33 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id LEFT JOIN file f2_ ON n1_.file_value = f2_.id LEFT JOIN node n3_ ON n1_.node_value = n3_.id WHERE n0_.type = ? AND n0_.service = ? AND n0_.locale = ? AND n0_.parent_id = ? ORDER BY n0_.pos ASC, n0_.pos ASC, n0_.id ASC, n1_.pos asc
Parameters:
[ "image" 0 "xx" "200" ] |
|
0.53 ms (1.58%) |
1 |
SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6, n1_.name AS name_7, n1_.locale AS locale_8, n1_.pos AS pos_9, n1_.type AS type_10, n1_.string_value AS string_value_11, n1_.int_value AS int_value_12, n1_.float_value AS float_value_13, n1_.text_value AS text_value_14, n1_.date_time_value AS date_time_value_15, f2_.id AS id_16, f2_.path AS path_17, f2_.repository AS repository_18, f2_.mime AS mime_19, f2_.size AS size_20, f2_.meta AS meta_21, n3_.id AS id_22, n3_.service AS service_23, n3_.pos AS pos_24, n3_.type AS type_25, n3_.locale AS locale_26, n3_.external_id AS external_id_27, n3_.meta AS meta_28, n0_.parent_id AS parent_id_29, n1_.node_id AS node_id_30, n1_.file_value AS file_value_31, n1_.node_value AS node_value_32, n3_.parent_id AS parent_id_33 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id LEFT JOIN file f2_ ON n1_.file_value = f2_.id LEFT JOIN node n3_ ON n1_.node_value = n3_.id WHERE n0_.type = ? AND n0_.service = ? AND n0_.locale = ? ORDER BY n0_.pos ASC, n0_.pos ASC, n0_.id ASC, n1_.pos asc
Parameters:
[ "slider" 0 "pl" ] |
|
0.36 ms (1.08%) |
1 |
SELECT t0.id AS id_1, t0.service AS service_2, t0.pos AS pos_3, t0.type AS type_4, t0.locale AS locale_5, t0.external_id AS external_id_6, t0.meta AS meta_7, t0.parent_id AS parent_id_8 FROM node t0 WHERE t0.id = ?
Parameters:
[
97
]
|
|
0.18 ms (0.54%) |
1 |
SELECT t0.type AS type_1, t0.pos AS pos_2, t0.node_id AS node_id_3, t0.target_node_id AS target_node_id_4 FROM node_pos t0 WHERE t0.node_id = ?
Parameters:
[
"97"
]
|
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 |
|---|---|
| w3des\AdminBundle\Entity\Url | No errors. |
| w3des\AdminBundle\Entity\Node | No errors. |
| w3des\AdminBundle\Entity\NodeVariable | No errors. |
| w3des\AdminBundle\Entity\NodePos | No errors. |
| w3des\AdminBundle\Entity\File | No errors. |