Query Metrics
99Database Queries
28Different statements
24.69 msQuery time
0Invalid entities
187Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828925 "site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828925THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3'); |
| 2 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828925 "system\x01tags\x01" "site\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828925THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','sitetags'); |
| 3 | 0.21 ms | 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'; |
| 4 | 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: [ "/ora/SPB503J1" "path" "auto_create" "/ora/SPB503J1" "path_query" "https://boutiqueapi.local.szerver.store/ora/SPB503J1" "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/SPB503J1'AND (`type`='path'OR`type`='auto_create')) OR (source='/ora/SPB503J1'AND`type`='path_query') OR (source='https://boutiqueapi.local.szerver.store/ora/SPB503J1'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
| 5 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828925 "system_route_redirect" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828925THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_route_redirect'); |
| 6 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794828925 "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>1794828925THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags'); |
| 7 | 0.16 ms | SELECT*FROMtmp_storeWHEREid=? Parameters: [
"maintenance_mode"
]SELECT*FROMtmp_storeWHEREid=? SELECT*FROMtmp_storeWHEREid='maintenance_mode'; |
| 8 | 0.19 ms | SELECT*FROMsettings_storeWHEREid=?ANDscope=? Parameters: [ "reports" "pimcore" ] SELECT*FROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='reports'ANDscope='pimcore'; |
| 9 | 0.32 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/ora/" "SPB503J1" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/ora/'AND`key`=BINARY'SPB503J1'; |
| 10 | 0.22 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/ora/SPB503J1"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/ora/SPB503J1'; |
| 11 | 0.23 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/" "ora" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY'ora'; |
| 12 | 0.21 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/ora"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/ora'; |
| 13 | 0.24 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [
"/"
""
]SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY''; |
| 14 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828925 "document_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828925THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1'); |
| 15 | 0.27 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1794828925 "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>1794828925THENitem_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.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828925 "document_properties_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828925THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_1'); |
| 17 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828925 "document_properties\x01tags\x01" "document_1\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828925THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_1tags'); |
| 18 | 0.35 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]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.30 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]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.21 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_order"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_order'; |
| 21 | 0.20 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "sites_path_mapping" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('sites_path_mapping'); |
| 22 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828926 "system\x01tags\x01" "resource\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','resourcetags'); |
| 23 | 0.17 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_product"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_product'; |
| 24 | 0.61 ms | SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE`sku`='SPB503J1'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`='SPB503J1'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`='SPB503J1'ANDobject_localized_cs_product_hu_HU.typeIN ('variant','object'); |
| 25 | 0.20 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_711668" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_711668'); |
| 26 | 0.20 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828926 "object_711668\x01tags\x01" "class_cs_product\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_711668tags','class_cs_producttags'); |
| 27 | 0.23 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [711668]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=711668; |
| 28 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30259" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30259'); |
| 29 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30259\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30259tags'); |
| 30 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30260" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30260'); |
| 31 | 0.09 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30260\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30260tags'); |
| 32 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30261" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30261'); |
| 33 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30261\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30261tags'); |
| 34 | 0.09 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30262" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30262'); |
| 35 | 0.09 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30262\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30262tags'); |
| 36 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30263" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30263'); |
| 37 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30263\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30263tags'); |
| 38 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30264" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30264'); |
| 39 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "asset_30264\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_30264tags'); |
| 40 | 0.11 ms | SELECTcustomSettingsFROMassetsWHEREid=? Parameters: [30259]SELECTcustomSettingsFROMassetsWHEREid=? SELECTcustomSettingsFROMassetsWHEREid=30259; |
| 41 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_375232" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232'); |
| 42 | 0.10 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_category"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_category'; |
| 43 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794828926 "object_375232\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16791\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232tags','class_cs_categorytags','asset_16791tags'); |
| 44 | 0.23 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]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; |
| 45 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_375256" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375256'); |
| 46 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794828926 "object_375256\x01tags\x01" "class_cs_category\x01tags\x01" "asset_25766\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375256tags','class_cs_categorytags','asset_25766tags'); |
| 47 | 0.12 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]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; |
| 48 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_598267" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598267'); |
| 49 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794828926 "object_598267\x01tags\x01" "class_cs_category\x01tags\x01" "asset_21649\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598267tags','class_cs_categorytags','asset_21649tags'); |
| 50 | 0.10 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]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; |
| 51 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_598268" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598268'); |
| 52 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) Parameters: [1794828926 "object_598268\x01tags\x01" "class_cs_category\x01tags\x01" "asset_23442\x01tags\x01" "asset_16665\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598268tags','class_cs_categorytags','asset_23442tags','asset_16665tags'); |
| 53 | 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: [4]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=4; |
| 54 | 0.24 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: [711668 "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=711668ANDc0_.fieldName='storeValues'; |
| 55 | 0.17 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: [] 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; |
| 56 | 0.24 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: [711668]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=711668ORDER BYc0_.priorityASC; |
| 57 | 0.20 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_4" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_4'); |
| 58 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_4\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_4tags'); |
| 59 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_2" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_2'); |
| 60 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_2\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_2tags'); |
| 61 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_1'); |
| 62 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_1\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_1tags'); |
| 63 | 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"
]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=? 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='HU'; |
| 64 | 0.12 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_address"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_address'; |
| 65 | 0.18 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]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; |
| 66 | 3.21 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: [711668 "Seiko 2025. Vol.1 - Prospex 10" ] 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 (711668) ANDseries='Seiko 2025. Vol.1 - Prospex 10'ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT5; |
| 67 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_711672" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_711672'); |
| 68 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828926 "object_711672\x01tags\x01" "class_cs_product\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_711672tags','class_cs_producttags'); |
| 69 | 0.20 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_711669" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_711669'); |
| 70 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828926 "object_711669\x01tags\x01" "class_cs_product\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_711669tags','class_cs_producttags'); |
| 71 | 0.73 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`DESCLIMIT3 Parameters: [711668711672711669 "Land" ] 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`DESCLIMIT3 SELECTobject_localized_cs_product_hu_HU.idasid,object_localized_cs_product_hu_HU.typeas`type`FROMobject_localized_cs_product_hu_HUWHERE (idNOTIN (711668,711672,711669) ANDsubcollection='Land'ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1ORDER BY`creationDate`DESCLIMIT3; |
| 72 | 0.20 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_912076" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_912076'); |
| 73 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828926 "object_912076\x01tags\x01" "class_cs_product\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_912076tags','class_cs_producttags'); |
| 74 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_762982" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762982'); |
| 75 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828926 "object_762982\x01tags\x01" "class_cs_product\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762982tags','class_cs_producttags'); |
| 76 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_458642" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_458642'); |
| 77 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828926 "object_458642\x01tags\x01" "class_cs_product\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_458642tags','class_cs_producttags'); |
| 78 | 0.23 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [711672]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=711672; |
| 79 | 0.18 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [711669]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=711669; |
| 80 | 0.14 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [912076]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=912076; |
| 81 | 0.14 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [762982]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=762982; |
| 82 | 0.12 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [458642]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=458642; |
| 83 | 0.24 ms | SELECT*FROMtranslations_messagesLIMIT1; Parameters: [] SELECT*FROMtranslations_messagesLIMIT1; SELECT*FROMtranslations_messagesLIMIT1;; |
| 84 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "translation_data_6431352cea3285deadebc5c2a566a87b" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translation_data_6431352cea3285deadebc5c2a566a87b'); |
| 85 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794828926 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translatortags','translator_websitetags','translatetags'); |
| 86 | 0.39 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "website_config" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_config'); |
| 87 | 0.27 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?) Parameters: [1794828926 "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>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_configtags','systemtags','configtags','outputtags','asset_15304tags'); |
| 88 | 0.28 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/shared/" "header" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/shared/'AND`key`=BINARY'header'; |
| 89 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "document_76" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_76'); |
| 90 | 0.32 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1794828926 "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>1794828926THENitem_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'); |
| 91 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "document_properties_76" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_76'); |
| 92 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794828926 "document_properties\x01tags\x01" "document_76\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_76tags'); |
| 93 | 0.19 ms | 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'; |
| 94 | 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" ] 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='/_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://boutiqueapi.local.szerver.store/_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; |
| 95 | 0.31 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_375163" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163'); |
| 96 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794828926 "object_375163\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794828926THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163tags'); |
| 97 | 0.26 ms | 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'; |
| 98 | 0.41 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" ] 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='/_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://boutiqueapi.local.szerver.store/_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; |
| 99 | 1.74 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]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 | 4 |
| CoreShop\Component\Index\Model\Index | 4 |
| CoreShop\Component\Core\Model\Country | 2 |
| CoreShop\Component\Core\Model\Store | 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
pimcore entity manager
No loaded entities.