Symfony Profiler

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_bf340ca7d22ee2e1c8e31157b737807c');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
tags
');

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

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

SELECT id FROM documents WHERE `path` = BINARY '/pimcore-graphql-webservices/' AND `key` = BINARY 'Material';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices/Material';

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

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'pimcore-graphql-webservices';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices';

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

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1
tags
');

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

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

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

SELECT
  id,
  name
FROM
  classes

SELECT id, name FROM classes;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '1';

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'SapMaterial';

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'SapMaterial';

SELECT
  object_localized_1_en.id as id,
  object_localized_1_en.type as `type`
FROM
  object_localized_1_en
WHERE
  (
    (
      SELECT
        `read`
      from
        `plugin_datahub_workspaces_object`
      WHERE
        `plugin_datahub_workspaces_object`.configuration = 'Material'
        AND LOCATE(
          CONCAT(
            `object_localized_1_en`.path, `object_localized_1_en`.key
          ),
          `plugin_datahub_workspaces_object`.cpath
        )= 1
      ORDER BY
        LENGTH(
          `plugin_datahub_workspaces_object`.cpath
        ) DESC
      LIMIT
        1
    ) = 1
    OR (
      SELECT
        `read`
      from
        `plugin_datahub_workspaces_object`
      WHERE
        `plugin_datahub_workspaces_object`.configuration = 'Material'
        AND LOCATE(
          `plugin_datahub_workspaces_object`.cpath,
          CONCAT(
            `object_localized_1_en`.path, `object_localized_1_en`.key
          )
        )= 1
      ORDER BY
        LENGTH(
          `plugin_datahub_workspaces_object`.cpath
        ) DESC
      LIMIT
        1
    ) = 1
  )
  AND (
    (
      `object_localized_1_en`.`key` = 'S4066530005000'
    )
  )
  AND object_localized_1_en.type IN ('object', 'folder', 'variant')

SELECT object_localized_1_en.id as id, object_localized_1_en.type as `type` FROM object_localized_1_en WHERE  (
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'Material'
                AND LOCATE(CONCAT(`object_localized_1_en`.path,`object_localized_1_en`.key),`plugin_datahub_workspaces_object`.cpath)=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            OR
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'Material'
                AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_1_en`.path,`object_localized_1_en`.key))=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            ) AND  ((`object_localized_1_en`.`key` = 'S4066530005000') )  AND  object_localized_1_en.type IN ('object','folder','variant');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_212354');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_212354
tags
', 'class_1
tags
');

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 212354;

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 212354;

SELECT
  *
FROM
  object_store_1
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_1 WHERE oo_id = 212354 FOR UPDATE;

SELECT
  *
FROM
  object_localized_data_1
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'fr', 'es', 'it', 'pl', 'cs',
    'nl', 'tr'
  )

SELECT * FROM object_localized_data_1 WHERE ooo_id = 212354 AND language IN ('en','de','fr','es','it','pl','cs','nl','tr');

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 212354;

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_211243');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_211243
tags
', 'class_1
tags
');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_207533');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_207533
tags
', 'class_1
tags
');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_138243');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_138243
tags
', 'class_1
tags
');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_62890');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_62890
tags
', 'class_8
tags
');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_15');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_15
tags
', 'class_11
tags
');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2
tags
', 'class_7
tags
');

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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_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 > 1762548010 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1
tags
');

SELECT
  `read`
FROM
  plugin_datahub_workspaces_object
WHERE
  cid IN (
    1, 211243, 207533, 138243, 62890, 15,
    2, 1, 212354
  )
  AND configuration = 'Material'
  AND `read` = 1
ORDER BY
  LENGTH(cpath) DESC
LIMIT
  1

SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,211243,207533,138243,62890,15,2,1,212354) AND configuration = 'Material' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1;

SELECT
  `read`
FROM
  plugin_datahub_workspaces_object
WHERE
  cid IN (
    1, 211243, 207533, 138243, 62890, 15,
    2, 1, 212354
  )
  AND configuration = 'Material'
  AND `read` = 1
ORDER BY
  LENGTH(cpath) DESC
LIMIT
  1

SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,211243,207533,138243,62890,15,2,1,212354) AND configuration = 'Material' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1;