Symfony Profiler

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 689;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 134;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 134;

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
  settings_store
WHERE
  id = ?
  AND scope = ?

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

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

SELECT id FROM documents WHERE `path` = BINARY '/de/kleinwalsertal-live/bergsportbericht-kleinwalsertal/' AND `key` = BINARY 'lifte';

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/kleinwalsertal-live/bergsportbericht-kleinwalsertal/lifte' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/kleinwalsertal-live/bergsportbericht-kleinwalsertal/lifte' AND `type` = 'path_query') OR
                (source = 'https://partnerinfo.kleinwalsertal-dev.conecto.rocks/de/kleinwalsertal-live/bergsportbericht-kleinwalsertal/lifte' 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
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'REPORT_REGION';

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

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

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

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 689;

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 35;

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 = 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, 5063, 5064, 5062))  AND (REPORT_LIFT.season IN ('both', 's'))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_LIFT.isOpen = 0 ASC, REPORT_LIFT.name ASC;

SELECT
  *
FROM
  object_relations_CN_WEATHERSTATION
WHERE
  src_id = ?

SELECT * FROM object_relations_CN_WEATHERSTATION WHERE src_id = 3840;

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, 5063, 5064, 5062))  AND (REPORT_LIFT.season IN ('both', 's'))  AND (REPORT_LIFT.isOpen = 1)  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1;

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

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

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

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

SELECT * FROM object_collection_AvalancheDangerRating_CN_AVALANCHEREPORT WHERE id = 6281 AND fieldname = 'dangerRating' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/kleinwalsertal-live/bergsportbericht-kleinwalsertal/lifte'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/kleinwalsertal-live/bergsportbericht-kleinwalsertal/lifte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'ReportLift';

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';