Query Metrics
389Database Queries
52Different statements
300.36 msQuery time
0Invalid entities
184Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
| 14.92 ms (4.97%) | 70 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1783621170 "site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3'); |
| 14.77 ms (4.92%) | 92 | 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'; |
| 11.68 ms (3.89%) | 85 | SELECT*FROMtmp_storeWHEREid=? Parameters: [
"maintenance_mode"
]SELECT*FROMtmp_storeWHEREid=? SELECT*FROMtmp_storeWHEREid='maintenance_mode'; |
| 11.43 ms (3.81%) | 1 | 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|375259,%') AND (trim(`formofcase`) ISNOTNULLANDtrim(`formofcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`formofcase`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`formofcase`) ISNOTNULLANDtrim(`formofcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`formofcase`) ASC; |
| 11.43 ms (3.81%) | 1 | 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|375259,%') AND (trim(`bandfilter`) ISNOTNULLANDtrim(`bandfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bandfilter`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`bandfilter`) ISNOTNULLANDtrim(`bandfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bandfilter`) ASC; |
| 11.34 ms (3.78%) | 1 | 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|375259,%') AND (trim(`backcase`) ISNOTNULLANDtrim(`backcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`backcase`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`backcase`) ISNOTNULLANDtrim(`backcase`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`backcase`) ASC; |
| 11.30 ms (3.76%) | 1 | 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|375259,%') AND (trim(`glassfilter`) ISNOTNULLANDtrim(`glassfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`glassfilter`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`glassfilter`) ISNOTNULLANDtrim(`glassfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`glassfilter`) ASC; |
| 11.29 ms (3.76%) | 1 | 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|375259,%') AND (trim(`colorofdial`) ISNOTNULLANDtrim(`colorofdial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`colorofdial`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`colorofdial`) ISNOTNULLANDtrim(`colorofdial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`colorofdial`) ASC; |
| 11.23 ms (3.74%) | 1 | 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|375259,%') AND (trim(`waterresistance`) ISNOTNULLANDtrim(`waterresistance`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`waterresistance`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`waterresistance`) ISNOTNULLANDtrim(`waterresistance`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`waterresistance`) ASC; |
| 11.22 ms (3.74%) | 1 | 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|375259,%') AND (trim(`style`) ISNOTNULLANDtrim(`style`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`style`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`style`) ISNOTNULLANDtrim(`style`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`style`) ASC; |
| 11.21 ms (3.73%) | 1 | 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|375259,%') AND (trim(`buckle`) ISNOTNULLANDtrim(`buckle`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`buckle`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`buckle`) ISNOTNULLANDtrim(`buckle`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`buckle`) ASC; |
| 11.02 ms (3.67%) | 1 | 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|375259,%') AND (trim(`casefilter`) ISNOTNULLANDtrim(`casefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`casefilter`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`casefilter`) ISNOTNULLANDtrim(`casefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`casefilter`) ASC; |
| 10.95 ms (3.65%) | 1 | 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|375259,%') AND (trim(`movementtypefilter`) ISNOTNULLANDtrim(`movementtypefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`movementtypefilter`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`movementtypefilter`) ISNOTNULLANDtrim(`movementtypefilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`movementtypefilter`) ASC; |
| 10.88 ms (3.62%) | 1 | 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|375259,%') AND (trim(`availability`) ISNOTNULLANDtrim(`availability`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`availability`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`availability`) ISNOTNULLANDtrim(`availability`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`availability`) ASC; |
| 10.68 ms (3.56%) | 1 | 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|375259,%') AND (trim(`typeofwatch`) ISNOTNULLANDtrim(`typeofwatch`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`typeofwatch`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`typeofwatch`) ISNOTNULLANDtrim(`typeofwatch`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`typeofwatch`) ASC; |
| 10.08 ms (3.36%) | 1 | 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|375259,%') AND (trim(`dial`) ISNOTNULLANDtrim(`dial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`dial`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`dial`) ISNOTNULLANDtrim(`dial`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`dial`) ASC; |
| 9.91 ms (3.30%) | 1 | 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|375259,%') AND (trim(`crownandbutton`) ISNOTNULLANDtrim(`crownandbutton`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`crownandbutton`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`crownandbutton`) ISNOTNULLANDtrim(`crownandbutton`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`crownandbutton`) ASC; |
| 9.78 ms (3.26%) | 1 | 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|375259,%"
]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|375259,%') ANDobject_localized_cs_product_hu_HU.typeIN ('object','variant','folder')) ANDobject_localized_cs_product_hu_HU.published=1; |
| 9.63 ms (3.21%) | 1 | 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|375259,%') AND (trim(`diamondsfilter`) ISNOTNULLANDtrim(`diamondsfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`diamondsfilter`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`diamondsfilter`) ISNOTNULLANDtrim(`diamondsfilter`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`diamondsfilter`) ASC; |
| 9.59 ms (3.19%) | 1 | 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|375259,%')) AND (NULLIF(outlet,0) ISNOTNULL) ORDER BYwholesalePriceDESCLIMIT1 Parameters: [] 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|375259,%' ) ) 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|375259,%')) AND (NULLIF(outlet,0) ISNOTNULL) ORDER BYwholesalePriceDESCLIMIT1; |
| 9.12 ms (3.04%) | 1 | 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|375259,%') ORDER BYwholesalePriceDESCLIMIT1 Parameters: [] 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|375259,%' ) 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|375259,%') ORDER BYwholesalePriceDESCLIMIT1; |
| 8.96 ms (2.98%) | 1 | 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|375259,%') ORDER BYwholesalePriceASCLIMIT1 Parameters: [] 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|375259,%' ) 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|375259,%') ORDER BYwholesalePriceASCLIMIT1; |
| 8.87 ms (2.95%) | 1 | 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|375259,%') AND (object_localized_cs_product_hu_HU.collectionISNOTNULL)) Parameters: [] 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|375259,%' ) 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|375259,%') AND (object_localized_cs_product_hu_HU.collectionISNOTNULL)); |
| 8.42 ms (2.80%) | 1 | 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|375259,%') AND (trim(`bezel`) ISNOTNULLANDtrim(`bezel`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bezel`) ASC Parameters: [] 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|375259,%' ) 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|375259,%') AND (trim(`bezel`) ISNOTNULLANDtrim(`bezel`) !='') AND (object_localized_cs_product_hu_HU.published=1)) ORDER BYtrim(`bezel`) ASC; |
| 6.07 ms (2.02%) | 24 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1783621170 "system\x01tags\x01" "site\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','sitetags'); |
| 4.50 ms (1.50%) | 15 | SELECT*FROMobject_relations_cs_productWHEREsrc_id=? Parameters: [900279]SELECT*FROMobject_relations_cs_productWHEREsrc_id=? SELECT*FROMobject_relations_cs_productWHEREsrc_id=900279; |
| 3.58 ms (1.19%) | 7 | SELECT*FROMredirectsWHERE ( (source=?AND (`type`=?OR`type`=?)) OR (source=?AND`type`=?) OR (source=?AND`type`=?) ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC Parameters: [ "/e-boutique/seiko/presage-c375259" "path" "auto_create" "/e-boutique/seiko/presage-c375259" "path_query" "https://boutiqueapi.local.szerver.store/e-boutique/seiko/presage-c375259" "entire_uri" ] SELECT*FROMredirectsWHERE ( ( source=?AND ( `type`=?OR`type`=? ) ) OR ( source=?AND`type`=? ) OR ( source=?AND`type`=? ) ) ANDactive=1AND ( regexISNULLORregex=0 ) AND ( expiry>UNIX_TIMESTAMP() ORexpiryISNULL ) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC SELECT*FROMredirectsWHERE ( (source='/e-boutique/seiko/presage-c375259'AND (`type`='path'OR`type`='auto_create')) OR (source='/e-boutique/seiko/presage-c375259'AND`type`='path_query') OR (source='https://boutiqueapi.local.szerver.store/e-boutique/seiko/presage-c375259'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
| 3.08 ms (1.03%) | 1 | SELECTDISTINCTq.o_idFROMcoreshop_index_mysql_localized_collection_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND (q.`parentCategoryIds`LIKE'%375259%') ORDER BYq.`newsfromdate`desc,q.`name`desc,q.`creationDate`descLIMIT15 Parameters: [] SELECTDISTINCTq.o_idFROMcoreshop_index_mysql_localized_collection_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND ( q.`parentCategoryIds`LIKE'%375259%' ) ORDER BYq.`newsfromdate`desc,q.`name`desc,q.`creationDate`descLIMIT15 SELECTDISTINCTq.o_idFROMcoreshop_index_mysql_localized_collection_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND (q.`parentCategoryIds`LIKE'%375259%') ORDER BYq.`newsfromdate`desc,q.`name`desc,q.`creationDate`descLIMIT15; |
| 2.76 ms (0.92%) | 14 | SELECT*FROMassets_image_thumbnail_cacheWHEREcid=? Parameters: [16826]SELECT*FROMassets_image_thumbnail_cacheWHEREcid=? SELECT*FROMassets_image_thumbnail_cacheWHEREcid=16826; |
| 2.57 ms (0.86%) | 15 | SELECTcustomSettingsFROMassetsWHEREid=? Parameters: [15304]SELECTcustomSettingsFROMassetsWHEREid=? SELECTcustomSettingsFROMassetsWHEREid=15304; |
| 2.56 ms (0.85%) | 1 | SELECTcount(*) FROMcoreshop_index_mysql_localized_collection_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND (q.`parentCategoryIds`LIKE'%375259%') Parameters: [] SELECTcount(*) FROMcoreshop_index_mysql_localized_collection_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND ( q.`parentCategoryIds`LIKE'%375259%' ) SELECTcount(*) FROMcoreshop_index_mysql_localized_collection_hu_HUqINNER JOINobject_localized_cs_product_hu_HUobject_localized_cs_product_hu_HUONobject_localized_cs_product_hu_HU.id=q.o_idWHERE (q.`active`='1') AND (q.o_type!='variant') AND (q.`parentCategoryIds`LIKE'%375259%'); |
| 2.43 ms (0.81%) | 11 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1783621170 "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>1783621170THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags'); |
| 1.86 ms (0.62%) | 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=? 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; |
| 1.80 ms (0.60%) | 4 | 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; |
| 1.54 ms (0.51%) | 5 | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/e-boutique/seiko/" "presage-c375259" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/e-boutique/seiko/'AND`key`=BINARY'presage-c375259'; |
| 0.92 ms (0.31%) | 3 | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_order"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_order'; |
| 0.84 ms (0.28%) | 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=? 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; |
| 0.82 ms (0.27%) | 3 | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/e-boutique/seiko/presage-c375259"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/e-boutique/seiko/presage-c375259'; |
| 0.52 ms (0.17%) | 1 | 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; |
| 0.48 ms (0.16%) | 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 Parameters: [2]SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_conditionsONt0.id=coreshop_filter_condition_conditions.conditionIdWHEREcoreshop_filter_condition_conditions.filterId=?ORDER BYt0.sortASC SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_conditionsONt0.id=coreshop_filter_condition_conditions.conditionIdWHEREcoreshop_filter_condition_conditions.filterId=2ORDER BYt0.sortASC; |
| 0.47 ms (0.16%) | 1 | SELECT*FROMdocuments_editablesWHEREdocumentId=? Parameters: [76]SELECT*FROMdocuments_editablesWHEREdocumentId=? SELECT*FROMdocuments_editablesWHEREdocumentId=76; |
| 0.44 ms (0.15%) | 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=? 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; |
| 0.43 ms (0.14%) | 1 | SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=? Parameters: [375259]SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=? SELECT*FROMobject_relations_cs_categoryWHEREsrc_id=375259; |
| 0.43 ms (0.14%) | 1 | 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; |
| 0.38 ms (0.13%) | 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=? Parameters: [2]SELECTt0.classASclass_1,t0.nameASname_2,t0.workerASworker_3,t0.configurationASconfiguration_4,t0.indexLastVersionASindexLastVersion_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_indext0WHEREt0.id=? SELECTt0.classASclass_1,t0.nameASname_2,t0.workerASworker_3,t0.configurationASconfiguration_4,t0.indexLastVersionASindexLastVersion_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_indext0WHEREt0.id=2; |
| 0.38 ms (0.13%) | 1 | 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); |
| 0.34 ms (0.11%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1783621171 "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>1783621171THENitem_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'); |
| 0.34 ms (0.11%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1783621170 "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>1783621170THENitem_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'); |
| 0.33 ms (0.11%) | 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 Parameters: [2]SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_pre_conditionsONt0.id=coreshop_filter_condition_pre_conditions.conditionIdWHEREcoreshop_filter_condition_pre_conditions.filterId=?ORDER BYt0.sortASC SELECTt0.typeAStype_1,t0.labelASlabel_2,t0.quantityUnitASquantityUnit_3,t0.configurationASconfiguration_4,t0.sortASsort_5,t0.creationDateAScreationDate_6,t0.modificationDateASmodificationDate_7,t0.idASid_8FROMcoreshop_filter_conditiont0INNER JOINcoreshop_filter_condition_pre_conditionsONt0.id=coreshop_filter_condition_pre_conditions.conditionIdWHEREcoreshop_filter_condition_pre_conditions.filterId=2ORDER BYt0.sortASC; |
| 0.28 ms (0.09%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?) Parameters: [1783621171 "document_78\x01tags\x01" "asset_17203\x01tags\x01" "asset_17204\x01tags\x01" "asset_17205\x01tags\x01" "asset_17211\x01tags\x01" "asset_17216\x01tags\x01" "asset_17215\x01tags\x01" "asset_17214\x01tags\x01" "asset_17213\x01tags\x01" "asset_17212\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621171THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_78tags','asset_17203tags','asset_17204tags','asset_17205tags','asset_17211tags','asset_17216tags','asset_17215tags','asset_17214tags','asset_17213tags','asset_17212tags'); |
| 0.26 ms (0.09%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?) Parameters: [1783621171 "document_101\x01tags\x01" "asset_25124\x01tags\x01" "asset_25745\x01tags\x01" "asset_25123\x01tags\x01" "asset_25744\x01tags\x01" "asset_25122\x01tags\x01" "asset_25743\x01tags\x01" "asset_26588\x01tags\x01" "asset_26589\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783621171THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_101tags','asset_25124tags','asset_25745tags','asset_25123tags','asset_25744tags','asset_25122tags','asset_25743tags','asset_26588tags','asset_26589tags'); |
| 0.24 ms (0.08%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?) Parameters: [1783621171 "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>1783621171THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('website_configtags','systemtags','configtags','outputtags','asset_15304tags'); |
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.