Query Metrics
32
Database Queries
15
Different statements
12.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.48 ms (19.17%) |
9 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/vcloud/v1/webhook/" "update" ] |
|
2.37 ms (18.27%) |
2 |
"COMMIT"
Parameters:
[] |
|
2.04 ms (15.78%) |
1 |
UPDATE conecto_synchronizer_queue SET status = ? WHERE priority = ?
Parameters:
[ 1 -5 ] |
|
1.61 ms (12.42%) |
8 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/vcloud/v1/webhook/update"
]
|
|
1.00 ms (7.72%) |
1 |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/vcloud/v1/webhook/update" "path" "auto_create" "/vcloud/v1/webhook/update" "path_query" "https://montafon-staging.conecto.rocks/vcloud/v1/webhook/update" "entire_uri" ] |
|
0.71 ms (5.49%) |
1 |
INSERT INTO conecto_synchronizer_queue (type, priority, label, data, id, status, created_at) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "CONECTO\SynchronizerBundle\Messenger\PrioritySyncTask" -5 "import Pois" "O:53:"CONECTO\SynchronizerBundle\Messenger\PrioritySyncTask":6:{s:54:"\x00CONECTO\SynchronizerBundle\Messenger\MyTask\x00reference";s:45:"priority_fc309404-89f4-4576-8b48-c867521c0979";s:8:"instance";N;s:52:"\x00CONECTO\SynchronizerBundle\Messenger\MyTask\x00message";a:12:{s:3:"@id";s:36:"fc309404-89f4-4576-8b48-c867521c0979";s:8:"@context";a:2:{i:0;s:19:"https://schema.org/";i:1;a:10:{s:5:"@base";s:45:"https://v-cloud.montafon.at/api/v4/universal/";s:4:"skos";s:52:"https://www.w3.org/2009/08/skos-reference/skos.html#";s:3:"dct";s:25:"http://purl.org/dc/terms/";s:2:"cc";s:30:"http://creativecommons.org/ns#";s:2:"dc";s:28:"https://schema.datacycle.at/";s:4:"dcls";s:35:"https://v-cloud.montafon.at/schema/";s:2:"og";s:18:"https://ogp.me/ns#";s:4:"odta";s:20:"https://odta.io/voc/";s:3:"sdm";s:28:"https://smartdatamodels.org/";s:4:"alps";s:94:"http://json-schema.org/draft-07/schema/destinationdata/schemas/2022-04/datatypes#/definitions/";}}s:5:"@type";a:3:{i:0;s:5:"Place";i:1;s:17:"TouristAttraction";i:2;s:22:"dcls:TouristAttraction";}s:15:"dc:multilingual";b:1;s:14:"dc:translation";a:2:{i:0;s:2:"de";i:1;s:2:"en";}s:17:"dc:classification";a:4:{i:0;a:12:{s:3:"@id";s:36:"8150e05e-1511-4a85-b552-a6c585776c6c";s:5:"@type";s:12:"skos:Concept";s:15:"dc:multilingual";b:1;s:14:"dc:translation";a:1:{i:0;s:2:"de";}s:12:"dc:entityUrl";s:150:"https://v-cloud.montafon.at/api/v4/concept_schemes/b2e5d379-59db-442e-ad55-7dce6203f407/concepts/8150e05e-1511-4a85-b552-a6c585776c6c?language=de%2Cen";s:14:"skos:prefLabel";a:1:{i:0;a:2:{s:9:"@language";s:2:"de";s:6:"@value";s:19:"Gemeinde Tschagguns";}}s:3:"url";s:37:"https://www.wikidata.org/wiki/Q478260";s:13:"skos:inScheme";a:2:{s:3:"@id";s:36:"b2e5d379-59db-442e-ad55-7dce6203f407";s:5:"@type";s:18:"skos:ConceptScheme";}s:12:"skos:broader";a:2:{s:3:"@id";s:36:"92216bbd-5986-4aa1-ac09-b268600eeb11";s:5:"@type";s:12:"skos:Concept";}s:14:"skos:ancestors";a:3:{i:0;a:2:{s:3:"@id";s:36:"92216bbd-5986-4aa1-ac09-b268600eeb11";s:5:"@type";s:12:"skos:Concept";}i:1;a:2:{s:3:"@id";s:36:"b469ffc1-77db-48ae-8ae0-325aaa105c97";s:5:"@type";s:12:"skos:Concept";}i:2;a:2:{s:3:"@id";s:36:"7863a8f2-b3ff-47f4-a33b-7c9f1ae15f6b";s:5:"@type";s:12:"skos:Concept";}}s:11:"dct:created";s:29:"2024-03-13T22:26:33.303+01:00";s:12:"dct:modified";s:29:"2024-03-13T22:26:33.303+01:00";}i:1;a:10:{s:3:"@id";s:36:"9aea5821-505e-471b-8116-b3d2ed90dc6a";s:5:"@type";s:12:"skos:Concept";s:15:"dc:multilingual";b:1;s:14:"dc:translation";a:1:{i:0;s:2:"de";}s:12:"dc:entityUrl";s:150:"https://v-cloud.montafon.at/api/v4/concept_schemes/7de38f7b-87e4-46ab-addc-9c6af94c66a0/concepts/9aea5821-505e-471b-8116-b3d2ed90dc6a?language=de%2Cen";s:14:"skos:prefLabel";a:1:{i:0;a:2:{s:9:"@language";s:2:"de";s:6:"@value";s:7:"Aktuell";}}s:13:"skos:inScheme";a:2:{s:3:"@id";s:36:"7de38f7b-87e4-46ab-addc-9c6af94c66a0";s:5:"@type";s:18:"skos:ConceptScheme";}s:17:"skos:topConceptOf";a:2:{s:3:"@id";s:36:"7de38f7b-87e4-46ab-addc-9c6af94c66a0";s:5:"@type";s:18:"skos:ConceptScheme";}s:11:"dct:created";s:29:"2024-02-15T15:47:14.154+01:00";s:12:"dct:modified";s:29:"2026-02-19T13:53:18.612+01:00";}i:2;a:11:{s:3:"@id";s:36:"a88c97ff-80fe-476d-b49a-66931ee73f07";s:5:"@type";s:12:"skos:Concept";s:15:"dc:multilingual";b:1;s:14:"dc:translation";a:1:{i:0;s:2:"de";}s:12:"dc:entityUrl";s:150:"https://v-cloud.montafon.at/api/v4/concept_schemes/420fe8ea-d6a6-4d19-97be-e3d191a16d0e/concepts/a88c97ff-80fe-476d-b49a-66931ee73f07?language=de%2Cen";s:14:"skos:prefLabel";a:1:{i:0;a:2:{s:9:"@language";s:2:"de";s:6:"@value";s:2:"AT";}}s:15:"dct:description";a:1:{i:0;a:2:{s:9:"@language";s:2:"de";s:6:"@value";s:11:"Österreich";}}s:13:"skos:inScheme";a:2:{s:3:"@id";s:36:"420fe8ea-d6a6-4d19-97be-e3d191a16d0e";s:5:"@type";s:18:"skos:ConceptScheme";}s:17:"skos:topConceptOf";a:2:{s:3:"@id";s:36:"420fe8ea-d6a6-4d19-97be-e3d191a16d0e";s:5:"@type";s:18:"skos:ConceptScheme";}s:11:"dct:created";s:29:"2024-02-15T15:47:11.239+01:00";s:12:"dct:modified";s:29:"2025-01-09T07:44:19.902+01:00";}i:3;a:11:{s:3:"@id";s:36:"41d3d7ee-4099-42ae-88ec-32cb6ddb3f79";s:5:"@type";s:12:"skos:Concept";s:15:"dc:multilingual";b:1;s:14:"dc:translation";a:2:{i:0;s:2:"de";i:1;s:2:"en";}s:12:"dc:entityUrl";s:150:"https://v-cloud.montafon.at/api/v4/concept_schemes/2da252aa-63ca-4303-b394-9e5463a7ecbe/concepts/41d3d7ee-4099-42ae-88ec-32cb6ddb3f79?language=de%2Cen";s:14:"skos:prefLabel";a:2:{i:0;a:2:{s:9:"@language";s:2:"de";s:6:"@value";s:14:"Skigebiet Golm";}i:1;a:2:{s:9:"@language";s:2:"en";s:6:"@value";s:14:"Skigebiet Golm";}}s:13:"skos:inScheme";a:2:{s:3:"@id";s:36:"2da252aa-63ca-4303-b394-9e5463a7ecbe";s:5:"@type";s:18:"skos:ConceptScheme";}s:12:"skos:broader";a:2:{s:3:"@id";s:36:"00f4fea1-e902-467f-86de-11d5da175c63";s:5:"@type";s:12:"skos:Concept";}s:14:"skos:ancestors";a:2:{i:0;a:2:{s:3:"@id";s:36:"00f4fea1-e902-467f-86de-11d5da175c63";s:5:"@type";s:12:"skos:Concept";}i:1;a:2:{s:3:"@id";s:36:"aec735d9-8179-4b38-a025-bb1070efd53d";s:5:"@type";s:12:"skos:Concept";}}s:11:"dct:created";s:29:"2025-05-12T12:09:21.073+02:00";s:12:"dct:modified";s:29:"2025-05-12T12:09:26.238+02:00";}}s:4:"name";a:2:{i:0;a:2:{s:9:"@language";s:2:"de";s:6:"@value";s:50:"Golmerbahn Mittelstation Latschau, Latschaustraße";}i:1;a:2:{s:9:"@language";s:2:"en";s:6:"@value";s:50:"Golmerbahn Mittelstation Latschau, Latschaustraße";}}s:7:"address";a:6:{s:5:"@type";s:13:"PostalAddress";s:13:"streetAddress";s:50:"Golmerbahn Mittelstation Latschau, Latschaustraße";s:10:"postalCode";s:4:"6774";s:15:"addressLocality";s:10:"Tschagguns";s:3:"@id";s:36:"fc309404-89f4-4576-8b48-6a82e3ce0fcb";s:14:"addressCountry";s:2:"AT";}s:3:"geo";a:4:{s:9:"longitude";d:9.87171;s:3:"@id";s:36:"fc309404-89f4-4576-8b48-24a626ffe955";s:5:"@type";s:14:"GeoCoordinates";s:8:"latitude";d:47.0755;}s:15:"dc:contentScore";a:1:{i:0;a:7:{s:5:"@type";s:13:"PropertyValue";s:10:"identifier";s:20:"internalContentScore";s:4:"name";s:22:"Interner Content Score";s:3:"@id";s:36:"fc309404-89f4-4576-8b48-fbbf41f7f440";s:5:"value";a:2:{i:0;a:2:{s:9:"@language";s:2:"de";s:6:"@value";i:39;}i:1;a:2:{s:9:"@language";s:2:"en";s:6:"@value";i:39;}}s:8:"minValue";i:0;s:8:"maxValue";i:100;}}s:7:"dc:slug";a:2:{i:0;a:2:{s:9:"@language";s:2:"de";s:6:"@value";s:49:"golmerbahn-mittelstation-latschau-latschaustrasse";}i:1;a:2:{s:9:"@language";s:2:"en";s:6:"@value";s:51:"golmerbahn-mittelstation-latschau-latschaustrasse-1";}}s:10:"identifier";a:1:{i:0;a:4:{s:5:"@type";s:13:"PropertyValue";s:10:"propertyID";s:8:"regiondo";s:5:"value";s:32:"8f9c2fd5c4e2b2023d86601ac610d61a";s:14:"valueReference";s:6:"import";}}}s:15:"\x00*\x00synchronizer";O:50:"CONECTO\VCloudBundle\Synchronizers\PoiSynchronizer":12:{s:8:"\x00*\x00csApi";O:43:"CONECTO\VCloudBundle\Apis\ConceptSchemesApi":1:{s:52:"\x00CONECTO\VCloudBundle\Apis\VCloudApiInterface\x00config";a:0:{}}s:72:"\x00CONECTO\VCloudBundle\Synchronizers\PoiSynchronizer\x00conceptsSynchronizer";O:55:"CONECTO\VCloudBundle\Synchronizers\ConceptsSynchronizer":9:{s:28:"\x00*\x00conceptSchemeSynchronizer";O:60:"CONECTO\VCloudBundle\Synchronizers\ConceptSchemeSynchronizer":8:{s:8:"\x00*\x00myApi";r:178;s:12:"\x00*\x00csService";O:51:"CONECTO\VCloudBundle\Services\ConceptSchemesService":1:{s:59:"\x00CONECTO\VCloudBundle\Services\ConceptSchemesService\x00config";a:0:{}}s:5:"tasks";i:1;s:14:"\x00*\x00useVersions";b:0;s:15:"\x00*\x00dumpFixtures";b:0;s:9:"\x00*\x00dryRun";b:0;s:12:"\x00*\x00isSyncRun";b:0;s:12:"\x00*\x00whitelist";N;}s:8:"\x00*\x00myApi";O:37:"CONECTO\VCloudBundle\Apis\ConceptsApi":1:{s:52:"\x00CONECTO\VCloudBundle\Apis\VCloudApiInterface\x00config";a:0:{}}s:12:"\x00*\x00csService";r:183;s:5:"tasks";i:1;s:14:"\x00*\x00useVersions";b:0;s:15:"\x00*\x00dumpFixtures";b:0;s:9:"\x00*\x00dryRun";b:0;s:12:"\x00*\x00isSyncRun";b:0;s:12:"\x00*\x00whitelist";N;}s:8:"\x00*\x00myApi";O:33:"CONECTO\VCloudBundle\Apis\PoisApi":1:{s:52:"\x00CONECTO\VCloudBundle\Apis\VCloudApiInterface\x00config";a:0:{}}s:12:"\x00*\x00csService";r:183;s:5:"tasks";i:1;s:8:"\x00*\x00query";O:36:"Pimcore\Model\DataObject\Poi\Listing":18:{s:8:"\x00*\x00order";a:0:{}s:11:"\x00*\x00orderKey";a:0:{}s:8:"\x00*\x00limit";N;s:9:"\x00*\x00offset";i:0;s:12:"\x00*\x00condition";N;s:21:"\x00*\x00conditionVariables";a:0:{}s:37:"\x00*\x00conditionVariablesFromSetCondition";N;s:10:"\x00*\x00groupBy";N;s:14:"\x00*\x00validOrders";a:2:{i:0;s:3:"ASC";i:1;s:4:"DESC";}s:18:"\x00*\x00conditionParams";a:0:{}s:25:"\x00*\x00conditionVariableTypes";a:0:{}s:7:"\x00*\x00data";N;s:14:"\x00*\x00unpublished";b:1;s:14:"\x00*\x00objectTypes";a:3:{i:0;s:6:"object";i:1;s:7:"variant";i:2;s:6:"folder";}s:10:"\x00*\x00classId";s:10:"vcloud_poi";s:12:"\x00*\x00className";s:3:"Poi";s:9:"\x00*\x00locale";N;s:24:"\x00*\x00ignoreLocalizedFields";b:0;}s:14:"\x00*\x00useVersions";b:0;s:15:"\x00*\x00dumpFixtures";b:0;s:9:"\x00*\x00dryRun";b:0;s:12:"\x00*\x00isSyncRun";b:0;s:6:"\x00*\x00job";O:30:"CONECTO\SynchronizerBundle\Job":4:{s:9:"\x00*\x00dryRun";b:0;s:12:"\x00*\x00isSyncRun";b:0;s:12:"\x00*\x00whitelist";N;s:19:"\x00*\x00synchronizerName";s:11:"import Pois";}s:12:"\x00*\x00whitelist";N;}s:8:"priority";i:-5;s:13:"\x00*\x00dependency";N;}" "priority_fc309404-89f4-4576-8b48-c867521c0979" 0 1786089870 ] |
|
0.52 ms (4.03%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.39 ms (2.97%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
1
]
|
|
0.34 ms (2.60%) |
1 |
SELECT status FROM conecto_synchronizer_queue WHERE id = 'priority_fc309404-89f4-4576-8b48-c867521c0979'
Parameters:
[] |
|
0.31 ms (2.41%) |
1 |
SELECT type FROM conecto_synchronizer_queue WHERE type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask' AND status < 2 LIMIT 1
Parameters:
[] |
|
0.30 ms (2.35%) |
1 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
0.26 ms (2.02%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.23 ms (1.81%) |
1 |
SELECT MIN(priority) FROM conecto_synchronizer_queue WHERE priority < 0
Parameters:
[] |
|
0.22 ms (1.69%) |
1 |
SELECT type FROM conecto_synchronizer_queue WHERE status = 2 AND type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask' LIMIT 1
Parameters:
[] |
|
0.16 ms (1.26%) |
1 |
SELECT status, started_at, completed_at FROM conecto_synchronizer_queue WHERE id = 'fc309404-89f4-4576-8b48-c867521c0979'
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| FormBuilderBundle\Model\OutputWorkflow | No errors. |
| FormBuilderBundle\Model\FormDefinition | No errors. |