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 > 1785321226 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
  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
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 577;

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
  sites
WHERE
  rootId = ?

SELECT * FROM sites WHERE rootId = 15;

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
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'thumb_32137__e9ad6c16b156537bbaa13ec25c7547b8';

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

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

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
  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(577, 577) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 577;

SELECT
  p.o_id
FROM
  object_collection_Period_experience p
  JOIN object_experience o ON o.o_id = p.o_id
WHERE
  (
    p.since >= 1785276000
    OR p.until >= 1785276000
  )
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 >= 1785276000 OR  p.until >= 1785276000 )  ORDER BY p.firstNextDate ASC , o.orderingPriority DESC ;

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' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/it/esplora-con-majellando/in-famiglia-nei-parchi-d-abruzzo' AND `type` = 'path_query') OR
                (source = 'https://majellando.by-mf.it/it/esplora-con-majellando/in-famiglia-nei-parchi-d-abruzzo' 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
  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 (
    626, 531, 622, 888, 304237, 904, 304267,
    307430, 961, 636, 321327, 721, 967,
    725, 17708, 728, 37362, 42418, 42422,
    730, 42482, 117766, 128115, 389487,
    880, 916, 308504, 308731, 1018, 783,
    205276, 205652, 213799, 219535, 882,
    258349, 616, 25069, 792, 817, 624, 502,
    323237, 736, 308170, 384814, 601, 735,
    398778, 591, 729, 140940, 392338, 381991,
    592, 393005, 625
  )
  AND p.multiwebsiteVisibility LIKE '%,majellando,%'
ORDER BY
  p.orderingPriority DESC,
  FIELD(
    p.o_id, 626, 531, 622, 888, 304237, 904,
    304267, 307430, 961, 636, 321327, 721,
    967, 725, 17708, 728, 37362, 42418,
    42422, 730, 42482, 117766, 128115,
    389487, 880, 916, 308504, 308731, 1018,
    783, 205276, 205652, 213799, 219535,
    882, 258349, 616, 25069, 792, 817, 624,
    502, 323237, 736, 308170, 384814, 601,
    735, 398778, 591, 729, 140940, 392338,
    381991, 592, 393005, 625
  )

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 (626,531,622,888,304237,904,304267,307430,961,636,321327,721,967,725,17708,728,37362,42418,42422,730,42482,117766,128115,389487,880,916,308504,308731,1018,783,205276,205652,213799,219535,882,258349,616,25069,792,817,624,502,323237,736,308170,384814,601,735,398778,591,729,140940,392338,381991,592,393005,625)  AND  p.multiwebsiteVisibility LIKE '%,majellando,%' ORDER BY p.orderingPriority DESC, FIELD(p.o_id,626,531,622,888,304237,904,304267,307430,961,636,321327,721,967,725,17708,728,37362,42418,42422,730,42482,117766,128115,389487,880,916,308504,308731,1018,783,205276,205652,213799,219535,882,258349,616,25069,792,817,624,502,323237,736,308170,384814,601,735,398778,591,729,140940,392338,381991,592,393005,625) ;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 577;

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

SELECT id FROM documents WHERE path = BINARY '/majellando/it/esplora-con-majellando/' AND `key` = BINARY 'in-famiglia-nei-parchi-d-abruzzo';

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/it/esplora-con-majellando/in-famiglia-nei-parchi-d-abruzzo'
  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' AND (siteId = 1 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

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, 663, 677, 709, 666, 657,
      1121, 1107, 711, 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,663,677,709,666,657,1121,1107,711,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
  DISTINCT categories
FROM
  object_localized_experience_it
WHERE
  o_published = 1
  AND title != ''
  AND o_id IN (
    626, 531, 622, 616, 601, 888, 304237,
    904, 304267, 307430, 961, 636, 321327,
    721, 967, 725, 17708, 728, 37362, 42418,
    42422, 730, 42482, 117766, 128115,
    389487, 880, 25069, 792, 817, 624, 502,
    323237, 736, 308170, 384814, 735, 398778,
    591, 729, 140940, 392338, 381991, 592,
    393005, 625, 916, 308504, 308731, 1018,
    783, 205276, 205652, 213799, 219535,
    882, 258349
  )
  AND multiwebsiteVisibility LIKE '%,majellando,%'

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

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, 21062, 21065,
    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,21062,21065,21067,21057,113777,205280)  ORDER BY name ;

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

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

SELECT
  DISTINCT city__id
FROM
  object_contact_location
WHERE
  o_published = 1
  AND o_id IN (
    299267, 452, 245490, 2048, 2025, 2028,
    2008, 20154, 314034, 2052, 2053, 466,
    820, 2097, 571, 2156, 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,245490,2048,2025,2028,2008,20154,314034,2052,2053,466,820,2097,571,2156,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
  *
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;