Symfony Profiler

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 5156;

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 5156;

SELECT
  *
FROM
  object_store_REPORT_HIKE
WHERE
  oo_id = ?

SELECT * FROM object_store_REPORT_HIKE WHERE oo_id = 5156;

SELECT
  *
FROM
  object_relations_REPORT_HIKE
WHERE
  src_id = ?

SELECT * FROM object_relations_REPORT_HIKE WHERE src_id = 5156;

SELECT
  *
FROM
  object_relations_REPORT_GASTRONOMY
WHERE
  src_id = ?

SELECT * FROM object_relations_REPORT_GASTRONOMY WHERE src_id = 5066;

SELECT
  *
FROM
  object_store_REPORT_GASTRONOMY
WHERE
  oo_id = ?

SELECT * FROM object_store_REPORT_GASTRONOMY WHERE oo_id = 5066;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 84;

SELECT
  COUNT(*)
FROM
  object_localized_REPORT_REGION_en
WHERE
  (
    object_localized_REPORT_REGION_en.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_REPORT_REGION_en.published = 1

SELECT COUNT(*) FROM object_localized_REPORT_REGION_en WHERE ( object_localized_REPORT_REGION_en.type IN ('object','variant','folder')) AND object_localized_REPORT_REGION_en.published = 1;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 845;

SELECT
  *
FROM
  object_relations_REPORT_REGION
WHERE
  src_id = ?

SELECT * FROM object_relations_REPORT_REGION WHERE src_id = 5006;

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
  LEFT JOIN object_REPORT_SLOPE REPORT_SLOPE ON objects.id = REPORT_SLOPE.oo_id
WHERE
  (
    (objects.type = ?)
    AND (objects.className = ?)
    AND (
      REPORT_SLOPE.oo_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?
      )
    )
    AND (
      REPORT_SLOPE.season IN (?, ?)
    )
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1
ORDER BY
  REPORT_SLOPE.isOpen = 0 ASC,
  REPORT_SLOPE.name ASC

SELECT objects.id as id, objects.type as `type` FROM objects LEFT JOIN object_REPORT_SLOPE REPORT_SLOPE ON objects.id = REPORT_SLOPE.oo_id WHERE ((objects.type = 'object')  AND (objects.className = 'ReportSlope')  AND (REPORT_SLOPE.oo_id IN (6160, 6161, 6162, 6163, 6164, 6165, 6166, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6203, 6204, 6205, 6206, 6207, 6208, 6209, 6210, 6211, 6213, 6214, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6222, 6223, 6224, 6226, 6227, 6228, 6229, 6230, 6231, 6232, 6233, 6234, 6235, 6236, 6237, 6238, 6239, 6240, 6241, 6242, 6243, 6244, 6245, 6246, 6247, 6248, 6249, 6250, 6251, 6252, 6253, 6254, 6255, 6256, 6257, 6258, 6259))  AND (REPORT_SLOPE.season IN ('both', 'w'))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_SLOPE.isOpen = 0 ASC, REPORT_SLOPE.name ASC;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 845;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'REPORT_REGION';

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
  LEFT JOIN object_REPORT_LIFT REPORT_LIFT ON objects.id = REPORT_LIFT.oo_id
WHERE
  (
    (objects.type = ?)
    AND (objects.className = ?)
    AND (
      REPORT_LIFT.oo_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
    )
    AND (
      REPORT_LIFT.season IN (?, ?)
    )
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1
ORDER BY
  REPORT_LIFT.isOpen = 0 ASC,
  REPORT_LIFT.name ASC

SELECT objects.id as id, objects.type as `type` FROM objects LEFT JOIN object_REPORT_LIFT REPORT_LIFT ON objects.id = REPORT_LIFT.oo_id WHERE ((objects.type = 'object')  AND (objects.className = 'ReportLift')  AND (REPORT_LIFT.oo_id IN (5014, 5015, 5016, 5017, 5018, 5019, 5020, 5021, 5022, 5023, 5024, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5034, 5035, 5036, 5037, 5038, 5040, 5041, 5042, 5043, 5045, 5046, 5047, 5048, 5049, 5050, 5052, 5053, 5054, 5055, 5056, 5057, 5058, 5059, 5060, 5061, 5062, 5063, 5064))  AND (REPORT_LIFT.season IN ('both', 'w'))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_LIFT.isOpen = 0 ASC, REPORT_LIFT.name ASC;

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

SELECT id,language FROM documents_translations WHERE sourceId = 551 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 551;

SELECT
  COUNT(*)
FROM
  objects
  LEFT JOIN object_REPORT_SLOPE REPORT_SLOPE ON objects.id = REPORT_SLOPE.oo_id
WHERE
  (
    (objects.type = ?)
    AND (objects.className = ?)
    AND (
      REPORT_SLOPE.oo_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?
      )
    )
    AND (
      REPORT_SLOPE.season IN (?, ?)
    )
    AND (REPORT_SLOPE.isOpen = ?)
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1

SELECT COUNT(*) FROM objects LEFT JOIN object_REPORT_SLOPE REPORT_SLOPE ON objects.id = REPORT_SLOPE.oo_id WHERE ((objects.type = 'object')  AND (objects.className = 'ReportSlope')  AND (REPORT_SLOPE.oo_id IN (6160, 6161, 6162, 6163, 6164, 6165, 6166, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6203, 6204, 6205, 6206, 6207, 6208, 6209, 6210, 6211, 6213, 6214, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6222, 6223, 6224, 6226, 6227, 6228, 6229, 6230, 6231, 6232, 6233, 6234, 6235, 6236, 6237, 6238, 6239, 6240, 6241, 6242, 6243, 6244, 6245, 6246, 6247, 6248, 6249, 6250, 6251, 6252, 6253, 6254, 6255, 6256, 6257, 6258, 6259))  AND (REPORT_SLOPE.season IN ('both', 'w'))  AND (REPORT_SLOPE.isOpen = 1)  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1;

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'ReportLift';

SELECT
  COUNT(*)
FROM
  objects
  LEFT JOIN object_REPORT_LIFT REPORT_LIFT ON objects.id = REPORT_LIFT.oo_id
WHERE
  (
    (objects.type = ?)
    AND (objects.className = ?)
    AND (
      REPORT_LIFT.oo_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
    )
    AND (
      REPORT_LIFT.season IN (?, ?)
    )
    AND (REPORT_LIFT.isOpen = ?)
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1

SELECT COUNT(*) FROM objects LEFT JOIN object_REPORT_LIFT REPORT_LIFT ON objects.id = REPORT_LIFT.oo_id WHERE ((objects.type = 'object')  AND (objects.className = 'ReportLift')  AND (REPORT_LIFT.oo_id IN (5014, 5015, 5016, 5017, 5018, 5019, 5020, 5021, 5022, 5023, 5024, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5034, 5035, 5036, 5037, 5038, 5040, 5041, 5042, 5043, 5045, 5046, 5047, 5048, 5049, 5050, 5052, 5053, 5054, 5055, 5056, 5057, 5058, 5059, 5060, 5061, 5062, 5063, 5064))  AND (REPORT_LIFT.season IN ('both', 'w'))  AND (REPORT_LIFT.isOpen = 1)  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1;

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

SELECT id FROM documents WHERE `path` = BINARY '/en/kleinwalsertal-live/' AND `key` = BINARY 'mountain-snow-sports-report';

SELECT
  object_localized_REPORT_REGION_en.id as id,
  object_localized_REPORT_REGION_en.type as `type`
FROM
  object_localized_REPORT_REGION_en
WHERE
  (
    object_localized_REPORT_REGION_en.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_REPORT_REGION_en.published = 1

SELECT object_localized_REPORT_REGION_en.id as id, object_localized_REPORT_REGION_en.type as `type` FROM object_localized_REPORT_REGION_en WHERE ( object_localized_REPORT_REGION_en.type IN ('object','variant','folder')) AND object_localized_REPORT_REGION_en.published = 1;

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

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
  LEFT JOIN object_REPORT_LOIPE REPORT_LOIPE ON objects.id = REPORT_LOIPE.oo_id
WHERE
  (
    (objects.type = ?)
    AND (objects.className = ?)
    AND (
      REPORT_LOIPE.oo_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?
      )
    )
    AND (
      REPORT_LOIPE.season IN (?, ?)
    )
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1
ORDER BY
  REPORT_LOIPE.isOpen = 0 ASC,
  REPORT_LOIPE.name ASC

SELECT objects.id as id, objects.type as `type` FROM objects LEFT JOIN object_REPORT_LOIPE REPORT_LOIPE ON objects.id = REPORT_LOIPE.oo_id WHERE ((objects.type = 'object')  AND (objects.className = 'ReportLoipe')  AND (REPORT_LOIPE.oo_id IN (6261, 6262, 6263, 6264, 6265, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279))  AND (REPORT_LOIPE.season IN ('both', 'w'))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_LOIPE.isOpen = 0 ASC, REPORT_LOIPE.name ASC;

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
  LEFT JOIN object_REPORT_HIKE REPORT_HIKE ON objects.id = REPORT_HIKE.oo_id
WHERE
  (
    (objects.type = ?)
    AND (objects.className = ?)
    AND (
      REPORT_HIKE.oo_id IN (
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?
      )
    )
    AND (
      REPORT_HIKE.season IN (?, ?)
    )
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1
ORDER BY
  REPORT_HIKE.isOpen = 0 ASC,
  REPORT_HIKE.name ASC

SELECT objects.id as id, objects.type as `type` FROM objects LEFT JOIN object_REPORT_HIKE REPORT_HIKE ON objects.id = REPORT_HIKE.oo_id WHERE ((objects.type = 'object')  AND (objects.className = 'ReportHike')  AND (REPORT_HIKE.oo_id IN (5156, 5157, 5158, 5159, 5160, 5161, 5162, 5163, 5164, 5165, 5166, 5167, 5168, 5169, 5170, 5171, 5173, 5174, 5175, 5176, 5177, 5178, 5179, 5180, 5181, 5182, 5183, 5184, 5185, 5186, 5187, 5189, 5190, 5192, 5193, 5194, 5195, 5196, 5197, 5198, 5199, 5200, 5202, 5203, 5204, 5205, 5206, 5207, 5208, 5209, 5210, 5211, 5212, 5213, 5214, 5215, 5216, 5217, 5218, 5219, 5220, 5221, 5222, 5224, 5225, 5226, 5227, 5228, 5229, 5230, 5231, 5232, 5233, 5234, 5235, 5236, 5237, 5247, 5248, 5249, 5250, 5251, 5253, 5254, 5255, 5262, 5263, 5264, 5265, 5268, 5269, 5274, 5275, 5276, 5277, 5283, 5285, 5286, 5288, 5289, 5294, 5295, 5297, 5299, 5301, 5305, 5308, 5310, 5311, 5313, 5314, 5316, 5317, 5318, 5319, 5320, 5322, 5324, 5325, 5326, 5329, 5331, 5333, 5334, 5336, 5337, 5340, 5342, 5343, 5345))  AND (REPORT_HIKE.season IN ('both', 'w'))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_HIKE.isOpen = 0 ASC, REPORT_HIKE.name ASC;

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
  LEFT JOIN object_REPORT_GASTRONOMY REPORT_GASTRONOMY ON objects.id = REPORT_GASTRONOMY.oo_id
WHERE
  (
    (objects.type = ?)
    AND (objects.className = ?)
    AND (
      REPORT_GASTRONOMY.oo_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?
      )
    )
    AND (
      REPORT_GASTRONOMY.season IN (?, ?)
    )
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1
ORDER BY
  REPORT_GASTRONOMY.isOpen = 0 ASC,
  REPORT_GASTRONOMY.name ASC

SELECT objects.id as id, objects.type as `type` FROM objects LEFT JOIN object_REPORT_GASTRONOMY REPORT_GASTRONOMY ON objects.id = REPORT_GASTRONOMY.oo_id WHERE ((objects.type = 'object')  AND (objects.className = 'ReportGastronomy')  AND (REPORT_GASTRONOMY.oo_id IN (5066, 5067, 5068, 5069, 5070, 5071, 5072, 5073, 5075, 5076, 5077, 5078, 5079, 5081, 5082, 5083, 5084, 5086, 5087, 5088, 5089, 5090, 5092, 5094, 5095, 5096, 5097, 5098, 5100, 5101, 5102, 5103, 5104, 5105, 5106, 5107, 5108, 5109, 5110, 5111, 5112, 5113, 5114, 5239, 5240, 5241, 5242, 5243, 5244, 5245, 5252, 5258, 5259, 5271, 5273, 5279, 5280, 5282, 5287, 5291, 5292, 5293, 5300, 5302, 5304, 5306, 5307, 5309, 5312, 5315, 5321, 5323, 5330, 5332, 5335, 5339, 5341, 5344, 6002))  AND (REPORT_GASTRONOMY.season IN ('both', 'w'))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_GASTRONOMY.isOpen = 0 ASC, REPORT_GASTRONOMY.name ASC;

SELECT
  *
FROM
  object_localized_data_REPORT_REGION
WHERE
  ooo_id = ?
  AND language IN ('de', 'en')

SELECT * FROM object_localized_data_REPORT_REGION WHERE ooo_id = 5007 AND language IN ('de','en');

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'weather.default_valley_station'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  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/kleinwalsertal-live/mountain-snow-sports-report' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/kleinwalsertal-live/mountain-snow-sports-report' AND `type` = 'path_query') OR
                (source = 'https://kleinwalsertal-dev.conecto.rocks/en/kleinwalsertal-live/mountain-snow-sports-report' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT
  *
FROM
  object_store_REPORT_REGION
WHERE
  oo_id = ?

SELECT * FROM object_store_REPORT_REGION WHERE oo_id = 5007;

SELECT
  COUNT(*)
FROM
  objects
  LEFT JOIN object_REPORT_HIKE REPORT_HIKE ON objects.id = REPORT_HIKE.oo_id
WHERE
  (
    (objects.type = ?)
    AND (objects.className = ?)
    AND (
      REPORT_HIKE.oo_id IN (
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?
      )
    )
    AND (
      REPORT_HIKE.season IN (?, ?)
    )
    AND (REPORT_HIKE.isOpen = ?)
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1