Query Metrics
40Database Queries
19Different statements
30.04 msQuery time
0Invalid entities
177Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.44 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1783767533 "site_domain_9867e6789b5051d02e962434c9a86b4a" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783767533THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('site_domain_9867e6789b5051d02e962434c9a86b4a'); |
| 2 | 0.39 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1783767533 "system\x01tags\x01" "site\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783767533THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','sitetags'); |
| 3 | 0.36 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.60 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: [ "/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/8l35.8d39856d.jpg" "path" "auto_create" "/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/8l35.8d39856d.jpg" "path_query" "https://www.sitebuild-local.szerver.online/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/8l35.8d39856d.jpg" "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='/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/8l35.8d39856d.jpg'AND (`type`='path'OR`type`='auto_create')) OR (source='/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/8l35.8d39856d.jpg'AND`type`='path_query') OR (source='https://www.sitebuild-local.szerver.online/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/8l35.8d39856d.jpg'AND`type`='entire_uri') ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC; |
| 5 | 0.28 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1783767533 "system_route_redirect" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783767533THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('system_route_redirect'); |
| 6 | 0.31 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?) Parameters: [1783767533 "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>1783767533THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('systemtags','redirecttags','routetags'); |
| 7 | 0.31 ms | SELECT*FROMtmp_storeWHEREid=? Parameters: [
"maintenance_mode"
]SELECT*FROMtmp_storeWHEREid=? SELECT*FROMtmp_storeWHEREid='maintenance_mode'; |
| 8 | 0.34 ms | SELECT*FROMsettings_storeWHEREid=?ANDscope=? Parameters: [ "reports" "pimcore" ] SELECT*FROMsettings_storeWHEREid=?ANDscope=? SELECT*FROMsettings_storeWHEREid='reports'ANDscope='pimcore'; |
| 9 | 0.45 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/" "8l35.8d39856d.jpg" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/'AND`key`=BINARY'8l35.8d39856d.jpg'; |
| 10 | 0.25 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/8l35.8d39856d.jpg"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent/8l35.8d39856d.jpg'; |
| 11 | 0.29 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/News/Hirek/KSK 2023-08-08/16634/" "image-thumb__16634__seiko_NewsImageContent" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/News/Hirek/KSK 2023-08-08/16634/'AND`key`=BINARY'image-thumb__16634__seiko_NewsImageContent'; |
| 12 | 0.27 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/News/Hirek/KSK 2023-08-08/16634/image-thumb__16634__seiko_NewsImageContent'; |
| 13 | 0.32 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/News/Hirek/KSK 2023-08-08/" "16634" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/News/Hirek/KSK 2023-08-08/'AND`key`=BINARY'16634'; |
| 14 | 0.32 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/News/Hirek/KSK 2023-08-08/16634"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/News/Hirek/KSK 2023-08-08/16634'; |
| 15 | 0.36 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/News/Hirek/" "KSK 2023-08-08" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/News/Hirek/'AND`key`=BINARY'KSK 2023-08-08'; |
| 16 | 0.32 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/News/Hirek/KSK 2023-08-08"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/News/Hirek/KSK 2023-08-08'; |
| 17 | 0.36 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/News/" "Hirek" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/News/'AND`key`=BINARY'Hirek'; |
| 18 | 0.22 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/News/Hirek"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/News/Hirek'; |
| 19 | 0.31 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [ "/" "News" ] SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY'News'; |
| 20 | 0.26 ms | SELECTidFROMdocuments_pageWHEREprettyUrl=? Parameters: [
"/News"
]SELECTidFROMdocuments_pageWHEREprettyUrl=? SELECTidFROMdocuments_pageWHEREprettyUrl='/News'; |
| 21 | 0.37 ms | SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? Parameters: [
"/"
""
]SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY? SELECTidFROMdocumentsWHERE`path`=BINARY'/'AND`key`=BINARY''; |
| 22 | 0.30 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1783767533 "document_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783767533THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_1'); |
| 23 | 0.45 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [1783767533 "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>1783767533THENitem_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'); |
| 24 | 0.33 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1783767533 "document_properties_1" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783767533THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_properties_1'); |
| 25 | 0.35 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?) Parameters: [1783767533 "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>1783767533THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('document_propertiestags','document_1tags'); |
| 26 | 0.50 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'; |
| 27 | 0.56 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); |
| 28 | 0.42 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_order"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_order'; |
| 29 | 0.46 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1783767533 "asset_16634" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783767533THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_16634'); |
| 30 | 0.33 ms | SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) Parameters: [1783767533 "asset_16634\x01tags\x01" ] SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?) SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>1783767533THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN ('asset_16634tags'); |
| 31 | 0.29 ms | SELECTcustomSettingsFROMassetsWHEREid=? Parameters: [16634]SELECTcustomSettingsFROMassetsWHEREid=? SELECTcustomSettingsFROMassetsWHEREid=16634; |
| 32 | 7.71 ms | INSERTINTOlock_keys (key_id,key_token,key_expiration) VALUES (?,?,UNIX_TIMESTAMP(NOW(6)) +300) Parameters: [ "a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239" "fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg=" ] INSERTINTOlock_keys ( key_id,key_token,key_expiration ) VALUES ( ?,?,UNIX_TIMESTAMP( NOW(6) ) +300 ) INSERTINTOlock_keys (key_id,key_token,key_expiration) VALUES ('a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239','fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg=',UNIX_TIMESTAMP(NOW(6)) +300); |
| 33 | 0.46 ms | UPDATElock_keysSETkey_expiration=UNIX_TIMESTAMP(NOW(6)) +?,key_token=?WHEREkey_id=?AND (key_token=?ORkey_expiration<=UNIX_TIMESTAMP(NOW(6))) Parameters: [300.0 "fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg=" "a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239" "fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg=" ] UPDATElock_keysSETkey_expiration=UNIX_TIMESTAMP( NOW(6) ) +?,key_token=?WHEREkey_id=?AND ( key_token=?ORkey_expiration<=UNIX_TIMESTAMP( NOW(6) ) ) UPDATElock_keysSETkey_expiration=UNIX_TIMESTAMP(NOW(6)) +300,key_token='fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg='WHEREkey_id='a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239'AND (key_token='fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg='ORkey_expiration<=UNIX_TIMESTAMP(NOW(6))); |
| 34 | 0.30 ms | SELECT1FROMlock_keysWHEREkey_id=?ANDkey_token=?ANDkey_expiration>UNIX_TIMESTAMP(NOW(6)) Parameters: [ "a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239" "fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg=" ] SELECT1FROMlock_keysWHEREkey_id=?ANDkey_token=?ANDkey_expiration>UNIX_TIMESTAMP( NOW(6) ) SELECT1FROMlock_keysWHEREkey_id='a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239'ANDkey_token='fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg='ANDkey_expiration>UNIX_TIMESTAMP(NOW(6)); |
| 35 | 0.39 ms | SELECT1FROMlock_keysWHEREkey_id=?ANDkey_token=?ANDkey_expiration>UNIX_TIMESTAMP(NOW(6)) Parameters: [ "a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239" "fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg=" ] SELECT1FROMlock_keysWHEREkey_id=?ANDkey_token=?ANDkey_expiration>UNIX_TIMESTAMP( NOW(6) ) SELECT1FROMlock_keysWHEREkey_id='a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239'ANDkey_token='fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg='ANDkey_expiration>UNIX_TIMESTAMP(NOW(6)); |
| 36 | 6.64 ms | DELETE FROMlock_keysWHEREkey_id=?ANDkey_token=? Parameters: [ "a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239" "fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg=" ] DELETE FROMlock_keysWHEREkey_id=?ANDkey_token=? DELETE FROMlock_keysWHEREkey_id='a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239'ANDkey_token='fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg='; |
| 37 | 0.33 ms | SELECT1FROMlock_keysWHEREkey_id=?ANDkey_token=?ANDkey_expiration>UNIX_TIMESTAMP(NOW(6)) Parameters: [ "a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239" "fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg=" ] SELECT1FROMlock_keysWHEREkey_id=?ANDkey_token=?ANDkey_expiration>UNIX_TIMESTAMP( NOW(6) ) SELECT1FROMlock_keysWHEREkey_id='a60d4e36e15c1d37a32d1684b871a94accdad537e754649e0b7e0e1816b27239'ANDkey_token='fS6ELFbVej4xPiPuqWLnj9TnX5J1F4a6V9nFd9MP/Wg='ANDkey_expiration>UNIX_TIMESTAMP(NOW(6)); |
| 38 | 0.32 ms | SELECT*FROMassets_image_thumbnail_cacheWHEREcid=? Parameters: [16634]SELECT*FROMassets_image_thumbnail_cacheWHEREcid=? SELECT*FROMassets_image_thumbnail_cacheWHEREcid=16634; |
| 39 | 2.36 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; |
| 40 | 0.40 ms | SELECTnameFROMclassesWHEREid=? Parameters: [
"cs_wishlist"
]SELECTnameFROMclassesWHEREid=? SELECTnameFROMclassesWHEREid='cs_wishlist'; |
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.