GET https://boutiqueapi.local.szerver.store/e-boutique/seiko/presage~c375259

Query Metrics

37Database Queries
15Different statements
22.15 msQuery time
0Invalid entities
181Managed entities

Queries

Group similar statements

#TimeInfo
1 0.33 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783621168
  "site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3"
]
2 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783621168
  "system\x01tags\x01"
  "site\x01tags\x01"
]
3 0.24 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.43 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:
[
  "/e-boutique/seiko/presage~c375259"
  "path"
  "auto_create"
  "/e-boutique/seiko/presage~c375259"
  "path_query"
  "https://boutiqueapi.local.szerver.store/e-boutique/seiko/presage~c375259"
  "entire_uri"
]
5 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783621168
  "system_route_redirect"
]
6 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783621168
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
7 0.16 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "maintenance_mode"
]
8 0.14 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "reports"
  "pimcore"
]
9 0.41 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/e-boutique/seiko/"
  "presage~c375259"
]
10 0.17 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/e-boutique/seiko/presage~c375259"
]
11 0.15 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/e-boutique/"
  "seiko"
]
12 0.10 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/e-boutique/seiko"
]
13 0.12 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/"
  "e-boutique"
]
14 0.09 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/e-boutique"
]
15 0.12 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/"
  ""
]
16 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783621168
  "document_1"
]
17 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1783621168
  "document_1\x01tags\x01"
  "asset_23886\x01tags\x01"
  "asset_15451\x01tags\x01"
  "asset_34564\x01tags\x01"
  "asset_15452\x01tags\x01"
  "asset_34567\x01tags\x01"
  "asset_15462\x01tags\x01"
  "asset_34566\x01tags\x01"
  "asset_15463\x01tags\x01"
  "asset_34568\x01tags\x01"
  "asset_15464\x01tags\x01"
  "asset_34565\x01tags\x01"
  "asset_15544\x01tags\x01"
  "asset_23694\x01tags\x01"
  "asset_33697\x01tags\x01"
  "asset_33703\x01tags\x01"
  "asset_33705\x01tags\x01"
  "asset_33706\x01tags\x01"
  "asset_33707\x01tags\x01"
  "asset_33708\x01tags\x01"
  "asset_33821\x01tags\x01"
  "asset_35094\x01tags\x01"
]
18 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783621168
  "document_properties_1"
]
19 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783621168
  "document_properties\x01tags\x01"
  "document_1\x01tags\x01"
]
20 0.43 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]
21 0.46 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]
22 0.30 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_order"
]
23 0.39 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783621168
  "sites_path_mapping"
]
24 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783621168
  "system\x01tags\x01"
  "resource\x01tags\x01"
]
25 0.39 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783621168
  "object_375259"
]
26 0.18 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_category"
]
27 0.40 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783621168
  "object_375259\x01tags\x01"
  "class_cs_category\x01tags\x01"
  "asset_25765\x01tags\x01"
]
28 0.36 ms
SELECTt0.nameASname_1,t0.resultsPerPageASresultsPerPage_2,t0.orderDirectionASorderDirection_3,t0.orderKeyASorderKey_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.indexIdASindexId_8FROMcoreshop_filtert0WHEREt0.id=?
Parameters:
[2]
29 0.31 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_product"
]
30 11.81 ms
SELECTCOUNT(*) FROMobject_localized_cs_product_hu_HUWHERE ((`categories`LIKE?)  ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1
Parameters:
[
  "%,object|375259,%"
]
31 0.34 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783621168
  "object_375232"
]
32 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783621168
  "object_375232\x01tags\x01"
  "class_cs_category\x01tags\x01"
  "asset_16791\x01tags\x01"
]
33 0.16 ms
SELECTt0.nameASname_1,t0.resultsPerPageASresultsPerPage_2,t0.orderDirectionASorderDirection_3,t0.orderKeyASorderKey_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.indexIdASindexId_8FROMcoreshop_filtert0WHEREt0.id=?
Parameters:
[1]
34 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783621168
  "object_375163"
]
35 0.14 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783621168
  "object_375163\x01tags\x01"
]
36 1.90 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]
37 0.35 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_wishlist"
]

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\Index\Model\Filter 2
CoreShop\Component\Index\Model\Index 2
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

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\Index\Model\Filter No errors.
CoreShop\Component\Index\Model\Index No errors.
CoreShop\Component\Index\Model\FilterCondition No errors.

pimcore entity manager

No loaded entities.