GET https://www.dakam.axpstudio.com/katalogi/2/16

Query Metrics

13 Database Queries
9 Different statements
6.89 ms Query time
0 Invalid entities
156 Managed entities

Queries

Group similar statements

# Time Info
1 1.15 ms
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 = ? AND p1_.id = ?
Parameters:
[
  1
  16
]
2 0.43 ms
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 = ? AND p1_.id = ? ORDER BY p0_.name ASC LIMIT 12 OFFSET 12
Parameters:
[
  1
  16
]
3 0.39 ms
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 p1_.id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.name ASC
Parameters:
[
  1
  16
  225
  268
  114
  235
  269
  115
  226
]
4 0.34 ms
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
]
5 0.27 ms
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"}"
]
6 0.36 ms
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
]
7 0.31 ms
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
]
8 0.97 ms
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
]
9 0.28 ms
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
]
10 0.90 ms
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
]
11 0.24 ms
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
]
12 0.92 ms
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
]
13 0.32 ms
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
]

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 7
App\Entity\SitemapNode 1
App\Entity\SeoMetadata 1

Entities Mapping

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