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

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

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

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

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

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, 48070, 119124, 119156, 119216, 119329, 119341, 119490, 119614, 119628, 119761, 119782, 119819, 119893, 119997, 120066, 120113, 120126, 120340, 120608, 120634, 120665, 120947, 121176, 121295, 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
  object_localized_4_ar.o_id as o_id,
  object_localized_4_ar.o_type as o_type
FROM
  object_localized_4_ar
WHERE
  (
    object_localized_4_ar.o_type IN ('object', 'folder')
  )
  AND object_localized_4_ar.o_published = 1
ORDER BY
  `order` ASC
LIMIT
  10

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

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

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

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

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '43';

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

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

SELECT
  object_EF_OSO.o_id as o_id,
  object_EF_OSO.o_type as o_type
FROM
  object_EF_OSO
WHERE
  (
    cartId = ?
    AND IFNULL(successorOrder__id, "") = ""
    AND object_EF_OSO.o_type IN ('object', 'folder')
  )
  AND object_EF_OSO.o_published = 1

SELECT object_EF_OSO.o_id as o_id, object_EF_OSO.o_type as o_type FROM object_EF_OSO WHERE (cartId = 'Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\SessionCart_sesscart_693b42433fa99' AND IFNULL(successorOrder__id , "") = "" AND  object_EF_OSO.o_type IN ('object','folder')) AND object_EF_OSO.o_published = 1;

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

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

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

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

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

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

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

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

SELECT
  COUNT(*)
FROM
  object_localized_38_ar
WHERE
  (
    mostpopular IN (?)
    AND (
      category__id IN (?)
    )
    AND object_localized_38_ar.o_type IN ('object', 'folder')
  )
  AND object_localized_38_ar.o_published = 1

SELECT COUNT(*) FROM object_localized_38_ar WHERE (mostpopular IN ('1') AND (category__id IN ('279'))  AND  object_localized_38_ar.o_type IN ('object','folder')) AND object_localized_38_ar.o_published = 1;

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

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

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

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

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

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

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/ar/resources/business';

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 = '/ar/resources/business' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/ar/resources/business' AND `type` = 'path_query') OR
                (source = 'https://gcs.centric.ae/ar/resources/business' 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_43_ar.o_id as o_id,
  object_localized_43_ar.o_type as o_type
FROM
  object_localized_43_ar
WHERE
  (
    o_id IN (?)
    AND object_localized_43_ar.o_type IN ('object', 'folder')
  )
  AND object_localized_43_ar.o_published = 1

SELECT object_localized_43_ar.o_id as o_id, object_localized_43_ar.o_type as o_type FROM object_localized_43_ar WHERE (o_id IN ('279') AND  object_localized_43_ar.o_type IN ('object','folder')) AND object_localized_43_ar.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
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

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 = '/ar/resources/business'
  AND (
    siteId = 0
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

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

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;