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

SELECT
  *
FROM
  versions
WHERE
  id = ?

SELECT * FROM versions WHERE id = 227115;

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

SELECT id FROM versions WHERE cid = 3140 AND ctype = 'object' AND (autoSave=0 OR (autoSave=1 AND userId = 16))   ORDER BY `date` ASC;

SELECT
  *
FROM
  object_localized_data_35
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'fr', 'it', 'da', 'ro', 'nl',
    'uk', 'ru'
  )

SELECT * FROM object_localized_data_35 WHERE ooo_id = 3140 AND language IN ('en','de','fr','it','da','ro','nl','uk','ru');

SELECT
  *
FROM
  object_classificationstore_data_35
WHERE
  o_id = '3140'
  AND fieldname = 'categoryParameters'

SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters';

SELECT
  *
FROM
  object_classificationstore_groups_35
WHERE
  o_id = '3140'
  AND fieldname = 'categoryParameters'

SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters';

SELECT
  *
FROM
  object_relations_35
WHERE
  src_id = ?

SELECT * FROM object_relations_35 WHERE src_id = 3140;

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

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

SELECT
  *
FROM
  object_store_35
WHERE
  oo_id = ?

SELECT * FROM object_store_35 WHERE oo_id = 3140;

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 ('object_3140\0tags\0', 0x000000022074A5A5EA5A23B128, NULL, 1789636301) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

SELECT
  *
FROM
  object_classificationstore_data_35
WHERE
  o_id = '3140'
  AND fieldname = 'categoryProperties'

SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties';

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

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

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 16;

SELECT
  *
FROM
  object_classificationstore_groups_35
WHERE
  o_id = '3140'
  AND fieldname = 'categoryProperties'

SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '35';

SELECT
  o_type,
  o_className,
  o_classId
FROM
  objects
WHERE
  o_id = ?

SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 3140;

select
  `highlights`
from
  object_localized_data_35
where
  language = 'da'
  and ooo_id = 3140

select `highlights` from object_localized_data_35 where language = 'da' and  ooo_id  = 3140;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 16;

select
  `highlights`
from
  object_localized_data_35
where
  language = 'de'
  and ooo_id = 3140

select `highlights` from object_localized_data_35 where language = 'de' and  ooo_id  = 3140;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 16;

select
  `highlights`
from
  object_localized_data_35
where
  language = 'en'
  and ooo_id = 3140

select `highlights` from object_localized_data_35 where language = 'en' and  ooo_id  = 3140;

select
  `highlights`
from
  object_localized_data_35
where
  language = 'it'
  and ooo_id = 3140

select `highlights` from object_localized_data_35 where language = 'it' and  ooo_id  = 3140;

select
  `highlights`
from
  object_localized_data_35
where
  language = 'fr'
  and ooo_id = 3140

select `highlights` from object_localized_data_35 where language = 'fr' and  ooo_id  = 3140;

select
  `highlights`
from
  object_localized_data_35
where
  language = 'nl'
  and ooo_id = 3140

select `highlights` from object_localized_data_35 where language = 'nl' and  ooo_id  = 3140;

select
  `highlights`
from
  object_localized_data_35
where
  language = 'ro'
  and ooo_id = 3140

select `highlights` from object_localized_data_35 where language = 'ro' and  ooo_id  = 3140;

select
  `highlights`
from
  object_localized_data_35
where
  language = 'uk'
  and ooo_id = 3140

select `highlights` from object_localized_data_35 where language = 'uk' and  ooo_id  = 3140;

select
  `highlights`
from
  object_localized_data_35
where
  language = 'ru'
  and ooo_id = 3140

select `highlights` from object_localized_data_35 where language = 'ru' and  ooo_id  = 3140;