Query Metrics

47Database Queries
20Different statements
19.88 msQuery time
0Invalid entities
178Managed entities

Queries

Group similar statements

#TimeInfo
1 1.34 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3"
]
2 0.39 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519103
  "system\x01tags\x01"
  "site\x01tags\x01"
]
3 0.41 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.63 ms
SELECT*FROMredirectsWHERE
            (
                (source=?AND (`type`=?OR`type`=?)) OR
                (source=?AND`type`=?) OR
                (source=?AND`type`=?)
            ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC
Parameters:
[
  "/aktualitasok/youtube/meghivo-prospex-marinemaster-event"
  "path"
  "auto_create"
  "/aktualitasok/youtube/meghivo-prospex-marinemaster-event"
  "path_query"
  "https://boutiqueapi.local.szerver.store/aktualitasok/youtube/meghivo-prospex-marinemaster-event"
  "entire_uri"
]
5 0.36 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "system_route_redirect"
]
6 0.37 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783519103
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
7 0.44 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "maintenance_mode"
]
8 0.31 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "reports"
  "pimcore"
]
9 0.52 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/aktualitasok/youtube/"
  "meghivo-prospex-marinemaster-event"
]
10 0.29 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/aktualitasok/youtube/meghivo-prospex-marinemaster-event"
]
11 0.37 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/aktualitasok/"
  "youtube"
]
12 0.26 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/aktualitasok/youtube"
]
13 0.29 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/"
  "aktualitasok"
]
14 0.32 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "document_12"
]
15 0.30 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "document_12\x01tags\x01"
]
16 0.32 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "document_properties_12"
]
17 0.33 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519103
  "document_properties\x01tags\x01"
  "document_12\x01tags\x01"
]
18 0.51 ms
SELECTt0.nameASname_1,t0.templateAStemplate_2,t0.isDefaultASisDefault_3,t0.siteIdASsiteId_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.useGrossPriceASuseGrossPrice_8,t0.currencyIdAScurrencyId_9,t0.baseCountryIdASbaseCountryId_10,t11.isoCodeASisoCode_12,t11.activeASactive_13,t11.addressFormatASaddressFormat_14,t11.salutationsASsalutations_15,t11.creationDateAScreationDate_16,t11.modificationDateASmodificationDate_17,t11.idASid_18,t11.zoneIdASzoneId_19,t11.currencyIdAScurrencyId_20FROMcoreshop_storet0LEFT JOINcoreshop_countryt11ONt0.baseCountryId=t11.idWHEREt0.id=?
Parameters:
[1]
19 0.54 ms
SELECTt0.configKeyASconfigKey_1,t0.dataASdata_2,t0.creationDateAScreationDate_3,t0.modificationDateASmodificationDate_4,t0.idASid_5,t0.store_idASstore_id_6FROMcoreshop_configurationt0WHEREt0.store_idIN (?)
Parameters:
[1]
20 0.42 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_order"
]
21 0.44 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "sites_path_mapping"
]
22 0.38 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519103
  "system\x01tags\x01"
  "resource\x01tags\x01"
]
23 0.43 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "3"
]
24 0.75 ms
SELECTobject_3.idasid,object_3.typeas`type`FROMobject_3WHERE`slug`='meghivo-prospex-marinemaster-event'ANDobject_3.typeIN ('variant','object') LIMIT1
Parameters:
[]
25 0.37 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "object_909264"
]
26 0.55 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?)
Parameters:
[1783519103
  "object_909264\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_34592\x01tags\x01"
  "asset_34593\x01tags\x01"
]
27 0.43 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[34593]
28 0.36 ms
SELECT*FROMobject_relations_3WHEREsrc_id=?
Parameters:
[909264]
29 0.32 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "object_375322"
]
30 0.37 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519103
  "object_375322\x01tags\x01"
  "class_4\x01tags\x01"
]
31 0.27 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "4"
]
32 0.49 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "website_config"
]
33 0.29 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?)
Parameters:
[1783519103
  "website_config\x01tags\x01"
  "system\x01tags\x01"
  "config\x01tags\x01"
  "output\x01tags\x01"
  "asset_15304\x01tags\x01"
]
34 0.27 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/shared/"
  "header"
]
35 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "document_76"
]
36 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1783519103
  "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"
]
37 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519103
  "document_properties_76"
]
38 0.17 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519103
  "document_properties\x01tags\x01"
  "document_76\x01tags\x01"
]
39 0.35 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
40 0.44 ms
SELECT*FROMredirectsWHERE
            (
                (source=?AND (`type`=?OR`type`=?)) OR
                (source=?AND`type`=?) OR
                (source=?AND`type`=?)
            ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController"
  "path_query"
  "https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController"
  "entire_uri"
]
41 0.36 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
42 0.42 ms
SELECT*FROMredirectsWHERE
            (
                (source=?AND (`type`=?OR`type`=?)) OR
                (source=?AND`type`=?) OR
                (source=?AND`type`=?)
            ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction"
  "path_query"
  "https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction"
  "entire_uri"
]
43 1.55 ms
SELECTDISTINCTc0_.isoCodeASisoCode_0,c0_.nameASname_1,c0_.numericIsoCodeASnumericIsoCode_2,c0_.symbolASsymbol_3,c0_.creationDateAScreationDate_4,c0_.modificationDateASmodificationDate_5,c0_.idASid_6FROMcoreshop_currencyc0_LEFT JOINcoreshop_countryc1_ONc0_.id=c1_.currencyIdINNER JOINcoreshop_store_countriesc3_ONc1_.id=c3_.country_idINNER JOINcoreshop_storec2_ONc2_.id=c3_.store_idWHEREc1_.active=1ANDc2_.id=?
Parameters:
[1]
44 0.41 ms
SELECTt0.nameASname_1,t0.creationDateAScreationDate_2,t0.modificationDateASmodificationDate_3,t0.idASid_4,t0.localeASlocale_5,t0.translatable_idAStranslatable_id_6FROMcoreshop_country_translationt0WHEREt0.translatable_id=?ANDt0.locale=?LIMIT1
Parameters:
[11
  "hu_HU"
]
45 0.31 ms
SELECTt0.nameASname_1,t0.templateAStemplate_2,t0.isDefaultASisDefault_3,t0.siteIdASsiteId_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.useGrossPriceASuseGrossPrice_8,t0.currencyIdAScurrencyId_9,t0.baseCountryIdASbaseCountryId_10,t11.isoCodeASisoCode_12,t11.activeASactive_13,t11.addressFormatASaddressFormat_14,t11.salutationsASsalutations_15,t11.creationDateAScreationDate_16,t11.modificationDateASmodificationDate_17,t11.idASid_18,t11.zoneIdASzoneId_19,t11.currencyIdAScurrencyId_20FROMcoreshop_storet0LEFT JOINcoreshop_countryt11ONt0.baseCountryId=t11.id
Parameters:
[]
46 0.37 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
47 0.44 ms
SELECT*FROMredirectsWHERE
            (
                (source=?AND (`type`=?OR`type`=?)) OR
                (source=?AND`type`=?) OR
                (source=?AND`type`=?)
            ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_format=html&_locale=hu&_controller=CoreShop%5CBundle%5CFrontendBundle%5CController%5CCartController%3A%3AwidgetAction"
  "path_query"
  "https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu&_controller=CoreShop%5CBundle%5CFrontendBundle%5CController%5CCartController%3A%3AwidgetAction"
  "entire_uri"
]

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
CoreShop\Component\Address\Model\CountryTranslation 1

pimcore entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
CoreShop\Component\Store\Model\Store No errors.
CoreShop\Component\Core\Model\Store No errors.
CoreShop\Component\Currency\Model\ExchangeRate No errors.
CoreShop\Component\Currency\Model\Currency No errors.
CoreShop\Component\Core\Model\Currency No errors.
CoreShop\Component\Product\Model\ProductPriceRule No errors.
CoreShop\Component\Taxation\Model\TaxRule No errors.
CoreShop\Component\Core\Model\TaxRule No errors.
CoreShop\Component\Configuration\Model\Configuration No errors.
CoreShop\Component\Core\Model\Configuration No errors.
CoreShop\Component\Taxation\Model\TaxRate No errors.
CoreShop\Component\Shipping\Model\ShippingRule No errors.
CoreShop\Component\Shipping\Model\Carrier No errors.
CoreShop\Component\Core\Model\Carrier No errors.
CoreShop\Component\Order\Model\CartPriceRule No errors.
CoreShop\Component\Order\Model\CartPriceRuleVoucherCode No errors.
CoreShop\Component\Order\Model\CartPriceRuleVoucherCodeCustomer No errors.
CoreShop\Component\Payment\Model\PaymentProviderRule No errors.
CoreShop\Component\Address\Model\Country No errors.
CoreShop\Component\Core\Model\Country No errors.
CoreShop\Component\Address\Model\Zone No errors.
CoreShop\Component\Address\Model\CountryTranslation No errors.
CoreShop\Component\Address\Model\State No errors.
CoreShop\Component\Product\Model\ProductPriceRuleTranslation No errors.
CoreShop\Component\Rule\Model\Condition No errors.
CoreShop\Component\Rule\Model\Action No errors.
CoreShop\Component\Taxation\Model\TaxRuleGroup No errors.
CoreShop\Component\Taxation\Model\TaxRateTranslation No errors.
CoreShop\Component\Shipping\Model\ShippingRuleGroup No errors.
CoreShop\Component\Shipping\Model\CarrierTranslation No errors.
CoreShop\Component\Order\Model\CartPriceRuleTranslation No errors.
CoreShop\Component\Payment\Model\PaymentProviderRuleTranslation No errors.
CoreShop\Component\Address\Model\StateTranslation No errors.

pimcore entity manager

No loaded entities.