Query Metrics
93Database Queries
26Different statements
40.14 msQuery time
0Invalid entities
185Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
| 10.96 ms (27.32%) | 35 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1783830967 "site_domain_f88e05d213a2a50dea8b80d01ef5a8ac" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783830967THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_f88e05d213a2a50dea8b80d01ef5a8ac'); |
| 5.20 ms (12.95%) | 1 | 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: [900294 "Seiko 2026. Vol.1 - Astron 5X63" ] 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 SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE (idNOTIN (900294) ANDseries='Seiko 2026. Vol.1 - Astron 5X63'ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT5; |
| 3.41 ms (8.50%) | 10 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1783830967 "system\x01tags\x01" "site\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783830967THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','sitetags'); |
| 2.33 ms (5.81%) | 1 | 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]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=? 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=1; |
| 2.30 ms (5.72%) | 4 | 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/HAB002J1" "path" "auto_create" "/ora/HAB002J1" "path_query" "https://5.187.189.176/ora/HAB002J1" "entire_uri" ] 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 SELECT*FROMredirectsWHERE ( (source='/ora/HAB002J1'AND (`type`='path'OR`type`='auto_create')) OR (source='/ora/HAB002J1'AND`type`='path_query') OR (source='https://5.187.189.176/ora/HAB002J1'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
| 2.14 ms (5.34%) | 6 | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [900294]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=900294; |
| 1.78 ms (4.44%) | 5 | SELECT*FROMsettings_storeWHEREid=?ANDscope=? Parameters: [ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] SELECT*FROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle'ANDscope='pimcore'; |
| 1.46 ms (3.64%) | 4 | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/ora/" "HAB002J1" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/ora/'AND`key`=BINARY'HAB002J1'; |
| 1.42 ms (3.53%) | 4 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1783830967 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783830967THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags'); |
| 1.37 ms (3.43%) | 4 | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_order"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_order'; |
| 0.93 ms (2.32%) | 1 | SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='HAB002J1'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object') Parameters: [] SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='HAB002J1'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object') SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='HAB002J1'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object'); |
| 0.89 ms (2.21%) | 3 | 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]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=? 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=1; |
| 0.56 ms (1.40%) | 2 | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/ora/HAB002J1"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/ora/HAB002J1'; |
| 0.54 ms (1.33%) | 1 | 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" ] 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 SELECTt0.nameASname_1,t0.creationDateAScreationDate_2,t0.modificationDateASmodificationDate_3,t0.idASid_4,t0.localeASlocale_5,t0.translatable_idAStranslatable_id_6FROMcoreshop_country_translationt0WHEREt0.translatable_id=11ANDt0.locale='hu_HU'LIMIT1; |
| 0.49 ms (1.22%) | 1 | 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"
]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=? 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='1'; |
| 0.48 ms (1.19%) | 1 | 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]SELECTt0.configKeyASconfigKey_1,t0.dataASdata_2,t0.creationDateAScreationDate_3,t0.modificationDateASmodificationDate_4,t0.idASid_5,t0.store_idASstore_id_6FROMcoreshop_configurationt0WHEREt0.store_idIN (?) SELECTt0.configKeyASconfigKey_1,t0.dataASdata_2,t0.creationDateAScreationDate_3,t0.modificationDateASmodificationDate_4,t0.idASid_5,t0.store_idASstore_id_6FROMcoreshop_configurationt0WHEREt0.store_idIN (1); |
| 0.47 ms (1.16%) | 1 | 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: [900294 "storeValues" ] 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=? SELECTc0_.fieldNameASfieldName_0,c0_.productASproduct_1,c0_.priceASprice_2,c0_.idASid_3,c0_.taxRuleIdAStaxRuleId_4,c0_.storeASstore_5FROMcoreshop_product_store_valuesc0_WHEREc0_.product=900294ANDc0_.fieldName='storeValues'; |
| 0.46 ms (1.16%) | 1 | 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: [] 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 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; |
| 0.46 ms (1.15%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1783830967 "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" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783830967THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1tags','asset_23886tags','asset_15451tags','asset_34564tags','asset_15452tags','asset_34567tags','asset_15462tags','asset_34566tags','asset_15463tags','asset_34568tags','asset_15464tags','asset_34565tags','asset_15544tags','asset_23694tags','asset_33697tags','asset_33703tags','asset_33705tags','asset_33706tags','asset_33707tags','asset_33708tags','asset_33821tags','asset_35094tags'); |
| 0.44 ms (1.11%) | 1 | 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: [900294]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 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=900294ORDER BYc0_.priorityASC; |
| 0.38 ms (0.95%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?) Parameters: [1783830967 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "asset_15304\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783830967THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_configtags','systemtags','configtags','outputtags','asset_15304tags'); |
| 0.37 ms (0.91%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1783830967 "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" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783830967THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_76tags','asset_16823tags','asset_16821tags','asset_16825tags','asset_16824tags','asset_16820tags','asset_20642tags','asset_21858tags','asset_20603tags','asset_20600tags','asset_20602tags','asset_20601tags','asset_20599tags','asset_16826tags','asset_20648tags'); |
| 0.36 ms (0.90%) | 1 | 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: [] 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 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; |
| 0.32 ms (0.80%) | 1 | SELECT*FROMtmp_storeWHEREid=? Parameters: [
"maintenance_mode"
]SELECT*FROMtmp_storeWHEREid=? SELECT*FROMtmp_storeWHEREid='maintenance_mode'; |
| 0.32 ms (0.80%) | 1 | 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]SELECTt0.isoCodeASisoCode_1,t0.nameASname_2,t0.numericIsoCodeASnumericIsoCode_3,t0.symbolASsymbol_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7FROMcoreshop_currencyt0WHEREt0.id=? SELECTt0.isoCodeASisoCode_1,t0.nameASname_2,t0.numericIsoCodeASnumericIsoCode_3,t0.symbolASsymbol_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7FROMcoreshop_currencyt0WHEREt0.id=65; |
| 0.29 ms (0.73%) | 1 | SELECTcustomSettingsFROMassetsWHEREid=? Parameters: [34274]SELECTcustomSettingsFROMassetsWHEREid=? SELECTcustomSettingsFROMassetsWHEREid=34274; |
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\Store | 1 |
| CoreShop\Component\Core\Model\Country | 1 |
| CoreShop\Component\Address\Model\Zone | 1 |
| CoreShop\Component\Core\Model\ProductStoreValues | 1 |
| CoreShop\Component\Address\Model\CountryTranslation | 1 |
pimcore entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
pimcore entity manager
No loaded entities.