Query Metrics
17Database Queries
17Different statements
10.20 msQuery time
0Invalid entities
177Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
| 2.59 ms (25.41%) | 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.32 ms (12.98%) | 1 | 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'; |
| 0.61 ms (5.99%) | 1 | 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: [ "/admin/notification/find-last-unread" "path" "auto_create" "/admin/notification/find-last-unread?_dc=1783532660653&lastUpdate=1783532630" "path_query" "https://boutique.local/admin/notification/find-last-unread?_dc=1783532660653&lastUpdate=1783532630" "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='/admin/notification/find-last-unread'AND (`type`='path'OR`type`='auto_create')) OR (source='/admin/notification/find-last-unread?_dc=1783532660653&lastUpdate=1783532630'AND`type`='path_query') OR (source='https://boutique.local/admin/notification/find-last-unread?_dc=1783532660653&lastUpdate=1783532630'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
| 0.53 ms (5.23%) | 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.53 ms (5.21%) | 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.52 ms (5.07%) | 1 | SELECTCOUNT(*) ASnumFROM`notifications`WHERErecipient=?AND`read`=0AND`isStudio`=0ANDcreationDate>=? Parameters: [2 "2026-07-08 17:43:50" ] SELECTCOUNT(*) ASnumFROM`notifications`WHERErecipient=?AND`read`=0AND`isStudio`=0ANDcreationDate>=? SELECTCOUNT(*) ASnumFROM`notifications`WHERErecipient=2AND`read`=0AND`isStudio`=0ANDcreationDate>='2026-07-08 17:43:50'; |
| 0.45 ms (4.42%) | 1 | SELECT*FROMusersWHERE`type`=?ANDid=? Parameters: [ "user" 2] SELECT*FROMusersWHERE`type`=?ANDid=? SELECT*FROMusersWHERE`type`='user'ANDid=2; |
| 0.45 ms (4.41%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1783532662 "system_route_redirect" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783532662THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_route_redirect'); |
| 0.43 ms (4.21%) | 1 | SELECT*FROMusers_workspaces_documentWHEREuserId=? Parameters: [2]SELECT*FROMusers_workspaces_documentWHEREuserId=? SELECT*FROMusers_workspaces_documentWHEREuserId=2; |
| 0.41 ms (4.01%) | 1 | SELECT*FROMusers_workspaces_assetWHEREuserId=? Parameters: [2]SELECT*FROMusers_workspaces_assetWHEREuserId=? SELECT*FROMusers_workspaces_assetWHEREuserId=2; |
| 0.41 ms (3.98%) | 1 | SELECT*FROMtmp_storeWHEREid=? Parameters: [
"maintenance_mode"
]SELECT*FROMtmp_storeWHEREid=? SELECT*FROMtmp_storeWHEREid='maintenance_mode'; |
| 0.39 ms (3.80%) | 1 | SELECTidFROM`notifications`WHERErecipient=?AND`read`=0AND`isStudio`=0ANDcreationDate>=?ORDER BY`creationDate`DESCLIMIT1 Parameters: [2 "2026-07-08 17:43:50" ] SELECTidFROM`notifications`WHERErecipient=?AND`read`=0AND`isStudio`=0ANDcreationDate>=?ORDER BY`creationDate`DESCLIMIT1 SELECTidFROM`notifications`WHERErecipient=2AND`read`=0AND`isStudio`=0ANDcreationDate>='2026-07-08 17:43:50'ORDER BY`creationDate`DESCLIMIT1; |
| 0.39 ms (3.78%) | 1 | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1783532662 "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>1783532662THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags'); |
| 0.39 ms (3.78%) | 1 | SELECT*FROMusers_workspaces_objectWHEREuserId=? Parameters: [2]SELECT*FROMusers_workspaces_objectWHEREuserId=? SELECT*FROMusers_workspaces_objectWHEREuserId=2; |
| 0.30 ms (2.99%) | 1 | SELECTCOUNT(*) ASnumFROM`notifications`WHERErecipient=?AND`read`=0AND`isStudio`=0 Parameters: [2]SELECTCOUNT(*) ASnumFROM`notifications`WHERErecipient=?AND`read`=0AND`isStudio`=0 SELECTCOUNT(*) ASnumFROM`notifications`WHERErecipient=2AND`read`=0AND`isStudio`=0; |
| 0.27 ms (2.67%) | 1 | "START TRANSACTION"Parameters: [] "START TRANSACTION""START TRANSACTION"; |
| 0.21 ms (2.07%) | 1 | "COMMIT"Parameters: [] "COMMIT""COMMIT"; |
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\Core\Model\Store | 1 |
| CoreShop\Component\Core\Model\Country | 1 |
| CoreShop\Component\Address\Model\Zone | 1 |
pimcore entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
pimcore entity manager
No loaded entities.