Query Metrics

56 Database Queries
25 Different statements
20.57 ms Query time
0 Invalid entities
177 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.64 ms
(22.56%)
16
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1773954456
  "site_domain_3808adc20ecab895921e2047a17d2dd8"
]
1.98 ms
(9.62%)
1
SELECT DISTINCT c0_.isoCode AS isoCode_0, c0_.name AS name_1, c0_.numericIsoCode AS numericIsoCode_2, c0_.symbol AS symbol_3, c0_.creationDate AS creationDate_4, c0_.modificationDate AS modificationDate_5, c0_.id AS id_6 FROM coreshop_currency c0_ LEFT JOIN coreshop_country c1_ ON c0_.id = c1_.currencyId INNER JOIN coreshop_store_countries c3_ ON c1_.id = c3_.country_id INNER JOIN coreshop_store c2_ ON c2_.id = c3_.store_id WHERE c1_.active = 1 AND c2_.id = ?
Parameters:
[
  1
]
1.51 ms
(7.34%)
4
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/aktualitasok/youtube/"
  "wabi-sabi-seiko-zen-kertek-presage-seiko-boutique-tv-s06e07"
]
1.39 ms
(6.75%)
3
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/aktualitasok/youtube/wabi-sabi-seiko-zen-kertek-presage-seiko-boutique-tv-s06e07"
  "path"
  "auto_create"
  "/aktualitasok/youtube/wabi-sabi-seiko-zen-kertek-presage-seiko-boutique-tv-s06e07"
  "path_query"
  "https://www.boutique.local.szerver.online/aktualitasok/youtube/wabi-sabi-seiko-zen-kertek-presage-seiko-boutique-tv-s06e07"
  "entire_uri"
]
1.39 ms
(6.74%)
4
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
1.17 ms
(5.69%)
4
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1773954456
  "system\x01tags\x01"
  "site\x01tags\x01"
]
1.14 ms
(5.56%)
1
SELECT * FROM object_collection_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  786206
  "content"
]
0.94 ms
(4.57%)
3
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "cs_order"
]
0.81 ms
(3.94%)
3
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  30238
]
0.69 ms
(3.33%)
1
SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE `slug` = 'wabi-sabi-seiko-zen-kertek-presage-seiko-boutique-tv-s06e07'  AND  object_3.type IN ('variant','object') LIMIT 1
Parameters:
[]
0.59 ms
(2.87%)
2
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/aktualitasok/youtube/wabi-sabi-seiko-zen-kertek-presage-seiko-boutique-tv-s06e07"
]
0.51 ms
(2.46%)
1
SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t0.baseCountryId AS baseCountryId_10, t11.isoCode AS isoCode_12, t11.active AS active_13, t11.addressFormat AS addressFormat_14, t11.salutations AS salutations_15, t11.creationDate AS creationDate_16, t11.modificationDate AS modificationDate_17, t11.id AS id_18, t11.zoneId AS zoneId_19, t11.currencyId AS currencyId_20 FROM coreshop_store t0 LEFT JOIN coreshop_country t11 ON t0.baseCountryId = t11.id WHERE t0.id = ?
Parameters:
[
  1
]
0.50 ms
(2.42%)
1
SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_id IN (?)
Parameters:
[
  1
]
0.33 ms
(1.58%)
1
SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  786206
  "content"
]
0.32 ms
(1.58%)
1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?)
Parameters:
[
  1773954457
  "website_config\x01tags\x01"
  "system\x01tags\x01"
  "config\x01tags\x01"
  "output\x01tags\x01"
  "asset_15304\x01tags\x01"
]
0.32 ms
(1.57%)
1
SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  786206
  "content"
]
0.31 ms
(1.51%)
1
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
0.30 ms
(1.44%)
1
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
Parameters:
[
  786206
]
0.27 ms
(1.33%)
1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1773954457
  "document_76\x01tags\x01"
  "asset_16823\x01tags\x01"
  "asset_16821\x01tags\x01"
  "asset_16825\x01tags\x01"
  "asset_16824\x01tags\x01"
  "asset_16820\x01tags\x01"
  "asset_20642\x01tags\x01"
  "asset_21858\x01tags\x01"
  "asset_20603\x01tags\x01"
  "asset_20600\x01tags\x01"
  "asset_20602\x01tags\x01"
  "asset_20601\x01tags\x01"
  "asset_20599\x01tags\x01"
  "asset_16826\x01tags\x01"
  "asset_20648\x01tags\x01"
]
0.26 ms
(1.27%)
1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1773954456
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
0.26 ms
(1.25%)
1
SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  786206
  "content"
]
0.25 ms
(1.19%)
1
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  786206
]
0.24 ms
(1.17%)
1
SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE
Parameters:
[
  786206
]
0.24 ms
(1.14%)
1
SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  786206
  "content"
]
0.23 ms
(1.11%)
1
SELECT * FROM object_relations_3 WHERE src_id = ?
Parameters:
[
  786206
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
pimcore doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
CoreShop\Component\Core\Model\Currency 156
CoreShop\Component\Core\Model\Configuration 18
CoreShop\Component\Core\Model\Store 1
CoreShop\Component\Core\Model\Country 1
CoreShop\Component\Address\Model\Zone 1

pimcore entity manager

Class Amount of managed objects