Query Metrics

302Database Queries
24Different statements
72.58 msQuery time
0Invalid entities
178Managed entities

Queries

Group similar statements

#TimeInfo
1 1.08 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "site_domain_a873c5c6d1bc2e8053f0fafddd85b206"
]
2 0.34 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519370
  "system\x01tags\x01"
  "site\x01tags\x01"
]
3 0.31 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.49 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/izmosabbak-lettek-a-5sports-katonai-seiko-boutique-tv-s06e45"
  "path"
  "auto_create"
  "/aktualitasok/hirek/izmosabbak-lettek-a-5sports-katonai-seiko-boutique-tv-s06e45"
  "path_query"
  "https://www.boutique.local.szerver.store/aktualitasok/hirek/izmosabbak-lettek-a-5sports-katonai-seiko-boutique-tv-s06e45"
  "entire_uri"
]
5 0.29 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "system_route_redirect"
]
6 0.33 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783519370
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
7 0.39 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "maintenance_mode"
]
8 0.28 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "reports"
  "pimcore"
]
9 0.36 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/aktualitasok/hirek/"
  "izmosabbak-lettek-a-5sports-katonai-seiko-boutique-tv-s06e45"
]
10 0.28 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/aktualitasok/hirek/izmosabbak-lettek-a-5sports-katonai-seiko-boutique-tv-s06e45"
]
11 0.26 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/aktualitasok/"
  "hirek"
]
12 0.27 ms
SELECTidFROMdocuments_pageWHEREprettyUrl=?
Parameters:
[
  "/aktualitasok/hirek"
]
13 0.30 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/"
  "aktualitasok"
]
14 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_12"
]
15 0.29 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_12\x01tags\x01"
]
16 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_properties_12"
]
17 0.23 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519370
  "document_properties\x01tags\x01"
  "document_12\x01tags\x01"
]
18 0.44 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]
19 0.41 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]
20 0.30 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "cs_order"
]
21 0.40 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "sites_path_mapping"
]
22 0.28 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519370
  "system\x01tags\x01"
  "resource\x01tags\x01"
]
23 0.37 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "3"
]
24 0.60 ms
SELECTobject_3.idasid,object_3.typeas`type`FROMobject_3WHERE`slug`='izmosabbak-lettek-a-5sports-katonai-seiko-boutique-tv-s06e45'ANDobject_3.typeIN ('variant','object') LIMIT1
Parameters:
[]
25 0.32 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "object_920414"
]
26 0.29 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?)
Parameters:
[1783519370
  "object_920414\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_35052\x01tags\x01"
  "asset_35061\x01tags\x01"
]
27 0.19 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[35061]
28 0.26 ms
SELECT*FROMobject_relations_3WHEREsrc_id=?
Parameters:
[920414]
29 0.23 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "object_375317"
]
30 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519370
  "object_375317\x01tags\x01"
  "class_4\x01tags\x01"
]
31 0.19 ms
SELECTnameFROMclassesWHEREid=?
Parameters:
[
  "4"
]
32 0.45 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "website_config"
]
33 0.34 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?)
Parameters:
[1783519370
  "website_config\x01tags\x01"
  "system\x01tags\x01"
  "config\x01tags\x01"
  "output\x01tags\x01"
  "asset_15304\x01tags\x01"
]
34 0.33 ms
SELECTidFROMdocumentsWHERE`path`=BINARY?AND`key`=BINARY?
Parameters:
[
  "/shared/"
  "header"
]
35 0.29 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_76"
]
36 0.37 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[1783519370
  "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"
]
37 0.27 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_properties_76"
]
38 0.27 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519370
  "document_properties\x01tags\x01"
  "document_76\x01tags\x01"
]
39 0.29 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
40 0.50 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://www.boutique.local.szerver.store/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController"
  "entire_uri"
]
41 0.33 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
42 0.51 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://www.boutique.local.szerver.store/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction"
  "entire_uri"
]
43 1.42 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]
44 0.36 ms
SELECTt0.nameASname_1,t0.creationDateAScreationDate_2,t0.modificationDateASmodificationDate_3,t0.idASid_4,t0.localeASlocale_5,t0.translatable_idAStranslatable_id_6FROMcoreshop_country_translationt0WHEREt0.translatable_id=?ANDt0.locale=?LIMIT1
Parameters:
[11
  "hu_HU"
]
45 0.38 ms
SELECTt0.nameASname_1,t0.templateAStemplate_2,t0.isDefaultASisDefault_3,t0.siteIdASsiteId_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.useGrossPriceASuseGrossPrice_8,t0.currencyIdAScurrencyId_9,t0.baseCountryIdASbaseCountryId_10,t11.isoCodeASisoCode_12,t11.activeASactive_13,t11.addressFormatASaddressFormat_14,t11.salutationsASsalutations_15,t11.creationDateAScreationDate_16,t11.modificationDateASmodificationDate_17,t11.idASid_18,t11.zoneIdASzoneId_19,t11.currencyIdAScurrencyId_20FROMcoreshop_storet0LEFT JOINcoreshop_countryt11ONt0.baseCountryId=t11.id
Parameters:
[]
46 0.31 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
47 0.52 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=CoreShop%5CBundle%5CFrontendBundle%5CController%5CCartController%3A%3AwidgetAction"
  "path_query"
  "https://www.boutique.local.szerver.store/_fragment?_path=_format=html&_locale=hu&_controller=CoreShop%5CBundle%5CFrontendBundle%5CController%5CCartController%3A%3AwidgetAction"
  "entire_uri"
]
48 0.39 ms
SELECTt0.nameASname_1,t0.templateAStemplate_2,t0.isDefaultASisDefault_3,t0.siteIdASsiteId_4,t0.creationDateAScreationDate_5,t0.modificationDateASmodificationDate_6,t0.idASid_7,t0.useGrossPriceASuseGrossPrice_8,t0.currencyIdAScurrencyId_9,t0.baseCountryIdASbaseCountryId_10,t11.isoCodeASisoCode_12,t11.activeASactive_13,t11.addressFormatASaddressFormat_14,t11.salutationsASsalutations_15,t11.creationDateAScreationDate_16,t11.modificationDateASmodificationDate_17,t11.idASid_18,t11.zoneIdASzoneId_19,t11.currencyIdAScurrencyId_20FROMcoreshop_storet0LEFT JOINcoreshop_countryt11ONt0.baseCountryId=t11.id
Parameters:
[]
49 0.50 ms
SELECT*FROMdocuments_editablesWHEREdocumentId=?
Parameters:
[76]
50 0.38 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_78"
]
51 0.39 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?,?)
Parameters:
[1783519370
  "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"
]
52 0.30 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_101"
]
53 0.38 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?,?,?,?,?,?,?)
Parameters:
[1783519370
  "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"
]
54 0.30 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_73"
]
55 0.28 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_73\x01tags\x01"
]
56 0.29 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_13"
]
57 0.28 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_13\x01tags\x01"
]
58 0.29 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_71"
]
59 0.26 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519370
  "document_71\x01tags\x01"
  "asset_15304\x01tags\x01"
]
60 0.29 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16826"
]
61 0.41 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[16826]
62 0.47 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[16826]
63 0.29 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
64 0.28 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16826__03cafa36e3553884f8ef4ec0e70d696d"
]
65 0.25 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
66 0.27 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16826__78e8aee544dd567f1a2603afd718c09c"
]
67 0.26 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
68 0.27 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16826__03cafa36e3553884f8ef4ec0e70d696d"
]
69 0.28 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
70 0.29 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16826__03cafa36e3553884f8ef4ec0e70d696d"
]
71 0.24 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
72 0.24 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16826__03cafa36e3553884f8ef4ec0e70d696d"
]
73 0.27 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
74 0.25 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16826__78e8aee544dd567f1a2603afd718c09c"
]
75 0.28 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20648"
]
76 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20648\x01tags\x01"
]
77 0.26 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[20648]
78 0.32 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[20648]
79 0.26 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
80 0.23 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20648__543dd99950e499610e501a0674f6eb0a"
]
81 0.27 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
82 0.24 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20648__093d1e39c33b7112823ad3b0b604263c"
]
83 0.21 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
84 0.23 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20648__543dd99950e499610e501a0674f6eb0a"
]
85 0.17 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
86 0.24 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20648__543dd99950e499610e501a0674f6eb0a"
]
87 0.23 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
88 0.21 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20648__543dd99950e499610e501a0674f6eb0a"
]
89 0.21 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
90 0.20 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20648__093d1e39c33b7112823ad3b0b604263c"
]
91 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_91"
]
92 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519370
  "document_91\x01tags\x01"
  "asset_9832\x01tags\x01"
]
93 0.23 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20603"
]
94 0.21 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20603\x01tags\x01"
]
95 0.17 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[20603]
96 0.21 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[20603]
97 0.16 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
98 0.15 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20603__6a259a339331e95d0a483bb1b31a9e37"
]
99 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
100 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20603__1c8d179a0023f793c7b8c6583c43aa27"
]
101 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
102 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20603__6a259a339331e95d0a483bb1b31a9e37"
]
103 0.14 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
104 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20603__6a259a339331e95d0a483bb1b31a9e37"
]
105 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
106 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20603__6a259a339331e95d0a483bb1b31a9e37"
]
107 0.14 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
108 0.13 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20603__1c8d179a0023f793c7b8c6583c43aa27"
]
109 0.17 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_92"
]
110 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783519370
  "document_92\x01tags\x01"
  "asset_15672\x01tags\x01"
  "asset_10633\x01tags\x01"
]
111 0.17 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20600"
]
112 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20600\x01tags\x01"
]
113 0.16 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[20600]
114 0.19 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[20600]
115 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
116 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20600__e29295e2601ed64e6900b8d9dd31cde0"
]
117 0.14 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
118 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20600__6588a3cdfd60240d17bff8f96a124abe"
]
119 0.16 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
120 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20600__e29295e2601ed64e6900b8d9dd31cde0"
]
121 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
122 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20600__e29295e2601ed64e6900b8d9dd31cde0"
]
123 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
124 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20600__e29295e2601ed64e6900b8d9dd31cde0"
]
125 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
126 0.23 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20600__6588a3cdfd60240d17bff8f96a124abe"
]
127 0.27 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_90"
]
128 0.28 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519370
  "document_90\x01tags\x01"
  "asset_10656\x01tags\x01"
]
129 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20602"
]
130 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20602\x01tags\x01"
]
131 0.24 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[20602]
132 0.28 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[20602]
133 0.24 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
134 0.44 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20602__93fd910699866ef8980855bd2a546189"
]
135 0.23 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
136 0.26 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20602__17d7d94bdd2961110a471866eac24360"
]
137 0.23 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
138 0.25 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20602__93fd910699866ef8980855bd2a546189"
]
139 0.22 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
140 0.21 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20602__93fd910699866ef8980855bd2a546189"
]
141 0.22 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
142 0.22 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20602__93fd910699866ef8980855bd2a546189"
]
143 0.26 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
144 0.29 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20602__17d7d94bdd2961110a471866eac24360"
]
145 0.38 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_93"
]
146 0.32 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?)
Parameters:
[1783519370
  "document_93\x01tags\x01"
  "asset_9855\x01tags\x01"
]
147 0.29 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20601"
]
148 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20601\x01tags\x01"
]
149 0.23 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[20601]
150 0.27 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[20601]
151 0.26 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
152 0.27 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20601__f07fa9d4a62f6f594f6f1567775e8f20"
]
153 0.28 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
154 0.26 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20601__a71dc7931c7470757bd1149125486b06"
]
155 0.27 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
156 0.27 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20601__f07fa9d4a62f6f594f6f1567775e8f20"
]
157 0.23 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
158 0.23 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20601__f07fa9d4a62f6f594f6f1567775e8f20"
]
159 0.23 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
160 0.26 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20601__f07fa9d4a62f6f594f6f1567775e8f20"
]
161 0.27 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
162 0.27 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20601__a71dc7931c7470757bd1149125486b06"
]
163 0.30 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_94"
]
164 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_94\x01tags\x01"
]
165 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20599"
]
166 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20599\x01tags\x01"
]
167 0.22 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[20599]
168 0.29 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[20599]
169 0.22 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
170 0.21 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20599__2c6ff71f39b94b6c2e24603093beba9b"
]
171 0.21 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
172 0.21 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20599__ff467e3b6a52dd6d7d3500719403a2c0"
]
173 0.19 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
174 0.16 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20599__2c6ff71f39b94b6c2e24603093beba9b"
]
175 0.24 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
176 0.22 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20599__2c6ff71f39b94b6c2e24603093beba9b"
]
177 0.23 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
178 0.22 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20599__2c6ff71f39b94b6c2e24603093beba9b"
]
179 0.22 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
180 0.23 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20599__ff467e3b6a52dd6d7d3500719403a2c0"
]
181 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_25"
]
182 0.27 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783519370
  "document_25\x01tags\x01"
  "asset_15787\x01tags\x01"
  "asset_11600\x01tags\x01"
]
183 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16823"
]
184 0.24 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16823\x01tags\x01"
]
185 0.23 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[16823]
186 0.29 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[16823]
187 0.22 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
188 0.22 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16823__f43b55e29814320fb33c0b25122ecc76"
]
189 0.22 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
190 0.22 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16823__c40be6b240accb5c9c4006efe32464b6"
]
191 0.23 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
192 0.23 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16823__f43b55e29814320fb33c0b25122ecc76"
]
193 0.24 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
194 0.22 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16823__f43b55e29814320fb33c0b25122ecc76"
]
195 0.21 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
196 0.20 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16823__f43b55e29814320fb33c0b25122ecc76"
]
197 0.17 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
198 0.17 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16823__c40be6b240accb5c9c4006efe32464b6"
]
199 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_20"
]
200 0.22 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783519370
  "document_20\x01tags\x01"
  "asset_33648\x01tags\x01"
  "asset_33701\x01tags\x01"
]
201 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16821"
]
202 0.21 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16821\x01tags\x01"
]
203 0.21 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[16821]
204 0.27 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[16821]
205 0.22 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
206 0.29 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16821__4b66895a386344435c147a9e19d8c6e4"
]
207 0.27 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
208 0.25 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16821__1b6be97abe907f95afe1767dcd3f5cc6"
]
209 0.27 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
210 0.26 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16821__4b66895a386344435c147a9e19d8c6e4"
]
211 0.28 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
212 0.22 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16821__4b66895a386344435c147a9e19d8c6e4"
]
213 0.22 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
214 0.25 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16821__4b66895a386344435c147a9e19d8c6e4"
]
215 0.23 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
216 0.23 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16821__1b6be97abe907f95afe1767dcd3f5cc6"
]
217 0.31 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_22"
]
218 0.32 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783519370
  "document_22\x01tags\x01"
  "asset_15785\x01tags\x01"
  "asset_12860\x01tags\x01"
]
219 0.28 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16825"
]
220 0.25 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16825\x01tags\x01"
]
221 0.23 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[16825]
222 0.33 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[16825]
223 0.23 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
224 0.24 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16825__a8c2cf422302c28ef6eebbe8343975dd"
]
225 0.22 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
226 0.20 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16825__8482b811999bdd66e3b704bfd82913bf"
]
227 0.20 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
228 0.20 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16825__a8c2cf422302c28ef6eebbe8343975dd"
]
229 0.20 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
230 0.20 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16825__a8c2cf422302c28ef6eebbe8343975dd"
]
231 0.16 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
232 0.15 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16825__a8c2cf422302c28ef6eebbe8343975dd"
]
233 0.17 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
234 0.15 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16825__8482b811999bdd66e3b704bfd82913bf"
]
235 0.19 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_23"
]
236 0.21 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783519370
  "document_23\x01tags\x01"
  "asset_15782\x01tags\x01"
  "asset_12077\x01tags\x01"
]
237 0.21 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16824"
]
238 0.21 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16824\x01tags\x01"
]
239 0.21 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[16824]
240 0.28 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[16824]
241 0.21 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
242 0.22 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16824__db97edf821626c8a6aae622f6ce93f95"
]
243 0.16 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
244 0.15 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16824__03f6d4c0994de073b745e23d270d8de0"
]
245 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
246 0.15 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16824__db97edf821626c8a6aae622f6ce93f95"
]
247 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
248 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16824__db97edf821626c8a6aae622f6ce93f95"
]
249 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
250 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16824__db97edf821626c8a6aae622f6ce93f95"
]
251 0.16 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
252 0.15 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16824__03f6d4c0994de073b745e23d270d8de0"
]
253 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "document_24"
]
254 0.20 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?,?,?)
Parameters:
[1783519370
  "document_24\x01tags\x01"
  "asset_15784\x01tags\x01"
  "asset_12043\x01tags\x01"
]
255 0.18 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16820"
]
256 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_16820\x01tags\x01"
]
257 0.16 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[16820]
258 0.20 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[16820]
259 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
260 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16820__cb4105acdce45a5732106bd6bec2c597"
]
261 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
262 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16820__695bb8295ff20664b1a5b2fc94a5b3ac"
]
263 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
264 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16820__cb4105acdce45a5732106bd6bec2c597"
]
265 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
266 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16820__cb4105acdce45a5732106bd6bec2c597"
]
267 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
268 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16820__cb4105acdce45a5732106bd6bec2c597"
]
269 0.26 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
270 0.15 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_16820__695bb8295ff20664b1a5b2fc94a5b3ac"
]
271 0.17 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20642"
]
272 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_20642\x01tags\x01"
]
273 0.15 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[20642]
274 0.19 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[20642]
275 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
276 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20642__bd371f8e20fd0c74a89fddc00b549133"
]
277 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
278 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20642__c4975a7bb6d09f8732ed0cbd2f99f165"
]
279 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
280 0.15 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20642__bd371f8e20fd0c74a89fddc00b549133"
]
281 0.14 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
282 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20642__bd371f8e20fd0c74a89fddc00b549133"
]
283 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
284 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20642__bd371f8e20fd0c74a89fddc00b549133"
]
285 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
286 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_20642__c4975a7bb6d09f8732ed0cbd2f99f165"
]
287 0.17 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_21858"
]
288 0.15 ms
SELECTitem_id,CASEWHENitem_lifetimeISNULLORitem_lifetime+item_time>?THENitem_dataELSENULLENDFROMcache_itemsWHEREitem_idIN (?)
Parameters:
[1783519370
  "asset_21858\x01tags\x01"
]
289 0.16 ms
SELECTcustomSettingsFROMassetsWHEREid=?
Parameters:
[21858]
290 0.19 ms
SELECT*FROMassets_image_thumbnail_cacheWHEREcid=?
Parameters:
[21858]
291 0.14 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
292 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_21858__f930d030141a3402a554a1ec3a129fdc"
]
293 0.14 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
294 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_21858__2c962f1257ad83fef13273a142b1344e"
]
295 0.14 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
296 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_21858__f930d030141a3402a554a1ec3a129fdc"
]
297 0.15 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
298 0.24 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_21858__f930d030141a3402a554a1ec3a129fdc"
]
299 0.18 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
300 0.14 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_21858__f930d030141a3402a554a1ec3a129fdc"
]
301 0.18 ms
SELECT*FROMsettings_storeWHEREid=?ANDscope=?
Parameters:
[
  "_auto_40cd750bba9870f18aada2478b24840a"
  "pimcore_image_thumbnails"
]
302 0.21 ms
SELECT*FROMtmp_storeWHEREid=?
Parameters:
[
  "thumb_21858__2c962f1257ad83fef13273a142b1344e"
]

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
CoreShop\Component\Address\Model\CountryTranslation 1

pimcore entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
CoreShop\Component\Store\Model\Store No errors.
CoreShop\Component\Core\Model\Store No errors.
CoreShop\Component\Currency\Model\ExchangeRate No errors.
CoreShop\Component\Currency\Model\Currency No errors.
CoreShop\Component\Core\Model\Currency No errors.
CoreShop\Component\Product\Model\ProductPriceRule No errors.
CoreShop\Component\Taxation\Model\TaxRule No errors.
CoreShop\Component\Core\Model\TaxRule No errors.
CoreShop\Component\Configuration\Model\Configuration No errors.
CoreShop\Component\Core\Model\Configuration No errors.
CoreShop\Component\Taxation\Model\TaxRate No errors.
CoreShop\Component\Shipping\Model\ShippingRule No errors.
CoreShop\Component\Shipping\Model\Carrier No errors.
CoreShop\Component\Core\Model\Carrier No errors.
CoreShop\Component\Order\Model\CartPriceRule No errors.
CoreShop\Component\Order\Model\CartPriceRuleVoucherCode No errors.
CoreShop\Component\Order\Model\CartPriceRuleVoucherCodeCustomer No errors.
CoreShop\Component\Payment\Model\PaymentProviderRule No errors.
CoreShop\Component\Address\Model\Country No errors.
CoreShop\Component\Core\Model\Country No errors.
CoreShop\Component\Address\Model\Zone No errors.
CoreShop\Component\Address\Model\CountryTranslation No errors.
CoreShop\Component\Address\Model\State No errors.
CoreShop\Component\Product\Model\ProductPriceRuleTranslation No errors.
CoreShop\Component\Rule\Model\Condition No errors.
CoreShop\Component\Rule\Model\Action No errors.
CoreShop\Component\Taxation\Model\TaxRuleGroup No errors.
CoreShop\Component\Taxation\Model\TaxRateTranslation No errors.
CoreShop\Component\Shipping\Model\ShippingRuleGroup No errors.
CoreShop\Component\Shipping\Model\CarrierTranslation No errors.
CoreShop\Component\Order\Model\CartPriceRuleTranslation No errors.
CoreShop\Component\Payment\Model\PaymentProviderRuleTranslation No errors.
CoreShop\Component\Address\Model\StateTranslation No errors.

pimcore entity manager

No loaded entities.