Symfony Profiler

Query Metrics

82Database Queries

25Different statements

42.58 msQuery time

0Invalid entities

184Managed entities

Queries


SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
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
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
SELECT*FROMtmp_storeWHEREid=?
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
SELECTidFROMdocuments_pageWHEREprettyUrl=?
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
SELECTidFROMdocuments_pageWHEREprettyUrl=?
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
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.configKeyASconfigKey_1,t0.dataASdata_2,t0.creationDateAScreationDate_3,t0.modificationDateASmodificationDate_4,t0.idASid_5,t0.store_idASstore_id_6FROMcoreshop_configurationt0WHEREt0.store_idIN (?)
SELECTnameFROMclassesWHEREid=?
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
SELECTnameFROMclassesWHEREid=?
SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='SUR377P1'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object')
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTcustomSettingsFROMassetsWHEREid=?
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTnameFROMclassesWHEREid=?
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
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=?
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
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=?
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
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=?
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_.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_.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
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTnameFROMclassesWHEREid=?
SELECTt0.isoCodeASisoCode_1,t0.nameASname_2,t0.numericIsoCodeASnumericIsoCode_3,t0.symbolASsymbol_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7FROMcoreshop_currencyt0WHEREt0.id=?
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
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
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
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
SELECT*FROMobject_relations_cs_productWHEREsrc_id=?
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?)
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
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
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
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
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=?

#▲	Time	Info
1	0.52 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "site_domain_2bb2bbeb61ceace141391e7400935783"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_2bb2bbeb61ceace141391e7400935783');
2	0.37 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','sitetags');
3	0.34 ms	SELECTFROMsettings_storeWHEREid=?ANDscope=? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECTFROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle'ANDscope='pimcore';
4	0.57 ms	SELECTFROMredirectsWHERE ( (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/SUR377P1" "path" "auto_create" "/ora/SUR377P1" "path_query" "https://www.pimcore3.local.szerver.online/ora/SUR377P1" "entire_uri"`] View formatted query View runnable query Explain query SELECTFROMredirectsWHERE ( ( 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/SUR377P1'AND (`type`='path'OR`type`='auto_create')) OR (source='/ora/SUR377P1'AND`type`='path_query') OR (source='https://www.pimcore3.local.szerver.online/ora/SUR377P1'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC;
5	0.32 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "system_route_redirect"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_route_redirect');
6	0.37 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [`1783871456 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags');
7	0.31 ms	SELECTFROMtmp_storeWHEREid=? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECTFROMtmp_storeWHEREid=? SELECT*FROMtmp_storeWHEREid='maintenance_mode';
8	0.31 ms	SELECTFROMsettings_storeWHEREid=?ANDscope=? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECTFROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='reports'ANDscope='pimcore';
9	0.40 ms	SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [`"/ora/" "SUR377P1"`] View formatted query View runnable query Explain query SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/ora/'AND`key`=BINARY'SUR377P1';
10	0.32 ms	SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [`"/ora/SUR377P1"`] View formatted query View runnable query Explain query SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/ora/SUR377P1';
11	0.35 ms	SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [`"/" "ora"`] View formatted query View runnable query Explain query SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY'ora';
12	0.32 ms	SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [`"/ora"`] View formatted query View runnable query Explain query SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/ora';
13	0.36 ms	SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [`"/" ""`] View formatted query View runnable query Explain query SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY'';
14	0.34 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "document_1"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1');
15	0.45 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1783871456 "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"] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_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');
16	0.32 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "document_properties_1"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_1');
17	0.34 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "document_properties\x01tags\x01" "document_1\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_1tags');
18	0.53 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"`] View formatted query View runnable query Explain query 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';
19	0.51 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`] View formatted query View runnable query Explain query 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);
20	0.30 ms	SELECTnameFROMclassesWHEREid=? Parameters: [`"cs_order"`] View formatted query View runnable query Explain query SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_order';
21	0.37 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "sites_path_mapping"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('sites_path_mapping');
22	0.36 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "system\x01tags\x01" "resource\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','resourcetags');
23	0.36 ms	SELECTnameFROMclassesWHEREid=? Parameters: [`"cs_product"`] View formatted query View runnable query Explain query SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_product';
24	0.96 ms	SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='SUR377P1'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object') Parameters: [] View formatted query View runnable query Explain query SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='SUR377P1'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`='SUR377P1'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object');
25	0.31 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_3996"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3996');
26	0.31 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "object_3996\x01tags\x01" "class_cs_product\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3996tags','class_cs_producttags');
27	0.40 ms	SELECTFROMobject_relations_cs_productWHEREsrc_id=? Parameters: [`3996`] View formatted query View runnable query Explain query SELECTFROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=3996;
28	0.33 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "asset_13335"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_13335');
29	0.28 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "asset_13335\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_13335tags');
30	0.31 ms	SELECTcustomSettingsFROMassetsWHEREid=? Parameters: [`13335`] View formatted query View runnable query Explain query SELECTcustomSettingsFROMassetsWHEREid=? SELECTcustomSettingsFROMassetsWHEREid=13335;
31	0.33 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_375232"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232');
32	0.30 ms	SELECTnameFROMclassesWHEREid=? Parameters: [`"cs_category"`] View formatted query View runnable query Explain query SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_category';
33	0.37 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [`1783871456 "object_375232\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16791\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232tags','class_cs_categorytags','asset_16791tags');
34	0.39 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`] View formatted query View runnable query Explain query 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;
35	0.33 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_375233"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375233');
36	0.31 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [`1783871456 "object_375233\x01tags\x01" "class_cs_category\x01tags\x01" "asset_25770\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375233tags','class_cs_categorytags','asset_25770tags');
37	0.27 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`] View formatted query View runnable query Explain query 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=2;
38	0.27 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_574859"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_574859');
39	0.31 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [`1783871456 "object_574859\x01tags\x01" "class_cs_category\x01tags\x01" "asset_19955\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_574859tags','class_cs_categorytags','asset_19955tags');
40	0.28 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`] View formatted query View runnable query Explain query 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=3;
41	0.41 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: [`3996 "storeValues"`] View formatted query View runnable query Explain query 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=3996ANDc0_.fieldName='storeValues';
42	0.39 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: [] View formatted query View runnable query Explain query 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;
43	0.49 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: [`3996`] View formatted query View runnable query Explain query 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=3996ORDER BYc0_.priorityASC;
44	0.33 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_4"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_4');
45	0.32 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_4\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_4tags');
46	0.31 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_2"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_2');
47	0.26 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_2tags');
48	0.27 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_1"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_1');
49	0.25 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_1\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_1tags');
50	0.46 ms	SELECTnameFROMclassesWHEREid=? Parameters: [`"cs_address"`] View formatted query View runnable query Explain query SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_address';
51	0.46 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`] View formatted query View runnable query Explain query 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;
52	5.45 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: [`3996 "Seiko 2020. Vol.2 - Essential Time 20."`] View formatted query View runnable query Explain query 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 (3996) ANDseries='Seiko 2020. Vol.2 - Essential Time 20.'ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT5;
53	0.42 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_3470"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3470');
54	0.38 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "object_3470\x01tags\x01" "class_cs_product\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3470tags','class_cs_producttags');
55	0.34 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_3390"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3390');
56	0.32 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "object_3390\x01tags\x01" "class_cs_product\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3390tags','class_cs_producttags');
57	0.29 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_3388"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3388');
58	0.34 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "object_3388\x01tags\x01" "class_cs_product\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3388tags','class_cs_producttags');
59	0.32 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_3389"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3389');
60	0.31 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "object_3389\x01tags\x01" "class_cs_product\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_3389tags','class_cs_producttags');
61	4.35 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: [`39963470339033883389 "Fémcsatos"`] View formatted query View runnable query Explain query 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 SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE (idNOTIN (3996,3470,3390,3388,3389) ANDsubcollection='Fémcsatos'ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT1;
62	0.41 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_786226"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_786226');
63	0.46 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "object_786226\x01tags\x01" "class_cs_product\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_786226tags','class_cs_producttags');
64	0.37 ms	SELECTFROMobject_relations_cs_productWHEREsrc_id=? Parameters: [`3470`] View formatted query View runnable query Explain query SELECTFROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=3470;
65	0.38 ms	SELECTFROMobject_relations_cs_productWHEREsrc_id=? Parameters: [`3390`] View formatted query View runnable query Explain query SELECTFROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=3390;
66	0.37 ms	SELECTFROMobject_relations_cs_productWHEREsrc_id=? Parameters: [`3388`] View formatted query View runnable query Explain query SELECTFROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=3388;
67	0.34 ms	SELECTFROMobject_relations_cs_productWHEREsrc_id=? Parameters: [`3389`] View formatted query View runnable query Explain query SELECTFROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=3389;
68	0.34 ms	SELECTFROMobject_relations_cs_productWHEREsrc_id=? Parameters: [`786226`] View formatted query View runnable query Explain query SELECTFROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=786226;
69	0.42 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "website_config"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_config');
70	0.41 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?) Parameters: [`1783871456 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "asset_15304\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_configtags','systemtags','configtags','outputtags','asset_15304tags');
71	0.48 ms	SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [`"/shared/" "header"`] View formatted query View runnable query Explain query SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/shared/'AND`key`=BINARY'header';
72	0.44 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "document_76"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_76');
73	0.51 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [`1783871456 "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"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_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');
74	0.36 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "document_properties_76"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_76');
75	0.39 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [`1783871456 "document_properties\x01tags\x01" "document_76\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_76tags');
76	0.44 ms	SELECTFROMsettings_storeWHEREid=?ANDscope=? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECTFROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle'ANDscope='pimcore';
77	0.65 ms	SELECTFROMredirectsWHERE ( (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://www.pimcore3.local.szerver.online/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController" "entire_uri"`] View formatted query View runnable query Explain query SELECTFROMredirectsWHERE ( ( 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='/_fragment'AND (`type`='path'OR`type`='auto_create')) OR (source='/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController'AND`type`='path_query') OR (source='https://www.pimcore3.local.szerver.online/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC;
78	0.49 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_375163"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163');
79	0.36 ms	SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [`1783871456 "object_375163\x01tags\x01"`] View formatted query View runnable query Explain query SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783871456THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163tags');
80	0.41 ms	SELECTFROMsettings_storeWHEREid=?ANDscope=? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECTFROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle'ANDscope='pimcore';
81	0.68 ms	SELECTFROMredirectsWHERE ( (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://www.pimcore3.local.szerver.online/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction" "entire_uri"`] View formatted query View runnable query Explain query SELECTFROMredirectsWHERE ( ( 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='/_fragment'AND (`type`='path'OR`type`='auto_create')) OR (source='/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction'AND`type`='path_query') OR (source='https://www.pimcore3.local.szerver.online/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC;
82	2.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`] View formatted query View runnable query Explain query 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;

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

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.
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.

pimcore entity manager

No loaded entities.

Symfony Profiler

GET https://www.pimcore3.local.szerver.online/_fragment?_path=_format%3Dhtml%26_locale%3Dhu%26_controller%3DApp%255CController%255CFrontend%255CWishlistController%2…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

pimcore entity manager

Entities Mapping

default entity manager

pimcore entity manager