Query Metrics
142Database Queries
49Different statements
200.38 msQuery time
0Invalid entities
183Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.31 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3'); |
| 2 | 0.31 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "system\x01tags\x01" "site\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','sitetags'); |
| 3 | 0.25 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.43 ms | SELECT*FROMredirectsWHERE ( (source=?AND (`type`=?OR`type`=?)) OR (source=?AND`type`=?) OR (source=?AND`type`=?) ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC Parameters: [ "/e-boutique/grand-seiko-c375273" "path" "auto_create" "/e-boutique/grand-seiko-c375273?page=7?reset-filter=17948314336afaf4494e1c6?reset-filter=17948402266afb16a2bcf07?reset-filter=17948402396afb16af97c35?reset-filter=17948407066afb18825176f?reset-filter=17948410486afb19d8713a3?reset-filter=17948411556afb1a43b0f61?reset-filter=17948411846afb1a6000d4f?reset-filter=17948412516afb1aa35e51a?reset-filter=17948412806afb1ac0054da?reset-filter=17948413166afb1ae49f643?reset-filter=17948413666afb1b164dcfb?reset-filter=17948415736afb1be5d5bd1?reset-filter=17948416146afb1c0e35367?reset-filter=17948416506afb1c326427b?reset-filter=17948416926afb1c5cd4518?reset-filter=17948417646afb1ca4df4d8?reset-filter=17948419136afb1d396deed" "path_query" "https://boutiqueapi.local.szerver.store/e-boutique/grand-seiko-c375273?page=7?reset-filter=17948314336afaf4494e1c6?reset-filter=17948402266afb16a2bcf07?reset-filter=17948402396afb16af97c35?reset-filter=17948407066afb18825176f?reset-filter=17948410486afb19d8713a3?reset-filter=17948411556afb1a43b0f61?reset-filter=17948411846afb1a6000d4f?reset-filter=17948412516afb1aa35e51a?reset-filter=17948412806afb1ac0054da?reset-filter=17948413166afb1ae49f643?reset-filter=17948413666afb1b164dcfb?reset-filter=17948415736afb1be5d5bd1?reset-filter=17948416146afb1c0e35367?reset-filter=17948416506afb1c326427b?reset-filter=17948416926afb1c5cd4518?reset-filter=17948417646afb1ca4df4d8?reset-filter=17948419136afb1d396deed" "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='/e-boutique/grand-seiko-c375273'AND (`type`='path'OR`type`='auto_create')) OR (source='/e-boutique/grand-seiko-c375273?page=7?reset-filter=17948314336afaf4494e1c6?reset-filter=17948402266afb16a2bcf07?reset-filter=17948402396afb16af97c35?reset-filter=17948407066afb18825176f?reset-filter=17948410486afb19d8713a3?reset-filter=17948411556afb1a43b0f61?reset-filter=17948411846afb1a6000d4f?reset-filter=17948412516afb1aa35e51a?reset-filter=17948412806afb1ac0054da?reset-filter=17948413166afb1ae49f643?reset-filter=17948413666afb1b164dcfb?reset-filter=17948415736afb1be5d5bd1?reset-filter=17948416146afb1c0e35367?reset-filter=17948416506afb1c326427b?reset-filter=17948416926afb1c5cd4518?reset-filter=17948417646afb1ca4df4d8?reset-filter=17948419136afb1d396deed'AND`type`='path_query') OR (source='https://boutiqueapi.local.szerver.store/e-boutique/grand-seiko-c375273?page=7?reset-filter=17948314336afaf4494e1c6?reset-filter=17948402266afb16a2bcf07?reset-filter=17948402396afb16af97c35?reset-filter=17948407066afb18825176f?reset-filter=17948410486afb19d8713a3?reset-filter=17948411556afb1a43b0f61?reset-filter=17948411846afb1a6000d4f?reset-filter=17948412516afb1aa35e51a?reset-filter=17948412806afb1ac0054da?reset-filter=17948413166afb1ae49f643?reset-filter=17948413666afb1b164dcfb?reset-filter=17948415736afb1be5d5bd1?reset-filter=17948416146afb1c0e35367?reset-filter=17948416506afb1c326427b?reset-filter=17948416926afb1c5cd4518?reset-filter=17948417646afb1ca4df4d8?reset-filter=17948419136afb1d396deed'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
| 5 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "system_route_redirect" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_route_redirect'); |
| 6 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags'); |
| 7 | 0.22 ms | SELECT*FROMtmp_storeWHEREid=? Parameters: [
"maintenance_mode"
]SELECT*FROMtmp_storeWHEREid=? SELECT*FROMtmp_storeWHEREid='maintenance_mode'; |
| 8 | 0.16 ms | SELECT*FROMsettings_storeWHEREid=?ANDscope=? Parameters: [ "reports" "pimcore" ] SELECT*FROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='reports'ANDscope='pimcore'; |
| 9 | 0.40 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/e-boutique/" "grand-seiko-c375273" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/e-boutique/'AND`key`=BINARY'grand-seiko-c375273'; |
| 10 | 0.23 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/e-boutique/grand-seiko-c375273"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique/grand-seiko-c375273'; |
| 11 | 0.28 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/" "e-boutique" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY'e-boutique'; |
| 12 | 0.25 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/e-boutique"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique'; |
| 13 | 0.26 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [
"/"
""
]SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY''; |
| 14 | 0.27 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "document_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1'); |
| 15 | 0.38 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1794844679 "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>1794844679THENitem_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.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "document_properties_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_1'); |
| 17 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_1tags'); |
| 18 | 0.48 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.48 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.38 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_order"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_order'; |
| 21 | 0.32 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "sites_path_mapping" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('sites_path_mapping'); |
| 22 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "system\x01tags\x01" "resource\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','resourcetags'); |
| 23 | 0.35 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375273" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375273'); |
| 24 | 0.16 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_category"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_category'; |
| 25 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "object_375273\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16792\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375273tags','class_cs_categorytags','asset_16792tags'); |
| 26 | 0.37 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; |
| 27 | 0.32 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_product"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_product'; |
| 28 | 11.33 ms | SELECTCOUNT(*) FROMobject_localized_cs_product_hu_HUWHERE ((`categories`LIKE?) ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1 Parameters: [
"%,object|375273,%"
]SELECTCOUNT(*) FROMobject_localized_cs_product_hu_HUWHERE ( (`categories`LIKE?) ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder') ) ANDobject_localized_cs_product_hu_HU.published=1 SELECTCOUNT(*) FROMobject_localized_cs_product_hu_HUWHERE ((`categories`LIKE'%,object|375273,%') ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1; |
| 29 | 0.36 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375163" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163'); |
| 30 | 0.27 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375163\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163tags'); |
| 31 | 10.14 ms | SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE (object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) ORDER BYwholesalePriceASCLIMIT1 Parameters: [
"%,object|375273,%"
]SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) ORDER BYwholesalePriceASCLIMIT1 SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE (object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') ORDER BYwholesalePriceASCLIMIT1; |
| 32 | 11.24 ms | SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE (object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) ORDER BYwholesalePriceDESCLIMIT1 Parameters: [
"%,object|375273,%"
]SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) ORDER BYwholesalePriceDESCLIMIT1 SELECTwholesalePriceFROMobject_localized_cs_product_hu_HUWHERE (object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') ORDER BYwholesalePriceDESCLIMIT1; |
| 33 | 9.71 ms | SELECTDISTINCTNULLIF(outlet,0) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?)) AND (NULLIF(outlet,0) ISNOTNULL) ORDER BYwholesalePriceDESCLIMIT1 Parameters: [
"%,object|375273,%"
]SELECTDISTINCTNULLIF(outlet,0) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) ) AND ( NULLIF(outlet,0) ISNOTNULL ) ORDER BYwholesalePriceDESCLIMIT1 SELECTDISTINCTNULLIF(outlet,0) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%')) AND (NULLIF(outlet,0) ISNOTNULL) ORDER BYwholesalePriceDESCLIMIT1; |
| 34 | 6.26 ms | SELECTDISTINCTtrim(`typeofwatch`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`typeofwatch`) ISNOTNULLANDtrim(`typeofwatch`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`typeofwatch`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`typeofwatch`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`typeofwatch`) ISNOTNULLANDtrim(`typeofwatch`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`typeofwatch`) ASC SELECTDISTINCTtrim(`typeofwatch`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`typeofwatch`) ISNOTNULLANDtrim(`typeofwatch`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`typeofwatch`) ASC; |
| 35 | 6.59 ms | SELECTDISTINCTobject_localized_cs_category_hu_HU.id,object_localized_cs_product_hu_HU.collectionFROMobject_localized_cs_category_hu_HULEFT JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_category_hu_HU.workingName=object_localized_cs_product_hu_HU.collectionWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (object_localized_cs_product_hu_HU.collectionISNOTNULL)) Parameters: [
"%,object|375273,%"
]SELECTDISTINCTobject_localized_cs_category_hu_HU.id,object_localized_cs_product_hu_HU.collectionFROMobject_localized_cs_category_hu_HULEFT JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_category_hu_HU.workingName=object_localized_cs_product_hu_HU.collectionWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( object_localized_cs_product_hu_HU.collectionISNOTNULL ) ) SELECTDISTINCTobject_localized_cs_category_hu_HU.id,object_localized_cs_product_hu_HU.collectionFROMobject_localized_cs_category_hu_HULEFT JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_category_hu_HU.workingName=object_localized_cs_product_hu_HU.collectionWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (object_localized_cs_product_hu_HU.collectionISNOTNULL)); |
| 36 | 6.28 ms | SELECTDISTINCTtrim(`availability`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`availability`) ISNOTNULLANDtrim(`availability`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`availability`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`availability`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`availability`) ISNOTNULLANDtrim(`availability`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`availability`) ASC SELECTDISTINCTtrim(`availability`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`availability`) ISNOTNULLANDtrim(`availability`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`availability`) ASC; |
| 37 | 6.25 ms | SELECTDISTINCTtrim(`movementtypefilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`movementtypefilter`) ISNOTNULLANDtrim(`movementtypefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`movementtypefilter`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`movementtypefilter`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`movementtypefilter`) ISNOTNULLANDtrim(`movementtypefilter`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`movementtypefilter`) ASC SELECTDISTINCTtrim(`movementtypefilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`movementtypefilter`) ISNOTNULLANDtrim(`movementtypefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`movementtypefilter`) ASC; |
| 38 | 6.43 ms | SELECTDISTINCTtrim(`casefilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`casefilter`) ISNOTNULLANDtrim(`casefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`casefilter`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`casefilter`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`casefilter`) ISNOTNULLANDtrim(`casefilter`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`casefilter`) ASC SELECTDISTINCTtrim(`casefilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`casefilter`) ISNOTNULLANDtrim(`casefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`casefilter`) ASC; |
| 39 | 6.36 ms | SELECTDISTINCTtrim(`glassfilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`glassfilter`) ISNOTNULLANDtrim(`glassfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`glassfilter`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`glassfilter`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`glassfilter`) ISNOTNULLANDtrim(`glassfilter`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`glassfilter`) ASC SELECTDISTINCTtrim(`glassfilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`glassfilter`) ISNOTNULLANDtrim(`glassfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`glassfilter`) ASC; |
| 40 | 6.33 ms | SELECTDISTINCTtrim(`formofcase`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`formofcase`) ISNOTNULLANDtrim(`formofcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`formofcase`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`formofcase`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`formofcase`) ISNOTNULLANDtrim(`formofcase`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`formofcase`) ASC SELECTDISTINCTtrim(`formofcase`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`formofcase`) ISNOTNULLANDtrim(`formofcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`formofcase`) ASC; |
| 41 | 6.43 ms | SELECTDISTINCTtrim(`style`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`style`) ISNOTNULLANDtrim(`style`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`style`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`style`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`style`) ISNOTNULLANDtrim(`style`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`style`) ASC SELECTDISTINCTtrim(`style`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`style`) ISNOTNULLANDtrim(`style`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`style`) ASC; |
| 42 | 6.38 ms | SELECTDISTINCTtrim(`bandfilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`bandfilter`) ISNOTNULLANDtrim(`bandfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bandfilter`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`bandfilter`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`bandfilter`) ISNOTNULLANDtrim(`bandfilter`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`bandfilter`) ASC SELECTDISTINCTtrim(`bandfilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`bandfilter`) ISNOTNULLANDtrim(`bandfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bandfilter`) ASC; |
| 43 | 10.67 ms | SELECTDISTINCTtrim(`bandwidth`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`bandwidth`) ISNOTNULLANDtrim(`bandwidth`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bandwidth`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`bandwidth`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`bandwidth`) ISNOTNULLANDtrim(`bandwidth`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`bandwidth`) ASC SELECTDISTINCTtrim(`bandwidth`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`bandwidth`) ISNOTNULLANDtrim(`bandwidth`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bandwidth`) ASC; |
| 44 | 8.74 ms | SELECTDISTINCTtrim(`buckle`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`buckle`) ISNOTNULLANDtrim(`buckle`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`buckle`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`buckle`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`buckle`) ISNOTNULLANDtrim(`buckle`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`buckle`) ASC SELECTDISTINCTtrim(`buckle`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`buckle`) ISNOTNULLANDtrim(`buckle`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`buckle`) ASC; |
| 45 | 5.88 ms | SELECTDISTINCTtrim(`bezel`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`bezel`) ISNOTNULLANDtrim(`bezel`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bezel`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`bezel`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`bezel`) ISNOTNULLANDtrim(`bezel`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`bezel`) ASC SELECTDISTINCTtrim(`bezel`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`bezel`) ISNOTNULLANDtrim(`bezel`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bezel`) ASC; |
| 46 | 6.27 ms | SELECTDISTINCTtrim(`backcase`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`backcase`) ISNOTNULLANDtrim(`backcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`backcase`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`backcase`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`backcase`) ISNOTNULLANDtrim(`backcase`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`backcase`) ASC SELECTDISTINCTtrim(`backcase`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`backcase`) ISNOTNULLANDtrim(`backcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`backcase`) ASC; |
| 47 | 6.28 ms | SELECTDISTINCTtrim(`colorofdial`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`colorofdial`) ISNOTNULLANDtrim(`colorofdial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`colorofdial`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`colorofdial`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`colorofdial`) ISNOTNULLANDtrim(`colorofdial`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`colorofdial`) ASC SELECTDISTINCTtrim(`colorofdial`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`colorofdial`) ISNOTNULLANDtrim(`colorofdial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`colorofdial`) ASC; |
| 48 | 6.19 ms | SELECTDISTINCTtrim(`waterresistance`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`waterresistance`) ISNOTNULLANDtrim(`waterresistance`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`waterresistance`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`waterresistance`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`waterresistance`) ISNOTNULLANDtrim(`waterresistance`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`waterresistance`) ASC SELECTDISTINCTtrim(`waterresistance`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`waterresistance`) ISNOTNULLANDtrim(`waterresistance`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`waterresistance`) ASC; |
| 49 | 6.06 ms | SELECTDISTINCTtrim(`crownandbutton`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`crownandbutton`) ISNOTNULLANDtrim(`crownandbutton`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`crownandbutton`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`crownandbutton`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`crownandbutton`) ISNOTNULLANDtrim(`crownandbutton`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`crownandbutton`) ASC SELECTDISTINCTtrim(`crownandbutton`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`crownandbutton`) ISNOTNULLANDtrim(`crownandbutton`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`crownandbutton`) ASC; |
| 50 | 5.87 ms | SELECTDISTINCTtrim(`dial`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`dial`) ISNOTNULLANDtrim(`dial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`dial`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`dial`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`dial`) ISNOTNULLANDtrim(`dial`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`dial`) ASC SELECTDISTINCTtrim(`dial`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`dial`) ISNOTNULLANDtrim(`dial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`dial`) ASC; |
| 51 | 5.83 ms | SELECTDISTINCTtrim(`diamondsfilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE?) AND (trim(`diamondsfilter`) ISNOTNULLANDtrim(`diamondsfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`diamondsfilter`) ASC Parameters: [
"%,object|375273,%"
]SELECTDISTINCTtrim(`diamondsfilter`) FROMobject_localized_cs_product_hu_HUWHERE ( ( object_localized_cs_product_hu_HU.typeIN ('object','folder') ) AND ( object_localized_cs_product_hu_HU.published=1 ) AND ( object_localized_cs_product_hu_HU.`categories`LIKE? ) AND ( trim(`diamondsfilter`) ISNOTNULLANDtrim(`diamondsfilter`) !='' ) AND ( object_localized_cs_product_hu_HU.published=1 ) ) ORDER BYtrim(`diamondsfilter`) ASC SELECTDISTINCTtrim(`diamondsfilter`) FROMobject_localized_cs_product_hu_HUWHERE ((object_localized_cs_product_hu_HU.typeIN ('object','folder')) AND (object_localized_cs_product_hu_HU.published=1) AND (object_localized_cs_product_hu_HU.`categories`LIKE'%,object|375273,%') AND (trim(`diamondsfilter`) ISNOTNULLANDtrim(`diamondsfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`diamondsfilter`) ASC; |
| 52 | 0.41 ms | SELECTt0.classASclass_1,t0.nameASname_2,t0.workerASworker_3,t0.configurationASconfiguration_4,t0.indexLastVersionASindexLastVersion_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_indext0WHEREt0.id=? Parameters: [1]SELECTt0.classASclass_1,t0.nameASname_2,t0.workerASworker_3,t0.configurationASconfiguration_4,t0.indexLastVersionASindexLastVersion_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_indext0WHEREt0.id=? SELECTt0.classASclass_1,t0.nameASname_2,t0.workerASworker_3,t0.configurationASconfiguration_4,t0.indexLastVersionASindexLastVersion_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_indext0WHEREt0.id=1; |
| 53 | 0.41 ms | SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_conditionsONt0.id=coreshop_filter_condition_conditions.conditionIdWHEREcoreshop_filter_condition_conditions.filterId=?ORDER BYt0.sortASC Parameters: [1]SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_conditionsONt0.id=coreshop_filter_condition_conditions.conditionIdWHEREcoreshop_filter_condition_conditions.filterId=?ORDER BYt0.sortASC SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_conditionsONt0.id=coreshop_filter_condition_conditions.conditionIdWHEREcoreshop_filter_condition_conditions.filterId=1ORDER BYt0.sortASC; |
| 54 | 0.30 ms | SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_pre_conditionsONt0.id=coreshop_filter_condition_pre_conditions.conditionIdWHEREcoreshop_filter_condition_pre_conditions.filterId=?ORDER BYt0.sortASC Parameters: [1]SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_pre_conditionsONt0.id=coreshop_filter_condition_pre_conditions.conditionIdWHEREcoreshop_filter_condition_pre_conditions.filterId=?ORDER BYt0.sortASC SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_pre_conditionsONt0.id=coreshop_filter_condition_pre_conditions.conditionIdWHEREcoreshop_filter_condition_pre_conditions.filterId=1ORDER BYt0.sortASC; |
| 55 | 2.89 ms | SELECTDISTINCTq.o_idFROMcoreshop_index_mysql_localized_brand_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND (q.`parentCategoryIds`LIKE'%375273%') ORDER BYq.`newsfromdate`DESC,q.`name`DESC,q.`creationDate`DESCLIMIT15 Parameters: [] SELECTDISTINCTq.o_idFROMcoreshop_index_mysql_localized_brand_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND ( q.`parentCategoryIds`LIKE'%375273%' ) ORDER BYq.`newsfromdate`DESC,q.`name`DESC,q.`creationDate`DESCLIMIT15 SELECTDISTINCTq.o_idFROMcoreshop_index_mysql_localized_brand_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND (q.`parentCategoryIds`LIKE'%375273%') ORDER BYq.`newsfromdate`DESC,q.`name`DESC,q.`creationDate`DESCLIMIT15; |
| 56 | 2.53 ms | SELECTcount(*) FROMcoreshop_index_mysql_localized_brand_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND (q.`parentCategoryIds`LIKE'%375273%') Parameters: [] SELECTcount(*) FROMcoreshop_index_mysql_localized_brand_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND ( q.`parentCategoryIds`LIKE'%375273%' ) SELECTcount(*) FROMcoreshop_index_mysql_localized_brand_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND (q.`parentCategoryIds`LIKE'%375273%'); |
| 57 | 0.30 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_861705" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861705'); |
| 58 | 0.28 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_861705\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861705tags','class_cs_producttags'); |
| 59 | 0.27 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_840192" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_840192'); |
| 60 | 0.30 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_840192\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_840192tags','class_cs_producttags'); |
| 61 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_840189" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_840189'); |
| 62 | 0.31 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_840189\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_840189tags','class_cs_producttags'); |
| 63 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_840191" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_840191'); |
| 64 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_840191\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_840191tags','class_cs_producttags'); |
| 65 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_840190" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_840190'); |
| 66 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_840190\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_840190tags','class_cs_producttags'); |
| 67 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_783212" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_783212'); |
| 68 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_783212\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_783212tags','class_cs_producttags'); |
| 69 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_814257" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_814257'); |
| 70 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_814257\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_814257tags','class_cs_producttags'); |
| 71 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_754400" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_754400'); |
| 72 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_754400\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_754400tags','class_cs_producttags'); |
| 73 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_703706" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_703706'); |
| 74 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_703706\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_703706tags','class_cs_producttags'); |
| 75 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_694813" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_694813'); |
| 76 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_694813\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_694813tags','class_cs_producttags'); |
| 77 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_694812" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_694812'); |
| 78 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_694812\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_694812tags','class_cs_producttags'); |
| 79 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_695702" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_695702'); |
| 80 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_695702\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_695702tags','class_cs_producttags'); |
| 81 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_695701" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_695701'); |
| 82 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_695701\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_695701tags','class_cs_producttags'); |
| 83 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_625622" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_625622'); |
| 84 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_625622\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_625622tags','class_cs_producttags'); |
| 85 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_598655" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598655'); |
| 86 | 0.27 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "object_598655\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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598655tags','class_cs_producttags'); |
| 87 | 0.38 ms | SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=? Parameters: [375273]SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=? SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=375273; |
| 88 | 0.54 ms | SELECTobject_localized_cs_category_hu_HU.idasid,object_localized_cs_category_hu_HU.typeas`type`FROMobject_localized_cs_category_hu_HUWHERE (`workingName`='GRAND SEIKO'ANDobject_localized_cs_category_hu_HU.typeIN ('variant','object')) ANDobject_localized_cs_category_hu_HU.published=1LIMIT1 Parameters: [] SELECTobject_localized_cs_category_hu_HU.idasid,object_localized_cs_category_hu_HU.typeas`type`FROMobject_localized_cs_category_hu_HUWHERE ( `workingName`='GRAND SEIKO'ANDobject_localized_cs_category_hu_HU.typeIN ('variant','object') ) ANDobject_localized_cs_category_hu_HU.published=1LIMIT1 SELECTobject_localized_cs_category_hu_HU.idasid,object_localized_cs_category_hu_HU.typeas`type`FROMobject_localized_cs_category_hu_HUWHERE (`workingName`='GRAND SEIKO'ANDobject_localized_cs_category_hu_HU.typeIN ('variant','object')) ANDobject_localized_cs_category_hu_HU.published=1LIMIT1; |
| 89 | 0.47 ms | SELECTobject_localized_cs_category_hu_HU.idasid,object_localized_cs_category_hu_HU.typeas`type`FROMobject_localized_cs_category_hu_HUWHERE (`workingName`='SEIKO'ANDobject_localized_cs_category_hu_HU.typeIN ('variant','object')) ANDobject_localized_cs_category_hu_HU.published=1LIMIT1 Parameters: [] SELECTobject_localized_cs_category_hu_HU.idasid,object_localized_cs_category_hu_HU.typeas`type`FROMobject_localized_cs_category_hu_HUWHERE ( `workingName`='SEIKO'ANDobject_localized_cs_category_hu_HU.typeIN ('variant','object') ) ANDobject_localized_cs_category_hu_HU.published=1LIMIT1 SELECTobject_localized_cs_category_hu_HU.idasid,object_localized_cs_category_hu_HU.typeas`type`FROMobject_localized_cs_category_hu_HUWHERE (`workingName`='SEIKO'ANDobject_localized_cs_category_hu_HU.typeIN ('variant','object')) ANDobject_localized_cs_category_hu_HU.published=1LIMIT1; |
| 90 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375232" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232'); |
| 91 | 0.27 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232tags','class_cs_categorytags','asset_16791tags'); |
| 92 | 0.30 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [861705]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=861705; |
| 93 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375277" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375277'); |
| 94 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "object_375277\x01tags\x01" "class_cs_category\x01tags\x01" "asset_25779\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375277tags','class_cs_categorytags','asset_25779tags'); |
| 95 | 0.19 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; |
| 96 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375278" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375278'); |
| 97 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "object_375278\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16748\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375278tags','class_cs_categorytags','asset_16748tags'); |
| 98 | 0.19 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; |
| 99 | 0.40 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [840192]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=840192; |
| 100 | 0.45 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [840189]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=840189; |
| 101 | 0.28 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [840191]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=840191; |
| 102 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375276" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375276'); |
| 103 | 0.27 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "object_375276\x01tags\x01" "class_cs_category\x01tags\x01" "asset_25777\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375276tags','class_cs_categorytags','asset_25777tags'); |
| 104 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375279" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375279'); |
| 105 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "object_375279\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16744\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375279tags','class_cs_categorytags','asset_16744tags'); |
| 106 | 0.24 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [840190]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=840190; |
| 107 | 0.26 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [783212]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=783212; |
| 108 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375291" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375291'); |
| 109 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "object_375291\x01tags\x01" "class_cs_category\x01tags\x01" "asset_25778\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375291tags','class_cs_categorytags','asset_25778tags'); |
| 110 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375937" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375937'); |
| 111 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "object_375937\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16698\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375937tags','class_cs_categorytags','asset_16698tags'); |
| 112 | 0.30 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [814257]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=814257; |
| 113 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375938" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375938'); |
| 114 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "object_375938\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16697\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375938tags','class_cs_categorytags','asset_16697tags'); |
| 115 | 0.21 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [754400]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=754400; |
| 116 | 0.24 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [703706]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=703706; |
| 117 | 0.18 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [694813]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=694813; |
| 118 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "object_375931" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375931'); |
| 119 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "object_375931\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16749\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375931tags','class_cs_categorytags','asset_16749tags'); |
| 120 | 0.21 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [694812]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=694812; |
| 121 | 0.18 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [695702]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=695702; |
| 122 | 0.16 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [695701]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=695701; |
| 123 | 0.16 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [625622]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=625622; |
| 124 | 0.17 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [598655]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=598655; |
| 125 | 0.41 ms | SELECT*FROMtranslations_messagesLIMIT1; Parameters: [] SELECT*FROMtranslations_messagesLIMIT1; SELECT*FROMtranslations_messagesLIMIT1;; |
| 126 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "translation_data_6431352cea3285deadebc5c2a566a87b" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translation_data_6431352cea3285deadebc5c2a566a87b'); |
| 127 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794844679 "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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translatortags','translator_websitetags','translatetags'); |
| 128 | 0.30 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "website_config" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_config'); |
| 129 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?) Parameters: [1794844679 "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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_configtags','systemtags','configtags','outputtags','asset_15304tags'); |
| 130 | 0.28 ms | SELECTcustomSettingsFROMassetsWHEREid=? Parameters: [15304]SELECTcustomSettingsFROMassetsWHEREid=? SELECTcustomSettingsFROMassetsWHEREid=15304; |
| 131 | 0.25 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/shared/" "header" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/shared/'AND`key`=BINARY'header'; |
| 132 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "document_76" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_76'); |
| 133 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1794844679 "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>1794844679THENitem_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'); |
| 134 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "document_properties_76" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_76'); |
| 135 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794844679 "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>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_76tags'); |
| 136 | 0.24 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'; |
| 137 | 0.38 ms | SELECT*FROMredirectsWHERE ( (source=?AND (`type`=?OR`type`=?)) OR (source=?AND`type`=?) OR (source=?AND`type`=?) ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC Parameters: [ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=hu_HU&_controller=App%5CController%5CFrontend%5CDefaultController" "path_query" "https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu_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_HU&_controller=App%5CController%5CFrontend%5CDefaultController'AND`type`='path_query') OR (source='https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu_HU&_controller=App%5CController%5CFrontend%5CDefaultController'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
| 138 | 0.30 ms | SELECT*FROMtranslations_messagesLIMIT1; Parameters: [] SELECT*FROMtranslations_messagesLIMIT1; SELECT*FROMtranslations_messagesLIMIT1;; |
| 139 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794844679 "translation_data_e3136baff57bbb51795a106feba2786d" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794844679THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translation_data_e3136baff57bbb51795a106feba2786d'); |
| 140 | 0.35 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'; |
| 141 | 0.54 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_HU&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction" "path_query" "https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu_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_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_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; |
| 142 | 1.91 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 | 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 |
pimcore entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
pimcore entity manager
No loaded entities.