GET https://herbaltest.softwizards.eu/pl/winiarnia

Query Metrics

44 Database Queries
6 Different statements
6.38 ms Query time
0 Invalid entities
154 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.04 ms
(47.74%)
18
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:
[
  "1936"
]
1.67 ms
(26.16%)
18
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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = ?
Parameters:
[
  "1935"
]
0.77 ms
(12.08%)
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, n0_.parent_id AS parent_id_7 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'module_type' AND n1_.locale IN (?, ?)) WHERE n0_.type = ? AND n0_.service = ? AND n0_.locale = ? AND n1_.string_value IN (?) ORDER BY n0_.pos ASC
Parameters:
[
  "xx"
  "pl"
  "winery_menu"
  0
  "pl"
  "left"
]
0.40 ms
(6.24%)
1
SELECT t0.service AS service_1, t0.name AS name_2, t0.locale AS locale_3, t0.pos AS pos_4, t0.type AS type_5, t0.string_value AS string_value_6, t0.int_value AS int_value_7, t0.float_value AS float_value_8, t0.text_value AS text_value_9, t0.date_time_value AS date_time_value_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 setting t0 LEFT JOIN file t12 ON t0.file_value = t12.id LEFT JOIN node t20 ON t0.node_value = t20.id WHERE t0.locale IN (?, ?) AND t0.service = ?
Parameters:
[
  "xx"
  "pl"
  0
]
0.34 ms
(5.35%)
2
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, n0_.parent_id AS parent_id_7 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'public' AND n1_.locale IN (?, ?)) WHERE n0_.type = ? AND n0_.service = ? AND n0_.locale = ? AND n1_.int_value IN (?) ORDER BY n0_.pos ASC
Parameters:
[
  "xx"
  "pl"
  "winery_slider"
  0
  "pl"
  1
]
0.15 ms
(2.43%)
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, n0_.parent_id AS parent_id_7 FROM node n0_ WHERE n0_.type = ? AND n0_.service = ? AND n0_.locale = ? ORDER BY n0_.pos ASC
Parameters:
[
  "winery_about"
  0
  "pl"
]

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
w3des\AdminBundle\Entity\NodeVariable 76
w3des\AdminBundle\Entity\Setting 45
w3des\AdminBundle\Entity\Node 18
w3des\AdminBundle\Entity\File 15