Query Metrics

128Database Queries
39Different statements
23.19 msQuery time
0Invalid entities
177Managed entities

Queries

Group similar statements

#▲TimeInfo
1 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826570
  "site_domain_11c5d8b0b5631c7a2566bb0d34acd7d3"
]
2 0.22 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794826570
  "system\x01tags\x01"
  "site\x01tags\x01"
]
3 0.19 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.35 ms
SELECT*FROMredirectsWHERE
            (
                (source=?AND (`type`=?OR`type`=?)) OR
                (source=?AND`type`=?) OR
                (source=?AND`type`=?)
            ) ANDactive=1AND (regexISNULLORregex=0) AND (expiry>UNIX_TIMESTAMP() ORexpiryISNULL) ANDsourceSiteISNULLANDpriority=99ORDER BY`priority`DESC
Parameters:
[
  "/aktualitasok/hirek-c375317"
  "path"
  "auto_create"
  "/aktualitasok/hirek-c375317?page=5"
  "path_query"
  "https://boutiqueapi.local.szerver.store/aktualitasok/hirek-c375317?page=5"
  "entire_uri"
]
5 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826570
  "system_route_redirect"
]
6 0.22 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1794826570
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
7 0.19 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "maintenance_mode"
]
8 0.17 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "reports"
  "pimcore"
]
9 0.22 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/aktualitasok/"
  "hirek-c375317"
]
10 0.16 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/aktualitasok/hirek-c375317"
]
11 0.16 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/"
  "aktualitasok"
]
12 0.11 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826570
  "document_12"
]
13 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826570
  "document_12\x01tags\x01"
]
14 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826570
  "document_properties_12"
]
15 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794826570
  "document_properties\x01tags\x01"
  "document_12\x01tags\x01"
]
16 0.27 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]
17 0.30 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]
18 0.22 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_order"
]
19 0.13 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "sites_path_mapping"
]
20 0.13 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794826571
  "system\x01tags\x01"
  "resource\x01tags\x01"
]
21 0.13 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_375317"
]
22 0.17 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794826571
  "object_375317\x01tags\x01"
  "class_4\x01tags\x01"
]
23 0.10 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "4"
]
24 0.10 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "3"
]
25 0.12 ms
SELECT*FROMtranslations_messagesLIMIT1;
Parameters:
[]
26 0.11 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "translation_data_6431352cea3285deadebc5c2a566a87b"
]
27 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1794826571
  "translator\x01tags\x01"
  "translator_website\x01tags\x01"
  "translate\x01tags\x01"
]
28 0.97 ms
SELECTobject_3.idasid,object_3.typeas`type`FROMobject_3WHERE (hiddenFromListISNOTTRUEAND (`category__id`=?AND`category__type`=?)  ANDobject_3.typeIN ('object','variant','folder')) ANDobject_3.published=1ORDER BY`highlighted`DESC,`date`DESCLIMIT15OFFSET60
Parameters:
[375317
  "object"
]
29 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_706090"
]
30 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?)
Parameters:
[1794826571
  "object_706090\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_25966\x01tags\x01"
  "asset_25959\x01tags\x01"
]
31 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_705243"
]
32 0.22 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_705243\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_25906\x01tags\x01"
  "asset_25907\x01tags\x01"
  "asset_25899\x01tags\x01"
  "asset_25902\x01tags\x01"
  "asset_25900\x01tags\x01"
  "asset_25905\x01tags\x01"
  "asset_25903\x01tags\x01"
  "asset_25904\x01tags\x01"
  "asset_25908\x01tags\x01"
]
33 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_702628"
]
34 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_702628\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_25803\x01tags\x01"
  "asset_25804\x01tags\x01"
  "asset_25791\x01tags\x01"
  "asset_25793\x01tags\x01"
  "asset_25794\x01tags\x01"
  "asset_25801\x01tags\x01"
  "asset_25800\x01tags\x01"
  "asset_25795\x01tags\x01"
  "asset_25798\x01tags\x01"
  "asset_25799\x01tags\x01"
  "asset_25796\x01tags\x01"
  "asset_25797\x01tags\x01"
  "asset_25802\x01tags\x01"
]
35 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_694862"
]
36 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_694862\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_25361\x01tags\x01"
  "asset_25374\x01tags\x01"
  "asset_25362\x01tags\x01"
  "asset_25363\x01tags\x01"
  "asset_25360\x01tags\x01"
  "asset_25364\x01tags\x01"
  "asset_25368\x01tags\x01"
  "asset_25372\x01tags\x01"
  "asset_25366\x01tags\x01"
  "asset_25369\x01tags\x01"
  "asset_25373\x01tags\x01"
  "asset_25371\x01tags\x01"
  "asset_25359\x01tags\x01"
  "asset_25367\x01tags\x01"
  "asset_25370\x01tags\x01"
]
37 0.14 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_685892"
]
38 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_685892\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_24951\x01tags\x01"
  "asset_24953\x01tags\x01"
  "asset_24952\x01tags\x01"
  "asset_24946\x01tags\x01"
  "asset_24949\x01tags\x01"
  "asset_24948\x01tags\x01"
  "asset_24950\x01tags\x01"
  "asset_24945\x01tags\x01"
  "asset_24954\x01tags\x01"
  "asset_24957\x01tags\x01"
  "asset_24947\x01tags\x01"
]
39 0.13 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_672089"
]
40 0.72 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_672089\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_24329\x01tags\x01"
  "asset_24330\x01tags\x01"
  "asset_24331\x01tags\x01"
  "asset_24337\x01tags\x01"
  "asset_24341\x01tags\x01"
  "asset_24336\x01tags\x01"
  "asset_24332\x01tags\x01"
  "asset_24333\x01tags\x01"
  "asset_24339\x01tags\x01"
  "asset_24338\x01tags\x01"
  "asset_24335\x01tags\x01"
  "asset_24340\x01tags\x01"
]
41 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_669607"
]
42 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_669607\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_24230\x01tags\x01"
  "asset_24232\x01tags\x01"
  "asset_24234\x01tags\x01"
  "asset_24237\x01tags\x01"
  "asset_24231\x01tags\x01"
  "asset_24235\x01tags\x01"
  "asset_24233\x01tags\x01"
  "asset_24241\x01tags\x01"
  "asset_24228\x01tags\x01"
  "asset_24240\x01tags\x01"
  "asset_24229\x01tags\x01"
  "asset_24252\x01tags\x01"
  "asset_24243\x01tags\x01"
  "asset_24238\x01tags\x01"
  "asset_24236\x01tags\x01"
  "asset_24242\x01tags\x01"
]
43 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_668363"
]
44 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_668363\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_24019\x01tags\x01"
  "asset_24022\x01tags\x01"
  "asset_24021\x01tags\x01"
  "asset_24026\x01tags\x01"
  "asset_24023\x01tags\x01"
  "asset_24142\x01tags\x01"
  "asset_24020\x01tags\x01"
  "asset_24024\x01tags\x01"
  "asset_24143\x01tags\x01"
  "asset_24144\x01tags\x01"
]
45 0.13 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_661807"
]
46 0.13 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?)
Parameters:
[1794826571
  "object_661807\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_23874\x01tags\x01"
  "asset_23867\x01tags\x01"
  "asset_23869\x01tags\x01"
  "asset_23868\x01tags\x01"
]
47 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_658874"
]
48 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_658874\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_23790\x01tags\x01"
  "asset_23792\x01tags\x01"
  "asset_23779\x01tags\x01"
  "asset_23786\x01tags\x01"
  "asset_23782\x01tags\x01"
  "asset_23778\x01tags\x01"
  "asset_23780\x01tags\x01"
  "asset_23787\x01tags\x01"
  "asset_23793\x01tags\x01"
  "asset_23784\x01tags\x01"
  "asset_23789\x01tags\x01"
  "asset_23781\x01tags\x01"
  "asset_23777\x01tags\x01"
  "asset_23776\x01tags\x01"
  "asset_23794\x01tags\x01"
  "asset_23785\x01tags\x01"
  "asset_23791\x01tags\x01"
  "asset_23783\x01tags\x01"
]
49 0.11 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_657498"
]
50 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_657498\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_23720\x01tags\x01"
  "asset_23722\x01tags\x01"
  "asset_23714\x01tags\x01"
  "asset_23718\x01tags\x01"
  "asset_23724\x01tags\x01"
  "asset_23716\x01tags\x01"
  "asset_23725\x01tags\x01"
  "asset_23715\x01tags\x01"
  "asset_23717\x01tags\x01"
  "asset_23719\x01tags\x01"
  "asset_23721\x01tags\x01"
  "asset_23723\x01tags\x01"
]
51 0.09 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_652974"
]
52 0.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00object_652974"
]
53 0.11 ms
SELECT`type`,`className`,`classId`FROMobjectsWHERE`id`=?
Parameters:
[652974]
54 0.15 ms
SELECTobjects.*,tree_locks.lockedaslockedFROMobjectsLEFT JOINtree_locksONobjects.id=tree_locks.idANDtree_locks.type='object'WHEREobjects.id=?
Parameters:
[652974]
55 0.11 ms
SELECT*FROMobject_store_3WHEREoo_id=?FORUPDATE
Parameters:
[652974]
56 0.11 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23551"
]
57 0.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23551"
]
58 0.12 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23551]
59 0.10 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23552"
]
60 0.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23552"
]
61 0.11 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23552]
62 0.10 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23552]
63 0.19 ms
SELECT*FROMobject_collection_NewsTextContent_3WHEREid=?ANDfieldname=?ORDER BY`index`ASC
Parameters:
[652974
  "content"
]
64 0.17 ms
SELECT*FROMobject_collection_NewsImageContent_3WHEREid=?ANDfieldname=?ORDER BY`index`ASC
Parameters:
[652974
  "content"
]
65 0.11 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23544"
]
66 0.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23544"
]
67 0.12 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23544]
68 0.11 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23544]
69 0.09 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23546"
]
70 0.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23546"
]
71 0.10 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23546]
72 0.10 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23546]
73 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23545"
]
74 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23545"
]
75 0.13 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23545]
76 0.15 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23545]
77 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23553"
]
78 0.16 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23553"
]
79 0.16 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23553]
80 0.16 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23553]
81 0.11 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23550"
]
82 0.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23550"
]
83 0.10 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23550]
84 0.10 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23550]
85 0.09 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23554"
]
86 0.07 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23554"
]
87 0.10 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23554]
88 0.10 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23554]
89 0.09 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23547"
]
90 0.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23547"
]
91 0.10 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23547]
92 0.10 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23547]
93 0.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23548"
]
94 0.07 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23548"
]
95 0.11 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23548]
96 0.21 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23548]
97 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23549"
]
98 0.10 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23549"
]
99 0.13 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23549]
100 0.12 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23549]
101 0.10 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "asset_23579"
]
102 0.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "\x00tags\x00asset_23579"
]
103 0.11 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23579]
104 0.11 ms
SELECTassets.*,tree_locks.lockedFROMassetsLEFT JOINtree_locksONassets.id=tree_locks.idANDtree_locks.type='asset'WHEREassets.id=?
Parameters:
[23579]
105 0.15 ms
SELECT*FROMobject_collection_NewsElementorContent_3WHEREid=?ANDfieldname=?ORDER BY`index`ASC
Parameters:
[652974
  "content"
]
106 0.12 ms
SELECT*FROMobject_collection_NewsEmbedContent_3WHEREid=?ANDfieldname=?ORDER BY`index`ASC
Parameters:
[652974
  "content"
]
107 0.13 ms
SELECT*FROMobject_collection_NewsGalleryContent_3WHEREid=?ANDfieldname=?ORDER BY`index`ASC
Parameters:
[652974
  "content"
]
108 0.12 ms
SELECT*FROMobject_relations_3WHEREsrc_id=?
Parameters:
[652974]
109 0.14 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_650370"
]
110 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_650370\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_23402\x01tags\x01"
  "asset_23404\x01tags\x01"
  "asset_23403\x01tags\x01"
  "asset_23405\x01tags\x01"
  "asset_23389\x01tags\x01"
  "asset_23393\x01tags\x01"
  "asset_23401\x01tags\x01"
  "asset_23410\x01tags\x01"
  "asset_23390\x01tags\x01"
  "asset_23411\x01tags\x01"
  "asset_23400\x01tags\x01"
  "asset_23412\x01tags\x01"
  "asset_23395\x01tags\x01"
  "asset_23408\x01tags\x01"
  "asset_23399\x01tags\x01"
  "asset_23406\x01tags\x01"
  "asset_23398\x01tags\x01"
  "asset_23388\x01tags\x01"
  "asset_23392\x01tags\x01"
  "asset_23397\x01tags\x01"
  "asset_23409\x01tags\x01"
  "asset_23394\x01tags\x01"
  "asset_23396\x01tags\x01"
]
111 0.14 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_645631"
]
112 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_645631\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_23061\x01tags\x01"
  "asset_23064\x01tags\x01"
  "asset_23063\x01tags\x01"
  "asset_23067\x01tags\x01"
  "asset_23065\x01tags\x01"
  "asset_23066\x01tags\x01"
  "asset_23083\x01tags\x01"
  "asset_23060\x01tags\x01"
  "asset_23059\x01tags\x01"
  "asset_23062\x01tags\x01"
  "asset_23068\x01tags\x01"
  "asset_23070\x01tags\x01"
  "asset_23072\x01tags\x01"
  "asset_23069\x01tags\x01"
  "asset_23071\x01tags\x01"
  "asset_23073\x01tags\x01"
  "asset_23074\x01tags\x01"
]
113 0.13 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "object_647967"
]
114 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1794826571
  "object_647967\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_23293\x01tags\x01"
  "asset_23295\x01tags\x01"
  "asset_23294\x01tags\x01"
  "asset_23291\x01tags\x01"
  "asset_23288\x01tags\x01"
  "asset_23296\x01tags\x01"
  "asset_23287\x01tags\x01"
  "asset_23292\x01tags\x01"
  "asset_23289\x01tags\x01"
  "asset_23290\x01tags\x01"
]
115 1.52 ms
SELECTCOUNT(*) FROMobject_3WHERE (hiddenFromListISNOTTRUEAND (`category__id`=?AND`category__type`=?)  ANDobject_3.typeIN ('object','variant','folder')) ANDobject_3.published=1
Parameters:
[375317
  "object"
]
116 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "website_config"
]
117 0.20 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"
]
118 0.14 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[15304]
119 0.17 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/shared/"
  "header"
]
120 0.13 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "document_76"
]
121 0.20 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"
]
122 0.12 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1794826571
  "document_properties_76"
]
123 0.13 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1794826571
  "document_properties\x01tags\x01"
  "document_76\x01tags\x01"
]
124 0.14 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
125 0.30 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&_controller=App%5CController%5CFrontend%5CDefaultController"
  "path_query"
  "https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController"
  "entire_uri"
]
126 0.16 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
127 0.32 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&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction"
  "path_query"
  "https://boutiqueapi.local.szerver.store/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction"
  "entire_uri"
]
128 1.67 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]

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