Query Metrics
143Database Queries
48Different statements
203.94 msQuery time
0Invalid entities
185Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826558 "site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826558THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3'); |
| 2 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826558 "system\x01tags\x01" "site\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826558THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','sitetags'); |
| 3 | 0.19 ms | SELECT*FROMsettings_storeWHEREid=?ANDscope=? Parameters: [ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] SELECT*FROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle'ANDscope='pimcore'; |
| 4 | 0.35 ms | SELECT*FROMredirectsWHERE ( (source=?AND (`type`=?OR`type`=?)) OR (source=?AND`type`=?) OR (source=?AND`type`=?) ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC Parameters: [ "/e-boutique/seiko/prospex-c375256" "path" "auto_create" "/e-boutique/seiko/prospex-c375256" "path_query" "https://boutiqueapi.local.szerver.store/e-boutique/seiko/prospex-c375256" "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/seiko/prospex-c375256'AND (`type`='path'OR`type`='auto_create')) OR (source='/e-boutique/seiko/prospex-c375256'AND`type`='path_query') OR (source='https://boutiqueapi.local.szerver.store/e-boutique/seiko/prospex-c375256'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
| 5 | 0.20 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826558 "system_route_redirect" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826558THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_route_redirect'); |
| 6 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826558 "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>1794826558THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags'); |
| 7 | 0.15 ms | SELECT*FROMtmp_storeWHEREid=? Parameters: [
"maintenance_mode"
]SELECT*FROMtmp_storeWHEREid=? SELECT*FROMtmp_storeWHEREid='maintenance_mode'; |
| 8 | 0.17 ms | SELECT*FROMsettings_storeWHEREid=?ANDscope=? Parameters: [ "reports" "pimcore" ] SELECT*FROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='reports'ANDscope='pimcore'; |
| 9 | 0.23 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/e-boutique/seiko/" "prospex-c375256" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/e-boutique/seiko/'AND`key`=BINARY'prospex-c375256'; |
| 10 | 0.17 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/e-boutique/seiko/prospex-c375256"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique/seiko/prospex-c375256'; |
| 11 | 0.17 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/e-boutique/" "seiko" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/e-boutique/'AND`key`=BINARY'seiko'; |
| 12 | 0.15 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/e-boutique/seiko"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique/seiko'; |
| 13 | 0.18 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/" "e-boutique" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY'e-boutique'; |
| 14 | 0.15 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/e-boutique"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique'; |
| 15 | 0.18 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [
"/"
""
]SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY''; |
| 16 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826558 "document_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826558THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1'); |
| 17 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1794826558 "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>1794826558THENitem_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'); |
| 18 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826558 "document_properties_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826558THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_1'); |
| 19 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826558 "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>1794826558THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_1tags'); |
| 20 | 0.32 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; |
| 21 | 0.34 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); |
| 22 | 0.19 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_order"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_order'; |
| 23 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "sites_path_mapping" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('sites_path_mapping'); |
| 24 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "system\x01tags\x01" "resource\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','resourcetags'); |
| 25 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_375256" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375256'); |
| 26 | 0.21 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_category"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_category'; |
| 27 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826559 "object_375256\x01tags\x01" "class_cs_category\x01tags\x01" "asset_25766\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375256tags','class_cs_categorytags','asset_25766tags'); |
| 28 | 0.20 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; |
| 29 | 0.19 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_product"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_product'; |
| 30 | 8.31 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|375256,%"
]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|375256,%') ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1; |
| 31 | 0.30 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_375232" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232'); |
| 32 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826559 "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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232tags','class_cs_categorytags','asset_16791tags'); |
| 33 | 0.18 ms | SELECTt0.nameASname_1,t0.resultsPerPageASresultsPerPage_2,t0.orderDirectionASorderDirection_3,t0.orderKeyASorderKey_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.indexIdASindexId_8FROMcoreshop_filtert0WHEREt0.id=? Parameters: [1]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; |
| 34 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_375163" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163'); |
| 35 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_375163\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163tags'); |
| 36 | 7.39 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|375256,%"
]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|375256,%') ORDER BYwholesalePriceASCLIMIT1; |
| 37 | 7.13 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|375256,%"
]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|375256,%') ORDER BYwholesalePriceDESCLIMIT1; |
| 38 | 5.27 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|375256,%"
]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|375256,%')) AND (NULLIF(outlet,0) ISNOTNULL) ORDER BYwholesalePriceDESCLIMIT1; |
| 39 | 8.50 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|375256,%"
]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|375256,%') AND (trim(`typeofwatch`) ISNOTNULLANDtrim(`typeofwatch`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`typeofwatch`) ASC; |
| 40 | 5.88 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|375256,%"
]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|375256,%') AND (object_localized_cs_product_hu_HU.collectionISNOTNULL)); |
| 41 | 7.13 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|375256,%"
]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|375256,%') AND (trim(`availability`) ISNOTNULLANDtrim(`availability`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`availability`) ASC; |
| 42 | 8.75 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|375256,%"
]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|375256,%') AND (trim(`movementtypefilter`) ISNOTNULLANDtrim(`movementtypefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`movementtypefilter`) ASC; |
| 43 | 5.72 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|375256,%"
]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|375256,%') AND (trim(`casefilter`) ISNOTNULLANDtrim(`casefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`casefilter`) ASC; |
| 44 | 6.03 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|375256,%"
]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|375256,%') AND (trim(`glassfilter`) ISNOTNULLANDtrim(`glassfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`glassfilter`) ASC; |
| 45 | 8.46 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|375256,%"
]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|375256,%') AND (trim(`formofcase`) ISNOTNULLANDtrim(`formofcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`formofcase`) ASC; |
| 46 | 9.11 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|375256,%"
]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|375256,%') AND (trim(`style`) ISNOTNULLANDtrim(`style`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`style`) ASC; |
| 47 | 10.56 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|375256,%"
]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|375256,%') AND (trim(`bandfilter`) ISNOTNULLANDtrim(`bandfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bandfilter`) ASC; |
| 48 | 6.58 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|375256,%"
]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|375256,%') AND (trim(`bandwidth`) ISNOTNULLANDtrim(`bandwidth`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bandwidth`) ASC; |
| 49 | 10.48 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|375256,%"
]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|375256,%') AND (trim(`buckle`) ISNOTNULLANDtrim(`buckle`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`buckle`) ASC; |
| 50 | 8.83 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|375256,%"
]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|375256,%') AND (trim(`bezel`) ISNOTNULLANDtrim(`bezel`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bezel`) ASC; |
| 51 | 9.22 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|375256,%"
]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|375256,%') AND (trim(`backcase`) ISNOTNULLANDtrim(`backcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`backcase`) ASC; |
| 52 | 9.06 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|375256,%"
]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|375256,%') AND (trim(`colorofdial`) ISNOTNULLANDtrim(`colorofdial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`colorofdial`) ASC; |
| 53 | 9.24 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|375256,%"
]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|375256,%') AND (trim(`waterresistance`) ISNOTNULLANDtrim(`waterresistance`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`waterresistance`) ASC; |
| 54 | 9.31 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|375256,%"
]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|375256,%') AND (trim(`crownandbutton`) ISNOTNULLANDtrim(`crownandbutton`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`crownandbutton`) ASC; |
| 55 | 8.10 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|375256,%"
]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|375256,%') AND (trim(`dial`) ISNOTNULLANDtrim(`dial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`dial`) ASC; |
| 56 | 7.97 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|375256,%"
]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|375256,%') AND (trim(`diamondsfilter`) ISNOTNULLANDtrim(`diamondsfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`diamondsfilter`) ASC; |
| 57 | 0.30 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: [2]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=2; |
| 58 | 0.33 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: [2]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=2ORDER BYt0.sortASC; |
| 59 | 0.28 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: [2]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=2ORDER BYt0.sortASC; |
| 60 | 2.95 ms | SELECTDISTINCTq.o_idFROMcoreshop_index_mysql_localized_collection_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'%375256%') ORDER BYq.`newsfromdate`DESC,q.`name`DESC,q.`creationDate`DESCLIMIT15 Parameters: [] SELECTDISTINCTq.o_idFROMcoreshop_index_mysql_localized_collection_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'%375256%' ) ORDER BYq.`newsfromdate`DESC,q.`name`DESC,q.`creationDate`DESCLIMIT15 SELECTDISTINCTq.o_idFROMcoreshop_index_mysql_localized_collection_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'%375256%') ORDER BYq.`newsfromdate`DESC,q.`name`DESC,q.`creationDate`DESCLIMIT15; |
| 61 | 2.43 ms | SELECTcount(*) FROMcoreshop_index_mysql_localized_collection_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'%375256%') Parameters: [] SELECTcount(*) FROMcoreshop_index_mysql_localized_collection_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'%375256%' ) SELECTcount(*) FROMcoreshop_index_mysql_localized_collection_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'%375256%'); |
| 62 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_912076" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_912076'); |
| 63 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_912076\x01tags\x01" "class_cs_product\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_912076tags','class_cs_producttags'); |
| 64 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_861573" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861573'); |
| 65 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_861573\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861573tags','class_cs_producttags'); |
| 66 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_861575" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861575'); |
| 67 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_861575\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861575tags','class_cs_producttags'); |
| 68 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_861574" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861574'); |
| 69 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_861574\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861574tags','class_cs_producttags'); |
| 70 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_861572" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861572'); |
| 71 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_861572\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861572tags','class_cs_producttags'); |
| 72 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_861571" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861571'); |
| 73 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_861571\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861571tags','class_cs_producttags'); |
| 74 | 0.21 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_861570" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861570'); |
| 75 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_861570\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861570tags','class_cs_producttags'); |
| 76 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_861569" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861569'); |
| 77 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_861569\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_861569tags','class_cs_producttags'); |
| 78 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_762956" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762956'); |
| 79 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_762956\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762956tags','class_cs_producttags'); |
| 80 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_762955" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762955'); |
| 81 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_762955\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762955tags','class_cs_producttags'); |
| 82 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_762954" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762954'); |
| 83 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_762954\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762954tags','class_cs_producttags'); |
| 84 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_762953" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762953'); |
| 85 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_762953\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762953tags','class_cs_producttags'); |
| 86 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_800888" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_800888'); |
| 87 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_800888\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_800888tags','class_cs_producttags'); |
| 88 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_762971" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762971'); |
| 89 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_762971\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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_762971tags','class_cs_producttags'); |
| 90 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_711672" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_711672'); |
| 91 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_711672\x01tags\x01" "class_cs_product\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_711672tags','class_cs_producttags'); |
| 92 | 0.30 ms | SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=? Parameters: [375256]SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=? SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=375256; |
| 93 | 0.23 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [912076]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=912076; |
| 94 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_598267" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598267'); |
| 95 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826559 "object_598267\x01tags\x01" "class_cs_category\x01tags\x01" "asset_21649\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598267tags','class_cs_categorytags','asset_21649tags'); |
| 96 | 0.16 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; |
| 97 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_598268" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598268'); |
| 98 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) Parameters: [1794826559 "object_598268\x01tags\x01" "class_cs_category\x01tags\x01" "asset_23442\x01tags\x01" "asset_16665\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598268tags','class_cs_categorytags','asset_23442tags','asset_16665tags'); |
| 99 | 0.11 ms | SELECTt0.nameASname_1,t0.resultsPerPageASresultsPerPage_2,t0.orderDirectionASorderDirection_3,t0.orderKeyASorderKey_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.indexIdASindexId_8FROMcoreshop_filtert0WHEREt0.id=? Parameters: [4]SELECTt0.nameASname_1,t0.resultsPerPageASresultsPerPage_2,t0.orderDirectionASorderDirection_3,t0.orderKeyASorderKey_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.indexIdASindexId_8FROMcoreshop_filtert0WHEREt0.id=? SELECTt0.nameASname_1,t0.resultsPerPageASresultsPerPage_2,t0.orderDirectionASorderDirection_3,t0.orderKeyASorderKey_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.indexIdASindexId_8FROMcoreshop_filtert0WHEREt0.id=4; |
| 100 | 0.17 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [861573]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=861573; |
| 101 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_598254" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598254'); |
| 102 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "object_598254\x01tags\x01" "class_cs_category\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598254tags','class_cs_categorytags'); |
| 103 | 0.15 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [861575]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=861575; |
| 104 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_598256" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598256'); |
| 105 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) Parameters: [1794826559 "object_598256\x01tags\x01" "class_cs_category\x01tags\x01" "asset_23158\x01tags\x01" "asset_16674\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598256tags','class_cs_categorytags','asset_23158tags','asset_16674tags'); |
| 106 | 0.18 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [861574]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=861574; |
| 107 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_598257" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598257'); |
| 108 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) Parameters: [1794826559 "object_598257\x01tags\x01" "class_cs_category\x01tags\x01" "asset_23155\x01tags\x01" "asset_16669\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598257tags','class_cs_categorytags','asset_23155tags','asset_16669tags'); |
| 109 | 0.15 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [861572]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=861572; |
| 110 | 0.14 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [861571]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=861571; |
| 111 | 0.14 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [861570]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=861570; |
| 112 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_590832" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_590832'); |
| 113 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826559 "object_590832\x01tags\x01" "class_cs_category\x01tags\x01" "asset_21651\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_590832tags','class_cs_categorytags','asset_21651tags'); |
| 114 | 0.15 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [861569]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=861569; |
| 115 | 0.14 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [762956]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=762956; |
| 116 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_375293" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375293'); |
| 117 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826559 "object_375293\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16671\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375293tags','class_cs_categorytags','asset_16671tags'); |
| 118 | 0.14 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [762955]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=762955; |
| 119 | 0.14 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [762954]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=762954; |
| 120 | 0.13 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [762953]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=762953; |
| 121 | 0.13 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [800888]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=800888; |
| 122 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "object_598259" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598259'); |
| 123 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) Parameters: [1794826559 "object_598259\x01tags\x01" "class_cs_category\x01tags\x01" "asset_23156\x01tags\x01" "asset_16670\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_598259tags','class_cs_categorytags','asset_23156tags','asset_16670tags'); |
| 124 | 0.15 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [762971]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=762971; |
| 125 | 0.14 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [711672]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=711672; |
| 126 | 0.15 ms | SELECT*FROMtranslations_messagesLIMIT1; Parameters: [] SELECT*FROMtranslations_messagesLIMIT1; SELECT*FROMtranslations_messagesLIMIT1;; |
| 127 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "translation_data_6431352cea3285deadebc5c2a566a87b" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translation_data_6431352cea3285deadebc5c2a566a87b'); |
| 128 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826559 "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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translatortags','translator_websitetags','translatetags'); |
| 129 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "website_config" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_config'); |
| 130 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?) Parameters: [1794826559 "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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_configtags','systemtags','configtags','outputtags','asset_15304tags'); |
| 131 | 0.12 ms | SELECTcustomSettingsFROMassetsWHEREid=? Parameters: [15304]SELECTcustomSettingsFROMassetsWHEREid=? SELECTcustomSettingsFROMassetsWHEREid=15304; |
| 132 | 0.16 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/shared/" "header" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/shared/'AND`key`=BINARY'header'; |
| 133 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "document_76" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_76'); |
| 134 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1794826559 "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>1794826559THENitem_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'); |
| 135 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "document_properties_76" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_76'); |
| 136 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826559 "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>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_76tags'); |
| 137 | 0.13 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'; |
| 138 | 0.28 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; |
| 139 | 0.12 ms | SELECT*FROMtranslations_messagesLIMIT1; Parameters: [] SELECT*FROMtranslations_messagesLIMIT1; SELECT*FROMtranslations_messagesLIMIT1;; |
| 140 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826559 "translation_data_e3136baff57bbb51795a106feba2786d" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826559THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translation_data_e3136baff57bbb51795a106feba2786d'); |
| 141 | 0.14 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'; |
| 142 | 0.26 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; |
| 143 | 1.50 ms | SELECTDISTINCTc0_.isoCodeASisoCode_0,c0_.nameASname_1,c0_.numericIsoCodeASnumericIsoCode_2,c0_.symbolASsymbol_3,c0_.creationDateAScreationDate_4,c0_.modificationDateASmodificationDate_5,c0_.idASid_6FROMcoreshop_currencyc0_LEFT JOINcoreshop_countryc1_ONc0_.id=c1_.currencyIdINNER JOINcoreshop_store_countriesc3_ONc1_.id=c3_.country_idINNER JOINcoreshop_storec2_ONc2_.id=c3_.store_idWHEREc1_.active=1ANDc2_.id=? Parameters: [1]SELECTDISTINCTc0_.isoCodeASisoCode_0,c0_.nameASname_1,c0_.numericIsoCodeASnumericIsoCode_2,c0_.symbolASsymbol_3,c0_.creationDateAScreationDate_4,c0_.modificationDateASmodificationDate_5,c0_.idASid_6FROMcoreshop_currencyc0_LEFT JOINcoreshop_countryc1_ONc0_.id=c1_.currencyIdINNER JOINcoreshop_store_countriesc3_ONc1_.id=c3_.country_idINNER JOINcoreshop_storec2_ONc2_.id=c3_.store_idWHEREc1_.active=1ANDc2_.id=? SELECTDISTINCTc0_.isoCodeASisoCode_0,c0_.nameASname_1,c0_.numericIsoCodeASnumericIsoCode_2,c0_.symbolASsymbol_3,c0_.creationDateAScreationDate_4,c0_.modificationDateASmodificationDate_5,c0_.idASid_6FROMcoreshop_currencyc0_LEFT JOINcoreshop_countryc1_ONc0_.id=c1_.currencyIdINNER JOINcoreshop_store_countriesc3_ONc1_.id=c3_.country_idINNER JOINcoreshop_storec2_ONc2_.id=c3_.store_idWHEREc1_.active=1ANDc2_.id=1; |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| pimcore | doctrine.orm.pimcore_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| CoreShop\Component\Core\Model\Currency | 156 |
| CoreShop\Component\Core\Model\Configuration | 18 |
| CoreShop\Component\Index\Model\Filter | 4 |
| CoreShop\Component\Index\Model\Index | 4 |
| CoreShop\Component\Core\Model\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.