Symfony Profiler

SELECT
  r.dest_id as dest_id,
  r.dest_id as id,
  r.type,
  o.className as subtype,
  o.published as published,
  concat(o.path, o.key) as `path`,
  r.index
FROM
  objects o,
  object_relations_34 r
WHERE
  r.fieldname = ?
  AND r.ownertype = 'object'
  AND r.src_id = ?
  AND o.id = r.dest_id
  AND r.type = 'object'
UNION
SELECT
  r.dest_id as dest_id,
  r.dest_id as id,
  r.type,
  a.type as subtype,
  "null" as published,
  concat(a.path, a.filename) as `path`,
  r.index
FROM
  assets a,
  object_relations_34 r
WHERE
  r.fieldname = ?
  AND r.ownertype = 'object'
  AND r.src_id = ?
  AND a.id = r.dest_id
  AND r.type = 'asset'
UNION
SELECT
  r.dest_id as dest_id,
  r.dest_id as id,
  r.type,
  d.type as subtype,
  d.published as published,
  concat(d.path, d.key) as `path`,
  r.index
FROM
  documents d,
  object_relations_34 r
WHERE
  r.fieldname = ?
  AND r.ownertype = 'object'
  AND r.src_id = ?
  AND d.id = r.dest_id
  AND r.type = 'document'
ORDER BY
  `index` ASC

SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index
            FROM objects o, object_relations_34 r
            WHERE r.fieldname= 'collocazioni_collegate'
            AND r.ownertype = 'object'
            AND r.src_id = 718
            AND o.id = r.dest_id
            AND r.type='object'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index
            FROM assets a, object_relations_34 r
            WHERE r.fieldname= 'collocazioni_collegate'
            AND r.ownertype = 'object'
            AND r.src_id = 718
            AND a.id = r.dest_id
            AND r.type='asset'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index
            FROM documents d, object_relations_34 r
            WHERE r.fieldname= 'collocazioni_collegate'
            AND r.ownertype = 'object'
            AND r.src_id = 718
            AND d.id = r.dest_id
            AND r.type='document'

            ORDER BY `index` ASC;

INSERT INTO edit_lock (
  `id`, `cid`, `ctype`, `userId`, `sessionId`,
  `date`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO edit_lock (`id`, `cid`, `ctype`, `userId`, `sessionId`, `date`) VALUES (NULL, 718, 'object', 24, 'c9bfdddef0549ba71de7239f81c0f113', 1784736053);

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'Documento';

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

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 ('PIMCORE_HOSTURL', 0x4F3A313A22A9223A313A7B733A363A22FFFFFF7FC01E223B733A33373A2268747470733A2F2F64656D6F63756C747572612E646174612E617263686976696F2E636F6D223B7D, 31536000, 1784736053) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '34';

SELECT
  *
FROM
  versions
WHERE
  id = ?

SELECT * FROM versions WHERE id = 1367;

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

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

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

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

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

SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE '/Fondo Promemoria Group (716)/Affari generali e societari (717)/Atto costitutivo e statuti (718)/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT
  id
FROM
  versions
WHERE
  cid = ?
  AND ctype = ?
  AND (
    `date` > ?
    OR versionCount > ?
  )
  AND (
    (
      autoSave = 1
      AND userId = ?
    )
    OR autoSave = 0
  )
ORDER BY
  `versionCount` DESC
LIMIT
  1

SELECT id FROM versions WHERE cid = 718 AND ctype = 'object' AND (`date` > 1784733239 OR versionCount > 9) AND ((autoSave = 1 AND userId = 24) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1;

SELECT
  id
FROM
  versions
WHERE
  cid = ?
  AND ctype = ?
  AND autoSave = 0
ORDER BY
  `id` ASC

SELECT id FROM versions WHERE cid = 718 AND ctype = 'object'  AND autoSave = 0 ORDER BY `id` ASC;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_39 ore
  INNER JOIN object_metadata_39 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_39 ore
        INNER JOIN object_metadata_39 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 24;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_38 ore
  INNER JOIN object_metadata_38 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_38 ore
        INNER JOIN object_metadata_38 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  DISTINCT classId
FROM
  objects
WHERE
  `path` like ?
  AND `type` = 'object'

SELECT DISTINCT classId FROM objects WHERE `path` like '/Fondo Promemoria Group (716)/Affari generali e societari (717)/Atto costitutivo e statuti (718)/%' AND `type` = 'object';

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 24;

SELECT
  *
FROM
  object_metadata_34
WHERE
  id = ?
  AND dest_id = ?
  AND fieldname = ?
  AND ownertype = ?
  AND ownername = ?
  and position = ?
  and `index` = ?
  AND (
    `type` = 'object'
    or `type` = ''
  )

SELECT * FROM object_metadata_34 WHERE id = 718 AND dest_id = 713 AND fieldname = 'enti_collegati' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1  AND (`type` = 'object' or `type` = '');

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 24;

SELECT
  className,
  count(*) as count
FROM
  `objects`
WHERE
  `path` LIKE '/Fondo Promemoria Group (716)/Affari generali e societari (717)/Atto costitutivo e statuti (718)/%'
  and type != 'folder'
GROUP BY
  className
ORDER BY
  className ASC

SELECT className, count(*) as count
FROM `objects`
WHERE `path` LIKE '/Fondo Promemoria Group (716)/Affari generali e societari (717)/Atto costitutivo e statuti (718)/%' and type != 'folder'
GROUP BY className
ORDER BY className ASC;

DELETE FROM
  tmp_store
WHERE
  id = ?

DELETE FROM tmp_store WHERE id = 'object_session_718_c9bfdddef0549ba71de7239f81c0f113';

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_40 ore
  INNER JOIN object_metadata_40 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_40 ore
        INNER JOIN object_metadata_40 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_52 ore
  INNER JOIN object_metadata_52 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_52 ore
        INNER JOIN object_metadata_52 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  `layouts`,
  cid,
  cpath
FROM
  users_workspaces_object
WHERE
  cid IN (1, 717, 716, 718)
  AND userId IN (24)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 24) DESC,
  `layouts` DESC

SELECT `layouts`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,717,716,718) AND userId IN (24) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 24) DESC, `layouts` DESC;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_15 ore
  INNER JOIN object_metadata_15 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_15 ore
        INNER JOIN object_metadata_15 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_37 ore
  INNER JOIN object_metadata_37 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_37 ore
        INNER JOIN object_metadata_37 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_5 ore
  INNER JOIN object_metadata_5 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_5 ore
        INNER JOIN object_metadata_5 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_46 ore
  INNER JOIN object_metadata_46 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_46 ore
        INNER JOIN object_metadata_46 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_11 ore
  INNER JOIN object_metadata_11 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_11 ore
        INNER JOIN object_metadata_11 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  *
FROM
  edit_lock
WHERE
  cid = ?
  AND ctype = ?

SELECT * FROM edit_lock WHERE cid = 718 AND ctype = 'object';

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_25 ore
  INNER JOIN object_metadata_25 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_25 ore
        INNER JOIN object_metadata_25 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_36 ore
  INNER JOIN object_metadata_36 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_36 ore
        INNER JOIN object_metadata_36 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_41 ore
  INNER JOIN object_metadata_41 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_41 ore
        INNER JOIN object_metadata_41 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_45 ore
  INNER JOIN object_metadata_45 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_45 ore
        INNER JOIN object_metadata_45 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  dataportId
FROM
  plugin_pim_fieldmapping
WHERE
  fieldName = ?
  AND calculation LIKE ?

SELECT dataportId 
            FROM plugin_pim_fieldmapping 
            WHERE fieldName='__result_callback' AND calculation LIKE '%\'Content-Disposition\', \'inline\'%';

SELECT
  name,
  type,
  data,
  cid,
  inheritable,
  cpath
FROM
  properties
WHERE
  (
    (
      cid IN (1, 717, 716)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'object'

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,717,716) AND inheritable = 1)
                         OR cid = 718 ) AND ctype='object';

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_12 ore
  INNER JOIN object_metadata_12 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_12 ore
        INNER JOIN object_metadata_12 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_35 ore
  INNER JOIN object_metadata_35 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_35 ore
        INNER JOIN object_metadata_35 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

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 > 1784736053 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_713
tags
', 'class_6
tags
', 'asset_71
tags
', 'asset_72
tags
', 'asset_65
tags
', 'asset_69
tags
', 'asset_66
tags
', 'asset_64
tags
');

SELECT
  *
FROM
  translations_admin
LIMIT
  1;

SELECT * FROM translations_admin LIMIT 1;;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_43 ore
  INNER JOIN object_metadata_43 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_43 ore
        INNER JOIN object_metadata_43 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_10 ore
  INNER JOIN object_metadata_10 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_10 ore
        INNER JOIN object_metadata_10 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_42 ore
  INNER JOIN object_metadata_42 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_42 ore
        INNER JOIN object_metadata_42 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  *
FROM
  object_relations_34
WHERE
  src_id = ?

SELECT * FROM object_relations_34 WHERE src_id = 718;

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_44 ore
  INNER JOIN object_metadata_44 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_44 ore
        INNER JOIN object_metadata_44 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  tagid
FROM
  tags_assignment
WHERE
  cid = ?
  AND ctype = ?

SELECT tagid FROM tags_assignment WHERE cid = 718 AND ctype = 'object';

SELECT
  id
FROM
  tree_locks
WHERE
  id IN (1, 717, 716)
  AND `type` = 'object'
  AND locked = 'propagate'
LIMIT
  1

SELECT id FROM tree_locks WHERE id IN (1,717,716) AND `type`='object' AND locked = 'propagate' LIMIT 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 > 1784736053 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translator
tags
', 'translator_website
tags
', 'translate
tags
');

SELECT
  ore.src_id,
  om.data
FROM
  object_relations_34 ore
  INNER JOIN object_metadata_34 om ON ore.src_id = om.id
  AND ore.dest_id = om.dest_id
  and ore.fieldname = om.fieldname
  AND om.column = 'tipo_relazione'
WHERE
  ore.dest_id = 718
  and ore.fieldname = 'raccolte_collegate'
ORDER BY
  ore.`index`

SELECT ore.src_id, om.data
        FROM object_relations_34 ore
        INNER JOIN object_metadata_34 om ON ore.src_id = om.id AND ore.dest_id = om.dest_id and ore.fieldname = om.fieldname AND om.column = 'tipo_relazione'
        WHERE ore.dest_id = 718 and ore.fieldname = 'raccolte_collegate'
        ORDER BY ore.`index`;

SELECT
  id
FROM
  tree_locks
WHERE
  id IN (1, 679, 670)
  AND `type` = 'object'
  AND locked = 'propagate'
LIMIT
  1

SELECT id FROM tree_locks WHERE id IN (1,679,670) AND `type`='object' AND locked = 'propagate' LIMIT 1;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_object_custom_layout';

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

SELECT id FROM schedule_tasks WHERE `cid` = 718 AND `ctype` = 'object' ;

SELECT
  id
FROM
  objects
WHERE
  id IN (713)

SELECT id FROM objects WHERE id IN (713);