Symfony Profiler

SELECT
  *
FROM
  users
WHERE
  `type` = ?
  AND id = ?

SELECT * FROM users WHERE `type` = 'user' AND id = 2;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 2;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 2;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 2;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0appb5003cab61b59631c83b2e65817e0bebe98e50d6', 'appb5003cab61b59631c83b2e65817e0bebe98e50d6');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0appb5003cab61b59631c83b2e65817e0bebe98e50d6', 'appb5003cab61b59631c83b2e65817e0bebe98e50d6');

INSERT INTO cache_items (
  item_id, item_data, item_lifetime,
  item_time
)
VALUES
  (?, ?, ?, ?) ON DUPLICATE KEY
UPDATE
  item_data =
VALUES
  (item_data),
  item_lifetime =
VALUES
  (item_lifetime),
  item_time =
VALUES
  (item_time)

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (NULL, NULL, 300, 1780342370) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

INSERT INTO cache_items (
  item_id, item_data, item_lifetime,
  item_time
)
VALUES
  (?, ?, ?, ?) ON DUPLICATE KEY
UPDATE
  item_data =
VALUES
  (item_data),
  item_lifetime =
VALUES
  (item_lifetime),
  item_time =
VALUES
  (item_time)

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (NULL, NULL, 300, 1780342370) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1', 'app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1', 'app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1');

INSERT INTO cache_items (
  item_id, item_data, item_lifetime,
  item_time
)
VALUES
  (?, ?, ?, ?) ON DUPLICATE KEY
UPDATE
  item_data =
VALUES
  (item_data),
  item_lifetime =
VALUES
  (item_lifetime),
  item_time =
VALUES
  (item_time)

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (NULL, NULL, 300, 1780342370) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

INSERT INTO cache_items (
  item_id, item_data, item_lifetime,
  item_time
)
VALUES
  (?, ?, ?, ?) ON DUPLICATE KEY
UPDATE
  item_data =
VALUES
  (item_data),
  item_lifetime =
VALUES
  (item_lifetime),
  item_time =
VALUES
  (item_time)

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (NULL, NULL, 300, 1780342370) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

SELECT
  *
FROM
  users
WHERE
  `type` = ?
  AND `name` = ?

SELECT * FROM users WHERE `type` = 'user' AND `name` = 'custompuzzles';

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 2;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 2;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 2;

DELETE FROM
  cache_items
WHERE
  item_id IN (?)

DELETE FROM cache_items WHERE item_id IN ('appb5003cab61b59631c83b2e65817e0bebe98e50d6', '\0tags\0appb5003cab61b59631c83b2e65817e0bebe98e50d6');

DELETE FROM
  cache_items
WHERE
  item_id IN (?)

DELETE FROM cache_items WHERE item_id IN ('app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1', '\0tags\0app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_296', 'document_296');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_296\0tags\0', 'asset_3363\0tags\0', 'asset_1818\0tags\0', 'asset_1816\0tags\0');

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'document_session_296_b87628133a97524250d51750fc5181fe';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_258', 'document_258');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_258\0tags\0', 'asset_1689\0tags\0', 'asset_2106\0tags\0', 'asset_2887\0tags\0', 'asset_2047\0tags\0', 'asset_1756\0tags\0', 'asset_2387\0tags\0', 'asset_3435\0tags\0', 'asset_1485\0tags\0', 'asset_2271\0tags\0', 'asset_1450\0tags\0', 'asset_2861\0tags\0', 'asset_2262\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_206', 'document_206');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_206\0tags\0', 'asset_2500\0tags\0', 'asset_2861\0tags\0', 'asset_2598\0tags\0', 'asset_1829\0tags\0', 'asset_1884\0tags\0', 'asset_1901\0tags\0', 'asset_2214\0tags\0', 'asset_2232\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', 'document_1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0', 'asset_411\0tags\0', 'asset_3\0tags\0', 'asset_319\0tags\0', 'asset_361\0tags\0', 'asset_320\0tags\0', 'asset_318\0tags\0', 'asset_321\0tags\0', 'asset_224\0tags\0', 'asset_35\0tags\0', 'asset_211\0tags\0', 'asset_90\0tags\0', 'asset_58\0tags\0', 'asset_180\0tags\0', 'asset_124\0tags\0', 'asset_164\0tags\0', 'asset_81\0tags\0');

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 258, 206)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE ((cid IN (1,258,206) AND inheritable = 1) OR cid = 296 )  AND ctype='document';

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'document_session_296_b87628133a97524250d51750fc5181fe_useForSave';

SELECT
  count(*)
FROM
  documents_editables
WHERE
  documentId = ?
  AND name LIKE ?

SELECT count(*) FROM documents_editables WHERE documentId = 296 AND name LIKE '%persona_-%-_%';

SELECT
  id
FROM
  schedule_tasks
WHERE
  `cid` = ?
  AND `ctype` = ?

SELECT id FROM schedule_tasks WHERE `cid` = 296 AND `ctype` = 'document' ;

DELETE FROM
  schedule_tasks
WHERE
  `cid` = '296'
  AND `ctype` = 'document'

DELETE FROM schedule_tasks WHERE `cid` = '296' AND `ctype` = 'document';

SELECT
  id
FROM
  versions
WHERE
  autoSave = 1
  AND cid = ?
  AND cType = ?
  AND userId = ?

SELECT id FROM versions WHERE autoSave = 1 AND cid = 296 AND cType = 'document' AND userId = 2  ;

SELECT
  *
FROM
  versions
WHERE
  id = ?

SELECT * FROM versions WHERE id = 37551;

SELECT
  versionCount
FROM
  documents
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM documents WHERE id = 296 FOR UPDATE;

SELECT
  MAX(versionCount)
FROM
  versions
WHERE
  cid = ?
  AND ctype = 'document'

SELECT MAX(versionCount) FROM versions WHERE cid = 296 AND ctype = 'document';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_versions', 'system_resource_columns_versions');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'resource\0tags\0', 'system_resource_columns_versions\0tags\0');

INSERT INTO `versions` (
  `id`, `cid`, `ctype`, `userId`, `note`,
  `date`, `public`, `serialized`, `stackTrace`,
  `versionCount`, `binaryFileHash`,
  `binaryFileId`, `autoSave`, `storageType`
)
VALUES
  (
    :col0, :col1, :col2, :col3, :col4, :col5,
    :col6, :col7, :col8, :col9, :col10,
    :col11, :col12, :col13
  ) ON DUPLICATE KEY
UPDATE
  `id` = :col0,
  `cid` = :col1,
  `ctype` = :col2,
  `userId` = :col3,
  `note` = :col4,
  `date` = :col5,
  `public` = :col6,
  `serialized` = :col7,
  `stackTrace` = :col8,
  `versionCount` = :col9,
  `binaryFileHash` = :col10,
  `binaryFileId` = :col11,
  `autoSave` = :col12,
  `storageType` = :col13;

INSERT INTO `versions` (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13) ON DUPLICATE KEY UPDATE `id` = :col0, `cid` = :col1, `ctype` = :col2, `userId` = :col3, `note` = :col4, `date` = :col5, `public` = :col6, `serialized` = :col7, `stackTrace` = :col8, `versionCount` = :col9, `binaryFileHash` = :col10, `binaryFileId` = :col11, `autoSave` = :col12, `storageType` = :col13;;

INSERT INTO `tmp_store` (
  `id`, `data`, `tag`, `date`, `expiryDate`,
  `serialized`
)
VALUES
  (
    :col0, :col1, :col2, :col3, :col4, :col5
  ) ON DUPLICATE KEY
UPDATE
  `id` = :col0,
  `data` = :col1,
  `tag` = :col2,
  `date` = :col3,
  `expiryDate` = :col4,
  `serialized` = :col5;

INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;

SELECT
  tree_locks.id
FROM
  tree_locks
  INNER JOIN documents ON tree_locks.id = documents.id
WHERE
  documents.path LIKE ?
  AND tree_locks.type = 'document'
  AND tree_locks.locked IS NOT NULL
  AND tree_locks.locked != ''
LIMIT
  1

SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE '/custompuzzles-xxl.com/spezialanfertigung/Geopuzzle/%' AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT
  id
FROM
  tree_locks
WHERE
  id IN (1, 258, 206)
  AND type = 'document'
  AND locked = 'propagate'
LIMIT
  1

SELECT id FROM tree_locks WHERE id IN (1,258,206) AND type='document' AND locked = 'propagate' LIMIT 1;

SELECT
  id
FROM
  documents d
WHERE
  parentId = ?
LIMIT
  1

SELECT id FROM documents d WHERE parentId = 296  LIMIT 1;

SELECT
  *
FROM
  sites
WHERE
  rootId = ?

SELECT * FROM sites WHERE rootId = 296;

SELECT
  *
FROM
  sites
WHERE
  rootId = ?

SELECT * FROM sites WHERE rootId = 296;

SELECT
  *
FROM
  sites
WHERE
  rootId = ?

SELECT * FROM sites WHERE rootId = 296;

SELECT
  id
FROM
  sites
ORDER BY
  (
    SELECT
      LENGTH(path)
    FROM
      documents
    WHERE
      documents.id = sites.rootId
  ) DESC

SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC ;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_id_2', 'site_id_2');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_id_2\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_id_3', 'site_id_3');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_id_3\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_id_4', 'site_id_4');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_id_4\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_id_6', 'site_id_6');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_id_6\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_id_7', 'site_id_7');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780342370 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_id_7\0tags\0');

SELECT
  tree_locks.id
FROM
  tree_locks
  INNER JOIN documents ON tree_locks.id = documents.id
WHERE
  documents.path LIKE ?
  AND tree_locks.type = 'document'
  AND tree_locks.locked IS NOT NULL
  AND tree_locks.locked != ''
LIMIT
  1

SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE '/custompuzzles-xxl.com/spezialanfertigung/Geopuzzle/%' AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT
  id
FROM
  tree_locks
WHERE
  id IN (1, 258, 206)
  AND type = 'document'
  AND locked = 'propagate'
LIMIT
  1

SELECT id FROM tree_locks WHERE id IN (1,258,206) AND type='document' AND locked = 'propagate' LIMIT 1;