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
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

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

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

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/' AND `key` = BINARY 'Angebote-Pauschalen';

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/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 1724;

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
  sites

SELECT id FROM sites;

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen';

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 7281, 6882, 51, 2, 1430)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE ((cid IN (1,7281,6882,51,2,1430) AND inheritable = 1) OR cid = 9675 )  AND ctype='document';

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/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen' 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,
  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(1724, 1724) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 1724;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 1724;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    o_parentId = ?
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1
ORDER BY
  `o_key` ASC

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11462 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` 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 = 9971 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 9971;

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

SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 5882747 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1024237;

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

SELECT * FROM website_settings WHERE id = 1;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Ausseerland-Salzkammergut/Urlaub-planen/Unterkuenfte-suchen-buchen/Angebote-Pauschalen' 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.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.product_id IN (
    38974429,
    47673756,
    46237683,
    47673606,
    47673647,
    47673722,
    47673701,
    47673598,
    47673630,
    47673685,
    47673794,
    47673809,
    47673639,
    38974445,
    47673692,
    47673731,
    47673715,
    47673802,
    46237660,
    46237691,
    47673679,
    47673787,
    46237675,
    47673766,
    17679354,
    17679497,
    17679345,
    17679327,
    16791740,
    16791764,
    17679464,
    17679448,
    16791755,
    17679480,
    16791746,
    17679336,
    36095866,
    1614019,
    51733863,
    51733902,
    36778983,
    1613706,
    36091878,
    36778918,
    1614149,
    1613837,
    36091742,
    1613989,
    36095468,
    36779118,
    36091844,
    36778784,
    36779079,
    36095606,
    36779034,
    32381314,
    1614173,
    1613947,
    1614137,
    1614467,
    36096025,
    1614101,
    1614013,
    1614479,
    29571128,
    1614300,
    1614294,
    36095702,
    51733945,
    29571194,
    51733629,
    1613843,
    1613983,
    1614449,
    1613861,
    1614461,
    36091776,
    51733821,
    1613676,
    1614167,
    29570869,
    36096005,
    37242249,
    1614258,
    1613849,
    29571286,
    1613670,
    1613867,
    36095791,
    36095501,
    36095588,
    36095770,
    29570875,
    51733547,
    36095677,
    1614312,
    36096097,
    1614143,
    36779157,
    1613682,
    36091913,
    1613995,
    51733715,
    29571134,
    51733776,
    1614413,
    36778854,
    1614306,
    1613640,
    39951878,
    1614324,
    36095942,
    1614485,
    39951870,
    1613700,
    36096071,
    36091640,
    39951817,
    1613831,
    36091943,
    36095917,
    36091693,
    1614001,
    32381308,
    32381359,
    32381365,
    36095848,
    1614455,
    1613688,
    1613795,
    1614330,
    1614155,
    49681471
  )
  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.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.product_id IN (38974429,47673756,46237683,47673606,47673647,47673722,47673701,47673598,47673630,47673685,47673794,47673809,47673639,38974445,47673692,47673731,47673715,47673802,46237660,46237691,47673679,47673787,46237675,47673766,17679354,17679497,17679345,17679327,16791740,16791764,17679464,17679448,16791755,17679480,16791746,17679336,36095866,1614019,51733863,51733902,36778983,1613706,36091878,36778918,1614149,1613837,36091742,1613989,36095468,36779118,36091844,36778784,36779079,36095606,36779034,32381314,1614173,1613947,1614137,1614467,36096025,1614101,1614013,1614479,29571128,1614300,1614294,36095702,51733945,29571194,51733629,1613843,1613983,1614449,1613861,1614461,36091776,51733821,1613676,1614167,29570869,36096005,37242249,1614258,1613849,29571286,1613670,1613867,36095791,36095501,36095588,36095770,29570875,51733547,36095677,1614312,36096097,1614143,36779157,1613682,36091913,1613995,51733715,29571134,51733776,1614413,36778854,1614306,1613640,39951878,1614324,36095942,1614485,39951870,1613700,36096071,36091640,39951817,1613831,36091943,36095917,36091693,1614001,32381308,32381359,32381365,36095848,1614455,1613688,1613795,1614330,1614155,49681471)
                       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 (
    9566396, 2458981, 1613214, 13169002
  )
  AND pt.product_id IN (
    38974429,
    47673756,
    46237683,
    47673606,
    47673647,
    47673722,
    47673701,
    47673598,
    47673630,
    47673685,
    47673794,
    47673809,
    47673639,
    38974445,
    47673692,
    47673731,
    47673715,
    47673802,
    46237660,
    46237691,
    47673679,
    47673787,
    46237675,
    47673766,
    17679354,
    17679497,
    17679345,
    17679327,
    16791740,
    16791764,
    17679464,
    17679448,
    16791755,
    17679480,
    16791746,
    17679336,
    36095866,
    1614019,
    51733863,
    51733902,
    36778983,
    1613706,
    36091878,
    36778918,
    1614149,
    1613837,
    36091742,
    1613989,
    36095468,
    36779118,
    36091844,
    36778784,
    36779079,
    36095606,
    36779034,
    32381314,
    1614173,
    1613947,
    1614137,
    1614467,
    36096025,
    1614101,
    1614013,
    1614479,
    29571128,
    1614300,
    1614294,
    36095702,
    51733945,
    29571194,
    51733629,
    1613843,
    1613983,
    1614449,
    1613861,
    1614461,
    36091776,
    51733821,
    1613676,
    1614167,
    29570869,
    36096005,
    37242249,
    1614258,
    1613849,
    29571286,
    1613670,
    1613867,
    36095791,
    36095501,
    36095588,
    36095770,
    29570875,
    51733547,
    36095677,
    1614312,
    36096097,
    1614143,
    36779157,
    1613682,
    36091913,
    1613995,
    51733715,
    29571134,
    51733776,
    1614413,
    36778854,
    1614306,
    1613640,
    39951878,
    1614324,
    36095942,
    1614485,
    39951870,
    1613700,
    36096071,
    36091640,
    39951817,
    1613831,
    36091943,
    36095917,
    36091693,
    1614001,
    32381308,
    32381359,
    32381365,
    36095848,
    1614455,
    1613688,
    1613795,
    1614330,
    1614155,
    49681471
  )
  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 (9566396,2458981,1613214,13169002)
                  AND pt.product_id IN (38974429,47673756,46237683,47673606,47673647,47673722,47673701,47673598,47673630,47673685,47673794,47673809,47673639,38974445,47673692,47673731,47673715,47673802,46237660,46237691,47673679,47673787,46237675,47673766,17679354,17679497,17679345,17679327,16791740,16791764,17679464,17679448,16791755,17679480,16791746,17679336,36095866,1614019,51733863,51733902,36778983,1613706,36091878,36778918,1614149,1613837,36091742,1613989,36095468,36779118,36091844,36778784,36779079,36095606,36779034,32381314,1614173,1613947,1614137,1614467,36096025,1614101,1614013,1614479,29571128,1614300,1614294,36095702,51733945,29571194,51733629,1613843,1613983,1614449,1613861,1614461,36091776,51733821,1613676,1614167,29570869,36096005,37242249,1614258,1613849,29571286,1613670,1613867,36095791,36095501,36095588,36095770,29570875,51733547,36095677,1614312,36096097,1614143,36779157,1613682,36091913,1613995,51733715,29571134,51733776,1614413,36778854,1614306,1613640,39951878,1614324,36095942,1614485,39951870,1613700,36096071,36091640,39951817,1613831,36091943,36095917,36091693,1614001,32381308,32381359,32381365,36095848,1614455,1613688,1613795,1614330,1614155,49681471)
                   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,
  products.oo_id product_id,
  hpMasters.src_id hpMaster_id
FROM
  `steiermark`.object_8 dacco
  INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId
  INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId
  INNER JOIN `steiermark`.object_relations_44 hpMasters ON hpMasters.dest_id = products.oo_id
WHERE
  dacco.o_published = 1
  AND (
    products.o_published = 1
    AND products.productType = 'Package'
  )
  AND (
    dacco.town__id IN (
      11465, 11466, 11464, 11463, 1612603
    )
  )
  AND (
    products.oo_id IN (
      SELECT
        DISTINCT o_id
      FROM
        `steiermark`.object_collection_demiDate_6
      WHERE
        `to` > 1732656680
    )
    OR validDatesType = 'Always'
  )
  AND hpMasters.src_id in (
    select
      o_id
    from
      `steiermark`.object_44
    where
      o_published = 1
      and active = 1
  )
GROUP BY
  product_id
ORDER BY
  RAND(342)

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id, hpMasters.src_id hpMaster_id  FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId  INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId  INNER JOIN `steiermark`.object_relations_44 hpMasters ON hpMasters.dest_id = products.oo_id  WHERE  dacco.o_published = 1  AND (products.o_published = 1  AND products.productType = 'Package') AND (dacco.town__id IN (11465, 11466, 11464, 11463, 1612603)) AND (
                products.oo_id  IN (SELECT DISTINCT o_id FROM `steiermark`.object_collection_demiDate_6
                WHERE  `to` > 1732656680) OR validDatesType = 'Always'
            )  AND hpMasters.src_id in (select o_id from `steiermark`.object_44 where o_published = 1 and active=1) GROUP BY product_id  ORDER BY  RAND(342) ;