Symfony Profiler

SELECT
  id
FROM
  documents d
WHERE
  parentId = ?
  AND published = 1
LIMIT
  1

SELECT id FROM documents d WHERE parentId = 156  AND published = 1 LIMIT 1;

SELECT
  documents.id,
  documents.type
FROM
  documents
WHERE
  (parentId = ?)
  AND published = 1
ORDER BY
  `index` ASC

SELECT documents.id, documents.type FROM documents WHERE  (parentId = 156) AND published = 1 ORDER BY `index` ASC  ;

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 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 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
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 723;

SELECT
  *
FROM
  object_relations_REPORT_REGION
WHERE
  src_id = ?

SELECT * FROM object_relations_REPORT_REGION WHERE src_id = 5009;

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
  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 = 5009;

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/pisten' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/kleinwalsertal-live/bergsportbericht-kleinwalsertal/pisten' AND `type` = 'path_query') OR
                (source = 'https://kleinwalsertal-dev.conecto.rocks/de/kleinwalsertal-live/bergsportbericht-kleinwalsertal/pisten' 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
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

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

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 = 5009 AND language IN ('de','en');

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 'pisten';

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

SELECT
  *
FROM
  object_store_REPORT_REGION
WHERE
  oo_id = ?

SELECT * FROM object_store_REPORT_REGION WHERE oo_id = 5009;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 723;

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

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

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
  COUNT(*)
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 (REPORT_LOIPE.isOpen = ?)
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1

SELECT COUNT(*) 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 (REPORT_LOIPE.isOpen = 1)  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 = ?)
    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
  *
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
  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 = 3846;

SELECT
  id
FROM
  website_settings

SELECT id FROM website_settings;

SELECT
  *
FROM
  object_store_CN_WEATHERSTATION
WHERE
  oo_id = ?

SELECT * FROM object_store_CN_WEATHERSTATION WHERE oo_id = 3846;

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'ReportSlope';

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  documents.*,
  tree_locks.locked
FROM
  documents
  LEFT JOIN tree_locks ON documents.id = tree_locks.id
  AND tree_locks.type = 'document'
WHERE
  documents.id = ?

SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = 9;

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

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