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

SELECT
  object_localized_38_en.o_id as o_id,
  object_localized_38_en.o_type as o_type
FROM
  object_localized_38_en
WHERE
  (
    object_localized_38_en.o_type IN ('object', 'folder')
  )
  AND object_localized_38_en.o_published = 1

SELECT object_localized_38_en.o_id as o_id, object_localized_38_en.o_type as o_type FROM object_localized_38_en WHERE ( object_localized_38_en.o_type IN ('object','folder')) AND object_localized_38_en.o_published = 1;

SELECT
  object_54.o_id as o_id,
  object_54.o_type as o_type
FROM
  object_54
WHERE
  (
    op_name = ?
    and u_id = ?
    and obj_mod_name = ?
    and obj_data__id IN (?)
    AND object_54.o_type IN ('object', 'folder')
  )
  AND object_54.o_published = 1

SELECT object_54.o_id as o_id, object_54.o_type as o_type FROM object_54 WHERE (op_name = 'Like' and u_id = NULL and obj_mod_name = 'Article' and obj_data__id IN (221, 299, 661, 48070, 119124, 119156, 119197, 119216, 119329, 119341, 119342, 119490, 119614, 119628, 119761, 119782, 119819, 119834, 119835, 119842, 119893, 119900, 119924, 119939, 119954, 119969, 119997, 120066, 120096, 120113, 120126, 120290, 120340, 120371, 120470, 120510, 120608, 120634, 120665, 120704, 120873, 120947, 121176, 121295, 121308, 121342, 121376, 121440, 121514, 121623, 121644, 121657, 121769, 122142, 122328, 122772, 122803, 122806, 122827, 122867, 122874, 122885, 122886, 122937, 122938, 122940, 123031, 123043, 123047, 123056, 123057, 123058, 123069, 123070, 123138, 123139, 123144, 123145, 123147, 123150, 123151, 123167, 123168, 123169, 123171, 123175, 123202, 123203, 123244, 123251, 123252, 123255, 123275, 123276, 123277, 123278, 123279, 123280, 123281, 123282, 123283, 123294, 123295, 123296, 123301, 123302, 123349, 123353, 123358, 123359, 123381, 123382, 123386, 123387, 123389) AND  object_54.o_type IN ('object','folder')) AND object_54.o_published = 1;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '27';

SELECT
  object_localized_11_en.o_id as o_id,
  object_localized_11_en.o_type as o_type
FROM
  object_localized_11_en
WHERE
  (
    object_localized_11_en.o_type IN ('object', 'folder')
  )
  AND object_localized_11_en.o_published = 1

SELECT object_localized_11_en.o_id as o_id, object_localized_11_en.o_type as o_type FROM object_localized_11_en WHERE ( object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1;

SELECT
  object_localized_4_en.o_id as o_id,
  object_localized_4_en.o_type as o_type
FROM
  object_localized_4_en
WHERE
  (
    object_localized_4_en.o_type IN ('object', 'folder')
  )
  AND object_localized_4_en.o_published = 1
ORDER BY
  `order` ASC
LIMIT
  10

SELECT object_localized_4_en.o_id as o_id, object_localized_4_en.o_type as o_type FROM object_localized_4_en WHERE ( object_localized_4_en.o_type IN ('object','folder')) AND object_localized_4_en.o_published = 1 ORDER BY `order` ASC   LIMIT 10;

SELECT
  object_localized_43_en.o_id as o_id,
  object_localized_43_en.o_type as o_type
FROM
  object_localized_43_en
WHERE
  (
    o_parentId = 269
    AND object_localized_43_en.o_type IN ('object', 'folder')
  )
  AND object_localized_43_en.o_published = 1
ORDER BY
  `name` ASC
LIMIT
  20

SELECT object_localized_43_en.o_id as o_id, object_localized_43_en.o_type as o_type FROM object_localized_43_en WHERE (o_parentId = 269 AND  object_localized_43_en.o_type IN ('object','folder')) AND object_localized_43_en.o_published = 1 ORDER BY `name` ASC   LIMIT 20;

SELECT
  object_localized_38_en.o_id as o_id,
  object_localized_38_en.o_type as o_type
FROM
  object_localized_38_en
WHERE
  (
    object_localized_38_en.o_type IN ('object', 'folder')
  )
  AND object_localized_38_en.o_published = 1
ORDER BY
  `o_creationDate` DESC
LIMIT
  4

SELECT object_localized_38_en.o_id as o_id, object_localized_38_en.o_type as o_type FROM object_localized_38_en WHERE ( object_localized_38_en.o_type IN ('object','folder')) AND object_localized_38_en.o_published = 1 ORDER BY `o_creationDate` DESC   LIMIT 4;

SELECT
  object_localized_38_en.o_id as o_id,
  object_localized_38_en.o_type as o_type
FROM
  object_localized_38_en
WHERE
  (
    category__id IN (?)
    AND object_localized_38_en.o_type IN ('object', 'folder')
  )
  AND object_localized_38_en.o_published = 1
LIMIT
  10

SELECT object_localized_38_en.o_id as o_id, object_localized_38_en.o_type as o_type FROM object_localized_38_en WHERE (category__id IN (279) AND  object_localized_38_en.o_type IN ('object','folder')) AND object_localized_38_en.o_published = 1 LIMIT 10;

SELECT
  object_localized_48_en.o_id as o_id,
  object_localized_48_en.o_type as o_type
FROM
  object_localized_48_en
WHERE
  (
    object_localized_48_en.o_type IN ('object', 'folder')
  )
  AND object_localized_48_en.o_published = 1

SELECT object_localized_48_en.o_id as o_id, object_localized_48_en.o_type as o_type FROM object_localized_48_en WHERE ( object_localized_48_en.o_type IN ('object','folder')) AND object_localized_48_en.o_published = 1;

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 = '/en/resources' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/resources' AND `type` = 'path_query') OR
                (source = 'https://gcs.centric.ae/en/resources' 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
  object_localized_67_en.o_id as o_id,
  object_localized_67_en.o_type as o_type
FROM
  object_localized_67_en
WHERE
  (
    o_id NOT IN (?)
    AND object_localized_67_en.o_type IN ('object', 'folder')
  )
  AND object_localized_67_en.o_published = 1
ORDER BY
  `oo_id` DESC
LIMIT
  1

SELECT object_localized_67_en.o_id as o_id, object_localized_67_en.o_type as o_type FROM object_localized_67_en WHERE (o_id NOT IN (122972) AND  object_localized_67_en.o_type IN ('object','folder')) AND object_localized_67_en.o_published = 1 ORDER BY `oo_id` DESC   LIMIT 1;

SELECT
  object_localized_43_en.o_id as o_id,
  object_localized_43_en.o_type as o_type
FROM
  object_localized_43_en
WHERE
  (
    o_parentId = 269
    AND object_localized_43_en.o_type IN ('object', 'folder')
  )
  AND object_localized_43_en.o_published = 1

SELECT object_localized_43_en.o_id as o_id, object_localized_43_en.o_type as o_type FROM object_localized_43_en WHERE (o_parentId = 269 AND  object_localized_43_en.o_type IN ('object','folder')) AND object_localized_43_en.o_published = 1;

SELECT
  object_localized_41_en.o_id as o_id,
  object_localized_41_en.o_type as o_type
FROM
  object_localized_41_en
WHERE
  (
    object_localized_41_en.o_type IN ('object', 'folder')
  )
  AND object_localized_41_en.o_published = 1
ORDER BY
  `order` ASC
LIMIT
  5

SELECT object_localized_41_en.o_id as o_id, object_localized_41_en.o_type as o_type FROM object_localized_41_en WHERE ( object_localized_41_en.o_type IN ('object','folder')) AND object_localized_41_en.o_published = 1 ORDER BY `order` ASC   LIMIT 5;

SELECT
  COUNT(*)
FROM
  object_localized_43_en
WHERE
  (
    o_parentId = 269
    AND object_localized_43_en.o_type IN ('object', 'folder')
  )
  AND object_localized_43_en.o_published = 1

SELECT COUNT(*) FROM object_localized_43_en WHERE (o_parentId = 269 AND  object_localized_43_en.o_type IN ('object','folder')) AND object_localized_43_en.o_published = 1;

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

SELECT o_id FROM objects WHERE o_path = '/NewsLetterHead/' AND `o_key` = 'Newsletter';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 38;

SELECT
  object_27.o_id as o_id,
  object_27.o_type as o_type
FROM
  object_27
WHERE
  (
    o_id = 284
    AND object_27.o_type IN ('object', 'folder')
  )
  AND object_27.o_published = 1

SELECT object_27.o_id as o_id, object_27.o_type as o_type FROM object_27 WHERE (o_id = 284 AND  object_27.o_type IN ('object','folder')) AND object_27.o_published = 1;

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

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

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/resources'
  AND (
    siteId = 0
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/resources' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;