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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Styria/Active-holidays-in-nature/Biking-cycling/' AND `key` = BINARY 'Bett-Bike-accommodation';

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 = '/en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 4983;

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 = '/en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation?page=7&randSeed=656' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation?page=7&randSeed=656' 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
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation';

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 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 = 4983 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 4983;

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

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
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3189171;

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
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 4983;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Styria/Active-holidays-in-nature/Biking-cycling/Bett-Bike-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages 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 (
    2093030,
    2060516,
    2100103,
    199572,
    1991966,
    1618898,
    26739531,
    104153,
    1969267,
    193837,
    1961622,
    2095446,
    2095560,
    2089848,
    2093101,
    2086710,
    39126410,
    1977863,
    1826686,
    1739806,
    2091472,
    1980623,
    2078155,
    23991,
    23500,
    2655626,
    1972586,
    2103588,
    2104757,
    2089077,
    26740224,
    2096263,
    1963111,
    5128432,
    2077723,
    1964309,
    2655655,
    1966896,
    10680394,
    2062975,
    2085791,
    11366349,
    1568077,
    2088680,
    214160,
    1636022,
    1977360,
    1627127,
    161664,
    2066578,
    1956234,
    1977491,
    2064618,
    1638406,
    21659,
    1982404,
    1995103,
    1618699,
    363214,
    2093462,
    1984508,
    2099252,
    1739520,
    1978232,
    1739830,
    362915,
    2081799,
    1964721,
    1600091,
    2061355,
    1966219,
    32353,
    10684008,
    2095239,
    1991623,
    1965864,
    1972698,
    1146711,
    1981704,
    1626682,
    1959616,
    195752,
    1957805,
    41969421,
    2079798,
    24242,
    2081355,
    1960208,
    122838,
    2080254,
    11213989,
    1644507,
    14600421,
    1968180,
    2104416,
    50325,
    2083262,
    1982005,
    1983915,
    2082077,
    4608269,
    1980811,
    40768,
    1613214,
    2079129,
    26740170,
    1977652,
    1959487,
    26337,
    1749742,
    1714950,
    2097658,
    1618672,
    1985246,
    1974414,
    2059839,
    1975755,
    2090846,
    174798,
    26739971,
    2079623,
    1993645,
    1978956,
    1568301,
    169035,
    2091589,
    1568590,
    1986716,
    23620,
    1967609,
    2069224,
    1968641,
    1750076,
    26684353,
    1984760,
    1631921,
    1977942,
    1985660,
    1641179,
    26739438,
    1973992,
    1634602,
    1618763,
    2073379,
    2065496,
    28124,
    1626078,
    2088269,
    1750182,
    2079352,
    1617940,
    211256,
    21193899,
    16878138,
    1963049,
    26739467,
    26739976,
    2062684,
    1982666,
    1827613,
    1615308,
    1635097,
    1968001,
    55010,
    2074396,
    1966052,
    40695402,
    2088601,
    2084957,
    1602287,
    1644056,
    1992394,
    2090036,
    2078992,
    2080373,
    1626162,
    1984126,
    26739403,
    1986015,
    1634534,
    25942,
    2092638
  )
  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 (2093030,2060516,2100103,199572,1991966,1618898,26739531,104153,1969267,193837,1961622,2095446,2095560,2089848,2093101,2086710,39126410,1977863,1826686,1739806,2091472,1980623,2078155,23991,23500,2655626,1972586,2103588,2104757,2089077,26740224,2096263,1963111,5128432,2077723,1964309,2655655,1966896,10680394,2062975,2085791,11366349,1568077,2088680,214160,1636022,1977360,1627127,161664,2066578,1956234,1977491,2064618,1638406,21659,1982404,1995103,1618699,363214,2093462,1984508,2099252,1739520,1978232,1739830,362915,2081799,1964721,1600091,2061355,1966219,32353,10684008,2095239,1991623,1965864,1972698,1146711,1981704,1626682,1959616,195752,1957805,41969421,2079798,24242,2081355,1960208,122838,2080254,11213989,1644507,14600421,1968180,2104416,50325,2083262,1982005,1983915,2082077,4608269,1980811,40768,1613214,2079129,26740170,1977652,1959487,26337,1749742,1714950,2097658,1618672,1985246,1974414,2059839,1975755,2090846,174798,26739971,2079623,1993645,1978956,1568301,169035,2091589,1568590,1986716,23620,1967609,2069224,1968641,1750076,26684353,1984760,1631921,1977942,1985660,1641179,26739438,1973992,1634602,1618763,2073379,2065496,28124,1626078,2088269,1750182,2079352,1617940,211256,21193899,16878138,1963049,26739467,26739976,2062684,1982666,1827613,1615308,1635097,1968001,55010,2074396,1966052,40695402,2088601,2084957,1602287,1644056,1992394,2090036,2078992,2080373,1626162,1984126,26739403,1986015,1634534,25942,2092638)
                  
                   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(656)

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(656) ;