Query Metrics
152Database Queries
51Different statements
198.38 msQuery time
0Invalid entities
184Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.24 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826569 "site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826569THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3'); |
| 2 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826569 "system\x01tags\x01" "site\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826569THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','sitetags'); |
| 3 | 0.15 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.34 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=3" "path_query" "https://boutiqueapi.local.szerver.store/e-boutique/grand-seiko-c375273?page=3" "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=3'AND`type`='path_query') OR (source='https://boutiqueapi.local.szerver.store/e-boutique/grand-seiko-c375273?page=3'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
| 5 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826569 "system_route_redirect" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826569THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_route_redirect'); |
| 6 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826569 "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>1794826569THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags'); |
| 7 | 0.08 ms | SELECT*FROMtmp_storeWHEREid=? Parameters: [
"maintenance_mode"
]SELECT*FROMtmp_storeWHEREid=? SELECT*FROMtmp_storeWHEREid='maintenance_mode'; |
| 8 | 0.07 ms | SELECT*FROMsettings_storeWHEREid=?ANDscope=? Parameters: [ "reports" "pimcore" ] SELECT*FROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='reports'ANDscope='pimcore'; |
| 9 | 0.14 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.07 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/e-boutique/grand-seiko-c375273"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique/grand-seiko-c375273'; |
| 11 | 0.07 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.05 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/e-boutique"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique'; |
| 13 | 0.07 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [
"/"
""
]SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY''; |
| 14 | 0.08 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826569 "document_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826569THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1'); |
| 15 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1794826569 "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>1794826569THENitem_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.08 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826569 "document_properties_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826569THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_1'); |
| 17 | 0.07 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826569 "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>1794826569THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_1tags'); |
| 18 | 0.22 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.25 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.14 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_order"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_order'; |
| 21 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "sites_path_mapping" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('sites_path_mapping'); |
| 22 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "system\x01tags\x01" "resource\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','resourcetags'); |
| 23 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_375273" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375273'); |
| 24 | 0.12 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_category"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_category'; |
| 25 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826570 "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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375273tags','class_cs_categorytags','asset_16792tags'); |
| 26 | 0.14 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.12 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_product"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_product'; |
| 28 | 7.87 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.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_375163" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163'); |
| 30 | 0.23 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_375163\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375163tags'); |
| 31 | 7.28 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 | 6.75 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 | 7.56 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 | 8.96 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 | 9.62 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 | 9.02 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 | 8.72 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 | 9.20 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 | 9.20 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 | 8.93 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 | 9.77 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 | 7.39 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 | 8.37 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 | 5.63 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 | 7.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|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 | 9.42 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.10 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 | 8.54 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.25 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 | 4.99 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.95 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.26 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.37 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.25 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.27 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`DESCLIMIT15OFFSET30 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`DESCLIMIT15OFFSET30 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`DESCLIMIT15OFFSET30; |
| 56 | 1.85 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.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_392676" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392676'); |
| 58 | 0.26 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_392676\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392676tags','class_cs_producttags'); |
| 59 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_437992" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_437992'); |
| 60 | 0.25 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_437992\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_437992tags','class_cs_producttags'); |
| 61 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_392670" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392670'); |
| 62 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_392670\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392670tags','class_cs_producttags'); |
| 63 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_392669" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392669'); |
| 64 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_392669\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392669tags','class_cs_producttags'); |
| 65 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_392672" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392672'); |
| 66 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_392672\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392672tags','class_cs_producttags'); |
| 67 | 0.19 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_392671" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392671'); |
| 68 | 0.22 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_392671\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392671tags','class_cs_producttags'); |
| 69 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_392667" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392667'); |
| 70 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_392667\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392667tags','class_cs_producttags'); |
| 71 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_392668" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392668'); |
| 72 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_392668\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392668tags','class_cs_producttags'); |
| 73 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_392575" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392575'); |
| 74 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_392575\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392575tags','class_cs_producttags'); |
| 75 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_392666" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392666'); |
| 76 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_392666\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_392666tags','class_cs_producttags'); |
| 77 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_375843" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375843'); |
| 78 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_375843\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375843tags','class_cs_producttags'); |
| 79 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_551968" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_551968'); |
| 80 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_551968\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_551968tags','class_cs_producttags'); |
| 81 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_551970" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_551970'); |
| 82 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_551970\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_551970tags','class_cs_producttags'); |
| 83 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_375839" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375839'); |
| 84 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_375839\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375839tags','class_cs_producttags'); |
| 85 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826570 "object_375834" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375834'); |
| 86 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826570 "object_375834\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>1794826570THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375834tags','class_cs_producttags'); |
| 87 | 0.27 ms | SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=? Parameters: [375273]SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=? SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=375273; |
| 88 | 0.46 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.23 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.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375232" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232'); |
| 91 | 0.08 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375232tags','class_cs_categorytags','asset_16791tags'); |
| 92 | 0.09 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [392676]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=392676; |
| 93 | 0.05 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375276" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375276'); |
| 94 | 0.18 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375276tags','class_cs_categorytags','asset_25777tags'); |
| 95 | 0.14 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.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375933" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375933'); |
| 97 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "object_375933\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16745\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375933tags','class_cs_categorytags','asset_16745tags'); |
| 98 | 0.14 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.09 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [437992]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=437992; |
| 100 | 0.06 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375277" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375277'); |
| 101 | 0.06 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375277tags','class_cs_categorytags','asset_25779tags'); |
| 102 | 0.04 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375278" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375278'); |
| 103 | 0.20 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375278tags','class_cs_categorytags','asset_16748tags'); |
| 104 | 0.22 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [392670]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=392670; |
| 105 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375931" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375931'); |
| 106 | 0.15 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375931tags','class_cs_categorytags','asset_16749tags'); |
| 107 | 0.17 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [392669]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=392669; |
| 108 | 0.13 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [392672]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=392672; |
| 109 | 0.12 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [392671]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=392671; |
| 110 | 0.11 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [392667]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=392667; |
| 111 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375291" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375291'); |
| 112 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375291tags','class_cs_categorytags','asset_25778tags'); |
| 113 | 0.09 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375938" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375938'); |
| 114 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375938tags','class_cs_categorytags','asset_16697tags'); |
| 115 | 0.12 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [392668]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=392668; |
| 116 | 0.12 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [392575]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=392575; |
| 117 | 0.09 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375937" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375937'); |
| 118 | 0.11 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375937tags','class_cs_categorytags','asset_16698tags'); |
| 119 | 0.12 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [392666]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=392666; |
| 120 | 0.11 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [375843]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=375843; |
| 121 | 0.09 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375279" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375279'); |
| 122 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375279tags','class_cs_categorytags','asset_16744tags'); |
| 123 | 0.12 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [551968]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=551968; |
| 124 | 0.11 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [551970]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=551970; |
| 125 | 0.11 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [375839]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=375839; |
| 126 | 0.09 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375274" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375274'); |
| 127 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "object_375274\x01tags\x01" "class_cs_category\x01tags\x01" "asset_25781\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375274tags','class_cs_categorytags','asset_25781tags'); |
| 128 | 0.09 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "object_375275" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375275'); |
| 129 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "object_375275\x01tags\x01" "class_cs_category\x01tags\x01" "asset_16753\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('object_375275tags','class_cs_categorytags','asset_16753tags'); |
| 130 | 0.12 ms | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [375834]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=375834; |
| 131 | 0.13 ms | SELECT*FROMtranslations_messagesLIMIT1; Parameters: [] SELECT*FROMtranslations_messagesLIMIT1; SELECT*FROMtranslations_messagesLIMIT1;; |
| 132 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "translation_data_6431352cea3285deadebc5c2a566a87b" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translation_data_6431352cea3285deadebc5c2a566a87b'); |
| 133 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translatortags','translator_websitetags','translatetags'); |
| 134 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "website_config" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_config'); |
| 135 | 0.13 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_configtags','systemtags','configtags','outputtags','asset_15304tags'); |
| 136 | 0.10 ms | SELECTcustomSettingsFROMassetsWHEREid=? Parameters: [15304]SELECTcustomSettingsFROMassetsWHEREid=? SELECTcustomSettingsFROMassetsWHEREid=15304; |
| 137 | 0.14 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/shared/" "header" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/shared/'AND`key`=BINARY'header'; |
| 138 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "document_76" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_76'); |
| 139 | 0.16 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1794826571 "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>1794826571THENitem_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'); |
| 140 | 0.10 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "document_properties_76" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_76'); |
| 141 | 0.12 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1794826571 "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>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_76tags'); |
| 142 | 0.12 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'; |
| 143 | 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%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; |
| 144 | 0.19 ms | SELECT*FROMtranslations_messagesLIMIT1; Parameters: [] SELECT*FROMtranslations_messagesLIMIT1; SELECT*FROMtranslations_messagesLIMIT1;; |
| 145 | 0.17 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1794826571 "translation_data_e3136baff57bbb51795a106feba2786d" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1794826571THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('translation_data_e3136baff57bbb51795a106feba2786d'); |
| 146 | 0.20 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'; |
| 147 | 0.31 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; |
| 148 | 1.61 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; |
| 149 | 0.36 ms | SELECTt0.nameASname_1,t0.creationDateAScreationDate_2,t0.modificationDateASmodificationDate_3,t0.idASid_4,t0.localeASlocale_5,t0.translatable_idAStranslatable_id_6FROMcoreshop_country_translationt0WHEREt0.translatable_id=?ANDt0.locale=?LIMIT1 Parameters: [11 "hu_HU" ] SELECTt0.nameASname_1,t0.creationDateAScreationDate_2,t0.modificationDateASmodificationDate_3,t0.idASid_4,t0.localeASlocale_5,t0.translatable_idAStranslatable_id_6FROMcoreshop_country_translationt0WHEREt0.translatable_id=?ANDt0.locale=?LIMIT1 SELECTt0.nameASname_1,t0.creationDateAScreationDate_2,t0.modificationDateASmodificationDate_3,t0.idASid_4,t0.localeASlocale_5,t0.translatable_idAStranslatable_id_6FROMcoreshop_country_translationt0WHEREt0.translatable_id=11ANDt0.locale='hu_HU'LIMIT1; |
| 150 | 0.26 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.id Parameters: [] SELECTt0.nameASname_1,t0.templateAStemplate_2,t0.isDefaultASisDefault_3,t0.siteIdASsiteId_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.useGrossPriceASuseGrossPrice_8,t0.currencyIdAScurrencyId_9,t0.baseCountryIdASbaseCountryId_10,t11.isoCodeASisoCode_12,t11.activeASactive_13,t11.addressFormatASaddressFormat_14,t11.salutationsASsalutations_15,t11.creationDateAScreationDate_16,t11.modificationDateASmodificationDate_17,t11.idASid_18,t11.zoneIdASzoneId_19,t11.currencyIdAScurrencyId_20FROMcoreshop_storet0LEFT JOINcoreshop_countryt11ONt0.baseCountryId=t11.id SELECTt0.nameASname_1,t0.templateAStemplate_2,t0.isDefaultASisDefault_3,t0.siteIdASsiteId_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.useGrossPriceASuseGrossPrice_8,t0.currencyIdAScurrencyId_9,t0.baseCountryIdASbaseCountryId_10,t11.isoCodeASisoCode_12,t11.activeASactive_13,t11.addressFormatASaddressFormat_14,t11.salutationsASsalutations_15,t11.creationDateAScreationDate_16,t11.modificationDateASmodificationDate_17,t11.idASid_18,t11.zoneIdASzoneId_19,t11.currencyIdAScurrencyId_20FROMcoreshop_storet0LEFT JOINcoreshop_countryt11ONt0.baseCountryId=t11.id; |
| 151 | 0.22 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'; |
| 152 | 0.37 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=CoreShop%5CBundle%5CFrontendBundle%5CController%5CCartController%3A%3AwidgetAction" "path_query" "https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu_HU&_controller=CoreShop%5CBundle%5CFrontendBundle%5CController%5CCartController%3A%3AwidgetAction" "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=CoreShop%5CBundle%5CFrontendBundle%5CController%5CCartController%3A%3AwidgetAction'AND`type`='path_query') OR (source='https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu_HU&_controller=CoreShop%5CBundle%5CFrontendBundle%5CController%5CCartController%3A%3AwidgetAction'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| pimcore | doctrine.orm.pimcore_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| CoreShop\Component\Core\Model\Currency | 156 |
| CoreShop\Component\Core\Model\Configuration | 18 |
| CoreShop\Component\Index\Model\Filter | 3 |
| CoreShop\Component\Index\Model\Index | 3 |
| CoreShop\Component\Core\Model\Store | 1 |
| CoreShop\Component\Core\Model\Country | 1 |
| CoreShop\Component\Address\Model\Zone | 1 |
| CoreShop\Component\Address\Model\CountryTranslation | 1 |
pimcore entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
pimcore entity manager
No loaded entities.