Symfony Profiler

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

SELECT id FROM documents WHERE `path` = BINARY '/de/poi/' AND `key` = BINARY 'bushaltestelle-fuchsfarm~1632';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/poi/bushaltestelle-fuchsfarm~1632';

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

SELECT id FROM documents WHERE `path` = BINARY '/de/' AND `key` = BINARY 'poi';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/poi';

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

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

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 2;

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

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

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 = '/de/poi/bushaltestelle-fuchsfarm~1632' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/poi/bushaltestelle-fuchsfarm~1632' AND `type` = 'path_query') OR
                (source = 'https://footprint.kleinwalsertal-dev.conecto.rocks/de/poi/bushaltestelle-fuchsfarm~1632' 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
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

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

SELECT id FROM documents WHERE `path` = BINARY '/de/poi/' AND `key` = BINARY 'bushaltestelle-fuchsfarm~1632';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/poi/bushaltestelle-fuchsfarm~1632';

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

SELECT id FROM documents WHERE `path` = BINARY '/de/' AND `key` = BINARY 'poi';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/poi';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'ft_poi';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'REPORT_REGION';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'CN_WEBCAM';

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 44639;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 44639;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 2;

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

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

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

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

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 2;

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

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

SELECT
  object_CN_WEATHERSTATION.id as id,
  object_CN_WEATHERSTATION.type as `type`
FROM
  object_CN_WEATHERSTATION
WHERE
  (
    (
      id = ?
      OR id = ?
    )
    AND object_CN_WEATHERSTATION.type IN ('object', 'variant', 'folder')
  )
  AND object_CN_WEATHERSTATION.published = 1
ORDER BY
  `altitude`
LIMIT
  2

SELECT object_CN_WEATHERSTATION.id as id, object_CN_WEATHERSTATION.type as `type` FROM object_CN_WEATHERSTATION WHERE (( id = NULL OR id = NULL)  AND  object_CN_WEATHERSTATION.type IN ('object','variant','folder')) AND object_CN_WEATHERSTATION.published = 1 ORDER BY `altitude`    LIMIT 2;

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

SELECT * FROM website_settings WHERE id = 35;

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

SELECT * FROM website_settings WHERE id = 34;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'CN_WEATHERSTATION';

SELECT
  *
FROM
  object_relations_CN_WEATHERSTATION
WHERE
  src_id = ?

SELECT * FROM object_relations_CN_WEATHERSTATION WHERE src_id = 3840;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'CN_WEATHERDAY';

SELECT
  *
FROM
  object_collection_Weather_CN_WEATHERDAY
WHERE
  id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_Weather_CN_WEATHERDAY WHERE id = 3901 AND fieldname = 'weatherData' ORDER BY `index` ASC;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 2;

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

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

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 3;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 134;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 134;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 393;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 748;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 748;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 91;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 855;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 855;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 72;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 1579;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1579;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 4;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 932;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 932;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 108;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 3376;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3376;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 112;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 1168;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1168;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 86;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 4776;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4776;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 118;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 1146;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1146;

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

SELECT id FROM documents WHERE `path` = BINARY '/de/Snippets/' AND `key` = BINARY 'footer';

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

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

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 = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/_fragment?_path=_locale=de&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction' AND `type` = 'path_query') OR
                (source = 'https://footprint.kleinwalsertal-dev.conecto.rocks/_fragment?_path=_locale=de&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction' 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
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 23;

SELECT
  object_CN_WEATHERSTATION.id as id,
  object_CN_WEATHERSTATION.type as `type`
FROM
  object_CN_WEATHERSTATION
WHERE
  (
    (
      id = ?
      OR id = ?
    )
    AND object_CN_WEATHERSTATION.type IN ('object', 'variant', 'folder')
  )
  AND object_CN_WEATHERSTATION.published = 1
ORDER BY
  `altitude`
LIMIT
  2

SELECT object_CN_WEATHERSTATION.id as id, object_CN_WEATHERSTATION.type as `type` FROM object_CN_WEATHERSTATION WHERE (( id = NULL OR id = NULL)  AND  object_CN_WEATHERSTATION.type IN ('object','variant','folder')) AND object_CN_WEATHERSTATION.published = 1 ORDER BY `altitude`    LIMIT 2;

SELECT
  *
FROM
  object_relations_CN_WEATHERSTATION
WHERE
  src_id = ?

SELECT * FROM object_relations_CN_WEATHERSTATION WHERE src_id = 3846;

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'ReportLift';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'REPORT_LIFT';

SELECT
  *
FROM
  object_relations_REPORT_REGION
WHERE
  src_id = ?

SELECT * FROM object_relations_REPORT_REGION WHERE src_id = 5009;

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` DESC

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', 's'))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `REPORT_LIFT`.`isOpen` DESC  ;

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', 's'))  AND (REPORT_LIFT.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 = 'ReportHike';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'REPORT_HIKE';

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` DESC

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', 's'))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `REPORT_HIKE`.`isOpen` DESC  ;

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