Symfony Profiler

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

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

SELECT 
  * 
FROM 
  object_relations_15 
WHERE 
  src_id = ?

SELECT * FROM object_relations_15 WHERE src_id = 52362;

SELECT 
  * 
FROM 
  object_store_15 
WHERE 
  oo_id = ?

SELECT * FROM object_store_15 WHERE oo_id = 52362;

SELECT 
  * 
FROM 
  object_collection_VehicleMasterCharacteristics_15 
WHERE 
  o_id = ? 
  AND fieldname = ? 
ORDER BY 
  `index` ASC

SELECT * FROM object_collection_VehicleMasterCharacteristics_15 WHERE o_id = 52362 AND fieldname = 'descriptiveInformation' ORDER BY `index` ASC;

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

INSERT INTO object_relations_15 (
  `dest_id`, `type`, `fieldname`, `src_id`, 
  `ownertype`, `ownername`, `position`
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_relations_15 (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (36, 'object', 'characteristics', 52362, 'fieldcollection', 'basicInformation', 0);

INSERT INTO object_collection_VehicleMasterCharacteristics_15 (
  `o_id`, `index`, `fieldname`, `isVisibleOnFront`, 
  `vmValues`, `vmValDesc`, `CommDescription`, 
  `dependency`
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_VehicleMasterCharacteristics_15 (`o_id`, `index`, `fieldname`, `isVisibleOnFront`, `vmValues`, `vmValDesc`, `CommDescription`, `dependency`) VALUES (52362, 0, 'basicInformation', 0, '01', 'VEHICULE PARTICULIER A900', '', 'a:0:{}');

"COMMIT"

"COMMIT";

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

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 49455 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 49455 and fieldname = 'descriptiveInformation' and `index` = 0;

DELETE FROM 
  object_collection_VehicleMasterCharacteristics_15 
WHERE 
  o_id = ? 
  AND fieldname = ?

DELETE FROM object_collection_VehicleMasterCharacteristics_15 WHERE o_id = 52362 AND fieldname = 'basicInformation';

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 26545 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 26545 and fieldname = 'descriptiveInformation' and `index` = 0;

SELECT 
  id, 
  date, 
  versionCount 
FROM 
  versions 
WHERE 
  cid = ? 
  AND ctype = 'object' 
ORDER BY 
  `versionCount` DESC, 
  `id` DESC 
LIMIT 
  1

SELECT id,date,versionCount FROM versions WHERE cid = 52362 AND ctype='object' ORDER BY `versionCount` DESC, `id` DESC LIMIT 1;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 22

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 22;

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` = '1CSHA5KIFKY0A0C4';

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

DELETE FROM 
  object_relations_15 
WHERE 
  (
    ownertype = 'fieldcollection' 
    AND ownername = 'basicInformation' 
    AND src_id = '52362'
  ) 
  OR (
    ownertype = 'localizedfield' 
    AND ownername LIKE '/fieldcollection~basicInformation/%' 
    AND src_id = '52362'
  )

DELETE FROM object_relations_15 WHERE (ownertype = 'fieldcollection' AND ownername = 'basicInformation' AND src_id = '52362') OR (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~basicInformation/%' AND src_id = '52362');

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'descriptiveInformation' and `index` = 0;

SELECT 
  tree_locks.id 
FROM 
  tree_locks 
  INNER JOIN objects ON tree_locks.id = objects.o_id 
WHERE 
  objects.o_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.o_id WHERE objects.o_path LIKE '/Vehicle Master/1CSHA5KIFKY0A0C4/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT 
  name 
FROM 
  classes 
WHERE 
  id = ?

SELECT name FROM classes WHERE id = '15';

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

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 45723 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 45723 and fieldname = 'descriptiveInformation' and `index` = 0;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 21

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 21;

INSERT INTO `object_store_15` (
  `oo_id`, `lcdv`, `startDate`, `endDate`, 
  `name`, `commercialDescription`, 
  `modelName`, `variantName`, `isDefaultVariant`, 
  `modelType`, `dst_is_disabled`, 
  `dp_is_disabled`, `validityStart`, 
  `validityEnd`, `cubicCapacity`, 
  `kilowatt`, `sittingCapacity`, `isantiTheftFaceLifted`, 
  `fuelType`, `groundClearance`, `length`, 
  `weight`, `isImported`, `isHybrid`, 
  `batteryCapacity`, `axisVariantName`, 
  `axisbrandId`, `axisvariantId`, 
  `axismakeId`, `axiscategory`
) 
VALUES 
  (
    : col0, : col1, : col2, : col3, : col4, : col5, 
    : col6, : col7, : col8, : col9, : col10, 
    : col11, : col12, : col13, : col14, : col15, 
    : col16, : col17, : col18, : col19, : col20, 
    : col21, : col22, : col23, : col24, : col25, 
    : col26, : col27, : col28, : col29
  ) ON DUPLICATE KEY 
UPDATE 
  `oo_id` = : col0, 
  `lcdv` = : col1, 
  `startDate` = : col2, 
  `endDate` = : col3, 
  `name` = : col4, 
  `commercialDescription` = : col5, 
  `modelName` = : col6, 
  `variantName` = : col7, 
  `isDefaultVariant` = : col8, 
  `modelType` = : col9, 
  `dst_is_disabled` = : col10, 
  `dp_is_disabled` = : col11, 
  `validityStart` = : col12, 
  `validityEnd` = : col13, 
  `cubicCapacity` = : col14, 
  `kilowatt` = : col15, 
  `sittingCapacity` = : col16, 
  `isantiTheftFaceLifted` = : col17, 
  `fuelType` = : col18, 
  `groundClearance` = : col19, 
  `length` = : col20, 
  `weight` = : col21, 
  `isImported` = : col22, 
  `isHybrid` = : col23, 
  `batteryCapacity` = : col24, 
  `axisVariantName` = : col25, 
  `axisbrandId` = : col26, 
  `axisvariantId` = : col27, 
  `axismakeId` = : col28, 
  `axiscategory` = : col29;

INSERT INTO `object_store_15` (`oo_id`, `lcdv`, `startDate`, `endDate`, `name`, `commercialDescription`, `modelName`, `variantName`, `isDefaultVariant`, `modelType`, `dst_is_disabled`, `dp_is_disabled`, `validityStart`, `validityEnd`, `cubicCapacity`, `kilowatt`, `sittingCapacity`, `isantiTheftFaceLifted`, `fuelType`, `groundClearance`, `length`, `weight`, `isImported`, `isHybrid`, `batteryCapacity`, `axisVariantName`, `axisbrandId`, `axisvariantId`, `axismakeId`, `axiscategory`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13, :col14, :col15, :col16, :col17, :col18, :col19, :col20, :col21, :col22, :col23, :col24, :col25, :col26, :col27, :col28, :col29) ON DUPLICATE KEY UPDATE `oo_id` = :col0, `lcdv` = :col1, `startDate` = :col2, `endDate` = :col3, `name` = :col4, `commercialDescription` = :col5, `modelName` = :col6, `variantName` = :col7, `isDefaultVariant` = :col8, `modelType` = :col9, `dst_is_disabled` = :col10, `dp_is_disabled` = :col11, `validityStart` = :col12, `validityEnd` = :col13, `cubicCapacity` = :col14, `kilowatt` = :col15, `sittingCapacity` = :col16, `isantiTheftFaceLifted` = :col17, `fuelType` = :col18, `groundClearance` = :col19, `length` = :col20, `weight` = :col21, `isImported` = :col22, `isHybrid` = :col23, `batteryCapacity` = :col24, `axisVariantName` = :col25, `axisbrandId` = :col26, `axisvariantId` = :col27, `axismakeId` = :col28, `axiscategory` = :col29;;

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

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

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 23

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 23;

INSERT INTO `object_query_15` (
  `lcdv`, `startDate`, `endDate`, `name`, 
  `commercialDescription`, `modelName`, 
  `variantName`, `isDefaultVariant`, 
  `modelType`, `dst_is_disabled`, 
  `dp_is_disabled`, `validityStart`, 
  `validityEnd`, `cubicCapacity`, 
  `kilowatt`, `sittingCapacity`, `isantiTheftFaceLifted`, 
  `fuelType`, `groundClearance`, `length`, 
  `weight`, `isImported`, `isHybrid`, 
  `batteryCapacity`, `axisVariantName`, 
  `axisbrandId`, `axisvariantId`, 
  `axismakeId`, `axiscategory`, `oo_id`
) 
VALUES 
  (
    : col0, : col1, : col2, : col3, : col4, : col5, 
    : col6, : col7, : col8, : col9, : col10, 
    : col11, : col12, : col13, : col14, : col15, 
    : col16, : col17, : col18, : col19, : col20, 
    : col21, : col22, : col23, : col24, : col25, 
    : col26, : col27, : col28, : col29
  ) ON DUPLICATE KEY 
UPDATE 
  `lcdv` = : col0, 
  `startDate` = : col1, 
  `endDate` = : col2, 
  `name` = : col3, 
  `commercialDescription` = : col4, 
  `modelName` = : col5, 
  `variantName` = : col6, 
  `isDefaultVariant` = : col7, 
  `modelType` = : col8, 
  `dst_is_disabled` = : col9, 
  `dp_is_disabled` = : col10, 
  `validityStart` = : col11, 
  `validityEnd` = : col12, 
  `cubicCapacity` = : col13, 
  `kilowatt` = : col14, 
  `sittingCapacity` = : col15, 
  `isantiTheftFaceLifted` = : col16, 
  `fuelType` = : col17, 
  `groundClearance` = : col18, 
  `length` = : col19, 
  `weight` = : col20, 
  `isImported` = : col21, 
  `isHybrid` = : col22, 
  `batteryCapacity` = : col23, 
  `axisVariantName` = : col24, 
  `axisbrandId` = : col25, 
  `axisvariantId` = : col26, 
  `axismakeId` = : col27, 
  `axiscategory` = : col28, 
  `oo_id` = : col29;

INSERT INTO `object_query_15` (`lcdv`, `startDate`, `endDate`, `name`, `commercialDescription`, `modelName`, `variantName`, `isDefaultVariant`, `modelType`, `dst_is_disabled`, `dp_is_disabled`, `validityStart`, `validityEnd`, `cubicCapacity`, `kilowatt`, `sittingCapacity`, `isantiTheftFaceLifted`, `fuelType`, `groundClearance`, `length`, `weight`, `isImported`, `isHybrid`, `batteryCapacity`, `axisVariantName`, `axisbrandId`, `axisvariantId`, `axismakeId`, `axiscategory`, `oo_id`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13, :col14, :col15, :col16, :col17, :col18, :col19, :col20, :col21, :col22, :col23, :col24, :col25, :col26, :col27, :col28, :col29) ON DUPLICATE KEY UPDATE `lcdv` = :col0, `startDate` = :col1, `endDate` = :col2, `name` = :col3, `commercialDescription` = :col4, `modelName` = :col5, `variantName` = :col6, `isDefaultVariant` = :col7, `modelType` = :col8, `dst_is_disabled` = :col9, `dp_is_disabled` = :col10, `validityStart` = :col11, `validityEnd` = :col12, `cubicCapacity` = :col13, `kilowatt` = :col14, `sittingCapacity` = :col15, `isantiTheftFaceLifted` = :col16, `fuelType` = :col17, `groundClearance` = :col18, `length` = :col19, `weight` = :col20, `isImported` = :col21, `isHybrid` = :col22, `batteryCapacity` = :col23, `axisVariantName` = :col24, `axisbrandId` = :col25, `axisvariantId` = :col26, `axismakeId` = :col27, `axiscategory` = :col28, `oo_id` = :col29;;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 4

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 4;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 1

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 1;

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

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

SELECT 
  * 
FROM 
  users_workspaces_asset 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 2;

SELECT 
  object_10.o_id as o_id, 
  `object_10`.`o_type` 
FROM 
  `object_10` 
WHERE 
  (
    (
      `vehicle__id` = ? 
      AND `vehicle__type` = ?
    ) 
    AND object_10.o_type IN ('object', 'folder')
  )

SELECT object_10.o_id as o_id, `object_10`.`o_type` FROM `object_10` WHERE ((`vehicle__id` = 52362 AND `vehicle__type` = 'object')  AND  object_10.o_type IN ('object','folder'));

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

SELECT 
  object_15.o_id as o_id, 
  `object_15`.`o_type` 
FROM 
  `object_15` 
WHERE 
  (
    object_15.o_type IN ('object', 'folder')
  )

SELECT object_15.o_id as o_id, `object_15`.`o_type` FROM `object_15` WHERE ( object_15.o_type IN ('object','folder'));

SHOW COLUMNS 
FROM 
  versions

SHOW COLUMNS FROM versions;

SHOW COLUMNS 
FROM 
  objects

SHOW COLUMNS FROM objects;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 18

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 18;

SELECT 
  o_versionCount 
FROM 
  objects 
WHERE 
  o_id = ? FOR 
UPDATE

SELECT o_versionCount FROM objects WHERE o_id = 52362 FOR UPDATE;

SELECT 
  * 
FROM 
  object_query_15 
WHERE 
  oo_id = ?

SELECT * FROM object_query_15 WHERE oo_id = 52362;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 44658 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 44658 and fieldname = 'descriptiveInformation' and `index` = 0;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 26222 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 26222 and fieldname = 'descriptiveInformation' and `index` = 0;

SELECT 
  * 
FROM 
  users_workspaces_object 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 2;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 8

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 8;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 45725 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 45725 and fieldname = 'descriptiveInformation' and `index` = 0;

DELETE FROM 
  properties 
WHERE 
  cid = ? 
  AND ctype = ?

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

SELECT 
  * 
FROM 
  users_workspaces_document 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 2;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 12

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 12;

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

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

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

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

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 0;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 2

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 2;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 14

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 14;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 5

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 5;

DELETE FROM 
  object_relations_15 
WHERE 
  (
    ownertype = 'fieldcollection' 
    AND ownername = 'descriptiveInformation' 
    AND src_id = '52362'
  ) 
  OR (
    ownertype = 'localizedfield' 
    AND ownername LIKE '/fieldcollection~descriptiveInformation/%' 
    AND src_id = '52362'
  )

DELETE FROM object_relations_15 WHERE (ownertype = 'fieldcollection' AND ownername = 'descriptiveInformation' AND src_id = '52362') OR (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~descriptiveInformation/%' AND src_id = '52362');

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 17

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 17;

"START TRANSACTION"

"START TRANSACTION";

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

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

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 38697 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 38697 and fieldname = 'descriptiveInformation' and `index` = 0;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 18729 
  and fieldname = 'descriptiveInformation' 
  and `index` = 2

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 18729 and fieldname = 'descriptiveInformation' and `index` = 2;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 9

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 9;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 19

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 19;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 10

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 10;

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

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

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 16

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 16;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 45722 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 45722 and fieldname = 'descriptiveInformation' and `index` = 0;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 26546 
  and fieldname = 'descriptiveInformation' 
  and `index` = 0

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 26546 and fieldname = 'descriptiveInformation' and `index` = 0;

select 
  `dependency` 
from 
  object_collection_VehicleMasterCharacteristics_15 
where 
  o_id = 52362 
  and fieldname = 'basicInformation' 
  and `index` = 3

select `dependency` from object_collection_VehicleMasterCharacteristics_15 where  o_id  = 52362 and fieldname = 'basicInformation' and `index` = 3;