Query Metrics
317
Database Queries
72
Different statements
277.47 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.41 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/bludenz/en/" "rundwanderung-unterrifats-braz-1_vc4008" ] |
| 2 | 0.34 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/bludenz/en/rundwanderung-unterrifats-braz-1_vc4008"
]
|
| 3 | 0.41 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/bludenz/" "en" ] |
| 4 | 0.83 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
79
]
|
| 5 | 0.32 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 6 | 0.49 ms |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/bludenz/en/rundwanderung-unterrifats-braz-1_vc4008" "path" "auto_create" "/bludenz/en/rundwanderung-unterrifats-braz-1_vc4008" "path_query" "https://alpenregion-staging.conecto.rocks/bludenz/en/rundwanderung-unterrifats-braz-1_vc4008" "entire_uri" ] |
| 7 | 0.26 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
| 8 | 0.51 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/bludenz/en/" "rundwanderung-unterrifats-braz-1_vc4008" ] |
| 9 | 0.35 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/bludenz/en/rundwanderung-unterrifats-braz-1_vc4008"
]
|
| 10 | 0.43 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"vcloud_tour"
]
|
| 11 | 0.79 ms |
SELECT * FROM object_relations_vcloud_tour WHERE src_id = ?
Parameters:
[
4008
]
|
| 12 | 0.34 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"vcloud_concept"
]
|
| 13 | 0.30 ms |
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
4853
]
|
| 14 | 0.30 ms |
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
4854
]
|
| 15 | 0.32 ms |
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
8003
]
|
| 16 | 0.32 ms |
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
8008
]
|
| 17 | 0.38 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "bludenz" ] |
| 18 | 0.25 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 19 | 0.43 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
89
]
|
| 20 | 7.11 ms |
SELECT * FROM properties WHERE ( (cid IN (1,12008,11373,661) AND inheritable = 1) OR cid = ? ) AND ctype='asset'
Parameters:
[
12009
]
|
| 21 | 0.80 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
12009
]
|
| 22 | 3.21 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
12009
]
|
| 23 | 0.42 ms |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
89
]
|
| 24 | 0.68 ms |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 79 89 89 ] |
| 25 | 0.44 ms |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 89 89 ] |
| 26 | 0.33 ms |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 79 79 ] |
| 27 | 0.33 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "de" ] |
| 28 | 0.43 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "en" ] |
| 29 | 0.28 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/bludenz/" "de" ] |
| 30 | 0.25 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 31 | 0.25 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 32 | 0.69 ms |
SELECT * FROM properties WHERE ( (cid IN (1,10) AND inheritable = 1) OR cid = ? ) AND ctype='asset'
Parameters:
[
17
]
|
| 33 | 0.37 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
17
]
|
| 34 | 3.63 ms |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
| 35 | 0.41 ms |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
| 36 | 0.47 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
17
]
|
| 37 | 0.47 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
17
]
|
| 38 | 0.53 ms |
SELECT * FROM properties WHERE ( (cid IN (1,10) AND inheritable = 1) OR cid = ? ) AND ctype='asset'
Parameters:
[
17
]
|
| 39 | 2.07 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
148
]
|
| 40 | 0.37 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
148
]
|
| 41 | 1.91 ms |
SELECT * FROM properties WHERE ( (cid IN (1,125,124,20) AND inheritable = 1) OR cid = ? ) AND ctype='asset'
Parameters:
[
148
]
|
| 42 | 3.77 ms |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
89
]
|
| 43 | 0.78 ms |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 79 89 89 ] |
| 44 | 0.52 ms |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 89 89 ] |
| 45 | 0.45 ms |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 79 79 ] |
| 46 | 0.34 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 47 | 0.31 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 48 | 1.32 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"weather"
]
|
| 49 | 0.61 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 50 | 0.74 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"vcloud_poi"
]
|
| 51 | 1.99 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 4008 "object" ] |
| 52 | 2.96 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 4008 ] |
| 53 | 5.55 ms |
SELECT * FROM object_collection_vcloudContentblock_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 4008 "contentblocks" ] |
| 54 | 2.64 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 0 ] |
| 55 | 1.71 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 0
Parameters:
[] |
| 56 | 0.34 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 0
Parameters:
[] |
| 57 | 0.89 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 1 ] |
| 58 | 2.87 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 1
Parameters:
[] |
| 59 | 0.35 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 1
Parameters:
[] |
| 60 | 0.55 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 2 ] |
| 61 | 0.33 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 2
Parameters:
[] |
| 62 | 0.26 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 2
Parameters:
[] |
| 63 | 0.64 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 3 ] |
| 64 | 0.34 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 3
Parameters:
[] |
| 65 | 0.33 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 3
Parameters:
[] |
| 66 | 0.55 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 4 ] |
| 67 | 0.30 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 4
Parameters:
[] |
| 68 | 2.94 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 4
Parameters:
[] |
| 69 | 0.82 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 5 ] |
| 70 | 0.32 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 5
Parameters:
[] |
| 71 | 0.29 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 5
Parameters:
[] |
| 72 | 0.55 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 6 ] |
| 73 | 0.48 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 6
Parameters:
[] |
| 74 | 0.24 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 6
Parameters:
[] |
| 75 | 0.45 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 7 ] |
| 76 | 1.98 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 7
Parameters:
[] |
| 77 | 0.28 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 7
Parameters:
[] |
| 78 | 0.44 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 8 ] |
| 79 | 2.65 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 8
Parameters:
[] |
| 80 | 0.44 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 8
Parameters:
[] |
| 81 | 0.69 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 9 ] |
| 82 | 0.32 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 9
Parameters:
[] |
| 83 | 0.31 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 9
Parameters:
[] |
| 84 | 0.67 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 10 ] |
| 85 | 0.33 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 10
Parameters:
[] |
| 86 | 0.25 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 10
Parameters:
[] |
| 87 | 0.52 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 11 ] |
| 88 | 3.29 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 11
Parameters:
[] |
| 89 | 0.59 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 11
Parameters:
[] |
| 90 | 0.79 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 12 ] |
| 91 | 0.36 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 12
Parameters:
[] |
| 92 | 0.34 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 12
Parameters:
[] |
| 93 | 0.73 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 13 ] |
| 94 | 0.36 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 13
Parameters:
[] |
| 95 | 0.30 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 13
Parameters:
[] |
| 96 | 1.66 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 14 ] |
| 97 | 0.30 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 14
Parameters:
[] |
| 98 | 0.92 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 14
Parameters:
[] |
| 99 | 0.58 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 15 ] |
| 100 | 1.08 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 15
Parameters:
[] |
| 101 | 0.32 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 15
Parameters:
[] |
| 102 | 2.74 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 16 ] |
| 103 | 0.36 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 16
Parameters:
[] |
| 104 | 2.08 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 16
Parameters:
[] |
| 105 | 0.91 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 17 ] |
| 106 | 0.26 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 17
Parameters:
[] |
| 107 | 0.23 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 17
Parameters:
[] |
| 108 | 0.43 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 18 ] |
| 109 | 0.28 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 18
Parameters:
[] |
| 110 | 0.55 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 18
Parameters:
[] |
| 111 | 0.76 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 19 ] |
| 112 | 0.54 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 19
Parameters:
[] |
| 113 | 1.41 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 19
Parameters:
[] |
| 114 | 1.37 ms |
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 4008 "contentblocks" 20 ] |
| 115 | 2.11 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 20
Parameters:
[] |
| 116 | 0.50 ms |
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4008 and fieldname = 'contentblocks' and `index` = 20
Parameters:
[] |
| 117 | 2.79 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"vcloud_safety_tip"
]
|
| 118 | 1.52 ms |
SELECT * FROM object_collection_vcloudExternalLink_vcloud_safety_tip WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 4884 "externalLinks" ] |
| 119 | 1.89 ms |
SELECT * FROM object_collection_vcloudExternalLink_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 4008 "externalLinks" ] |
| 120 | 3.85 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 121 | 0.35 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 122 | 1.93 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__b7ed422dd5156f650763be3a7be5471e"
]
|
| 123 | 0.30 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 124 | 0.70 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__7c1bae6286114472e591889719d3fb8d"
]
|
| 125 | 0.58 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 126 | 3.03 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__1cc929cbf04b92f0ef20f2733707edd4"
]
|
| 127 | 0.28 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 128 | 0.26 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__2a4036d66e15557b40b8c7f0235c4dcb"
]
|
| 129 | 1.07 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 130 | 0.30 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__be07f8c1697c4aad9c41dfb585d877a1"
]
|
| 131 | 0.44 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 132 | 1.18 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__10fd21294767b3f4563a7d7acb050945"
]
|
| 133 | 0.32 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 134 | 0.26 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__88a04d9e8b1b6457976eafbcc48d0b6e"
]
|
| 135 | 0.24 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 136 | 0.74 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__40107fbdd820f6c0a4b1df18c435edb0"
]
|
| 137 | 0.24 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 138 | 0.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__a64813c076dc176e22a1271f57c991aa"
]
|
| 139 | 0.25 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 140 | 0.65 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__fe69a2b5a5a22213bf326b08ae5f9dd4"
]
|
| 141 | 0.85 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 142 | 0.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__1e8c59320a1b7b1065403f62f4a9668e"
]
|
| 143 | 2.28 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 144 | 0.94 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__5377a4e181a49ece2908eea5099cdc9d"
]
|
| 145 | 0.30 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 146 | 0.30 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__cfd16dcbe94d573a38cb38bd8b63e56f"
]
|
| 147 | 0.38 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 148 | 0.23 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__2b1519de51d544d496040625c20c527e"
]
|
| 149 | 3.53 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 150 | 1.04 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__fbf7c690915d737d244acf657795addd"
]
|
| 151 | 0.27 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 152 | 1.08 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__932275372c000c9c7516ed40c584ea6e"
]
|
| 153 | 0.28 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 154 | 0.30 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__ea4b5b5b6f59da02d9bf7cbe4db1c853"
]
|
| 155 | 0.26 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 156 | 2.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__a4240f3d95cc910a6492a4e2b85655e8"
]
|
| 157 | 1.83 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 158 | 0.30 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__8f8d483ec19d0b637f7327c562dff6a7"
]
|
| 159 | 0.35 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 160 | 0.48 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__1eeab248e9f0aa6a4e7e8269c6a8520f"
]
|
| 161 | 0.21 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 162 | 2.58 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__7d29d1da0e1f475e6a3b00936bcbe66f"
]
|
| 163 | 0.34 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 164 | 0.35 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__efe0c410c3d2b439ca800e850d341e20"
]
|
| 165 | 0.31 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 166 | 0.35 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__c35391e8f398a329a553025580891c49"
]
|
| 167 | 0.36 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 168 | 1.99 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__c9353972a20fdfdfe85a8c358952f5f4"
]
|
| 169 | 0.33 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 170 | 0.30 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__4d833ed7a0c87dba429873cb63ec21c3"
]
|
| 171 | 0.26 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 172 | 2.04 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__c223ca7ee1cda90dd5d131210636f8a5"
]
|
| 173 | 0.31 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 174 | 0.26 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__3080d74e0d4d69f730b9860f5cdfc090"
]
|
| 175 | 0.27 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 176 | 0.24 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__c223ca7ee1cda90dd5d131210636f8a5"
]
|
| 177 | 0.24 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 178 | 2.45 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12009__4d833ed7a0c87dba429873cb63ec21c3"
]
|
| 179 | 0.86 ms |
SELECT * FROM properties WHERE ( (cid IN (1,12008,11373,661) AND inheritable = 1) OR cid = ? ) AND ctype='asset'
Parameters:
[
12010
]
|
| 180 | 0.43 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
12010
]
|
| 181 | 0.39 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
12010
]
|
| 182 | 0.86 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 183 | 4.79 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__921e380955f31f171355c12b459dd6b1"
]
|
| 184 | 0.36 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 185 | 0.33 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__6c8ba8a331963d1f886cc05f2b886664"
]
|
| 186 | 2.57 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 187 | 4.03 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__363ce2fbe11c4c8e702dbb3fffd6f060"
]
|
| 188 | 0.43 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 189 | 0.37 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__3623ec6aa022805ce8c467935990bc9e"
]
|
| 190 | 0.32 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 191 | 0.30 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__8564599f5616bea8d41e0ce660fe281f"
]
|
| 192 | 0.27 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 193 | 3.02 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__8a25aeb214f022beb0c788aff2042820"
]
|
| 194 | 0.42 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 195 | 0.37 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__52a04f3b564a80e78706b5e3f4d5622a"
]
|
| 196 | 0.34 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 197 | 0.35 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__f9340c63069b1a47bb501e97358a21e9"
]
|
| 198 | 0.33 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 199 | 0.37 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__be27949d9b1ce7bfd530acc9bf5545b5"
]
|
| 200 | 0.34 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 201 | 0.35 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__51c581d23ea8bd13bba27f70d8f6c370"
]
|
| 202 | 0.34 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 203 | 0.32 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__4c7778b43f1bddf590ce2a16d1f67a2d"
]
|
| 204 | 2.63 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 205 | 0.33 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__097c834f174156240b3ca6482c0d632d"
]
|
| 206 | 0.36 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 207 | 0.31 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__93731b88bc5dfd1f63eaf7d5cfb11af1"
]
|
| 208 | 0.32 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 209 | 0.34 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__3ab23b4029e7d3f31ca079be28818c04"
]
|
| 210 | 0.27 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 211 | 0.35 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__0aec93e814e23c77a31e12d74e686a74"
]
|
| 212 | 1.30 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 213 | 0.36 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__8953ed559776b893dab8d19450a1d654"
]
|
| 214 | 0.34 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 215 | 0.32 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__89d3df51fc4c6cecdbc953cf832d2a72"
]
|
| 216 | 2.40 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 217 | 0.40 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__6e1b613ad46449999026faf170acdf82"
]
|
| 218 | 2.49 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 219 | 0.38 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__660951150d27825aacfadbebfcaa15c0"
]
|
| 220 | 0.32 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 221 | 0.37 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__c0a25c7ae8729a57b891d836ffb3dcda"
]
|
| 222 | 0.31 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 223 | 1.65 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__ab85cea70c22c922379adb5127444c15"
]
|
| 224 | 0.34 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 225 | 0.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__9122dad1593b7a84a5237aa452945778"
]
|
| 226 | 0.28 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 227 | 2.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__223997ac71c15ff20925cccbce21256a"
]
|
| 228 | 0.25 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 229 | 0.25 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__08596956d30ac1736d7b9272a1ccb767"
]
|
| 230 | 0.27 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 231 | 0.25 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__dc1a14e3a16d8c3de4044086a3fc4d9a"
]
|
| 232 | 0.27 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 233 | 2.52 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__720afb384d685d9dfea836f38929faf7"
]
|
| 234 | 0.39 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 235 | 0.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__3cd3b224170ca7d735a195292c4d3d52"
]
|
| 236 | 0.27 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 237 | 0.50 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__720afb384d685d9dfea836f38929faf7"
]
|
| 238 | 0.78 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "textMedia_1-33_3" "pimcore_image_thumbnails" ] |
| 239 | 0.35 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_12010__dc1a14e3a16d8c3de4044086a3fc4d9a"
]
|
| 240 | 0.95 ms |
SELECT * FROM object_collection_vcloudOpeningHours_vcloud_poi WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 2396 "openingHours" ] |
| 241 | 3.32 ms |
SELECT * FROM object_collection_vcloudOpeningHours_localized_vcloud_poi WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 2396 "openingHours" 0 ] |
| 242 | 1.03 ms |
SELECT * FROM object_collection_vcloudOpeningHours_localized_vcloud_poi WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 2396 "openingHours" 1 ] |
| 243 | 0.54 ms |
SELECT * FROM object_relations_vcloud_poi WHERE src_id = ?
Parameters:
[
2396
]
|
| 244 | 0.26 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 245 | 1.14 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 246 | 2.28 ms |
SELECT * FROM properties WHERE ( (cid IN (1,8051,5773,661) AND inheritable = 1) OR cid = ? ) AND ctype='asset'
Parameters:
[
23137
]
|
| 247 | 0.31 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
23137
]
|
| 248 | 1.51 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
23137
]
|
| 249 | 0.24 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 250 | 0.81 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__5467a7e94ac87d2b49c5f83446f31e43"
]
|
| 251 | 1.14 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 252 | 0.76 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__252ab490c22e663403c24006e170d84b"
]
|
| 253 | 1.38 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 254 | 0.67 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__9e96ba903ea48a630addac8269c0af35"
]
|
| 255 | 1.94 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 256 | 0.33 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__5bb16c436a2ded994e1edc03c2ae7800"
]
|
| 257 | 0.30 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 258 | 0.72 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__fd229274102d9063341b36192dd0e42b"
]
|
| 259 | 0.25 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 260 | 1.84 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__9380b90bab938e8d9c3de2b6afe30b0c"
]
|
| 261 | 2.55 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 262 | 0.92 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__3b9aded60d7a3a5395557bd0398fa788"
]
|
| 263 | 0.24 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 264 | 0.25 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__1bd0fc20a4c4ba61cddd8a91b70d9e03"
]
|
| 265 | 3.28 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 266 | 0.94 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__7140f4c0d90e935e88dfb178c201daf8"
]
|
| 267 | 0.30 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 268 | 0.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__e523b2a533175ea29e84e316861084f6"
]
|
| 269 | 2.35 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 270 | 0.71 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__10afd63afec52adee7558e9bda47fb91"
]
|
| 271 | 0.28 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 272 | 0.26 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__c68d6719190962ae605bee88141c56f5"
]
|
| 273 | 0.25 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 274 | 0.72 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__6467b5bd71daf14e132b27cb8c6aa40b"
]
|
| 275 | 0.25 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 276 | 1.42 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__1aa01cabf0b1e3f57eb1c0c1595e8df7"
]
|
| 277 | 0.34 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 278 | 0.27 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__67d619ed36721c9c2648a9c8f8bd093f"
]
|
| 279 | 0.27 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 280 | 2.35 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__157df29ba713683569353cc8db4efca1"
]
|
| 281 | 0.25 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 282 | 0.22 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__4e87c1d0b8e26f51a23fd22f6909127f"
]
|
| 283 | 0.25 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 284 | 1.03 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__dcc46ab2d307b1f6db4eee0d0e20b756"
]
|
| 285 | 0.26 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 286 | 0.27 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__0efb8b0a4aae48b37d3370b1ecce1ddf"
]
|
| 287 | 0.24 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 288 | 1.39 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__324ea106d5d063d7c17fa28fc4af9e22"
]
|
| 289 | 0.29 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 290 | 0.25 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__47d44afd2fdaa9581496cdb7371dd372"
]
|
| 291 | 2.70 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 292 | 0.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__7a0ba309218b6f9c08ab75d815b5942e"
]
|
| 293 | 0.26 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 294 | 0.26 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__4de51abefe8cc152250b34ab1154b29d"
]
|
| 295 | 0.21 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 296 | 1.59 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__9aeb8bdb624e0a6a3364e5694d989ccf"
]
|
| 297 | 0.26 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 298 | 0.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__cad5d1621d0059d1fbb71e02662927e8"
]
|
| 299 | 0.25 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 300 | 0.24 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__0f487d7771903393740b0a24b6c4f795"
]
|
| 301 | 2.83 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 302 | 0.30 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__2bec844af53803577d8af23d3f6214d3"
]
|
| 303 | 0.29 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 304 | 0.27 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__0f487d7771903393740b0a24b6c4f795"
]
|
| 305 | 0.26 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "teaserDefault_1-78_3" "pimcore_image_thumbnails" ] |
| 306 | 0.26 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_23137__cad5d1621d0059d1fbb71e02662927e8"
]
|
| 307 | 0.25 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 308 | 0.28 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 309 | 1.52 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 310 | 1.46 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 311 | 0.28 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
78
]
|
| 312 | 1.84 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 4008 ] |
| 313 | 1.44 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 314 | 1.80 ms |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_locale=en&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction" "path_query" "https://alpenregion-staging.conecto.rocks/_fragment?_path=_locale=en&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction" "entire_uri" ] |
| 315 | 4.86 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
99
]
|
| 316 | 0.42 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
81
]
|
| 317 | 0.44 ms |
SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
1064
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| FormBuilderBundle\Model\OutputWorkflow | No errors. |
| FormBuilderBundle\Model\FormDefinition | No errors. |