Query Metrics
8884
Database Queries
54
Different statements
1376.66 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
162.90 ms (11.83%) |
1075 |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 44503290 "prices" ] |
155.82 ms (11.32%) |
1075 |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 44503290 "mealTypes" ] |
152.90 ms (11.11%) |
1075 |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 44503290 "periods" ] |
142.44 ms (10.35%) |
1075 |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 44503290 "prices" ] |
138.64 ms (10.07%) |
1087 |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
44503290
]
|
130.57 ms (9.48%) |
1075 |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
44503290
]
|
104.46 ms (7.59%) |
1087 |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
44503290
]
|
101.50 ms (7.37%) |
1075 |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
44503290
]
|
16.68 ms (1.21%) |
15 |
SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds))
Parameters:
[ "dcValue1" => 1729653355 ":templateIds" => [ 51617792 51617793 51569921 51426069 51186955 51092034 50946365 50718438 50656271 50609334 50325942 50325945 50325948 50325950 50279382 50279385 50231101 50184263 49949088 49660011 49615229 49146056 48967263 48875854 48875855 48594704 47960914 47960916 47865334 47865337 47865340 47865341 47865347 47495039 47403676 47403677 46927189 46833383 46833386 46833387 46833390 46743671 46743672 46743673 46743675 46743676 44503280 44503281 44503287 47585970 44503290 44503291 44503292 44503293 44503294 44503300 44503302 44503304 44503306 44503325 44503327 44503329 44503330 46743682 44503332 13169088 51760004 51805384 51805385 51805386 51862130 51862133 51918471 51918472 ] ] |
13.61 ms (0.99%) |
15 |
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
Parameters:
[ "dcValue1" => "Standard" ":templateIds" => [ 51617792 51617793 51569921 51426069 51186955 51092034 50946365 50718438 50656271 50609334 50325942 50325945 50325948 50325950 50279382 50279385 50231101 50184263 49949088 49660011 49615229 49146056 48967263 48875854 48875855 48594704 47960914 47960916 47865334 47865337 47865340 47865341 47865347 47495039 47403676 47403677 46927189 46833383 46833386 46833387 46833390 46743671 46743672 46743673 46743675 46743676 44503280 44503281 44503287 47585970 44503290 44503291 44503292 44503293 44503294 44503300 44503302 44503304 44503306 44503325 44503327 44503329 44503330 46743682 44503332 13169088 51760004 51805384 51805385 51805386 51862130 51862133 51918471 51918472 ] ] |
12.48 ms (0.91%) |
82 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 5535153 ] |
6.48 ms (0.47%) |
31 |
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
Parameters:
[ "dcValue1" => 13169079 ] |
3.16 ms (0.23%) |
17 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
2.87 ms (0.21%) |
21 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
1.35 ms (0.10%) |
5 |
SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 13169070 "facilities" ] |
1.27 ms (0.09%) |
4 |
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:
[ 13169002 "links" 0 ] |
1.22 ms (0.09%) |
10 |
SELECT * FROM object_relations_23 WHERE src_id = ?
Parameters:
[
13169072
]
|
1.09 ms (0.08%) |
2 |
SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE (fid='' AND object_52.o_type IN ('object')) AND object_52.o_published = 1 ORDER BY `o_published` DESC LIMIT 2
Parameters:
[] |
1.08 ms (0.08%) |
10 |
SELECT * FROM object_store_23 WHERE oo_id = ?
Parameters:
[
13169072
]
|
0.90 ms (0.07%) |
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" => "%,11462%" ] |
0.84 ms (0.06%) |
5 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
9975
]
|
0.69 ms (0.05%) |
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.04%) |
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" => "%,11462%" ] |
0.57 ms (0.04%) |
1 |
SELECT object_62.o_id as o_id, object_62.o_type as o_type FROM object_62 WHERE (`salutationLanguage` = 'en' AND object_62.o_type IN ('object','folder')) AND object_62.o_published = 1
Parameters:
[] |
0.56 ms (0.04%) |
4 |
SELECT id FROM sites
Parameters:
[] |
0.44 ms (0.03%) |
1 |
SELECT objectRelations.src_id FROM object_relations_55 objectRelations WHERE (objectRelations.dest_id IN (SELECT objectRelationsPSection.src_id FROM object_relations_57 objectRelationsPSection WHERE (objectRelationsPSection.dest_id = :dcValue1) AND (objectRelationsPSection.fieldname = :dcValue2))) AND (objectRelations.fieldname = :dcValue3)
Parameters:
[ "dcValue1" => 13169002 "dcValue2" => "serviceProvider" "dcValue3" => "sections" ] |
0.43 ms (0.03%) |
1 |
SELECT * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 13169002 "links" ] |
0.41 ms (0.03%) |
1 |
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,5815,5673,5670) AND inheritable = 1) OR cid = ? ) AND ctype='object'
Parameters:
[
13169002
]
|
0.40 ms (0.03%) |
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/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/MONDI-Appartements-am-Grundlsee-hotel-Grundlsee_ad-13169002" "sourcePathQuery" => "/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/MONDI-Appartements-am-Grundlsee-hotel-Grundlsee_ad-13169002?locale=en" "sourceEntireUri" => "https://stage.steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/MONDI-Appartements-am-Grundlsee-hotel-Grundlsee_ad-13169002?locale=en" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
0.33 ms (0.02%) |
1 |
SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 13169002 "addresses" ] |
0.26 ms (0.02%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
0.26 ms (0.02%) |
2 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "MONDI-Appartements-am-Grundlsee-hotel-Grundlsee_ad-13169002" "path" => "/steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/" ] |
0.25 ms (0.02%) |
1 |
SELECT * FROM object_localized_data_MediaCopyright WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
12905728
]
|
0.24 ms (0.02%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
9975
]
|
0.22 ms (0.02%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 9667 9975 9975 ] |
0.20 ms (0.01%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 9975 9975 ] |
0.18 ms (0.01%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
0.16 ms (0.01%) |
1 |
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 5882747 "datepickerInfoTexts" ] |
0.15 ms (0.01%) |
1 |
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/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/MONDI-Appartements-am-Grundlsee-hotel-Grundlsee_ad-13169002" ] |
0.14 ms (0.01%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
0.13 ms (0.01%) |
1 |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "customer" "path" => "/deskline/" ] |
0.11 ms (0.01%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/MONDI-Appartements-am-Grundlsee-hotel-Grundlsee_ad-13169002" ] |
0.10 ms (0.01%) |
1 |
SELECT * FROM object_relations_MediaCopyright WHERE src_id = ?
Parameters:
[
12905728
]
|
0.10 ms (0.01%) |
1 |
SELECT * FROM object_store_79 WHERE oo_id = ?
Parameters:
[
13041129
]
|
0.10 ms (0.01%) |
1 |
SELECT * FROM object_relations_79 WHERE src_id = ?
Parameters:
[
13041129
]
|
0.08 ms (0.01%) |
1 |
SELECT * FROM object_store_MediaCopyright WHERE oo_id = ?
Parameters:
[
12905728
]
|
demi_vacancies connection
Time▼ | Count | Info |
---|---|---|
87.22 ms (6.34%) |
2 |
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 (13169002) 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:
[] |
39.84 ms (2.89%) |
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 (13169079,13169390,13169407,13169357,13169154,13169582,13169418,13169137,13169610,13169599,13169346,13169095,13169329,13169164,13169106) 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:
[] |
30.77 ms (2.24%) |
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 (13169002) AND pt.product_id IN (13169079,13169390,13169407,13169357,13169154,13169582,13169418,13169137,13169610,13169599,13169346,13169095,13169329,13169164,13169106) 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:
[] |
27.19 ms (1.98%) |
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 (13169002) AND pt.product_id IN (49681471) 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:
[] |
27.16 ms (1.97%) |
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 (49681471) AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id) order by minPrice
Parameters:
[] |
3.13 ms (0.23%) |
2 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId WHERE products.oo_id IN (13169610,13169599,13169582,13169164,13169137,13169154,13169329,13169357,13169346,13169407,13169390,13169418,13169106,13169079,13169095,49681471) AND dacco.oo_id IN (13169002) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11463)) GROUP BY product_id ORDER BY RAND(587)
Parameters:
[] |
1.21 ms (0.09%) |
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 (49681471) AND dacco.oo_id IN (13169002) 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` > 1729653355) 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:
[] |
0.79 ms (0.06%) |
1 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (13169002) AND dacco.o_published = 1 GROUP BY dacco.oo_id
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.