Query Metrics
98
Database Queries
33
Different statements
174.48 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
5.99 ms (3.43%) |
27 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 1058282 ] |
4.18 ms (2.40%) |
4 |
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
Parameters:
[ "dcValue1" => "Standard" ":templateIds" => [ 48697684 40039292 40039293 43119066 40039053 40361231 40694043 40039290 40148652 51668324 51401916 40039052 40039286 40039288 40039289 51098090 51192877 43119070 40039049 40039284 40039047 48880942 44116979 49620758 40039281 40039280 49242561 40039278 40039279 40067864 48014709 51668340 50998603 48922862 51668343 48306466 49200277 42788083 48552838 40039295 49523636 40039296 49620768 40039297 40039055 51811256 51924509 ] ] |
3.00 ms (1.72%) |
18 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
1.84 ms (1.06%) |
4 |
SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39126422 "facilities" ] |
1.11 ms (0.63%) |
5 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
0.86 ms (0.50%) |
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.83 ms (0.48%) |
4 |
SELECT id FROM sites
Parameters:
[] |
0.77 ms (0.44%) |
1 |
SELECT COUNT(*) FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE :demiRegionId AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[ "demiRegionId" => "%,11467%" ] |
0.73 ms (0.42%) |
2 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
5970
]
|
0.56 ms (0.32%) |
4 |
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
Parameters:
[ "dcValue1" => 39126425 ] |
0.53 ms (0.30%) |
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" => "/de/Region-Graz/Urlaub-planen/Unterkuenfte/Harry-s-Home-Hotel-Hart-bei-Graz-Hotel-Hart-bei-Graz_ad-39126410" "sourcePathQuery" => "/de/Region-Graz/Urlaub-planen/Unterkuenfte/Harry-s-Home-Hotel-Hart-bei-Graz-Hotel-Hart-bei-Graz_ad-39126410?nearbySearchId=324802&nearbySearchLat=47.05047&nearbySearchLong=16.07622&sorting=nearbySearchAsc" "sourceEntireUri" => "https://stage.steiermark.com/de/Region-Graz/Urlaub-planen/Unterkuenfte/Harry-s-Home-Hotel-Hart-bei-Graz-Hotel-Hart-bei-Graz_ad-39126410?nearbySearchId=324802&nearbySearchLat=47.05047&nearbySearchLong=16.07622&sorting=nearbySearchAsc" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
0.46 ms (0.27%) |
1 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE :demiRegionId AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1 LIMIT 1
Parameters:
[ "demiRegionId" => "%,11467%" ] |
0.43 ms (0.25%) |
1 |
SELECT * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39126410 "links" ] |
0.41 ms (0.24%) |
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:
[
39126410
]
|
0.32 ms (0.18%) |
1 |
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:
[ 39126410 "links" 0 ] |
0.29 ms (0.17%) |
1 |
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 5882750 "datepickerInfoTexts" ] |
0.27 ms (0.15%) |
1 |
SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 39126410 "addresses" ] |
0.27 ms (0.15%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
5970
]
|
0.23 ms (0.13%) |
2 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Harry-s-Home-Hotel-Hart-bei-Graz-Hotel-Hart-bei-Graz_ad-39126410" "path" => "/steiermark.com/de/Region-Graz/Urlaub-planen/Unterkuenfte/" ] |
0.20 ms (0.12%) |
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" => 39126410 "dcValue2" => "serviceProvider" "dcValue3" => "sections" ] |
0.18 ms (0.10%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
0.17 ms (0.10%) |
1 |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "customer" "path" => "/deskline/" ] |
0.17 ms (0.10%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 5970 5970 5970 ] |
0.14 ms (0.08%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
0.14 ms (0.08%) |
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/%" "/de/Region-Graz/Urlaub-planen/Unterkuenfte/Harry-s-Home-Hotel-Hart-bei-Graz-Hotel-Hart-bei-Graz_ad-39126410" ] |
0.12 ms (0.07%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 13974 13974 ] |
0.12 ms (0.07%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/steiermark.com/de/Region-Graz/Urlaub-planen/Unterkuenfte/Harry-s-Home-Hotel-Hart-bei-Graz-Hotel-Hart-bei-Graz_ad-39126410" ] |
0.07 ms (0.04%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
demi_vacancies connection
Time▼ | Count | Info |
---|---|---|
81.09 ms (46.47%) |
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 (39126410) 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:
[] |
38.16 ms (21.87%) |
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 (39126425,39126441,39126433,39126449) 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.17 ms (15.57%) |
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 (39126410) AND pt.product_id IN (39126425,39126441,39126433,39126449) 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:
[] |
2.95 ms (1.69%) |
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 (39126425,39126433,39126449,39126441) AND dacco.oo_id IN (39126410) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11494)) GROUP BY product_id ORDER BY RAND(184)
Parameters:
[] |
0.71 ms (0.41%) |
1 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (39126410) 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.