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 
  o_id 
FROM 
  objects 
WHERE 
  o_path = : path 
  AND `o_key` = : key

SELECT o_id FROM objects WHERE o_path = '/Vehicle Price Options/1CSHA5KIFQY0A0C4/' AND `o_key` = '1CSHA5KIFQY0A0C4_LK_DQK_15';

SELECT 
  name 
FROM 
  classes 
WHERE 
  id = ?

SELECT name FROM classes WHERE id = '13';

SELECT 
  o_id 
FROM 
  objects 
WHERE 
  o_path = : path 
  AND `o_key` = : key

SELECT o_id FROM objects WHERE o_path = '/Location/State/' AND `o_key` = 'LAKSHADWEEP';

SELECT 
  o_id 
FROM 
  objects 
WHERE 
  o_path = : path 
  AND `o_key` = : key

SELECT o_id FROM objects WHERE o_path = '/Vehicle Master/' AND `o_key` = '1CSHA5KIFQY0A0C4';

SELECT 
  o_id 
FROM 
  objects 
WHERE 
  o_path = : path 
  AND `o_key` = : key

SELECT o_id FROM objects WHERE o_path = '/Location/State/' AND `o_key` = 'TAMIL NADU';

SELECT 
  o_id 
FROM 
  objects 
WHERE 
  o_path = : path 
  AND `o_key` = : key

SELECT o_id FROM objects WHERE o_path = '/Country/' AND `o_key` = 'India';

SELECT 
  o_id 
FROM 
  objects 
WHERE 
  o_path = : path 
  AND `o_key` = : key

SELECT o_id FROM objects WHERE o_path = '/Currency/' AND `o_key` = 'INR';

SELECT 
  CONCAT(o_path, `o_key`) as o_path 
FROM 
  objects 
WHERE 
  o_id = ?

SELECT CONCAT(o_path,`o_key`) as o_path FROM objects WHERE o_id = 52555;

SELECT 
  o_id 
FROM 
  objects 
WHERE 
  o_path = : path 
  AND `o_key` = : key

SELECT o_id FROM objects WHERE o_path = '/Vehicle Price Options/1CSHA5KIFQY0A0C4/' AND `o_key` = '1CSHA5KIFQY0A0C4_LK_DQK_15';

SELECT 
  o_id 
FROM 
  objects 
WHERE 
  o_path = : path 
  AND `o_key` = : key

SELECT o_id FROM objects WHERE o_path = '/Vehicle Price Options/1CSHA5KIFQY0A0C4/' AND `o_key` = '1CSHA5KIFQY0A0C4_LK_DQK_15';

"START TRANSACTION"

"START TRANSACTION";

SELECT 
  CONCAT(o_path, `o_key`) as o_path 
FROM 
  objects 
WHERE 
  o_id = ?

SELECT CONCAT(o_path,`o_key`) as o_path FROM objects WHERE o_id = 52699;

SELECT 
  o_versionCount 
FROM 
  objects 
WHERE 
  o_id = ? FOR 
UPDATE

SELECT o_versionCount FROM objects WHERE o_id = 52699 FOR UPDATE;

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

SELECT MAX(versionCount) FROM versions WHERE cid = 52699 AND ctype = 'object';

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

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,52555,40398) AND inheritable = 1) OR cid = 52699 ) AND ctype='object';

DELETE FROM 
  properties 
WHERE 
  cid = ? 
  AND ctype = ?

DELETE FROM properties WHERE cid = 52699 AND ctype = 'object';

SELECT 
  id, 
  targetType, 
  targetId 
FROM 
  dependencies 
WHERE 
  sourceType = ? 
  AND sourceId = ?

SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'object' AND sourceId = 52699;

SHOW COLUMNS 
FROM 
  objects

SHOW COLUMNS FROM objects;

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

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

INSERT INTO `objects` (
  `o_classId`, `o_className`, `o_published`, 
  `o_id`, `o_parentId`, `o_type`, `o_key`, 
  `o_path`, `o_index`, `o_creationDate`, 
  `o_modificationDate`, `o_userOwner`, 
  `o_userModification`, `o_childrenSortBy`, 
  `o_versionCount`
) 
VALUES 
  (
    : col0, : col1, : col2, : col3, : col4, : col5, 
    : col6, : col7, : col8, : col9, : col10, 
    : col11, : col12, : col13, : col14
  ) ON DUPLICATE KEY 
UPDATE 
  `o_classId` = : col0, 
  `o_className` = : col1, 
  `o_published` = : col2, 
  `o_id` = : col3, 
  `o_parentId` = : col4, 
  `o_type` = : col5, 
  `o_key` = : col6, 
  `o_path` = : col7, 
  `o_index` = : col8, 
  `o_creationDate` = : col9, 
  `o_modificationDate` = : col10, 
  `o_userOwner` = : col11, 
  `o_userModification` = : col12, 
  `o_childrenSortBy` = : col13, 
  `o_versionCount` = : col14;

INSERT INTO `objects` (`o_classId`, `o_className`, `o_published`, `o_id`, `o_parentId`, `o_type`, `o_key`, `o_path`, `o_index`, `o_creationDate`, `o_modificationDate`, `o_userOwner`, `o_userModification`, `o_childrenSortBy`, `o_versionCount`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13, :col14) ON DUPLICATE KEY UPDATE `o_classId` = :col0, `o_className` = :col1, `o_published` = :col2, `o_id` = :col3, `o_parentId` = :col4, `o_type` = :col5, `o_key` = :col6, `o_path` = :col7, `o_index` = :col8, `o_creationDate` = :col9, `o_modificationDate` = :col10, `o_userOwner` = :col11, `o_userModification` = :col12, `o_childrenSortBy` = :col13, `o_versionCount` = :col14;;

DELETE FROM 
  tree_locks 
WHERE 
  id = ? 
  AND type = ?

DELETE FROM tree_locks WHERE id = 52699 AND type = 'object';

DELETE FROM 
  object_relations_13 
WHERE 
  (
    src_id = '52699' 
    AND fieldname not in (
      'plantRegion', 'custRegion', 'country', 
      'currency', 'lcdv16'
    ) 
    AND ownertype = 'object' 
    AND ownerType != "localizedfield" 
    AND ownerType != "fieldcollection"
  )

DELETE FROM object_relations_13 WHERE (src_id = '52699' AND fieldname not in ('plantRegion','custRegion','country','currency','lcdv16') AND ownertype = 'object' AND ownerType != "localizedfield" AND ownerType != "fieldcollection");

INSERT INTO `object_store_13` (
  `oo_id`, `condType`, `saleOrg`, `distCha`, 
  `city`, `mainAttr`, `validStart`, 
  `validEnd`, `amount`, `exGSTPrice`
) 
VALUES 
  (
    : col0, : col1, : col2, : col3, : col4, : col5, 
    : col6, : col7, : col8, : col9
  ) ON DUPLICATE KEY 
UPDATE 
  `oo_id` = : col0, 
  `condType` = : col1, 
  `saleOrg` = : col2, 
  `distCha` = : col3, 
  `city` = : col4, 
  `mainAttr` = : col5, 
  `validStart` = : col6, 
  `validEnd` = : col7, 
  `amount` = : col8, 
  `exGSTPrice` = : col9;

INSERT INTO `object_store_13` (`oo_id`, `condType`, `saleOrg`, `distCha`, `city`, `mainAttr`, `validStart`, `validEnd`, `amount`, `exGSTPrice`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9) ON DUPLICATE KEY UPDATE `oo_id` = :col0, `condType` = :col1, `saleOrg` = :col2, `distCha` = :col3, `city` = :col4, `mainAttr` = :col5, `validStart` = :col6, `validEnd` = :col7, `amount` = :col8, `exGSTPrice` = :col9;;

SELECT 
  * 
FROM 
  object_query_13 
WHERE 
  oo_id = ?

SELECT * FROM object_query_13 WHERE oo_id = 52699;

INSERT INTO `object_query_13` (
  `condType`, `saleOrg`, `distCha`, 
  `city`, `mainAttr`, `validStart`, 
  `validEnd`, `amount`, `exGSTPrice`, 
  `oo_id`
) 
VALUES 
  (
    : col0, : col1, : col2, : col3, : col4, : col5, 
    : col6, : col7, : col8, : col9
  ) ON DUPLICATE KEY 
UPDATE 
  `condType` = : col0, 
  `saleOrg` = : col1, 
  `distCha` = : col2, 
  `city` = : col3, 
  `mainAttr` = : col4, 
  `validStart` = : col5, 
  `validEnd` = : col6, 
  `amount` = : col7, 
  `exGSTPrice` = : col8, 
  `oo_id` = : col9;

INSERT INTO `object_query_13` (`condType`, `saleOrg`, `distCha`, `city`, `mainAttr`, `validStart`, `validEnd`, `amount`, `exGSTPrice`, `oo_id`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9) ON DUPLICATE KEY UPDATE `condType` = :col0, `saleOrg` = :col1, `distCha` = :col2, `city` = :col3, `mainAttr` = :col4, `validStart` = :col5, `validEnd` = :col6, `amount` = :col7, `exGSTPrice` = :col8, `oo_id` = :col9;;

SELECT 
  id 
FROM 
  schedule_tasks 
WHERE 
  cid = ? 
  AND ctype = 'object'

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

DELETE FROM 
  schedule_tasks 
WHERE 
  cid = ? 
  AND ctype = ?

DELETE FROM schedule_tasks WHERE cid = 52699 AND ctype = 'object';

SHOW COLUMNS 
FROM 
  versions

SHOW COLUMNS FROM versions;

INSERT INTO `versions` (
  `id`, `cid`, `ctype`, `userId`, `note`, 
  `date`, `public`, `serialized`, `stackTrace`, 
  `versionCount`, `binaryFileHash`, 
  `binaryFileId`
) 
VALUES 
  (
    : col0, : col1, : col2, : col3, : col4, : col5, 
    : col6, : col7, : col8, : col9, : col10, 
    : col11
  ) 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;

INSERT INTO `versions` (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11) 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;;

"COMMIT"

"COMMIT";

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

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

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 = 52699;

SELECT 
  * 
FROM 
  object_store_13 
WHERE 
  oo_id = ?

SELECT * FROM object_store_13 WHERE oo_id = 52699;

SELECT 
  * 
FROM 
  object_relations_13 
WHERE 
  src_id = ?

SELECT * FROM object_relations_13 WHERE src_id = 52699;

SELECT 
  * 
FROM 
  search_backend_data 
WHERE 
  id = ? 
  AND maintype = ?

SELECT * FROM search_backend_data WHERE id= 52699 AND maintype = 'object' ;

INSERT INTO `search_backend_data` (
  `id`, `fullpath`, `maintype`, `type`, 
  `subtype`, `published`, `creationDate`, 
  `modificationDate`, `userOwner`, 
  `userModification`, `data`, `properties`
) 
VALUES 
  (
    : col0, : col1, : col2, : col3, : col4, : col5, 
    : col6, : col7, : col8, : col9, : col10, 
    : col11
  ) ON DUPLICATE KEY 
UPDATE 
  `id` = : col0, 
  `fullpath` = : col1, 
  `maintype` = : col2, 
  `type` = : col3, 
  `subtype` = : col4, 
  `published` = : col5, 
  `creationDate` = : col6, 
  `modificationDate` = : col7, 
  `userOwner` = : col8, 
  `userModification` = : col9, 
  `data` = : col10, 
  `properties` = : col11;

INSERT INTO `search_backend_data` (`id`, `fullpath`, `maintype`, `type`, `subtype`, `published`, `creationDate`, `modificationDate`, `userOwner`, `userModification`, `data`, `properties`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11) ON DUPLICATE KEY UPDATE `id` = :col0, `fullpath` = :col1, `maintype` = :col2, `type` = :col3, `subtype` = :col4, `published` = :col5, `creationDate` = :col6, `modificationDate` = :col7, `userOwner` = :col8, `userModification` = :col9, `data` = :col10, `properties` = :col11;;