Query Metrics
2290
Database Queries
183
Different statements
739.13 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
319.16 ms (43.18%) |
1275 |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
3943
]
|
156.34 ms (21.15%) |
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.81%) |
21 |
SELECT * FROM properties WHERE ((cid IN (1,3943,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
3947
]
|
5.23 ms (0.71%) |
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.64%) |
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.60%) |
15 |
SELECT * FROM properties WHERE ((cid IN (1,18566,3943,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
18571
]
|
4.18 ms (0.57%) |
12 |
SELECT * FROM properties WHERE ((cid IN (1,9931,9929,3943,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
9966
]
|
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.78 ms (0.51%) |
10 |
SELECT * FROM properties WHERE ((cid IN (1,4192,4010,3944,3943,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
7439
]
|
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.41 ms (0.46%) |
20 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5365351 ] |
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
]
|
3.09 ms (0.42%) |
27 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
4084
]
|
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.34%) |
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.29%) |
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.29%) |
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.14%) |
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.14%) |
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.14%) |
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.09%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,33971,16384,3943,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
33973
]
|
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.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.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%) |
3 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
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.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.28 ms (0.04%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,3944,3943,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
4016
]
|
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
]
|
0.13 ms (0.02%) |
1 |
SELECT id FROM sites
Parameters:
[] |
demi_vacancies connection
Time▼ | Count | Info |
---|---|---|
26.46 ms (3.58%) |
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.56%) |
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.