Query Metrics

95Database Queries
30Different statements
27.41 msQuery time
0Invalid entities
187Managed entities

Queries

Group similar statements

#▲TimeInfo
1 0.27 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3"
]
2 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "system\x01tags\x01"
  "site\x01tags\x01"
]
3 0.24 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.38 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:
[
  "/ora/L Prospex Softshell Jacket"
  "path"
  "auto_create"
  "/ora/L Prospex Softshell Jacket"
  "path_query"
  "https://boutiqueapi.local.szerver.store/ora/L Prospex Softshell Jacket"
  "entire_uri"
]
5 0.17 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "system_route_redirect"
]
6 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1794829089
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
7 0.20 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "maintenance_mode"
]
8 0.18 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "reports"
  "pimcore"
]
9 0.24 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/ora/"
  "L Prospex Softshell Jacket"
]
10 0.21 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/ora/L Prospex Softshell Jacket"
]
11 0.19 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/"
  "ora"
]
12 0.16 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/ora"
]
13 0.19 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/"
  ""
]
14 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "document_1"
]
15 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794829089
  "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"
]
16 0.21 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "document_properties_1"
]
17 0.23 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "document_properties\x01tags\x01"
  "document_1\x01tags\x01"
]
18 0.37 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.33 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.19 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_order"
]
21 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "sites_path_mapping"
]
22 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "system\x01tags\x01"
  "resource\x01tags\x01"
]
23 0.22 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_product"
]
24 0.63 ms
SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='L Prospex Softshell Jacket'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object')
Parameters:
[]
25 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_620890"
]
26 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "object_620890\x01tags\x01"
  "class_cs_product\x01tags\x01"
]
27 0.22 ms
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
Parameters:
[620890]
28 0.17 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "asset_21900"
]
29 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "asset_21900\x01tags\x01"
]
30 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "asset_21899"
]
31 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "asset_21899\x01tags\x01"
]
32 0.14 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "asset_21901"
]
33 0.11 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "asset_21901\x01tags\x01"
]
34 0.12 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[21900]
35 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_375232"
]
36 0.14 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_category"
]
37 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1794829089
  "object_375232\x01tags\x01"
  "class_cs_category\x01tags\x01"
  "asset_16791\x01tags\x01"
]
38 0.18 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]
39 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_619631"
]
40 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1794829089
  "object_619631\x01tags\x01"
  "class_cs_category\x01tags\x01"
  "asset_25768\x01tags\x01"
]
41 0.13 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]
42 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_620870"
]
43 0.14 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1794829089
  "object_620870\x01tags\x01"
  "class_cs_category\x01tags\x01"
  "asset_21928\x01tags\x01"
]
44 0.11 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:
[3]
45 0.30 ms
SELECTc0_.fieldNameASfieldName_0,c0_.productASproduct_1,c0_.priceASprice_2,c0_.idASid_3,c0_.taxRuleIdAStaxRuleId_4,c0_.storeASstore_5FROMcoreshop_product_store_valuesc0_WHEREc0_.product=?ANDc0_.fieldName=?
Parameters:
[620890
  "storeValues"
]
46 0.32 ms
SELECTc0_.nameASname_0,c0_.descriptionASdescription_1,c0_.priorityASpriority_2,c0_.activeASactive_3,c0_.stopPropagationASstopPropagation_4,c0_.creationDateAScreationDate_5,c0_.modificationDateASmodificationDate_6,c0_.idASid_7FROMcoreshop_product_price_rulec0_WHEREc0_.active=1ORDER BYc0_.priorityASC
Parameters:
[]
47 0.50 ms
SELECTc0_.nameASname_0,c0_.priorityASpriority_1,c0_.activeASactive_2,c0_.inheritASinherit_3,c0_.productASproduct_4,c0_.stopPropagationASstopPropagation_5,c0_.creationDateAScreationDate_6,c0_.modificationDateASmodificationDate_7,c0_.idASid_8FROMcoreshop_product_specific_price_rulec0_WHEREc0_.product=?ORDER BYc0_.priorityASC
Parameters:
[620890]
48 0.43 ms
SELECTt0.typeAStype_1,t0.sortASsort_2,t0.configurationASconfiguration_3,t0.idASid_4FROMcoreshop_rule_conditiont0INNER JOINcoreshop_product_specific_price_rule_conditionsONt0.id=coreshop_product_specific_price_rule_conditions.condition_idWHEREcoreshop_product_specific_price_rule_conditions.price_rule_id=?ORDER BYt0.sortASC
Parameters:
[324]
49 0.33 ms
SELECTt0.typeAStype_1,t0.sortASsort_2,t0.configurationASconfiguration_3,t0.idASid_4FROMcoreshop_rule_actiont0INNER JOINcoreshop_product_specific_price_rule_actionONt0.id=coreshop_product_specific_price_rule_action.action_idWHEREcoreshop_product_specific_price_rule_action.price_rule_id=?ORDER BYt0.sortASC
Parameters:
[324]
50 0.19 ms
SELECTt0.isoCodeASisoCode_1,t0.nameASname_2,t0.numericIsoCodeASnumericIsoCode_3,t0.symbolASsymbol_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7FROMcoreshop_currencyt0WHEREt0.id=?
Parameters:
[65]
51 0.28 ms
SELECTc0_.isoCodeASisoCode_0,c0_.activeASactive_1,c0_.addressFormatASaddressFormat_2,c0_.salutationsASsalutations_3,c0_.creationDateAScreationDate_4,c0_.modificationDateASmodificationDate_5,c0_.idASid_6,c0_.zoneIdASzoneId_7,c0_.currencyIdAScurrencyId_8FROMcoreshop_countryc0_WHEREc0_.isoCode=?
Parameters:
[
  "HU"
]
52 0.17 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_address"
]
53 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_4"
]
54 0.22 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_4\x01tags\x01"
]
55 0.17 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_2"
]
56 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_2\x01tags\x01"
]
57 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_1"
]
58 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_1\x01tags\x01"
]
59 3.62 ms
SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE (idNOTIN (?) ANDseries=?ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT5
Parameters:
[620890
  "Prospex ruhazat - Softshell kabat 2023"
]
60 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_620901"
]
61 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "object_620901\x01tags\x01"
  "class_cs_product\x01tags\x01"
]
62 0.23 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_620892"
]
63 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "object_620892\x01tags\x01"
  "class_cs_product\x01tags\x01"
]
64 0.22 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_620889"
]
65 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "object_620889\x01tags\x01"
  "class_cs_product\x01tags\x01"
]
66 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_620871"
]
67 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "object_620871\x01tags\x01"
  "class_cs_product\x01tags\x01"
]
68 0.74 ms
SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE (idNOTIN (?,?,?,?,?) ANDsubcollection=?ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT1
Parameters:
[620890620901620892620889620871
  "Softshell Jacket"
]
69 0.83 ms
SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE (idNOTIN (?,?,?,?,?) ANDcollection=?ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT1
Parameters:
[620890620901620892620889620871
  "Prospex ruházat"
]
70 0.22 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_620916"
]
71 0.39 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "object_620916\x01tags\x01"
  "class_cs_product\x01tags\x01"
]
72 0.24 ms
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
Parameters:
[620901]
73 0.25 ms
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
Parameters:
[620892]
74 0.25 ms
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
Parameters:
[620889]
75 0.25 ms
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
Parameters:
[620871]
76 0.25 ms
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
Parameters:
[620916]
77 0.23 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_620915"
]
78 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1794829089
  "object_620915\x01tags\x01"
  "class_cs_category\x01tags\x01"
  "asset_21929\x01tags\x01"
]
79 0.26 ms
SELECT*FROMtranslations_messagesLIMIT1;
Parameters:
[]
80 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "translation_data_6431352cea3285deadebc5c2a566a87b"
]
81 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1794829089
  "translator\x01tags\x01"
  "translator_website\x01tags\x01"
  "translate\x01tags\x01"
]
82 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "website_config"
]
83 0.21 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?)
Parameters:
[1794829089
  "website_config\x01tags\x01"
  "system\x01tags\x01"
  "config\x01tags\x01"
  "output\x01tags\x01"
  "asset_15304\x01tags\x01"
]
84 0.22 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/shared/"
  "header"
]
85 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "document_76"
]
86 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794829089
  "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"
]
87 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "document_properties_76"
]
88 0.14 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794829089
  "document_properties\x01tags\x01"
  "document_76\x01tags\x01"
]
89 0.20 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
90 0.35 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"
]
91 0.23 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_375163"
]
92 0.22 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794829089
  "object_375163\x01tags\x01"
]
93 0.24 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
94 0.39 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"
]
95 1.60 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]

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 3
CoreShop\Component\Index\Model\Index 3
CoreShop\Component\Core\Model\Country 2
CoreShop\Component\Core\Model\Store 1
CoreShop\Component\Address\Model\Zone 1
CoreShop\Component\Core\Model\ProductStoreValues 1
CoreShop\Component\Product\Model\ProductSpecificPriceRule 1
CoreShop\Component\Rule\Model\Action 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\Address\Model\Country No errors.
CoreShop\Component\Core\Model\Country No errors.
CoreShop\Component\Address\Model\AddressIdentifier 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\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.
CoreShop\Component\Core\Model\ProductStoreValues No errors.
CoreShop\Component\Taxation\Model\TaxRuleGroup No errors.
CoreShop\Component\Product\Model\ProductUnitDefinitionPrice No errors.
CoreShop\Component\Core\Model\ProductUnitDefinitionPrice No errors.
CoreShop\Component\Product\Model\ProductSpecificPriceRule No errors.
CoreShop\Component\Product\Model\ProductSpecificPriceRuleTranslation No errors.
CoreShop\Component\Rule\Model\Condition No errors.
CoreShop\Component\Rule\Model\Action No errors.

pimcore entity manager

No loaded entities.