Query Metrics
288
Database Queries
51
Different statements
159.02 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.34 ms |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "defaultSiteConfig" null null ] |
2 | 0.09 ms |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
3 | 0.29 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
4 | 0.27 ms |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "mainBlogPortal" null null ] |
5 | 0.09 ms |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
8
]
|
6 | 0.11 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"BlogPortal"
]
|
7 | 0.45 ms |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen/Gaestehaus-Enzinger-Hotel-Spielberg_ad-1744268" "sourcePathQuery" => "/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen/Gaestehaus-Enzinger-Hotel-Spielberg_ad-1744268" "sourceEntireUri" => "https://stage.steiermark.com/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen/Gaestehaus-Enzinger-Hotel-Spielberg_ad-1744268" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
8 | 0.15 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
9 | 0.17 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Gaestehaus-Enzinger-Hotel-Spielberg_ad-1744268" "path" => "/steiermark.com/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen/" ] |
10 | 0.12 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/steiermark.com/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen/Gaestehaus-Enzinger-Hotel-Spielberg_ad-1744268" ] |
11 | 0.19 ms |
SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[ "/steiermark.com/%" "/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen/Gaestehaus-Enzinger-Hotel-Spielberg_ad-1744268" ] |
12 | 0.11 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Unterkuenfte-suchen-und-buchen" "path" => "/steiermark.com/de/Murau/Urlaub-planen/" ] |
13 | 0.21 ms |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
14 | 0.31 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "customer" "path" => "/deskline/" ] |
15 | 0.12 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"8"
]
|
16 | 0.25 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"69"
]
|
17 | 0.23 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"51"
]
|
18 | 0.24 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"30"
]
|
19 | 0.26 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"29"
]
|
20 | 0.29 ms |
SELECT * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 1744268 "links" ] |
21 | 0.36 ms |
SELECT * FROM object_collection_demiLink_localized_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk','es') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 1744268 "links" 0 ] |
22 | 0.24 ms |
SELECT * FROM object_collection_demiLink_localized_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk','es') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 1744268 "links" 1 ] |
23 | 0.22 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"21"
]
|
24 | 0.12 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"18"
]
|
25 | 0.10 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"72"
]
|
26 | 0.28 ms |
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
27 | 0.24 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
6681
]
|
28 | 0.21 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"7"
]
|
29 | 0.14 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"6"
]
|
30 | 0.13 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"44"
]
|
31 | 0.31 ms |
SELECT objectRelations.src_id FROM object_relations_55 objectRelations WHERE (objectRelations.dest_id IN (SELECT objectRelationsPSection.src_id FROM object_relations_57 objectRelationsPSection WHERE (objectRelationsPSection.dest_id = :dcValue1) AND (objectRelationsPSection.fieldname = :dcValue2))) AND (objectRelations.fieldname = :dcValue3)
Parameters:
[ "dcValue1" => 1744268 "dcValue2" => "serviceProvider" "dcValue3" => "sections" ] |
32 | 0.16 ms |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
33 | 0.12 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"23"
]
|
34 | 0.26 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"59"
]
|
35 | 0.95 ms |
SELECT COUNT(*) FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE :demiRegionId AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[ "demiRegionId" => "%,11886%" ] |
36 | 0.68 ms |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE :demiRegionId AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1 LIMIT 1
Parameters:
[ "demiRegionId" => "%,11886%" ] |
37 | 0.11 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"Region"
]
|
38 | 0.39 ms |
SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 1744268 "addresses" ] |
39 | 0.22 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"27"
]
|
40 | 0.22 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"20"
]
|
41 | 0.20 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "slider-main" "scope" => "pimcore_image_thumbnails" ] |
42 | 0.25 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5228113 ] |
43 | 0.15 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-gallery-wide-1" "scope" => "pimcore_image_thumbnails" ] |
44 | 0.31 ms |
SELECT id FROM sites
Parameters:
[] |
45 | 0.16 ms |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
6681
]
|
46 | 0.20 ms |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 6681 6681 6681 ] |
47 | 0.12 ms |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 9789 9789 ] |
48 | 0.20 ms |
SELECT id FROM sites
Parameters:
[] |
49 | 0.22 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 1039116 ] |
50 | 0.33 ms |
SELECT id FROM sites
Parameters:
[] |
51 | 0.11 ms |
SELECT id FROM sites
Parameters:
[] |
52 | 0.38 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-full-img-header" "scope" => "pimcore_image_thumbnails" ] |
53 | 0.32 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
9382
]
|
54 | 0.35 ms |
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 5882752 "datepickerInfoTexts" ] |
55 | 0.60 ms |
SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE (fid='' AND object_52.o_type IN ('object')) AND object_52.o_published = 1 ORDER BY `o_published` DESC LIMIT 2
Parameters:
[] |
56 | 0.38 ms |
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,5815,5673,5670) AND inheritable = 1) OR cid = ? ) AND ctype='object'
Parameters:
[
1744268
]
|
57 | 0.32 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-gallery-overlay" "scope" => "pimcore_image_thumbnails" ] |
58 | 0.23 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5228114 ] |
59 | 0.29 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-gallery-2" "scope" => "pimcore_image_thumbnails" ] |
60 | 0.34 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5228115 ] |
61 | 0.34 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 1114619 ] |
62 | 0.09 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-gallery-3" "scope" => "pimcore_image_thumbnails" ] |
63 | 0.31 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5228116 ] |
64 | 0.24 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"MediaCopyright"
]
|
65 | 0.29 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5228117 ] |
66 | 0.09 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-gallery-4" "scope" => "pimcore_image_thumbnails" ] |
67 | 0.26 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 1114620 ] |
68 | 0.08 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-gallery-5" "scope" => "pimcore_image_thumbnails" ] |
69 | 0.28 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5228118 ] |
70 | 0.20 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 2677739 ] |
71 | 0.13 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
12841685
]
|
72 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
12841685
]
|
73 | 0.07 ms |
SELECT * FROM object_store_MediaCopyright WHERE oo_id = ?
Parameters:
[
12841685
]
|
74 | 0.22 ms |
SELECT * FROM object_localized_data_MediaCopyright WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk','es')
Parameters:
[
12841685
]
|
75 | 0.08 ms |
SELECT * FROM object_relations_MediaCopyright WHERE src_id = ?
Parameters:
[
12841685
]
|
76 | 0.17 ms |
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
Parameters:
[ "dcValue1" => 1744281 ] |
77 | 0.24 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
39642264
]
|
78 | 0.12 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
39642264
]
|
79 | 0.06 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"58"
]
|
80 | 0.08 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
39642264
]
|
81 | 0.15 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642264 "mealTypes" ] |
82 | 0.11 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642264 "periods" ] |
83 | 0.12 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642264 "prices" ] |
84 | 0.10 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642264 "prices" ] |
85 | 0.10 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
39642264
]
|
86 | 0.07 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
39642265
]
|
87 | 0.10 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
39642265
]
|
88 | 0.06 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
39642265
]
|
89 | 0.10 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642265 "mealTypes" ] |
90 | 0.09 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642265 "periods" ] |
91 | 0.10 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642265 "prices" ] |
92 | 0.09 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642265 "prices" ] |
93 | 0.08 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
39642265
]
|
94 | 0.06 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
39642266
]
|
95 | 0.09 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
39642266
]
|
96 | 0.07 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
39642266
]
|
97 | 0.10 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642266 "mealTypes" ] |
98 | 0.09 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642266 "periods" ] |
99 | 0.10 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642266 "prices" ] |
100 | 0.09 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39642266 "prices" ] |
101 | 0.09 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
39642266
]
|
102 | 0.07 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
42599294
]
|
103 | 0.09 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
42599294
]
|
104 | 0.06 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
42599294
]
|
105 | 0.10 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599294 "mealTypes" ] |
106 | 0.10 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599294 "periods" ] |
107 | 0.10 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599294 "prices" ] |
108 | 0.09 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599294 "prices" ] |
109 | 0.08 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
42599294
]
|
110 | 0.06 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
42599296
]
|
111 | 0.09 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
42599296
]
|
112 | 0.06 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
42599296
]
|
113 | 0.10 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599296 "mealTypes" ] |
114 | 0.10 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599296 "periods" ] |
115 | 0.10 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599296 "prices" ] |
116 | 0.09 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599296 "prices" ] |
117 | 0.08 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
42599296
]
|
118 | 0.06 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
42599302
]
|
119 | 0.09 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
42599302
]
|
120 | 0.06 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
42599302
]
|
121 | 0.10 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599302 "mealTypes" ] |
122 | 0.10 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599302 "periods" ] |
123 | 0.11 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599302 "prices" ] |
124 | 0.09 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42599302 "prices" ] |
125 | 0.08 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
42599302
]
|
126 | 0.07 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542155
]
|
127 | 0.09 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542155
]
|
128 | 0.07 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542155
]
|
129 | 0.10 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542155 "mealTypes" ] |
130 | 0.11 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542155 "periods" ] |
131 | 0.11 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542155 "prices" ] |
132 | 0.10 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542155 "prices" ] |
133 | 0.09 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542155
]
|
134 | 0.07 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542156
]
|
135 | 0.10 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542156
]
|
136 | 0.07 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542156
]
|
137 | 0.10 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542156 "mealTypes" ] |
138 | 0.29 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542156 "periods" ] |
139 | 0.26 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542156 "prices" ] |
140 | 0.16 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542156 "prices" ] |
141 | 0.14 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542156
]
|
142 | 0.11 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542157
]
|
143 | 0.17 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542157
]
|
144 | 0.10 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542157
]
|
145 | 0.16 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542157 "mealTypes" ] |
146 | 0.15 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542157 "periods" ] |
147 | 0.15 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542157 "prices" ] |
148 | 0.14 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542157 "prices" ] |
149 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542157
]
|
150 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542158
]
|
151 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542158
]
|
152 | 0.10 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542158
]
|
153 | 0.15 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542158 "mealTypes" ] |
154 | 0.15 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542158 "periods" ] |
155 | 0.16 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542158 "prices" ] |
156 | 0.13 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542158 "prices" ] |
157 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542158
]
|
158 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542159
]
|
159 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542159
]
|
160 | 0.09 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542159
]
|
161 | 0.15 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542159 "mealTypes" ] |
162 | 0.16 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542159 "periods" ] |
163 | 0.16 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542159 "prices" ] |
164 | 0.16 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542159 "prices" ] |
165 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542159
]
|
166 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542160
]
|
167 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542160
]
|
168 | 0.09 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542160
]
|
169 | 0.16 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542160 "mealTypes" ] |
170 | 0.15 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542160 "periods" ] |
171 | 0.15 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542160 "prices" ] |
172 | 0.13 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542160 "prices" ] |
173 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542160
]
|
174 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542161
]
|
175 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542161
]
|
176 | 0.09 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542161
]
|
177 | 0.14 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542161 "mealTypes" ] |
178 | 0.15 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542161 "periods" ] |
179 | 0.16 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542161 "prices" ] |
180 | 0.14 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542161 "prices" ] |
181 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542161
]
|
182 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542162
]
|
183 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542162
]
|
184 | 0.09 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542162
]
|
185 | 0.15 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542162 "mealTypes" ] |
186 | 0.16 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542162 "periods" ] |
187 | 0.15 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542162 "prices" ] |
188 | 0.14 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542162 "prices" ] |
189 | 0.13 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542162
]
|
190 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542163
]
|
191 | 0.14 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542163
]
|
192 | 0.10 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542163
]
|
193 | 0.16 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542163 "mealTypes" ] |
194 | 0.20 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542163 "periods" ] |
195 | 0.16 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542163 "prices" ] |
196 | 0.14 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542163 "prices" ] |
197 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542163
]
|
198 | 0.10 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542164
]
|
199 | 0.14 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542164
]
|
200 | 0.09 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542164
]
|
201 | 0.15 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542164 "mealTypes" ] |
202 | 0.15 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542164 "periods" ] |
203 | 0.15 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542164 "prices" ] |
204 | 0.13 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542164 "prices" ] |
205 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542164
]
|
206 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542166
]
|
207 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542166
]
|
208 | 0.09 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542166
]
|
209 | 0.14 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542166 "mealTypes" ] |
210 | 0.16 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542166 "periods" ] |
211 | 0.16 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542166 "prices" ] |
212 | 0.14 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542166 "prices" ] |
213 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542166
]
|
214 | 0.10 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
46542168
]
|
215 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
46542168
]
|
216 | 0.09 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
46542168
]
|
217 | 0.15 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542168 "mealTypes" ] |
218 | 0.18 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542168 "periods" ] |
219 | 0.15 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542168 "prices" ] |
220 | 0.13 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 46542168 "prices" ] |
221 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
46542168
]
|
222 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
47690744
]
|
223 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
47690744
]
|
224 | 0.09 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
47690744
]
|
225 | 0.15 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 47690744 "mealTypes" ] |
226 | 0.14 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 47690744 "periods" ] |
227 | 0.15 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 47690744 "prices" ] |
228 | 0.13 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 47690744 "prices" ] |
229 | 0.13 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
47690744
]
|
230 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
47690747
]
|
231 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
47690747
]
|
232 | 0.09 ms |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
47690747
]
|
233 | 0.15 ms |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 47690747 "mealTypes" ] |
234 | 0.14 ms |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 47690747 "periods" ] |
235 | 0.15 ms |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 47690747 "prices" ] |
236 | 0.14 ms |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 47690747 "prices" ] |
237 | 0.12 ms |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
47690747
]
|
238 | 0.73 ms |
SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds))
Parameters:
[ "dcValue1" => 1738300119 ":templateIds" => [ 1744298 16090692 19964720 19964723 19964725 28005295 29857944 29857945 31817976 33318495 33318498 33318500 33318501 36550013 36550015 37227698 37227701 37227703 39642262 39642263 39642264 39642265 39642266 42599294 42599296 42599302 46542155 46542156 46542157 46542158 46542159 46542160 46542161 46542162 46542163 46542164 46542166 46542168 47690744 47690747 ] ] |
239 | 0.10 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
1744285
]
|
240 | 0.14 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
1744285
]
|
241 | 0.12 ms |
SELECT * FROM object_store_23 WHERE oo_id = ?
Parameters:
[
1744285
]
|
242 | 0.11 ms |
SELECT * FROM object_relations_23 WHERE src_id = ?
Parameters:
[
1744285
]
|
243 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
1744286
]
|
244 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
1744286
]
|
245 | 0.10 ms |
SELECT * FROM object_store_23 WHERE oo_id = ?
Parameters:
[
1744286
]
|
246 | 0.10 ms |
SELECT * FROM object_relations_23 WHERE src_id = ?
Parameters:
[
1744286
]
|
247 | 0.09 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
1744278
]
|
248 | 0.13 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
1744278
]
|
249 | 0.09 ms |
SELECT * FROM object_store_23 WHERE oo_id = ?
Parameters:
[
1744278
]
|
250 | 0.10 ms |
SELECT * FROM object_relations_23 WHERE src_id = ?
Parameters:
[
1744278
]
|
251 | 0.10 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
1744279
]
|
252 | 0.12 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
1744279
]
|
253 | 0.09 ms |
SELECT * FROM object_store_23 WHERE oo_id = ?
Parameters:
[
1744279
]
|
254 | 0.11 ms |
SELECT * FROM object_relations_23 WHERE src_id = ?
Parameters:
[
1744279
]
|
255 | 0.36 ms |
SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 1744276 "facilities" ] |
256 | 0.12 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-room-teaser" "scope" => "pimcore_image_thumbnails" ] |
257 | 0.17 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5228119 ] |
258 | 0.15 ms |
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
Parameters:
[ "dcValue1" => 1744281 ] |
259 | 0.10 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-gallery-small" "scope" => "pimcore_image_thumbnails" ] |
260 | 0.09 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-room-details" "scope" => "pimcore_image_thumbnails" ] |
261 | 0.32 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 4320121 ] |
262 | 0.11 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
50211272
]
|
263 | 0.14 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
50211272
]
|
264 | 0.09 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"79"
]
|
265 | 0.11 ms |
SELECT * FROM object_store_79 WHERE oo_id = ?
Parameters:
[
50211272
]
|
266 | 0.12 ms |
SELECT * FROM object_relations_79 WHERE src_id = ?
Parameters:
[
50211272
]
|
267 | 0.14 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5228121 ] |
268 | 0.10 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
21484940
]
|
269 | 0.14 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
21484940
]
|
270 | 0.11 ms |
SELECT * FROM object_store_79 WHERE oo_id = ?
Parameters:
[
21484940
]
|
271 | 0.10 ms |
SELECT * FROM object_relations_79 WHERE src_id = ?
Parameters:
[
21484940
]
|
272 | 0.15 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 1114624 ] |
273 | 0.18 ms |
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
Parameters:
[ "dcValue1" => 1744281 ] |
274 | 0.12 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "demi-desktop-searchInfoBox-teaser" "scope" => "pimcore_image_thumbnails" ] |
275 | 0.48 ms |
SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE (fid='' AND object_52.o_type IN ('object')) AND object_52.o_published = 1 ORDER BY `o_published` DESC LIMIT 2
Parameters:
[] |
276 | 0.16 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
8847
]
|
277 | 0.16 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"62"
]
|
278 | 0.51 ms |
SELECT object_62.o_id as o_id, object_62.o_type as o_type FROM object_62 WHERE (`salutationLanguage` = 'de' AND object_62.o_type IN ('object','folder')) AND object_62.o_published = 1
Parameters:
[] |
279 | 0.17 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
6888
]
|
280 | 0.11 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "footer-logo" "scope" => "pimcore_image_thumbnails" ] |
281 | 0.21 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 3189171 ] |
demi_vacancies connection
#▲ | Time | Info |
---|---|---|
1 | 0.77 ms |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId WHERE products.oo_id IN (1744281) AND dacco.oo_id IN (1744268) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11928)) GROUP BY product_id ORDER BY RAND(764)
Parameters:
[] |
2 | 27.65 ms |
SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights FROM `steiermark_vacancies`.price_template pt INNER JOIN `steiermark_vacancies`.price_template_base_prices bp ON bp.price_template_id = pt.id WHERE pt.acco_id IN (1744268) AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id) order by minPrice
Parameters:
[] |
3 | 0.75 ms |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId WHERE products.oo_id IN (1744281) AND dacco.oo_id IN (1744268) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11928)) GROUP BY product_id ORDER BY RAND(764)
Parameters:
[] |
4 | 27.67 ms |
SELECT pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights FROM `steiermark_vacancies`.price_template pt INNER JOIN `steiermark_vacancies`.price_template_base_prices bp ON bp.price_template_id = pt.id WHERE pt.product_id IN (1744281) AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id) order by minPrice
Parameters:
[] |
5 | 27.70 ms |
SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights FROM `steiermark_vacancies`.price_template pt INNER JOIN `steiermark_vacancies`.price_template_base_prices bp ON bp.price_template_id = pt.id WHERE pt.acco_id IN (1744268) AND pt.product_id IN (1744281) AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id) order by minPrice
Parameters:
[] |
6 | 0.43 ms |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (1744268) AND dacco.o_published = 1 GROUP BY dacco.oo_id
Parameters:
[] |
7 | 29.71 ms |
SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights FROM `steiermark_vacancies`.price_template pt INNER JOIN `steiermark_vacancies`.price_template_base_prices bp ON bp.price_template_id = pt.id WHERE pt.acco_id IN (1744268) AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id) order by minPrice
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
demi_vacancies | doctrine.dbal.demi_vacancies_connection |
Entity Managers
Name | Service |
---|---|
portal_engine | doctrine.orm.portal_engine_entity_manager |
pimcore_direct_edit | doctrine.orm.pimcore_direct_edit_entity_manager |
statistics_explorer | doctrine.orm.statistics_explorer_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
portal_engine entity manager
No loaded entities.
pimcore_direct_edit entity manager
No loaded entities.
statistics_explorer entity manager
No loaded entities.