Symfony Profiler

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

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 888;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 888;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 85;

SELECT
  *
FROM
  object_relations_ft_poiFilter
WHERE
  src_id = ?

SELECT * FROM object_relations_ft_poiFilter WHERE src_id = 4988;

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
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/en/kleinwalsertal-live/' AND `key` = BINARY 'currently-open-restaurants';

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
WHERE
  (
    parentId = ?
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1
ORDER BY
  `key` ASC

SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = 3903 AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC  ;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'REPORT_REGION';

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 550;

SELECT
  object_localized_ft_poi_en.id as id,
  object_localized_ft_poi_en.type as `type`
FROM
  object_localized_ft_poi_en
WHERE
  (
    (`published` = ?)
    AND (`active` = ?)
    AND (topics LIKE ?)
    AND object_localized_ft_poi_en.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_ft_poi_en.published = 1

SELECT object_localized_ft_poi_en.id as id, object_localized_ft_poi_en.type as `type` FROM object_localized_ft_poi_en WHERE ((`published` = 1)  AND (`active` = 1)  AND ( topics LIKE '%650%')  AND  object_localized_ft_poi_en.type IN ('object','variant','folder')) AND object_localized_ft_poi_en.published = 1;

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

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/currently-open-restaurants' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/kleinwalsertal-live/currently-open-restaurants?filter[topics][]=650' AND `type` = 'path_query') OR
                (source = 'https://partnerinfo.kleinwalsertal-dev.conecto.rocks/en/kleinwalsertal-live/currently-open-restaurants?filter[topics][0]=650' 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
  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
  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(85, 550) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 550;

SELECT
  object_localized_ft_poi_en.id as id,
  object_localized_ft_poi_en.type as `type`
FROM
  object_localized_ft_poi_en
WHERE
  (
    (`published` = ?)
    AND (`active` = ?)
    AND (topics LIKE ?)
    AND (
      object_localized_ft_poi_en.oo_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
    )
    AND object_localized_ft_poi_en.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_ft_poi_en.published = 1
ORDER BY
  `object_localized_ft_poi_en`.`name` ASC

SELECT object_localized_ft_poi_en.id as id, object_localized_ft_poi_en.type as `type` FROM object_localized_ft_poi_en WHERE ((`published` = 1)  AND (`active` = 1)  AND ( topics LIKE '%650%')  AND (object_localized_ft_poi_en.oo_id IN (1358, 1360, 1362, 1399, 1420, 1435, 1463, 1506, 1535, 1538, 1539, 1547, 1590, 1602, 1623, 1631, 1640, 1644, 1669, 1676, 1684, 1744, 1782, 1787, 1796, 1832, 1858))  AND  object_localized_ft_poi_en.type IN ('object','variant','folder')) AND object_localized_ft_poi_en.published = 1 ORDER BY `object_localized_ft_poi_en`.`name` ASC  ;

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 35;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  *
FROM
  object_relations_CN_WEATHERSTATION
WHERE
  src_id = ?

SELECT * FROM object_relations_CN_WEATHERSTATION WHERE src_id = 3840;

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
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/kleinwalsertal-live/currently-open-restaurants'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/kleinwalsertal-live/currently-open-restaurants' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  mainValue,
  validTimePeriod,
  lowerBound,
  upperBound
FROM
  object_collection_AvalancheDangerRating_CN_AVALANCHEREPORT
ORDER BY
  (
    upperBound IS NULL
    AND lowerBound IS NULL
  ) ASC,
  upperBound DESC,
  lowerBound DESC;

SELECT mainValue, validTimePeriod, lowerBound, upperBound
            FROM object_collection_AvalancheDangerRating_CN_AVALANCHEREPORT
            ORDER BY (upperBound IS NULL AND lowerBound IS NULL) ASC,
                upperBound DESC,
                lowerBound DESC;
        ;