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

SELECT
  *
FROM
  object_collection_Period_localized_experience
WHERE
  ooo_id = ?
  AND language IN ('it', 'en', 'de')
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_Period_localized_experience WHERE ooo_id = 531 AND language IN ('it','en','de') AND `fieldname` = 'periods' AND `index` = '0';

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

SELECT * FROM object_collection_Period_experience WHERE o_id = 531 AND fieldname = 'periods' ORDER BY `index` ASC;

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'thumb_32137__e9ad6c16b156537bbaa13ec25c7547b8';

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    o_parentId = ?
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1
ORDER BY
  `o_key` ASC

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 21056 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

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

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

SELECT
  o_id,
  objVisibilityName
FROM
  object_multisite_owner
WHERE
  o_published = 1
  AND (objVisibilityName = 'majellando')
  AND (
    isMainSite = 0
    OR isMainSite IS NULL
  )
ORDER BY
  FIELD(objVisibilityName, 'majellando')

SELECT o_id, objVisibilityName  FROM object_multisite_owner  WHERE o_published = 1 AND ( objVisibilityName = 'majellando' )  AND (isMainSite = 0 OR isMainSite IS NULL) ORDER BY FIELD(objVisibilityName, 'majellando');

SELECT
  *
FROM
  sites
WHERE
  rootId = ?

SELECT * FROM sites WHERE rootId = 15;

SELECT
  cid
FROM
  properties
WHERE
  name = 'multisiteOwner'
  AND data = '3'

SELECT cid FROM properties WHERE name = 'multisiteOwner' AND data = '3' ;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 695;

SELECT
  o_id,
  objVisibilityName
FROM
  object_multisite_owner
WHERE
  o_published = 1
  AND (objVisibilityName = 'majellando')
ORDER BY
  FIELD(objVisibilityName, 'majellando')

SELECT o_id, objVisibilityName  FROM object_multisite_owner  WHERE o_published = 1 AND ( objVisibilityName = 'majellando' ) ORDER BY FIELD(objVisibilityName, 'majellando');

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 = '1'
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/it/esplora-con-majellando/in-famiglia-nei-parchi-d-abruzzo/da-12-mesi-a-15kg/nella-valle-del-tirino' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/it/esplora-con-majellando/in-famiglia-nei-parchi-d-abruzzo/da-12-mesi-a-15kg/nella-valle-del-tirino' AND `type` = 'path_query') OR
                (source = 'https://majellando.by-mf.it/it/esplora-con-majellando/in-famiglia-nei-parchi-d-abruzzo/da-12-mesi-a-15kg/nella-valle-del-tirino' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '1' AND priority = 99 ORDER BY `priority` DESC;

SELECT
  p.o_id
FROM
  object_collection_Period_experience p
  JOIN object_experience o ON o.o_id = p.o_id
WHERE
  (
    p.since >= 1781388000
    OR p.until >= 1781388000
  )
ORDER BY
  p.firstNextDate ASC,
  o.orderingPriority DESC

SELECT p.o_id  FROM object_collection_Period_experience p JOIN object_experience o ON o.o_id = p.o_id  WHERE  (p.since >= 1781388000 OR  p.until >= 1781388000 )  ORDER BY p.firstNextDate ASC , o.orderingPriority DESC ;

SELECT
  DISTINCT p.o_id
FROM
  object_localized_experience_it p
  LEFT JOIN object_relations_experience pl ON pl.src_id = p.o_id
WHERE
  p.o_published = 1
  AND p.title != ""
  AND p.o_id IN (
    584, 616, 531, 622, 42422, 42482, 792,
    117766, 128115, 817, 389487, 880, 888,
    904, 721, 384814, 725, 728, 304237,
    730, 735, 967, 308170, 17708, 736, 321327,
    42418, 783, 882, 916, 213799, 1018,
    308504, 308731, 307430, 205276, 205652,
    219535, 258349, 961, 304267, 626, 606,
    621, 323237, 502, 601, 624, 140940,
    381991, 392338, 393005, 398778, 773,
    625, 37362, 636, 591, 592, 25069, 729
  )
  AND p.multiwebsiteVisibility LIKE '%,majellando,%'
ORDER BY
  p.orderingPriority DESC,
  FIELD(
    p.o_id, 584, 616, 531, 622, 42422, 42482,
    792, 117766, 128115, 817, 389487, 880,
    888, 904, 721, 384814, 725, 728, 304237,
    730, 735, 967, 308170, 17708, 736, 321327,
    42418, 783, 882, 916, 213799, 1018,
    308504, 308731, 307430, 205276, 205652,
    219535, 258349, 961, 304267, 626, 606,
    621, 323237, 502, 601, 624, 140940,
    381991, 392338, 393005, 398778, 773,
    625, 37362, 636, 591, 592, 25069, 729
  )

SELECT DISTINCT p.o_id  FROM object_localized_experience_it p  LEFT JOIN object_relations_experience pl  ON pl.src_id = p.o_id  WHERE  p.o_published = 1  AND  p.title != ""  AND  p.o_id IN (584,616,531,622,42422,42482,792,117766,128115,817,389487,880,888,904,721,384814,725,728,304237,730,735,967,308170,17708,736,321327,42418,783,882,916,213799,1018,308504,308731,307430,205276,205652,219535,258349,961,304267,626,606,621,323237,502,601,624,140940,381991,392338,393005,398778,773,625,37362,636,591,592,25069,729)  AND  p.multiwebsiteVisibility LIKE '%,majellando,%' ORDER BY p.orderingPriority DESC, FIELD(p.o_id,584,616,531,622,42422,42482,792,117766,128115,817,389487,880,888,904,721,384814,725,728,304237,730,735,967,308170,17708,736,321327,42418,783,882,916,213799,1018,308504,308731,307430,205276,205652,219535,258349,961,304267,626,606,621,323237,502,601,624,140940,381991,392338,393005,398778,773,625,37362,636,591,592,25069,729) ;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'multisite_owner';

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId IN(?, ?)
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId IN(695, 695) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 695;

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

SELECT id FROM documents WHERE path = BINARY '/majellando/it/esplora-con-majellando/in-famiglia-nei-parchi-d-abruzzo/da-12-mesi-a-15kg/' AND `key` = BINARY 'nella-valle-del-tirino';

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/it/esplora-con-majellando/in-famiglia-nei-parchi-d-abruzzo/da-12-mesi-a-15kg/nella-valle-del-tirino'
  AND (
    siteId = 1
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/it/esplora-con-majellando/in-famiglia-nei-parchi-d-abruzzo/da-12-mesi-a-15kg/nella-valle-del-tirino' AND (siteId = 1 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 695;

SELECT
  DISTINCT city__id
FROM
  object_contact_location
WHERE
  o_published = 1
  AND o_id IN (
    299267, 452, 587, 245490, 2048, 2025,
    2020, 2028, 2008, 20154, 314034, 2052,
    2053, 466, 820, 2097, 571, 2156, 959,
    2180, 1137, 30496, 878, 885, 67267,
    785, 204891, 299317, 614, 28403, 830,
    25088, 43711, 42512, 117772, 126412,
    301030, 205278, 205653, 213802, 219537,
    258351, 1861, 304684, 308172, 308505,
    308767, 382124, 389488, 392431, 363393
  )

SELECT DISTINCT city__id  FROM object_contact_location  WHERE o_published = 1  AND o_id IN (299267,452,587,245490,2048,2025,2020,2028,2008,20154,314034,2052,2053,466,820,2097,571,2156,959,2180,1137,30496,878,885,67267,785,204891,299317,614,28403,830,25088,43711,42512,117772,126412,301030,205278,205653,213802,219537,258351,1861,304684,308172,308505,308767,382124,389488,392431,363393) ;

select
  oo_id
FROM
  object_localized_experience_category_it
WHERE
  o_published = 1
  AND oo_id IN (
    21059, 30, 21064, 21056, 21058, 21069,
    27987, 43845, 21063, 21065, 21062,
    21067, 21057, 113777, 205280
  )
ORDER BY
  name

select oo_id  FROM object_localized_experience_category_it  WHERE  o_published = 1  AND oo_id IN (21059,30,21064,21056,21058,21069,27987,43845,21063,21065,21062,21067,21057,113777,205280)  ORDER BY name ;

SELECT
  DISTINCT categories
FROM
  object_localized_experience_it
WHERE
  o_published = 1
  AND title != ''
  AND o_id IN (
    616, 531, 622, 626, 606, 621, 601, 584,
    42422, 42482, 792, 117766, 128115,
    817, 389487, 880, 888, 904, 721, 384814,
    725, 728, 304237, 730, 735, 967, 308170,
    17708, 736, 321327, 42418, 307430,
    961, 304267, 323237, 502, 624, 140940,
    381991, 392338, 393005, 398778, 773,
    625, 37362, 636, 591, 592, 25069, 729,
    783, 882, 916, 213799, 1018, 308504,
    308731, 205276, 205652, 219535, 258349
  )
  AND multiwebsiteVisibility LIKE '%,majellando,%'

SELECT DISTINCT categories FROM object_localized_experience_it WHERE  o_published = 1  AND title != ''  AND o_id IN (616,531,622,626,606,621,601,584,42422,42482,792,117766,128115,817,389487,880,888,904,721,384814,725,728,304237,730,735,967,308170,17708,736,321327,42418,307430,961,304267,323237,502,624,140940,381991,392338,393005,398778,773,625,37362,636,591,592,25069,729,783,882,916,213799,1018,308504,308731,205276,205652,219535,258349)  AND  multiwebsiteVisibility LIKE '%,majellando,%';

SELECT
  DISTINCT locations
FROM
  object_localized_experience_it
WHERE
  o_published = 1
  AND title != ''
  AND o_id IN (
    616, 531, 622, 626, 606, 621, 601, 584,
    42422, 42482, 792, 117766, 128115,
    817, 389487, 880, 888, 904, 721, 384814,
    725, 728, 304237, 730, 735, 967, 308170,
    17708, 736, 321327, 42418, 307430,
    961, 304267, 323237, 502, 624, 140940,
    381991, 392338, 393005, 398778, 773,
    625, 37362, 636, 591, 592, 25069, 729,
    783, 882, 916, 213799, 1018, 308504,
    308731, 205276, 205652, 219535, 258349
  )
  AND multiwebsiteVisibility LIKE '%,majellando,%'

SELECT DISTINCT locations FROM object_localized_experience_it  WHERE  o_published = 1  AND title != ''  AND o_id IN (616,531,622,626,606,621,601,584,42422,42482,792,117766,128115,817,389487,880,888,904,721,384814,725,728,304237,730,735,967,308170,17708,736,321327,42418,307430,961,304267,323237,502,624,140940,381991,392338,393005,398778,773,625,37362,636,591,592,25069,729,783,882,916,213799,1018,308504,308731,205276,205652,219535,258349)  AND  multiwebsiteVisibility LIKE '%,majellando,%';

SELECT
  object_localized_location_it.o_id as o_id,
  object_localized_location_it.o_type as o_type
FROM
  object_localized_location_it
WHERE
  (
    o_id IN (
      688, 652, 664, 640, 663, 677, 709, 666,
      657, 669, 1121, 1107, 711, 661, 662,
      697, 639, 659, 714, 695, 2057, 42510,
      671, 684, 204890, 24027, 641, 258352,
      299266, 141420, 658, 309722, 696, 665,
      382125, 1124, 1126
    )
    AND object_localized_location_it.o_type IN ('object', 'folder')
  )
  AND object_localized_location_it.o_published = 1
ORDER BY
  `name` ASC

SELECT object_localized_location_it.o_id as o_id, object_localized_location_it.o_type as o_type FROM object_localized_location_it WHERE ( o_id IN (688,652,664,640,663,677,709,666,657,669,1121,1107,711,661,662,697,639,659,714,695,2057,42510,671,684,204890,24027,641,258352,299266,141420,658,309722,696,665,382125,1124,1126)  AND  object_localized_location_it.o_type IN ('object','folder')) AND object_localized_location_it.o_published = 1 ORDER BY `name` ASC  ;

SELECT
  object_localized_location_it.o_id as o_id,
  object_localized_location_it.o_type as o_type
FROM
  object_localized_location_it
WHERE
  (
    o_id IN (22, 20, 21, 604)
    AND object_localized_location_it.o_type IN ('object', 'folder')
  )
  AND object_localized_location_it.o_published = 1
ORDER BY
  `name` ASC

SELECT object_localized_location_it.o_id as o_id, object_localized_location_it.o_type as o_type FROM object_localized_location_it WHERE ( o_id IN (22,20,21,604)  AND  object_localized_location_it.o_type IN ('object','folder')) AND object_localized_location_it.o_published = 1 ORDER BY `name` ASC  ;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

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;