Symfony Profiler

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 29;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 29;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 29;

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

SELECT * FROM users WHERE `type` = 'role' AND id = '21';

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 21;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 21;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 21;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_perspectives';

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

SELECT * FROM settings_store WHERE id = 'web_to_print' AND scope = 'pimcore_web_to_print';

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_custom_views';

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 > 1788948971 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_12556', 'object_12556');

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 > 1788948971 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_12556\0tags\0');

SELECT
  1
FROM
  objects o
WHERE
  o_parentId = ?
  AND o_type IN ('object', 'folder')
LIMIT
  1

SELECT 1 FROM objects o WHERE o_parentId = 12556  AND o_type IN ('object','folder') LIMIT 1;

SELECT
  `list`
FROM
  users_workspaces_object
WHERE
  LOCATE(cpath, ?)= 1
  AND userId IN (21, 29)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 29) DESC,
  `list` DESC
LIMIT
  1

SELECT `list` FROM users_workspaces_object WHERE LOCATE(cpath, '/Prodotti/Biennale di Venezia')=1 AND
        userId IN (21,29)
        ORDER BY LENGTH(cpath) DESC, FIELD(userId, 29) DESC, `list` DESC LIMIT 1;

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  objects.o_parentId = '12556'
  AND IF(
    EXISTS(
      SELECT
        list
      FROM
        users_workspaces_object uwo
      WHERE
        userId IN (21, 29)
        AND list = 1
        AND LOCATE(
          CONCAT(objects.o_path, objects.o_key),
          cpath
        )= 1
        AND NOT EXISTS(
          SELECT
            list
          FROM
            users_workspaces_object
          WHERE
            userId = 29
            AND list = 0
            AND cpath = uwo.cpath
        )
    ),
    1,
    IF(
      1,
      EXISTS(
        SELECT
          list
        FROM
          users_workspaces_object
        WHERE
          userId IN (21, 29)
          AND cid = objects.o_id
          AND list = 0
      ) = 0,
      0
    )
  ) = 1
  AND CAST(
    objects.o_key AS CHAR CHARACTER SET utf8
  ) COLLATE utf8_general_ci LIKE 'TOTE BAG 83. MOSTRA INTERNAZIONALE D’ARTE CINEMATOGRAFICA%'
  AND objects.o_type IN ('object', 'folder')
ORDER BY
  objects.o_index ASC
LIMIT
  100

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE objects.o_parentId = '12556' AND IF(EXISTS(SELECT list FROM users_workspaces_object uwo WHERE userId IN (21,29) AND list=1 AND LOCATE(CONCAT(objects.o_path,objects.o_key),cpath)=1 AND
                NOT EXISTS(SELECT list FROM users_workspaces_object WHERE userId =29  AND list=0 AND cpath = uwo.cpath)),1,IF(1, EXISTS(SELECT list FROM users_workspaces_object WHERE userId IN (21,29)  AND cid = objects.o_id AND list=0) = 0, 0)) = 1 AND CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE 'TOTE BAG 83. MOSTRA INTERNAZIONALE D’ARTE CINEMATOGRAFICA%' AND  objects.o_type IN ('object','folder') ORDER BY objects.o_index ASC    LIMIT 100;

SELECT
  COUNT(*)
FROM
  objects
WHERE
  objects.o_parentId = '12556'
  AND IF(
    EXISTS(
      SELECT
        list
      FROM
        users_workspaces_object uwo
      WHERE
        userId IN (21, 29)
        AND list = 1
        AND LOCATE(
          CONCAT(objects.o_path, objects.o_key),
          cpath
        )= 1
        AND NOT EXISTS(
          SELECT
            list
          FROM
            users_workspaces_object
          WHERE
            userId = 29
            AND list = 0
            AND cpath = uwo.cpath
        )
    ),
    1,
    IF(
      1,
      EXISTS(
        SELECT
          list
        FROM
          users_workspaces_object
        WHERE
          userId IN (21, 29)
          AND cid = objects.o_id
          AND list = 0
      ) = 0,
      0
    )
  ) = 1
  AND CAST(
    objects.o_key AS CHAR CHARACTER SET utf8
  ) COLLATE utf8_general_ci LIKE 'TOTE BAG 83. MOSTRA INTERNAZIONALE D’ARTE CINEMATOGRAFICA%'
  AND objects.o_type IN ('object', 'folder')

SELECT COUNT(*) FROM objects WHERE objects.o_parentId = '12556' AND IF(EXISTS(SELECT list FROM users_workspaces_object uwo WHERE userId IN (21,29) AND list=1 AND LOCATE(CONCAT(objects.o_path,objects.o_key),cpath)=1 AND
                NOT EXISTS(SELECT list FROM users_workspaces_object WHERE userId =29  AND list=0 AND cpath = uwo.cpath)),1,IF(1, EXISTS(SELECT list FROM users_workspaces_object WHERE userId IN (21,29)  AND cid = objects.o_id AND list=0) = 0, 0)) = 1 AND CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE 'TOTE BAG 83. MOSTRA INTERNAZIONALE D’ARTE CINEMATOGRAFICA%' AND  objects.o_type IN ('object','folder');

SELECT
  `list`
FROM
  users_workspaces_object
WHERE
  LOCATE(cpath, ?)= 1
  AND userId IN (21, 29)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 29) DESC,
  `list` DESC
LIMIT
  1

SELECT `list` FROM users_workspaces_object WHERE LOCATE(cpath, '/Prodotti/Biennale di Venezia')=1 AND
        userId IN (21,29)
        ORDER BY LENGTH(cpath) DESC, FIELD(userId, 29) DESC, `list` DESC LIMIT 1;

SELECT
  COUNT(*) AS count
FROM
  objects o
WHERE
  o_parentId = ?
  AND IF(
    EXISTS(
      SELECT
        list
      FROM
        users_workspaces_object uwo
      WHERE
        userId IN (21, 29)
        AND list = 1
        AND LOCATE(
          CONCAT(o.o_path, o.o_key),
          cpath
        )= 1
        AND NOT EXISTS(
          SELECT
            list
          FROM
            users_workspaces_object
          WHERE
            userId = 29
            AND list = 0
            AND cpath = uwo.cpath
        )
    ),
    1,
    IF(
      1,
      EXISTS(
        SELECT
          list
        FROM
          users_workspaces_object uworow
        WHERE
          userId IN (21, 29)
          AND cid = o_id
          AND list = 0
      ) = 0,
      0
    )
  ) = 1

SELECT COUNT(*) AS count FROM objects o WHERE o_parentId = 12556 AND IF(EXISTS(SELECT list FROM users_workspaces_object uwo WHERE userId IN (21,29) AND list=1 AND LOCATE(CONCAT(o.o_path,o.o_key),cpath)=1 AND
            NOT EXISTS(SELECT list FROM users_workspaces_object WHERE userId =29  AND list=0 AND cpath = uwo.cpath)),1,IF(1, EXISTS(SELECT list FROM users_workspaces_object uworow WHERE userId IN (21,29)  AND cid = o_id AND list=0) = 0, 0)) = 1;