Symfony Profiler

CREATE TABLE IF NOT EXISTS conecto_synchronizer_queue (
  id VARCHAR(700) NOT NULL,
  type VARCHAR(65) NOT NULL,
  status INTEGER DEFAULT 0,
  priority INTEGER NOT NULL,
  label VARCHAR(100),
  data LONGTEXT,
  result TEXT,
  started_at INTEGER(11) UNSIGNED,
  completed_at INTEGER(11) UNSIGNED,
  created_at INTEGER(11) UNSIGNED NOT NULL,
  sequence INTEGER NOT NULL AUTO_INCREMENT,
  UNIQUE KEY (sequence),
  PRIMARY KEY (id)
)

CREATE TABLE IF NOT EXISTS conecto_synchronizer_queue (id VARCHAR(700) NOT NULL, type VARCHAR(65) NOT NULL, status INTEGER DEFAULT 0, priority INTEGER NOT NULL, label VARCHAR(100), data LONGTEXT, result TEXT, started_at INTEGER(11) UNSIGNED, completed_at INTEGER(11) UNSIGNED, created_at INTEGER(11) UNSIGNED NOT NULL, sequence INTEGER NOT NULL AUTO_INCREMENT, UNIQUE KEY (sequence), PRIMARY KEY (id) );

"COMMIT"

"COMMIT";

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/vcloud/v1/webhook/' AND `key` = BINARY 'update';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/vcloud/v1/webhook/update';

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:2:{s:53:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\\";a:1:{i:0;O:53:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\\":1:{s:69:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\0transportNames\\\";a:1:{i:0;s:21:\\\"synchronizer_priority\\\";}}}s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:26:\\\"messenger.bus.pimcore-core\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:48:\\\"CONECTO\\\\SynchronizerBundle\\\\Messenger\\\\PrepareTask\\\":2:{s:54:\\\"\\0CONECTO\\\\SynchronizerBundle\\\\Messenger\\\\PrepareTask\\0data\\\";s:45:\\\"priority_47afe20d-e8d5-4483-abac-f5a2c7dba697\\\";s:53:\\\"\\0CONECTO\\\\SynchronizerBundle\\\\Messenger\\\\PrepareTask\\0job\\\";O:30:\\\"CONECTO\\\\SynchronizerBundle\\\\Job\\\":4:{s:9:\\\"\\0*\\0dryRun\\\";b:0;s:12:\\\"\\0*\\0isSyncRun\\\";b:0;s:12:\\\"\\0*\\0whitelist\\\";N;s:19:\\\"\\0*\\0synchronizerName\\\";s:11:\\\"import Pois\\\";}}}', '[]', 'synchronizer_priority', '2026-08-05 20:34:11', '2026-08-05 20:34:11');

"START TRANSACTION"

"START TRANSACTION";

SELECT
  status
FROM
  conecto_synchronizer_queue
WHERE
  id = 'priority_47afe20d-e8d5-4483-abac-f5a2c7dba697'

SELECT status FROM conecto_synchronizer_queue WHERE id = 'priority_47afe20d-e8d5-4483-abac-f5a2c7dba697';

UPDATE
  conecto_synchronizer_queue
SET
  status = ?
WHERE
  priority = ?

UPDATE conecto_synchronizer_queue SET status = 1 WHERE priority = -1;

INSERT INTO conecto_synchronizer_queue (
  type, priority, label, data, id, status,
  created_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO conecto_synchronizer_queue (type, priority, label, data, id, status, created_at) VALUES ('CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask', -1, 'import Pois', 'O:53:\"CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask\":6:{s:54:\"\0CONECTO\\SynchronizerBundle\\Messenger\\MyTask\0reference\";s:45:\"priority_47afe20d-e8d5-4483-abac-f5a2c7dba697\";s:8:\"instance\";N;s:52:\"\0CONECTO\\SynchronizerBundle\\Messenger\\MyTask\0message\";a:11:{s:3:\"@id\";s:36:\"47afe20d-e8d5-4483-abac-f5a2c7dba697\";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:1:{i:0;s:2:\"de\";}s:17:\"dc:classification\";a:4:{i:0;a:12:{s:3:\"@id\";s:36:\"8331332b-d27d-4e67-a923-212f003e4b62\";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/8331332b-d27d-4e67-a923-212f003e4b62?language=de%2Cen\";s:14:\"skos:prefLabel\";a:1:{i:0;a:2:{s:9:\"@language\";s:2:\"de\";s:6:\"@value\";s:21:\"Marktgemeinde Schruns\";}}s:3:\"url\";s:37:\"https://www.wikidata.org/wiki/Q603733\";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:25.402+01:00\";s:12:\"dct:modified\";s:29:\"2024-03-13T22:26:25.402+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:\"00f4fea1-e902-467f-86de-11d5da175c63\";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/00f4fea1-e902-467f-86de-11d5da175c63?language=de%2Cen\";s:14:\"skos:prefLabel\";a:2:{i:0;a:2:{s:9:\"@language\";s:2:\"de\";s:6:\"@value\";s:8:\"Montafon\";}i:1;a:2:{s:9:\"@language\";s:2:\"en\";s:6:\"@value\";s:8:\"Montafon\";}}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:\"aec735d9-8179-4b38-a025-bb1070efd53d\";s:5:\"@type\";s:12:\"skos:Concept\";}s:14:\"skos:ancestors\";a:1:{i:0;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-01-29T15:38:26.439+01:00\";s:12:\"dct:modified\";s:29:\"2025-01-29T15:38:27.960+01:00\";}}s:4:\"name\";a:1:{i:0;a:2:{s:9:\"@language\";s:2:\"de\";s:6:\"@value\";s:27:\"Sitzungssaal Stand Montafon\";}}s:7:\"address\";a:6:{s:5:\"@type\";s:13:\"PostalAddress\";s:13:\"streetAddress\";s:21:\"Montafoner Straße 21\";s:10:\"postalCode\";s:4:\"6780\";s:15:\"addressLocality\";s:7:\"Schruns\";s:3:\"@id\";s:36:\"47afe20d-e8d5-4483-abac-57477609a025\";s:14:\"addressCountry\";s:2:\"AT\";}s:3:\"geo\";a:4:{s:9:\"longitude\";d:9.91163;s:3:\"@id\";s:36:\"47afe20d-e8d5-4483-abac-1963b33846bb\";s:5:\"@type\";s:14:\"GeoCoordinates\";s:8:\"latitude\";d:47.075;}s:7:\"dc:slug\";a:1:{i:0;a:2:{s:9:\"@language\";s:2:\"de\";s:6:\"@value\";s:27:\"sitzungssaal-stand-montafon\";}}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:\"53cf5b01b111d000cdbf85c69e244648\";s:14:\"valueReference\";s:6:\"import\";}}}s:15:\"\0*\0synchronizer\";O:50:\"CONECTO\\VCloudBundle\\Synchronizers\\PoiSynchronizer\":12:{s:8:\"\0*\0csApi\";O:43:\"CONECTO\\VCloudBundle\\Apis\\ConceptSchemesApi\":1:{s:52:\"\0CONECTO\\VCloudBundle\\Apis\\VCloudApiInterface\0config\";a:0:{}}s:72:\"\0CONECTO\\VCloudBundle\\Synchronizers\\PoiSynchronizer\0conceptsSynchronizer\";O:55:\"CONECTO\\VCloudBundle\\Synchronizers\\ConceptsSynchronizer\":9:{s:28:\"\0*\0conceptSchemeSynchronizer\";O:60:\"CONECTO\\VCloudBundle\\Synchronizers\\ConceptSchemeSynchronizer\":8:{s:8:\"\0*\0myApi\";r:153;s:12:\"\0*\0csService\";O:51:\"CONECTO\\VCloudBundle\\Services\\ConceptSchemesService\":1:{s:59:\"\0CONECTO\\VCloudBundle\\Services\\ConceptSchemesService\0config\";a:0:{}}s:5:\"tasks\";i:1;s:14:\"\0*\0useVersions\";b:0;s:15:\"\0*\0dumpFixtures\";b:0;s:9:\"\0*\0dryRun\";b:0;s:12:\"\0*\0isSyncRun\";b:0;s:12:\"\0*\0whitelist\";N;}s:8:\"\0*\0myApi\";O:37:\"CONECTO\\VCloudBundle\\Apis\\ConceptsApi\":1:{s:52:\"\0CONECTO\\VCloudBundle\\Apis\\VCloudApiInterface\0config\";a:0:{}}s:12:\"\0*\0csService\";r:158;s:5:\"tasks\";i:1;s:14:\"\0*\0useVersions\";b:0;s:15:\"\0*\0dumpFixtures\";b:0;s:9:\"\0*\0dryRun\";b:0;s:12:\"\0*\0isSyncRun\";b:0;s:12:\"\0*\0whitelist\";N;}s:8:\"\0*\0myApi\";O:33:\"CONECTO\\VCloudBundle\\Apis\\PoisApi\":1:{s:52:\"\0CONECTO\\VCloudBundle\\Apis\\VCloudApiInterface\0config\";a:0:{}}s:12:\"\0*\0csService\";r:158;s:5:\"tasks\";i:1;s:8:\"\0*\0query\";O:36:\"Pimcore\\Model\\DataObject\\Poi\\Listing\":18:{s:8:\"\0*\0order\";a:0:{}s:11:\"\0*\0orderKey\";a:0:{}s:8:\"\0*\0limit\";N;s:9:\"\0*\0offset\";i:0;s:12:\"\0*\0condition\";N;s:21:\"\0*\0conditionVariables\";a:0:{}s:37:\"\0*\0conditionVariablesFromSetCondition\";N;s:10:\"\0*\0groupBy\";N;s:14:\"\0*\0validOrders\";a:2:{i:0;s:3:\"ASC\";i:1;s:4:\"DESC\";}s:18:\"\0*\0conditionParams\";a:0:{}s:25:\"\0*\0conditionVariableTypes\";a:0:{}s:7:\"\0*\0data\";N;s:14:\"\0*\0unpublished\";b:1;s:14:\"\0*\0objectTypes\";a:3:{i:0;s:6:\"object\";i:1;s:7:\"variant\";i:2;s:6:\"folder\";}s:10:\"\0*\0classId\";s:10:\"vcloud_poi\";s:12:\"\0*\0className\";s:3:\"Poi\";s:9:\"\0*\0locale\";N;s:24:\"\0*\0ignoreLocalizedFields\";b:0;}s:14:\"\0*\0useVersions\";b:0;s:15:\"\0*\0dumpFixtures\";b:0;s:9:\"\0*\0dryRun\";b:0;s:12:\"\0*\0isSyncRun\";b:0;s:6:\"\0*\0job\";O:30:\"CONECTO\\SynchronizerBundle\\Job\":4:{s:9:\"\0*\0dryRun\";b:0;s:12:\"\0*\0isSyncRun\";b:0;s:12:\"\0*\0whitelist\";N;s:19:\"\0*\0synchronizerName\";s:11:\"import Pois\";}s:12:\"\0*\0whitelist\";N;}s:8:\"priority\";i:-1;s:13:\"\0*\0dependency\";N;}', 'priority_47afe20d-e8d5-4483-abac-f5a2c7dba697', 0, 1785962051);

SELECT
  id
FROM
  conecto_synchronizer_queue
WHERE
  status = 2
  AND started_at IS NULL
  AND type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask'
ORDER BY
  sequence

SELECT id FROM conecto_synchronizer_queue WHERE status = 2 AND started_at IS NULL AND type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask' ORDER BY sequence;

SELECT
  type
FROM
  conecto_synchronizer_queue
WHERE
  type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask'
  AND status < 2
LIMIT
  1

SELECT type FROM conecto_synchronizer_queue WHERE type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask' AND status < 2 LIMIT 1;

UPDATE
  conecto_synchronizer_queue
SET
  status = 2
WHERE
  status = 1
  AND type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask'
  AND priority = -1

UPDATE conecto_synchronizer_queue SET status = 2 WHERE status = 1 AND type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask' AND priority = -1;

SELECT
  type
FROM
  conecto_synchronizer_queue
WHERE
  status = 2
  AND type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask'
LIMIT
  1

SELECT type FROM conecto_synchronizer_queue WHERE status = 2 AND type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask' LIMIT 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

SELECT * FROM redirects WHERE
            (
                (source = '/vcloud/v1/webhook/update' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/vcloud/v1/webhook/update' AND `type` = 'path_query') OR
                (source = 'https://montafon-staging.conecto.rocks/vcloud/v1/webhook/update' AND `type` = 'entire_uri')
            ) 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;

SELECT
  MAX(priority)
FROM
  conecto_synchronizer_queue
WHERE
  type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask'
  AND status = 1

SELECT MAX(priority) FROM conecto_synchronizer_queue WHERE type = 'CONECTO\\SynchronizerBundle\\Messenger\\PrioritySyncTask' AND status = 1;

SELECT
  MIN(priority)
FROM
  conecto_synchronizer_queue
WHERE
  priority < 0

SELECT MIN(priority) FROM conecto_synchronizer_queue WHERE priority < 0;

SELECT
  status,
  started_at,
  completed_at
FROM
  conecto_synchronizer_queue
WHERE
  id = '47afe20d-e8d5-4483-abac-f5a2c7dba697'

SELECT status, started_at, completed_at FROM conecto_synchronizer_queue WHERE id = '47afe20d-e8d5-4483-abac-f5a2c7dba697';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 1;

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

"ROLLBACK"

"ROLLBACK";