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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/' AND `key` = BINARY 'Offers';

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/Ausseerland-Salzkammergut/Plan-your-holidays/Offers';

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
  *
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/Ausseerland-Salzkammergut/Plan-your-holidays/Offers' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Ausseerland-Salzkammergut/Plan-your-holidays/Offers?page=2&randSeed=140' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Offers?page=2&randSeed=140' 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/Ausseerland-Salzkammergut/Plan-your-holidays/Offers';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 9971;

SELECT
  id
FROM
  sites

SELECT id FROM sites;

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

SELECT id,language FROM documents_translations WHERE sourceId IN(1724, 9971) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 9971;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//en/Ausseerland-Salzkammergut/Plan-your-holidays/Offers'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Ausseerland-Salzkammergut/Plan-your-holidays/Offers' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Ausseerland-Salzkammergut/Plan-your-holidays/Offers'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Ausseerland-Salzkammergut/Plan-your-holidays/Offers' 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
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId 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 = '/en/Ausseerland-Salzkammergut/Plan-your-holidays/Offers'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Ausseerland-Salzkammergut/Plan-your-holidays/Offers' 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
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

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 (
    47673685,
    47673692,
    47673639,
    47673701,
    46237660,
    47673787,
    46237675,
    47673756,
    47673731,
    47673630,
    47673647,
    47673598,
    46237691,
    47673809,
    47673616,
    38974445,
    47673679,
    38974429,
    47673722,
    47673606,
    47673715,
    47673802,
    38974413,
    47673794,
    47673766,
    46237683,
    1614258,
    1613676,
    51733629,
    51733776,
    1614149,
    29571134,
    36096025,
    1613795,
    51733547,
    36091693,
    36095677,
    40713505,
    36091878,
    40713401,
    1614137,
    1614455,
    1614300,
    1614173,
    40713434,
    36095917,
    29571194,
    40713344,
    1613837,
    1613843,
    36095848,
    39951817,
    1614013,
    39951870,
    1613688,
    36095866,
    29571286,
    1614001,
    36095791,
    1613831,
    36091844,
    36091640,
    1614324,
    32381314,
    36096071,
    36779118,
    1613983,
    36091742,
    36095702,
    1614019,
    36091913,
    1614306,
    1614294,
    51733945,
    1613849,
    1614330,
    40713573,
    36095942,
    29570875,
    40713471,
    1614155,
    32381365,
    1614167,
    40713291,
    36095468,
    1613640,
    36091943,
    40713539,
    36778983,
    36095770,
    1614101,
    1614449,
    51733821,
    1614413,
    36779157,
    36778918,
    36779034,
    36096005,
    1613861,
    51733715,
    36778784,
    1613947,
    1613995,
    29571128,
    1614312,
    1613700,
    1613670,
    29570869,
    36778854,
    1613989,
    32381308,
    36095588,
    36095606,
    37242249,
    1613682,
    1614485,
    1614461,
    32381359,
    36095501,
    51733863,
    51733902,
    1614143,
    1614467,
    36091776,
    1614479,
    36779079,
    1613706,
    36096097,
    1613867,
    39951878,
    17679448,
    16791764,
    17679336,
    17679354,
    17679480,
    16791740,
    16791746,
    17679327,
    17679464,
    16791755,
    17679497,
    17679345,
    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 (47673685,47673692,47673639,47673701,46237660,47673787,46237675,47673756,47673731,47673630,47673647,47673598,46237691,47673809,47673616,38974445,47673679,38974429,47673722,47673606,47673715,47673802,38974413,47673794,47673766,46237683,1614258,1613676,51733629,51733776,1614149,29571134,36096025,1613795,51733547,36091693,36095677,40713505,36091878,40713401,1614137,1614455,1614300,1614173,40713434,36095917,29571194,40713344,1613837,1613843,36095848,39951817,1614013,39951870,1613688,36095866,29571286,1614001,36095791,1613831,36091844,36091640,1614324,32381314,36096071,36779118,1613983,36091742,36095702,1614019,36091913,1614306,1614294,51733945,1613849,1614330,40713573,36095942,29570875,40713471,1614155,32381365,1614167,40713291,36095468,1613640,36091943,40713539,36778983,36095770,1614101,1614449,51733821,1614413,36779157,36778918,36779034,36096005,1613861,51733715,36778784,1613947,1613995,29571128,1614312,1613700,1613670,29570869,36778854,1613989,32381308,36095588,36095606,37242249,1613682,1614485,1614461,32381359,36095501,51733863,51733902,1614143,1614467,36091776,1614479,36779079,1613706,36096097,1613867,39951878,17679448,16791764,17679336,17679354,17679480,16791740,16791746,17679327,17679464,16791755,17679497,17679345,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` > 1729639972
    )
    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(140)

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` > 1729639972) 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(140) ;

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, 1613214, 2458981, 13169002
  )
  AND pt.product_id IN (
    47673685,
    47673692,
    47673639,
    47673701,
    46237660,
    47673787,
    46237675,
    47673756,
    47673731,
    47673630,
    47673647,
    47673598,
    46237691,
    47673809,
    47673616,
    38974445,
    47673679,
    38974429,
    47673722,
    47673606,
    47673715,
    47673802,
    38974413,
    47673794,
    47673766,
    46237683,
    1614258,
    1613676,
    51733629,
    51733776,
    1614149,
    29571134,
    36096025,
    1613795,
    51733547,
    36091693,
    36095677,
    40713505,
    36091878,
    40713401,
    1614137,
    1614455,
    1614300,
    1614173,
    40713434,
    36095917,
    29571194,
    40713344,
    1613837,
    1613843,
    36095848,
    39951817,
    1614013,
    39951870,
    1613688,
    36095866,
    29571286,
    1614001,
    36095791,
    1613831,
    36091844,
    36091640,
    1614324,
    32381314,
    36096071,
    36779118,
    1613983,
    36091742,
    36095702,
    1614019,
    36091913,
    1614306,
    1614294,
    51733945,
    1613849,
    1614330,
    40713573,
    36095942,
    29570875,
    40713471,
    1614155,
    32381365,
    1614167,
    40713291,
    36095468,
    1613640,
    36091943,
    40713539,
    36778983,
    36095770,
    1614101,
    1614449,
    51733821,
    1614413,
    36779157,
    36778918,
    36779034,
    36096005,
    1613861,
    51733715,
    36778784,
    1613947,
    1613995,
    29571128,
    1614312,
    1613700,
    1613670,
    29570869,
    36778854,
    1613989,
    32381308,
    36095588,
    36095606,
    37242249,
    1613682,
    1614485,
    1614461,
    32381359,
    36095501,
    51733863,
    51733902,
    1614143,
    1614467,
    36091776,
    1614479,
    36779079,
    1613706,
    36096097,
    1613867,
    39951878,
    17679448,
    16791764,
    17679336,
    17679354,
    17679480,
    16791740,
    16791746,
    17679327,
    17679464,
    16791755,
    17679497,
    17679345,
    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,1613214,2458981,13169002)
                  AND pt.product_id IN (47673685,47673692,47673639,47673701,46237660,47673787,46237675,47673756,47673731,47673630,47673647,47673598,46237691,47673809,47673616,38974445,47673679,38974429,47673722,47673606,47673715,47673802,38974413,47673794,47673766,46237683,1614258,1613676,51733629,51733776,1614149,29571134,36096025,1613795,51733547,36091693,36095677,40713505,36091878,40713401,1614137,1614455,1614300,1614173,40713434,36095917,29571194,40713344,1613837,1613843,36095848,39951817,1614013,39951870,1613688,36095866,29571286,1614001,36095791,1613831,36091844,36091640,1614324,32381314,36096071,36779118,1613983,36091742,36095702,1614019,36091913,1614306,1614294,51733945,1613849,1614330,40713573,36095942,29570875,40713471,1614155,32381365,1614167,40713291,36095468,1613640,36091943,40713539,36778983,36095770,1614101,1614449,51733821,1614413,36779157,36778918,36779034,36096005,1613861,51733715,36778784,1613947,1613995,29571128,1614312,1613700,1613670,29570869,36778854,1613989,32381308,36095588,36095606,37242249,1613682,1614485,1614461,32381359,36095501,51733863,51733902,1614143,1614467,36091776,1614479,36779079,1613706,36096097,1613867,39951878,17679448,16791764,17679336,17679354,17679480,16791740,16791746,17679327,17679464,16791755,17679497,17679345,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
        ;