Symfony Profiler

select
  o_id,
  contentScore,
  priority,
  bookable
from
  object_8
where
  o_published = 1

select o_id,contentScore,priority,bookable  from object_8 where o_published = 1;

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

SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

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 = 'defaultSiteConfig'
                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
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe';

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/' AND `key` = BINARY 'Bett-Bike-Betriebe';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe';

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite = '6'
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe?page=5&randSeed=774' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe?page=5&randSeed=774' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 285;

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

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

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 285;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3189171;

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

SELECT
  *
FROM
  object_collection_demiDatePickerInfoText_21
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 6804 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` 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 = 4983 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 4983;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Steiermark/Aktiv-in-der-Natur/Rad-Bike/Bett-Bike-Betriebe' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

SELECT
  pt.acco_id,
  pt.product_id,
  bp.price as minPrice,
  pt.rule type,
  pt.nights nights
FROM
  `steiermark_vacancies`.price_template pt
  INNER JOIN `steiermark_vacancies`.price_template_base_prices bp ON bp.price_template_id = pt.id
WHERE
  pt.acco_id IN (
    1739520,
    2097658,
    1968001,
    1977942,
    2081799,
    1634534,
    2091472,
    1982666,
    23620,
    1714950,
    10680394,
    2064618,
    1977863,
    2088680,
    1613214,
    1750076,
    40695402,
    2079798,
    1984126,
    1626078,
    1977652,
    2065496,
    1991623,
    2077723,
    26739531,
    2089848,
    1957805,
    1615308,
    1985246,
    26740170,
    1972698,
    1984760,
    1739830,
    26739976,
    25942,
    23991,
    1992394,
    26740224,
    1964721,
    2062684,
    1985660,
    26739438,
    1963049,
    122838,
    2095239,
    21193899,
    1618699,
    2086710,
    1972586,
    2100103,
    2085791,
    199572,
    1749742,
    1635097,
    2060516,
    1600091,
    26684353,
    2095560,
    11213989,
    16878138,
    1959487,
    2066578,
    1959616,
    1644056,
    211256,
    2091589,
    195752,
    1568590,
    1967609,
    2069224,
    2096263,
    1965864,
    2082077,
    1602287,
    50325,
    1966052,
    1750182,
    2078992,
    2095446,
    2084957,
    1995103,
    4608269,
    1982005,
    1956234,
    55010,
    1644507,
    1631921,
    2061355,
    2655626,
    1568077,
    174798,
    161664,
    1641179,
    1982404,
    1961622,
    2088269,
    1617940,
    2104757,
    1978956,
    362915,
    2088601,
    1968641,
    2080373,
    39126410,
    40768,
    1568301,
    193837,
    2080254,
    26739467,
    1618763,
    169035,
    11366349,
    1626162,
    2093101,
    2074396,
    2090846,
    2093462,
    1986716,
    2104416,
    1638406,
    1986015,
    26337,
    363214,
    1980623,
    23500,
    1626682,
    1960208,
    1991966,
    10684008,
    1627127,
    1963111,
    1975755,
    2059839,
    2062975,
    24242,
    2655655,
    28124,
    2078155,
    32353,
    1969267,
    2092638,
    1993645,
    2093030,
    41969421,
    21659,
    14600421,
    1977491,
    2079129,
    1739806,
    26739403,
    1966219,
    1983915,
    1826686,
    1973992,
    1974414,
    1964309,
    5128432,
    2089077,
    2099252,
    1981704,
    1984508,
    1634602,
    2079352,
    1146711,
    104153,
    26739971,
    1978232,
    2103588,
    1968180,
    2081355,
    1636022,
    214160,
    2083262,
    1618672,
    2079623,
    1618898,
    2073379,
    1966896,
    1980811,
    1977360,
    1827613,
    2090036
  )
  AND pt.stdOccupancy BETWEEN bp.occupancyFrom
  AND bp.occupancyTo
  AND price > 0
  and (
    select
      active
    from
      `steiermark`.object_6 product
    where
      product.o_id = pt.product_id
  )
order by
  minPrice

SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights
              FROM    `steiermark_vacancies`.price_template pt
                   INNER JOIN
                      `steiermark_vacancies`.price_template_base_prices bp
                   ON bp.price_template_id = pt.id
             WHERE     pt.acco_id IN (1739520,2097658,1968001,1977942,2081799,1634534,2091472,1982666,23620,1714950,10680394,2064618,1977863,2088680,1613214,1750076,40695402,2079798,1984126,1626078,1977652,2065496,1991623,2077723,26739531,2089848,1957805,1615308,1985246,26740170,1972698,1984760,1739830,26739976,25942,23991,1992394,26740224,1964721,2062684,1985660,26739438,1963049,122838,2095239,21193899,1618699,2086710,1972586,2100103,2085791,199572,1749742,1635097,2060516,1600091,26684353,2095560,11213989,16878138,1959487,2066578,1959616,1644056,211256,2091589,195752,1568590,1967609,2069224,2096263,1965864,2082077,1602287,50325,1966052,1750182,2078992,2095446,2084957,1995103,4608269,1982005,1956234,55010,1644507,1631921,2061355,2655626,1568077,174798,161664,1641179,1982404,1961622,2088269,1617940,2104757,1978956,362915,2088601,1968641,2080373,39126410,40768,1568301,193837,2080254,26739467,1618763,169035,11366349,1626162,2093101,2074396,2090846,2093462,1986716,2104416,1638406,1986015,26337,363214,1980623,23500,1626682,1960208,1991966,10684008,1627127,1963111,1975755,2059839,2062975,24242,2655655,28124,2078155,32353,1969267,2092638,1993645,2093030,41969421,21659,14600421,1977491,2079129,1739806,26739403,1966219,1983915,1826686,1973992,1974414,1964309,5128432,2089077,2099252,1981704,1984508,1634602,2079352,1146711,104153,26739971,1978232,2103588,1968180,2081355,1636022,214160,2083262,1618672,2079623,1618898,2073379,1966896,1980811,1977360,1827613,2090036)
                  
                   AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo
                   AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id)
                   order by minPrice
        ;

SELECT
  dacco.isTop,
  dacco.bookable,
  dacco.oo_id oo_id
FROM
  `steiermark`.object_8 dacco
WHERE
  dacco.o_published = 1
  AND (
    dacco.marketingGroups LIKE '%,9804,%'
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(774)

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.o_published = 1  AND (dacco.marketingGroups LIKE '%,9804,%')  GROUP BY dacco.oo_id  ORDER BY  RAND(774) ;