GET https://www.dakam.axpstudio.com/katalogi/37/0/138

Query Metrics

14 Database Queries
10 Different statements
6.64 ms Query time
0 Invalid entities
161 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.71 ms
(40.88%)
3
SELECT t0.id AS id_1, t0.parent AS parent_2, t0.parents AS parents_3, t0.name AS name_4, t0.short AS short_5, t0.content AS content_6, t0.image AS image_7, t0.position AS position_8, t0.clickable AS clickable_9, t0.active AS active_10 FROM pl_products t0 WHERE t0.parent = ? AND t0.active = ? ORDER BY t0.position ASC
Parameters:
[
  0
  1
]
0.75 ms
(11.31%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM pl_catalogs p0_ LEFT JOIN pl_catalogs_categories p1_ ON p0_.catalogs_categories_id = p1_.id WHERE p0_.active = ? ORDER BY p0_.name ASC LIMIT 12 OFFSET 432
Parameters:
[
  1
]
0.64 ms
(9.58%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.active AS active_4 FROM pl_producers t0 WHERE t0.active = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
0.50 ms
(7.54%)
1
SELECT p0_.id AS id_0, p0_.producer AS producer_1, p0_.language AS language_2, p0_.type AS type_3, p0_.name AS name_4, p0_.file AS file_5, p0_.size AS size_6, p0_.active AS active_7, p0_.catalogs_categories_id AS catalogs_categories_id_8 FROM pl_catalogs p0_ LEFT JOIN pl_catalogs_categories p1_ ON p0_.catalogs_categories_id = p1_.id WHERE p0_.active = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.name ASC
Parameters:
[
  1
  41
  548
  157
  158
  159
  105
  75
  69
  268
  152
  114
  235
]
0.47 ms
(7.03%)
2
SELECT t0.id AS id_1, t0.parent AS parent_2, t0.parents AS parents_3, t0.name AS name_4, t0.short AS short_5, t0.content AS content_6, t0.image AS image_7, t0.position AS position_8, t0.clickable AS clickable_9, t0.active AS active_10 FROM pl_knowledge t0 WHERE t0.parent = ? AND t0.position = ? AND t0.active = ? AND t0.clickable = ? LIMIT 1
Parameters:
[
  0
  1
  1
  1
]
0.40 ms
(6.05%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pl_catalogs p0_ LEFT JOIN pl_catalogs_categories p1_ ON p0_.catalogs_categories_id = p1_.id WHERE p0_.active = ?
Parameters:
[
  1
]
0.38 ms
(5.65%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.active AS active_4 FROM pl_producers t0 WHERE t0.id = ?
Parameters:
[
  138
]
0.28 ms
(4.19%)
1
SELECT t0.id AS id_1, t0.parent AS parent_2, t0.parents AS parents_3, t0.level AS level_4, t0.name AS name_5, t0.domain_text AS domain_text_6, t0.title AS title_7, t0.short AS short_8, t0.content AS content_9, t0.image AS image_10, t0.position AS position_11, t0.forward AS forward_12, t0.active AS active_13, t0.in_menu AS in_menu_14, t0.token AS token_15 FROM pl_sitemap t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.27 ms
(4.08%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM pl_catalogs_categories t0 WHERE t0.active = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
0.24 ms
(3.69%)
1
SELECT t0.name AS name_1, t0.params AS params_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5 FROM pl_seo t0 WHERE t0.name = ? AND t0.params = ? LIMIT 1
Parameters:
[
  "sitemap"
  "{"dt":"katalogi"}"
]

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
App\Entity\Producer 96
App\Entity\Product 26
App\Entity\CatalogCategory 25
App\Entity\Catalog 12
App\Entity\SitemapNode 1
App\Entity\SeoMetadata 1

Entities Mapping

Class Mapping errors
App\Entity\Catalog No errors.
App\Entity\Producer No errors.
App\Entity\CatalogCategory No errors.
App\Entity\SitemapNode No errors.
App\Entity\SeoMetadata No errors.
App\Entity\Product No errors.
App\Entity\Knowledge No errors.