Query Metrics

212 Database Queries
24 Different statements
52.19 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.41 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/discover-kleinwalsertal/"
  "tour-search-kleinwalsertal"
]
2 0.27 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  68
]
3 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.40 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:
[
  "/en/discover-kleinwalsertal/tour-search-kleinwalsertal"
  "path"
  "auto_create"
  "/en/discover-kleinwalsertal/tour-search-kleinwalsertal?filter[cat][0]=176"
  "path_query"
  "https://partnerinfo.kleinwalsertal-dev.conecto.rocks/en/discover-kleinwalsertal/tour-search-kleinwalsertal?filter[cat][0]=176"
  "entire_uri"
]
5 0.19 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
6 0.31 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,441,429) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
Parameters:
[
  577
]
7 0.15 ms
SELECT * FROM object_url_slugs WHERE slug = '/en/discover-kleinwalsertal/tour-search-kleinwalsertal' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
8 0.21 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  577
]
9 0.17 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  1220
]
10 0.27 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  1220
]
11 0.16 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  577
]
12 0.33 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  68
  577
  577
]
13 0.23 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  577
  577
]
14 0.22 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  68
  68
]
15 0.33 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,4,2) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
Parameters:
[
  68
]
16 0.22 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "de"
]
17 0.18 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "en"
]
18 0.16 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "REPORT_REGION"
]
19 0.11 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CN_WEBCAM"
]
20 0.11 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CN_AVALANCHEREPORT"
]
21 0.17 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
22 0.20 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  577
]
23 0.34 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  68
  577
  577
]
24 0.28 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  577
  577
]
25 0.26 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  68
  68
]
26 0.47 ms
SELECT object_CN_WEATHERSTATION.id as id, object_CN_WEATHERSTATION.type as `type` FROM object_CN_WEATHERSTATION WHERE (( id = ? OR id = ?)  AND  object_CN_WEATHERSTATION.type IN ('object','variant','folder')) AND object_CN_WEATHERSTATION.published = 1 ORDER BY `altitude`    LIMIT 2
Parameters:
[
  null
  null
]
27 0.39 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:
[
  "weather.default_valley_station"
  null
  null
]
28 0.17 ms
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  35
]
29 0.33 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:
[
  "weather.default_mountain_station"
  null
  null
]
30 0.15 ms
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  34
]
31 0.14 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CN_WEATHERSTATION"
]
32 0.21 ms
SELECT * FROM object_relations_CN_WEATHERSTATION WHERE src_id = ?
Parameters:
[
  3840
]
33 0.14 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CN_WEATHERDAY"
]
34 0.42 ms
SELECT * FROM object_collection_Weather_CN_WEATHERDAY WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  3901
  "weatherData"
]
35 0.22 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  577
]
36 0.35 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  68
  577
  577
]
37 0.34 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  577
  577
]
38 0.30 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  68
  68
]
39 0.39 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  451
]
40 0.35 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  134
]
41 0.41 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  134
]
42 0.34 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  442
]
43 0.28 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  748
]
44 0.43 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  748
]
45 0.58 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  437
]
46 0.27 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  855
]
47 0.32 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  855
]
48 0.38 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  446
]
49 0.28 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  1579
]
50 0.43 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  1579
]
51 0.55 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  441
]
52 0.36 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  850
]
53 0.41 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  850
]
54 0.44 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  444
]
55 0.28 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3376
]
56 0.36 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3376
]
57 0.38 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  443
]
58 0.28 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  1168
]
59 0.40 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  1168
]
60 0.55 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  447
]
61 0.23 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4776
]
62 0.32 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4776
]
63 0.49 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  445
]
64 0.28 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  1146
]
65 0.43 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  1146
]
66 2.27 ms
SELECT object_localized_contwise_tour_en.id as id, object_localized_contwise_tour_en.type as `type` FROM object_localized_contwise_tour_en WHERE ( object_localized_contwise_tour_en.type IN ('object','variant','folder')) AND object_localized_contwise_tour_en.published = 1
Parameters:
[]
67 0.22 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "contwise_tour"
]
68 1.83 ms
SELECT object_localized_contwise_tour_en.id as id, object_localized_contwise_tour_en.type as `type` FROM object_localized_contwise_tour_en WHERE ( object_localized_contwise_tour_en.type IN ('object','variant','folder')) AND object_localized_contwise_tour_en.published = 1
Parameters:
[]
69 0.37 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  238
]
70 0.19 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "contwise_category"
]
71 0.34 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  239
]
72 0.27 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  240
]
73 0.22 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  241
]
74 0.22 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  242
]
75 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  243
]
76 0.17 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  244
]
77 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  245
]
78 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  246
]
79 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  247
]
80 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  248
]
81 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  249
]
82 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  250
]
83 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  251
]
84 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  252
]
85 0.16 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  253
]
86 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  254
]
87 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  255
]
88 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  256
]
89 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  257
]
90 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  258
]
91 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  259
]
92 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  260
]
93 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  261
]
94 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  262
]
95 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  263
]
96 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  264
]
97 0.28 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  265
]
98 0.23 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  266
]
99 0.21 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  267
]
100 0.21 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  268
]
101 0.21 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  269
]
102 0.22 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  270
]
103 0.21 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  271
]
104 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  272
]
105 0.19 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  273
]
106 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  274
]
107 0.26 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  275
]
108 0.21 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  276
]
109 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  277
]
110 0.22 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  279
]
111 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  280
]
112 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  281
]
113 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  282
]
114 0.22 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  283
]
115 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  284
]
116 0.19 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  285
]
117 0.19 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  286
]
118 0.21 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  287
]
119 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  288
]
120 0.24 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  289
]
121 0.39 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  290
]
122 0.34 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  291
]
123 0.35 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  293
]
124 0.34 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  294
]
125 0.33 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  295
]
126 0.35 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  296
]
127 0.33 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  297
]
128 0.33 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  298
]
129 0.31 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  299
]
130 0.23 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  300
]
131 0.23 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  301
]
132 0.20 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  302
]
133 0.19 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  303
]
134 0.16 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  304
]
135 0.18 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  305
]
136 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  306
]
137 0.13 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  307
]
138 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  308
]
139 0.12 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  309
]
140 0.12 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  310
]
141 0.12 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  311
]
142 0.13 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  312
]
143 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  313
]
144 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  314
]
145 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  315
]
146 0.16 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  316
]
147 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  317
]
148 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  318
]
149 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  319
]
150 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  320
]
151 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  321
]
152 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  322
]
153 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  323
]
154 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  324
]
155 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  325
]
156 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  326
]
157 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  327
]
158 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  328
]
159 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  329
]
160 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  330
]
161 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  331
]
162 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  332
]
163 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  333
]
164 0.33 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  334
]
165 0.28 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  335
]
166 0.22 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  336
]
167 0.16 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  337
]
168 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  338
]
169 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  339
]
170 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  340
]
171 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  341
]
172 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  342
]
173 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  343
]
174 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  344
]
175 0.15 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  345
]
176 0.16 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  346
]
177 0.14 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  347
]
178 0.12 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  348
]
179 0.12 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  349
]
180 0.11 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  350
]
181 0.35 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  351
]
182 0.13 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  352
]
183 0.10 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  353
]
184 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  354
]
185 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  355
]
186 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  356
]
187 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  357
]
188 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  358
]
189 0.08 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  359
]
190 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  360
]
191 0.08 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  361
]
192 0.08 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  362
]
193 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  363
]
194 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  364
]
195 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  365
]
196 0.13 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  366
]
197 0.10 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  367
]
198 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  368
]
199 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  369
]
200 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  370
]
201 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  6085
]
202 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  6086
]
203 0.09 ms
SELECT * FROM object_relations_contwise_tour WHERE src_id = ?
Parameters:
[
  6147
]
204 0.98 ms
SELECT object_localized_contwise_tour_en.id as id, object_localized_contwise_tour_en.type as `type` FROM object_localized_contwise_tour_en WHERE (( categories LIKE ?)  AND  object_localized_contwise_tour_en.type IN ('object','variant','folder')) AND object_localized_contwise_tour_en.published = 1 ORDER BY `title` ASC   LIMIT 24
Parameters:
[
  "%176%"
]
205 0.70 ms
SELECT COUNT(*) FROM object_localized_contwise_tour_en WHERE (( categories LIKE ?)  AND  object_localized_contwise_tour_en.type IN ('object','variant','folder')) AND object_localized_contwise_tour_en.published = 1
Parameters:
[
  "%176%"
]
206 0.68 ms
SELECT COUNT(*) FROM object_localized_contwise_tour_en WHERE (( categories LIKE ?)  AND  object_localized_contwise_tour_en.type IN ('object','variant','folder')) AND object_localized_contwise_tour_en.published = 1
Parameters:
[
  "%176%"
]
207 0.13 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
208 1.18 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/Snippets/"
  "footer"
]
209 0.19 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
210 0.36 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://partnerinfo.kleinwalsertal-dev.conecto.rocks/_fragment?_path=_locale=en&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction"
  "entire_uri"
]
211 0.21 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  520
]
212 0.21 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  23
]

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