Symfony Profiler

SELECT 
  * 
FROM 
  redirects 
WHERE 
  (
    (
      source = : sourcePath 
      AND (
        `type` = : typePath 
        OR `type` = : typeAuto
      )
    ) 
    OR (
      source = : sourcePathQuery 
      AND `type` = : typePathQuery
    ) 
    OR (
      source = : sourceEntireUri 
      AND `type` = : typeEntireUri
    )
  ) 
  AND active = 1 
  AND regex IS NULL 
  AND (
    expiry > UNIX_TIMESTAMP() 
    OR expiry IS NULL
  ) 
  AND sourceSite IS NULL 
  AND priority = 99 
ORDER BY 
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/api/vehiclepriceinfo' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/api/vehiclepriceinfo' AND `type` = 'path_query') OR
                (source = 'http://ps.dp-uat.citroen.in/api/vehiclepriceinfo' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT 
  id 
FROM 
  documents 
WHERE 
  path = : path 
  AND `key` = : key

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

SELECT 
  id 
FROM 
  documents_page 
WHERE 
  prettyUrl = : prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/api/vehiclepriceinfo';

SELECT 
  id 
FROM 
  documents 
WHERE 
  path = : path 
  AND `key` = : key

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

SELECT 
  id 
FROM 
  documents_page 
WHERE 
  prettyUrl = : prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/api';

SELECT 
  id 
FROM 
  documents 
WHERE 
  path = : path 
  AND `key` = : key

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

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

SELECT * FROM users WHERE `type` = 'user' AND `name` = 'PIMAP001';

SELECT 
  * 
FROM 
  users_workspaces_asset 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 9;

SELECT 
  * 
FROM 
  users_workspaces_document 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 9;

SELECT 
  * 
FROM 
  users_workspaces_object 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 9;

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

SELECT * FROM users WHERE `type` = 'role' AND id = '3';

SELECT 
  * 
FROM 
  users_workspaces_asset 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 3;

SELECT 
  * 
FROM 
  users_workspaces_document 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 3;

SELECT 
  * 
FROM 
  users_workspaces_object 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 3;

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

SELECT * FROM users WHERE `type` = 'user' AND `name` = 'PIMAP001';

SELECT 
  * 
FROM 
  users_workspaces_asset 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 9;

SELECT 
  * 
FROM 
  users_workspaces_document 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 9;

SELECT 
  * 
FROM 
  users_workspaces_object 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 9;

UPDATE 
  users 
SET 
  `lastLogin` = ? 
WHERE 
  `id` = ?

UPDATE users SET `lastLogin` = 1761656458 WHERE `id` = 9;

SELECT 
  name 
FROM 
  classes 
WHERE 
  id = ?

SELECT name FROM classes WHERE id = '4';

SELECT 
  object_4.o_id as o_id, 
  `object_4`.`o_type` 
FROM 
  `object_4` 
WHERE 
  (
    (
      code = '21' 
      AND object_4.o_type IN ('object', 'folder')
    ) 
    AND object_4.o_published = 1
  ) 
LIMIT 
  1

SELECT object_4.o_id as o_id, `object_4`.`o_type` FROM `object_4` WHERE ((code = '21'  AND  object_4.o_type IN ('object','folder')) AND object_4.o_published = 1) LIMIT 1;

SELECT 
  name 
FROM 
  classes 
WHERE 
  id = ?

SELECT name FROM classes WHERE id = '15';

SELECT 
  object_15.o_id as o_id, 
  `object_15`.`o_type` 
FROM 
  `object_15` 
WHERE 
  (
    (
      lcdv = '1CSISUKIFKY0A0D4' 
      AND object_15.o_type IN ('object', 'folder')
    ) 
    AND object_15.o_published = 1
  ) 
LIMIT 
  1

SELECT object_15.o_id as o_id, `object_15`.`o_type` FROM `object_15` WHERE ((lcdv = '1CSISUKIFKY0A0D4'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1) LIMIT 1;

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

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

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

SELECT 
  * 
FROM 
  object_store_15 
WHERE 
  oo_id = ?

SELECT * FROM object_store_15 WHERE oo_id = 53558;

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

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

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

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

SELECT 
  * 
FROM 
  object_relations_15 
WHERE 
  src_id = ?

SELECT * FROM object_relations_15 WHERE src_id = 53558;

SELECT 
  object_12.o_id as o_id, 
  `object_12`.`o_type` 
FROM 
  `object_12` 
WHERE 
  (
    (
      lcdv16__id = : lcdv 
      AND (customerRegion__id = : regid) 
      AND object_12.o_type IN ('object', 'folder')
    ) 
    AND object_12.o_published = 1
  )

SELECT object_12.o_id as o_id, `object_12`.`o_type` FROM `object_12` WHERE ((lcdv16__id = 53558 AND (customerRegion__id = 872)  AND  object_12.o_type IN ('object','folder')) AND object_12.o_published = 1);

SELECT 
  object_13.o_id as o_id, 
  `object_13`.`o_type` 
FROM 
  `object_13` 
WHERE 
  (
    (
      lcdv16__id = : lcdv 
      AND (custRegion__id = : regid) 
      AND object_13.o_type IN ('object', 'folder')
    ) 
    AND object_13.o_published = 1
  )

SELECT object_13.o_id as o_id, `object_13`.`o_type` FROM `object_13` WHERE ((lcdv16__id = 53558 AND (custRegion__id = 872)  AND  object_13.o_type IN ('object','folder')) AND object_13.o_published = 1);

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

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

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

SELECT 
  name 
FROM 
  classes 
WHERE 
  id = ?

SELECT name FROM classes WHERE id = '13';

SELECT 
  * 
FROM 
  object_store_13 
WHERE 
  oo_id = ?

SELECT * FROM object_store_13 WHERE oo_id = 53560;

SELECT 
  * 
FROM 
  object_relations_13 
WHERE 
  src_id = ?

SELECT * FROM object_relations_13 WHERE src_id = 53560;

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

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

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

SELECT 
  * 
FROM 
  object_store_13 
WHERE 
  oo_id = ?

SELECT * FROM object_store_13 WHERE oo_id = 53596;

SELECT 
  * 
FROM 
  object_relations_13 
WHERE 
  src_id = ?

SELECT * FROM object_relations_13 WHERE src_id = 53596;

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

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

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

SELECT 
  * 
FROM 
  object_store_13 
WHERE 
  oo_id = ?

SELECT * FROM object_store_13 WHERE oo_id = 53632;

SELECT 
  * 
FROM 
  object_relations_13 
WHERE 
  src_id = ?

SELECT * FROM object_relations_13 WHERE src_id = 53632;

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

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

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

SELECT 
  * 
FROM 
  object_store_13 
WHERE 
  oo_id = ?

SELECT * FROM object_store_13 WHERE oo_id = 53668;

SELECT 
  * 
FROM 
  object_relations_13 
WHERE 
  src_id = ?

SELECT * FROM object_relations_13 WHERE src_id = 53668;

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

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

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

SELECT 
  * 
FROM 
  object_store_13 
WHERE 
  oo_id = ?

SELECT * FROM object_store_13 WHERE oo_id = 53704;

SELECT 
  * 
FROM 
  object_relations_13 
WHERE 
  src_id = ?

SELECT * FROM object_relations_13 WHERE src_id = 53704;

SELECT 
  object_5.o_id as o_id, 
  `object_5`.`o_type` 
FROM 
  `object_5` 
WHERE 
  (
    (
      lcdv16__id = : lcdv 
      AND (customerRegion__id = : regid) 
      AND object_5.o_type IN ('object', 'folder')
    ) 
    AND object_5.o_published = 1
  )

SELECT object_5.o_id as o_id, `object_5`.`o_type` FROM `object_5` WHERE ((lcdv16__id = 53558 AND (customerRegion__id = 872)  AND  object_5.o_type IN ('object','folder')) AND object_5.o_published = 1);

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

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

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

SELECT 
  name 
FROM 
  classes 
WHERE 
  id = ?

SELECT name FROM classes WHERE id = '5';

SELECT 
  * 
FROM 
  object_store_5 
WHERE 
  oo_id = ?

SELECT * FROM object_store_5 WHERE oo_id = 53522;

SELECT 
  * 
FROM 
  object_relations_5 
WHERE 
  src_id = ?

SELECT * FROM object_relations_5 WHERE src_id = 53522;

SELECT 
  object_14.o_id as o_id, 
  `object_14`.`o_type` 
FROM 
  `object_14` 
WHERE 
  (
    (
      lcdv16__id = ? 
      AND (custRegion__id = ?) 
      AND object_14.o_type IN ('object', 'folder')
    ) 
    AND object_14.o_published = 1
  )

SELECT object_14.o_id as o_id, `object_14`.`o_type` FROM `object_14` WHERE ((lcdv16__id = 53558 AND (custRegion__id = 872)  AND  object_14.o_type IN ('object','folder')) AND object_14.o_published = 1);