GET https://www.dakam.axpstudio.com/katalogi/10/0/106

Query Metrics

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

Queries

Group similar statements

# Time Info
1 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.id = ?
Parameters:
[
  106
]
2 0.51 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 p0_.producer = ?
Parameters:
[
  1
  "q6OU2C_loctite.jpg"
]
3 0.50 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 p0_.producer = ? ORDER BY p0_.name ASC LIMIT 12 OFFSET 108
Parameters:
[
  1
  "q6OU2C_loctite.jpg"
]
4 0.44 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 p0_.producer = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.name ASC
Parameters:
[
  1
  "q6OU2C_loctite.jpg"
  470
  454
  492
  494
  496
  521
  499
  501
  503
  505
  507
  523
]
5 0.43 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
]
6 0.23 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"}"
]
7 0.29 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
]
8 0.23 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
]
9 1.27 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
]
10 0.27 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
]
11 1.09 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
]
12 0.61 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
]
13 1.34 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
]
14 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
]

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.