GET https://dakam.axpstudio.com/katalogi/36/0/138

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
2.72 ms
(40.95%)
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.74 ms
(11.09%)
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.71 ms
(10.72%)
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 420
Parameters:
[
  1
]
0.54 ms
(8.14%)
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.45 ms
(6.82%)
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.37 ms
(5.64%)
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
  101
  102
  103
  550
  376
  335
  267
  87
  307
  104
  559
  312
]
0.32 ms
(4.76%)
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.28 ms
(4.16%)
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.27 ms
(4.04%)
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"}"
]
0.24 ms
(3.67%)
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
]

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.