Query Metrics

2307 Database Queries
184 Different statements
742.47 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
319.16 ms
(42.99%)
1275
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  3943
]
156.34 ms
(21.06%)
324
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  3943
]
6.09 ms
(0.82%)
20
SELECT * FROM properties WHERE ((cid IN (1,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4082
]
5.97 ms
(0.80%)
21
SELECT * FROM properties WHERE ((cid IN (1,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  3947
]
5.23 ms
(0.70%)
16
SELECT * FROM properties WHERE ((cid IN (1,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  9933
]
4.71 ms
(0.63%)
12
SELECT * FROM properties WHERE ((cid IN (1,16431,16386,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  26088
]
4.47 ms
(0.60%)
15
SELECT * FROM properties WHERE ((cid IN (1,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  19850
]
4.41 ms
(0.59%)
15
SELECT * FROM properties WHERE ((cid IN (1,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18571
]
4.22 ms
(0.57%)
11
SELECT * FROM properties WHERE ((cid IN (1,4192,4010,3944,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  7439
]
4.18 ms
(0.56%)
12
SELECT * FROM properties WHERE ((cid IN (1,9931,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  9966
]
4.18 ms
(0.56%)
24
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 5365351
]
4.17 ms
(0.56%)
35
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
4.13 ms
(0.56%)
13
SELECT * FROM properties WHERE ((cid IN (1,20130,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  20134
]
3.80 ms
(0.51%)
12
SELECT * FROM properties WHERE ((cid IN (1,18569,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18815
]
3.68 ms
(0.50%)
12
SELECT * FROM properties WHERE ((cid IN (1,3947,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10547
]
3.54 ms
(0.48%)
11
SELECT * FROM properties WHERE ((cid IN (1,8322,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8326
]
3.19 ms
(0.43%)
10
SELECT * FROM properties WHERE ((cid IN (1,8199,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8200
]
3.16 ms
(0.43%)
10
SELECT * FROM properties WHERE ((cid IN (1,18572,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18618
]
3.10 ms
(0.42%)
9
SELECT * FROM properties WHERE ((cid IN (1,8326,8322,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8386
]
2.81 ms
(0.38%)
9
SELECT * FROM properties WHERE ((cid IN (1,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16435
]
2.73 ms
(0.37%)
9
SELECT * FROM properties WHERE ((cid IN (1,10872,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10882
]
2.71 ms
(0.37%)
9
SELECT * FROM properties WHERE ((cid IN (1,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16390
]
2.68 ms
(0.36%)
8
SELECT * FROM properties WHERE ((cid IN (1,20135,20130,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  20151
]
2.62 ms
(0.35%)
7
SELECT * FROM properties WHERE ((cid IN (1,16388,16386,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  36476
]
2.57 ms
(0.35%)
8
SELECT * FROM properties WHERE ((cid IN (1,19850,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  19867
]
2.57 ms
(0.35%)
7
SELECT * FROM properties WHERE ((cid IN (1,20136,20130,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  20163
]
2.51 ms
(0.34%)
8
SELECT * FROM properties WHERE ((cid IN (1,16392,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16396
]
2.48 ms
(0.33%)
7
SELECT * FROM properties WHERE ((cid IN (1,4864,4116,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5491
]
2.46 ms
(0.33%)
14
SELECT * FROM properties WHERE cid = ? AND ctype='document'
Parameters:
[
  3975
]
2.23 ms
(0.30%)
6
SELECT * FROM object_collection_demiLink_localized_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  9624503
  "links"
  0
]
2.14 ms
(0.29%)
7
SELECT * FROM properties WHERE ((cid IN (1,4669,4115,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5012
]
2.13 ms
(0.29%)
6
SELECT * FROM properties WHERE ((cid IN (1,4616,4117,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5076
]
2.12 ms
(0.29%)
6
SELECT * FROM properties WHERE ((cid IN (1,5298,4117,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5455
]
2.12 ms
(0.28%)
6
SELECT * FROM properties WHERE ((cid IN (1,8324,8322,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8817
]
2.11 ms
(0.28%)
7
SELECT * FROM properties WHERE ((cid IN (1,4676,4115,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5276
]
1.99 ms
(0.27%)
6
SELECT * FROM properties WHERE ((cid IN (1,36776,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  36778
]
1.96 ms
(0.26%)
6
SELECT * FROM properties WHERE ((cid IN (1,4086,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4466
]
1.90 ms
(0.26%)
6
SELECT * FROM properties WHERE ((cid IN (1,3971,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4074
]
1.88 ms
(0.25%)
6
SELECT * FROM properties WHERE ((cid IN (1,18621,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18741
]
1.70 ms
(0.23%)
6
SELECT * FROM properties WHERE ((cid IN (1,4115,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4671
]
1.70 ms
(0.23%)
5
SELECT * FROM properties WHERE ((cid IN (1,8208,8199,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8227
]
1.69 ms
(0.23%)
5
SELECT * FROM properties WHERE ((cid IN (1,34012,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  34013
]
1.68 ms
(0.23%)
5
SELECT * FROM properties WHERE ((cid IN (1,18815,18569,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18867
]
1.68 ms
(0.23%)
5
SELECT * FROM properties WHERE ((cid IN (1,4117,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4615
]
1.68 ms
(0.23%)
5
SELECT * FROM properties WHERE ((cid IN (1,4116,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4863
]
1.66 ms
(0.22%)
5
SELECT * FROM properties WHERE ((cid IN (1,19853,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  19888
]
1.64 ms
(0.22%)
5
SELECT * FROM properties WHERE ((cid IN (1,4118,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4762
]
1.58 ms
(0.21%)
5
SELECT * FROM properties WHERE ((cid IN (1,16429,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16570
]
1.51 ms
(0.20%)
17
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.41 ms
(0.19%)
4
SELECT * FROM properties WHERE ((cid IN (1,4866,4116,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5412
]
1.36 ms
(0.18%)
4
SELECT * FROM properties WHERE ((cid IN (1,20134,20130,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  20173
]
1.35 ms
(0.18%)
4
SELECT * FROM properties WHERE ((cid IN (1,8202,8199,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8224
]
1.33 ms
(0.18%)
4
SELECT * FROM properties WHERE ((cid IN (1,33990,33971,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  33991
]
1.33 ms
(0.18%)
4
SELECT * FROM properties WHERE ((cid IN (1,33973,33971,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  33976
]
1.25 ms
(0.17%)
3
SELECT * FROM properties WHERE ((cid IN (1,26088,16431,16386,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  34112
]
1.25 ms
(0.17%)
3
SELECT * FROM properties WHERE ((cid IN (1,4015,3944,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8849
]
1.20 ms
(0.16%)
4
SELECT * FROM properties WHERE ((cid IN (1,4675,4115,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5185
]
1.20 ms
(0.16%)
4
SELECT * FROM properties WHERE ((cid IN (1,4674,4115,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5072
]
1.17 ms
(0.16%)
3
SELECT * FROM properties WHERE ((cid IN (1,36790,36785,36776,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  36821
]
1.13 ms
(0.15%)
3
SELECT * FROM properties WHERE ((cid IN (1,4762,4118,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5498
]
1.06 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,4615,4117,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5297
]
1.06 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,4759,4118,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5409
]
1.04 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,18616,18572,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18648
]
1.02 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,18585,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18624
]
1.02 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,18580,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18757
]
1.01 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,18587,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18607
]
1.01 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,18582,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18669
]
1.01 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,32260,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  32261
]
1.01 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,18584,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18751
]
1.01 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,29352,18569,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  29355
]
1.01 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,18583,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18677
]
1.00 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,18589,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18754
]
1.00 ms
(0.14%)
3
SELECT * FROM properties WHERE ((cid IN (1,18586,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18770
]
1.00 ms
(0.13%)
3
SELECT * FROM properties WHERE ((cid IN (1,18581,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18627
]
1.00 ms
(0.13%)
3
SELECT * FROM properties WHERE ((cid IN (1,18619,18572,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18646
]
1.00 ms
(0.13%)
3
SELECT * FROM properties WHERE ((cid IN (1,8200,8199,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8232
]
1.00 ms
(0.13%)
1
SELECT COUNT(*) FROM object_localized_Region_en 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_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1
Parameters:
[
  "demiRegionId" => "%,11507%"
]
0.99 ms
(0.13%)
3
SELECT * FROM properties WHERE ((cid IN (1,4085,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4312
]
0.99 ms
(0.13%)
3
SELECT * FROM properties WHERE ((cid IN (1,10879,10872,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10919
]
0.95 ms
(0.13%)
3
SELECT * FROM properties WHERE ((cid IN (1,16390,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16421
]
0.95 ms
(0.13%)
3
SELECT * FROM properties WHERE ((cid IN (1,18571,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18582
]
0.77 ms
(0.10%)
1
SELECT object_localized_Region_en.o_id as o_id, object_localized_Region_en.o_type as o_type FROM object_localized_Region_en 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_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1 LIMIT 1
Parameters:
[
  "demiRegionId" => "%,11507%"
]
0.76 ms
(0.10%)
2
SELECT * FROM properties WHERE ((cid IN (1,16386,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16431
]
0.76 ms
(0.10%)
2
SELECT * FROM properties WHERE ((cid IN (1,9975,9931,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10173
]
0.74 ms
(0.10%)
2
SELECT * FROM properties WHERE ((cid IN (1,9970,9931,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10112
]
0.74 ms
(0.10%)
1
SELECT o_id from object_43 WHERE o_id in (select src_id from object_relations_43 where
            dest_id in (select dest_id from object_relations_44 where src_id = 46190043) and fieldname = 'products')
Parameters:
[]
0.74 ms
(0.10%)
2
SELECT * FROM properties WHERE ((cid IN (1,38751,9931,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  38752
]
0.73 ms
(0.10%)
2
SELECT * FROM properties WHERE ((cid IN (1,29374,9931,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  29375
]
0.73 ms
(0.10%)
2
SELECT * FROM properties WHERE ((cid IN (1,36785,36776,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  36805
]
0.71 ms
(0.10%)
2
SELECT * FROM properties WHERE ((cid IN (1,4863,4116,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5407
]
0.70 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,19888,19853,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  19954
]
0.69 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,4074,3971,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4431
]
0.68 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,18634,18569,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18820
]
0.67 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,26367,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  25902
]
0.67 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,18633,18569,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18834
]
0.67 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,19917,19858,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  20080
]
0.65 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,26974,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  27178
]
0.65 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,4089,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4793
]
0.64 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,25928,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  25934
]
0.64 ms
(0.09%)
2
SELECT * FROM properties WHERE ((cid IN (1,18570,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18604
]
0.63 ms
(0.08%)
2
SELECT * FROM properties WHERE ((cid IN (1,33971,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  33973
]
0.62 ms
(0.08%)
2
SELECT * FROM properties WHERE ((cid IN (1,3944,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4016
]
0.61 ms
(0.08%)
1
SELECT * FROM properties WHERE ((cid IN (1,36781,36776,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  36810
]
0.61 ms
(0.08%)
2
SELECT * FROM properties WHERE ((cid IN (1,3969,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4103
]
0.61 ms
(0.08%)
2
SELECT * FROM properties WHERE ((cid IN (1,3966,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4029
]
0.60 ms
(0.08%)
2
SELECT * FROM properties WHERE ((cid IN (1,4673,4115,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5048
]
0.58 ms
(0.08%)
1
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" => "/en/Plan-your-holiday/Search-book-accommodation/Hotel-Montestyria-Chalets-Suiten-hotel-Mariazell_ad-9624503/Das-Mariazellerland-mit-dem-E-Bike-erleben_p-46190043"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation/Hotel-Montestyria-Chalets-Suiten-hotel-Mariazell_ad-9624503/Das-Mariazellerland-mit-dem-E-Bike-erleben_p-46190043?activeTab=#rooms?????????????????????????????????????????????????????????????????????????????????"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation/Hotel-Montestyria-Chalets-Suiten-hotel-Mariazell_ad-9624503/Das-Mariazellerland-mit-dem-E-Bike-erleben_p-46190043?activeTab=#rooms?????????????????????????????????????????????????????????????????????????????????"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.58 ms
(0.08%)
2
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
]
0.58 ms
(0.08%)
2
SELECT * FROM properties WHERE ((cid IN (1,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4116
]
0.48 ms
(0.07%)
4
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.40 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,9976,9971,9931,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10134
]
0.39 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,4197,4010,3944,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4181
]
0.38 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,9968,9931,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10109
]
0.38 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,9947,9930,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10052
]
0.38 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,18862,18641,18569,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  38868
]
0.38 ms
(0.05%)
3
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Das-Mariazellerland-mit-dem-E-Bike-erleben_p-46190043"
  "path" => "/steiermark.com/en/Plan-your-holiday/Search-book-accommodation/Hotel-Montestyria-Chalets-Suiten-hotel-Mariazell_ad-9624503/"
]
0.38 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,8396,8326,8322,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8912
]
0.38 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,8385,8326,8322,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  9014
]
0.38 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,25906,26367,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  25907
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,9971,9931,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  9976
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,36782,36776,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  36796
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,34013,34012,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  34020
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,34015,34012,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  34021
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,34014,34012,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  34022
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,32261,32260,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  32264
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,25902,26367,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  25903
]
0.37 ms
(0.05%)
2
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/%"
  "/en/Plan-your-holiday/Search-book-accommodation/Hotel-Montestyria-Chalets-Suiten-hotel-Mariazell_ad-9624503/Das-Mariazellerland-mit-dem-E-Bike-erleben_p-46190043"
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,34016,34012,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  34018
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,8217,8202,8199,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8234
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,34017,34012,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  34019
]
0.37 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,29353,29352,18569,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  29356
]
0.36 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,9940,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  9958
]
0.36 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,8340,8322,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8357
]
0.36 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,18749,18610,18572,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18848
]
0.36 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,16433,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16576
]
0.36 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,4093,4085,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4730
]
0.36 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,21414,19917,19858,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  21416
]
0.35 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,20080,19917,19858,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  20107
]
0.35 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,38898,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  38900
]
0.35 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,8336,8322,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  9286
]
0.35 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,18620,18572,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18830
]
0.35 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,18612,18572,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18797
]
0.35 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,9937,9929,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  9965
]
0.35 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,24971,8199,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  24972
]
0.35 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,4084,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8988
]
0.35 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,20137,20130,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  20148
]
0.34 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,20131,20130,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  20150
]
0.34 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,18622,18572,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18715
]
0.34 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,29062,18569,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  29063
]
0.34 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,18610,18572,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18749
]
0.34 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,18618,18572,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18750
]
0.34 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,16438,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16490
]
0.34 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,4079,3971,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10192
]
0.34 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,16572,16387,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16577
]
0.34 ms
(0.05%)
1
SELECT * FROM properties WHERE ((cid IN (1,10882,10872,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10912
]
0.34 ms
(0.05%)
2
SELECT id FROM sites
Parameters:
[]
0.33 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,4082,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10194
]
0.33 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,4102,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  9281
]
0.33 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,10878,10872,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  10916
]
0.33 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,4096,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  7373
]
0.33 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,4083,3962,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4517
]
0.32 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,18573,18566,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  18590
]
0.32 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,36251,10872,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  36256
]
0.32 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,19858,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  19917
]
0.32 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,16393,16384,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  16408
]
0.32 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,19852,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  20128
]
0.32 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,19851,19847,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  19871
]
0.31 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,4671,4115,3974,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  5184
]
0.31 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,3946,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  4033
]
0.31 ms
(0.04%)
1
SELECT * FROM properties WHERE ((cid IN (1,3965,3943,1430) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  7335
]
0.31 ms
(0.04%)
2
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:
[
  3960
]
0.30 ms
(0.04%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.24 ms
(0.03%)
1
SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  9624503
  "addresses"
]
0.24 ms
(0.03%)
2
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/steiermark.com/en/Plan-your-holiday/Search-book-accommodation/Hotel-Montestyria-Chalets-Suiten-hotel-Mariazell_ad-9624503/Das-Mariazellerland-mit-dem-E-Bike-erleben_p-46190043"
]
0.23 ms
(0.03%)
1
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[
  "key" => "customer"
  "path" => "/deskline/"
]
0.22 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.22 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.20 ms
(0.03%)
1
SELECT * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  9624503
  "links"
]
0.16 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.15 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.14 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]

demi_vacancies connection

Time Count Info
26.46 ms
(3.56%)
1
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 (9624503)
                  AND pt.product_id IN (46190031)
                   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:
[]
26.30 ms
(3.54%)
1
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 (46190031)
                       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:
[]
0.93 ms
(0.13%)
1
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id, hpMasters.src_id hpMaster_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  INNER JOIN `steiermark`.object_relations_44 hpMasters ON hpMasters.dest_id = products.oo_id  WHERE  products.oo_id IN (46190031) AND dacco.oo_id IN (9624503)  AND  dacco.o_published = 1  AND (products.o_published = 1  AND products.productType = 'Package') AND (
                products.oo_id  IN (SELECT DISTINCT o_id FROM `steiermark`.object_collection_demiDate_6
                WHERE  `to` > 1727872121) OR validDatesType = 'Always'
            )  AND hpMasters.src_id in (select o_id from `steiermark`.object_44 where o_published = 1 and active=1) GROUP BY product_id  ORDER BY dacco.bookable DESC, RAND(1)
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.