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` = 1747565986 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 = '7' 
      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 = '7'  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 = '1CCESYVKA1Y0FK44' 
      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 = '1CCESYVKA1Y0FK44'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1) LIMIT 1;

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 = 18720 AND (customerRegion__id = 858)  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 = 18720 AND (custRegion__id = 858)  AND  object_13.o_type IN ('object','folder')) AND object_13.o_published = 1);

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 = 18720 AND (customerRegion__id = 858)  AND  object_5.o_type IN ('object','folder')) AND object_5.o_published = 1);

SELECT 
  name 
FROM 
  classes 
WHERE 
  id = ?

SELECT name FROM classes WHERE id = '5';

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 = 18720 AND (custRegion__id = 858)  AND  object_14.o_type IN ('object','folder')) AND object_14.o_published = 1);