Symfony Profiler

select
  o_id as id,
  position__longitude as lon,
  position__latitude as lat
from
  object_8
WHERE
  position__longitude IS NOT NULL
  AND position__latitude IS NOT NULL

select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL;

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

SELECT * FROM documents_editables WHERE documentId = 19883;

SELECT
  id
FROM
  sites

SELECT id FROM sites;

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/' AND `key` = BINARY 'book-accommodation';

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/Suedsteiermark/Holiday/book-accommodation' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Suedsteiermark/Holiday/book-accommodation?randSeed=518&showMap=1&nearbySearchId=854384&nearbySearchLat=46.93009&nearbySearchLong=15.25674&page=10&sorting=nearbySearchAsc' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation?nearbySearchId=854384&nearbySearchLat=46.93009&nearbySearchLong=15.25674&page=10&randSeed=518&showMap=1&sorting=nearbySearchAsc' 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
  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 = 6938 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

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/Suedsteiermark/Holiday/book-accommodation';

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//en/Suedsteiermark/Holiday/book-accommodation'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Suedsteiermark/Holiday/book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Suedsteiermark/Holiday/book-accommodation';

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Suedsteiermark/Holiday/book-accommodation'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Suedsteiermark/Holiday/book-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 = 19883 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 19883;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1223526;

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

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

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

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

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Suedsteiermark/Holiday/book-accommodation'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Suedsteiermark/Holiday/book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

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 (
    1989306,
    2060888,
    4061338,
    2684053,
    36160,
    17823,
    1984665,
    4061122,
    38060,
    42350,
    35655,
    49790,
    38423,
    14659516,
    54695,
    44660,
    4061187,
    52545,
    1990539,
    10114007,
    45252,
    31772,
    2065496,
    1986681,
    39297,
    23435,
    53239,
    24242,
    20108,
    21859,
    1994545,
    42911,
    8537205,
    43837572,
    47398,
    47606,
    39083,
    48496,
    27685,
    31422,
    42114,
    1433530,
    25942,
    47781,
    29547,
    18042,
    46636,
    44172,
    38904,
    51034,
    9455693,
    23620,
    32750792,
    46733,
    55395,
    37746,
    18776204,
    41649,
    41615,
    367300,
    45582,
    27419533,
    25273,
    55242,
    23920,
    45797,
    46578,
    50189,
    27471,
    1987095,
    17593634,
    16110362,
    43758,
    44222,
    1991623,
    28657,
    4061211,
    41879,
    17418,
    12910729,
    48365,
    45375,
    1986627,
    1986865,
    4761749,
    18328480,
    35666823,
    49548934,
    49387,
    1988937,
    43125,
    44781642,
    18290,
    39454,
    11365272,
    1986795,
    38807,
    46450,
    4063051,
    51357,
    38480,
    6645142,
    44587191,
    34831,
    30731557,
    50194,
    1989566,
    39575,
    50086,
    30764208,
    53743,
    43414,
    31117139,
    33100,
    9484915,
    15498539,
    1993711,
    26337,
    53347,
    26570,
    26431,
    53593,
    1986433,
    41793,
    53159,
    1984959,
    55324,
    2060516,
    20707,
    46874,
    18813,
    46968,
    19115,
    42655,
    35324,
    36935,
    33519,
    1990954,
    1986946,
    28867356,
    42785,
    2059361,
    43702020,
    52190,
    48890,
    25522,
    31474,
    33905,
    1992394,
    2063458,
    1986716,
    36664,
    38616,
    1988816,
    40473,
    52476,
    40768,
    4608272,
    45198113,
    11364731,
    1985351,
    53474,
    33451,
    25763,
    1988207,
    1984508,
    35206879,
    5367477,
    43641,
    2062410,
    47487,
    17126,
    35330412,
    12879304,
    46206,
    49502,
    42753168,
    24375268,
    42581,
    37942,
    33768,
    2064618,
    1995103,
    35206874,
    1993811,
    25025,
    45143324,
    54798,
    36617,
    25766745,
    24781077,
    40425,
    50325,
    34983,
    45122,
    23991,
    7738640,
    26721,
    45054,
    54523,
    9529160,
    1989012,
    51151,
    48905589,
    55167,
    2059839,
    31340,
    48017,
    1986015,
    1993946,
    53948,
    1994889,
    20023418,
    20291,
    41366,
    36531210,
    1990285,
    34013,
    31543,
    1984904,
    1985660,
    1994732,
    2059991,
    21659,
    15375608,
    37175,
    20577,
    28470795,
    38373,
    43155,
    10664738,
    22475,
    1993878,
    30565,
    35070,
    2065944,
    28124,
    4525614,
    46152494,
    44781629,
    40556,
    28867350,
    41160,
    43184382,
    1985474,
    34358,
    9313566,
    50011,
    45319,
    5949155,
    1984760,
    25423486,
    34270,
    18462,
    1993209,
    59655,
    47131,
    39377,
    49276,
    19054,
    26851,
    35666828,
    44339,
    31625,
    43804,
    1833139,
    42428,
    2064720,
    1993645,
    7738339,
    54166,
    32689,
    49497910,
    18746,
    1984997,
    44831,
    39687,
    43433,
    43526,
    2059260,
    41198698,
    32305843,
    39998,
    17676,
    50850,
    1993242,
    18680,
    47247,
    28587,
    35382,
    35666833,
    46316,
    32353,
    28278,
    1988385,
    2062684,
    21368,
    17811174,
    37365,
    32298578,
    48570,
    19158,
    30482936,
    28876,
    1991492,
    27868,
    1992261,
    1985174,
    1985415,
    28091523,
    15843263,
    2058868,
    24971,
    24448,
    7351637,
    44387,
    2063745,
    30773134,
    17904,
    12910566,
    2064808,
    31843325,
    47921,
    46250,
    30101,
    1146742,
    24793,
    1991966,
    44050,
    42841,
    19475,
    18165472,
    51833,
    32010,
    25723022,
    2064168,
    23077,
    1992182,
    40646,
    23500,
    1988139,
    54118,
    31203,
    1995175,
    11185192,
    39231,
    2061355,
    1995257,
    36492,
    52801,
    18432,
    28828,
    4149206,
    19852,
    41239,
    9283115,
    43065,
    1146711,
    39007,
    1988874,
    1985522,
    37217,
    1987463,
    14913865,
    27631,
    1994374,
    19857,
    39558266,
    30980,
    11436541,
    11367489,
    54339,
    8142109,
    12279128,
    20840,
    22213550,
    30756,
    1987706,
    20203610,
    36327,
    21427,
    36531205
  )
  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 (1989306,2060888,4061338,2684053,36160,17823,1984665,4061122,38060,42350,35655,49790,38423,14659516,54695,44660,4061187,52545,1990539,10114007,45252,31772,2065496,1986681,39297,23435,53239,24242,20108,21859,1994545,42911,8537205,43837572,47398,47606,39083,48496,27685,31422,42114,1433530,25942,47781,29547,18042,46636,44172,38904,51034,9455693,23620,32750792,46733,55395,37746,18776204,41649,41615,367300,45582,27419533,25273,55242,23920,45797,46578,50189,27471,1987095,17593634,16110362,43758,44222,1991623,28657,4061211,41879,17418,12910729,48365,45375,1986627,1986865,4761749,18328480,35666823,49548934,49387,1988937,43125,44781642,18290,39454,11365272,1986795,38807,46450,4063051,51357,38480,6645142,44587191,34831,30731557,50194,1989566,39575,50086,30764208,53743,43414,31117139,33100,9484915,15498539,1993711,26337,53347,26570,26431,53593,1986433,41793,53159,1984959,55324,2060516,20707,46874,18813,46968,19115,42655,35324,36935,33519,1990954,1986946,28867356,42785,2059361,43702020,52190,48890,25522,31474,33905,1992394,2063458,1986716,36664,38616,1988816,40473,52476,40768,4608272,45198113,11364731,1985351,53474,33451,25763,1988207,1984508,35206879,5367477,43641,2062410,47487,17126,35330412,12879304,46206,49502,42753168,24375268,42581,37942,33768,2064618,1995103,35206874,1993811,25025,45143324,54798,36617,25766745,24781077,40425,50325,34983,45122,23991,7738640,26721,45054,54523,9529160,1989012,51151,48905589,55167,2059839,31340,48017,1986015,1993946,53948,1994889,20023418,20291,41366,36531210,1990285,34013,31543,1984904,1985660,1994732,2059991,21659,15375608,37175,20577,28470795,38373,43155,10664738,22475,1993878,30565,35070,2065944,28124,4525614,46152494,44781629,40556,28867350,41160,43184382,1985474,34358,9313566,50011,45319,5949155,1984760,25423486,34270,18462,1993209,59655,47131,39377,49276,19054,26851,35666828,44339,31625,43804,1833139,42428,2064720,1993645,7738339,54166,32689,49497910,18746,1984997,44831,39687,43433,43526,2059260,41198698,32305843,39998,17676,50850,1993242,18680,47247,28587,35382,35666833,46316,32353,28278,1988385,2062684,21368,17811174,37365,32298578,48570,19158,30482936,28876,1991492,27868,1992261,1985174,1985415,28091523,15843263,2058868,24971,24448,7351637,44387,2063745,30773134,17904,12910566,2064808,31843325,47921,46250,30101,1146742,24793,1991966,44050,42841,19475,18165472,51833,32010,25723022,2064168,23077,1992182,40646,23500,1988139,54118,31203,1995175,11185192,39231,2061355,1995257,36492,52801,18432,28828,4149206,19852,41239,9283115,43065,1146711,39007,1988874,1985522,37217,1987463,14913865,27631,1994374,19857,39558266,30980,11436541,11367489,54339,8142109,12279128,20840,22213550,30756,1987706,20203610,36327,21427,36531205)
                  
                   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.town__id IN (
      6944, 6971, 12312, 12321, 6973, 12320,
      6953, 12309, 6955, 6957, 6963, 6948,
      12304, 6969, 6945, 6966, 6951, 6968,
      6949, 12305, 6958, 6959, 6970, 6974,
      12324, 12342, 6946, 6956, 6964, 6954,
      6967, 12319, 12333, 6965, 12323, 12316,
      6961, 12318, 6972, 6962, 6960, 12329,
      12311, 6947
    )
  )
  AND dacco.bookable = 1
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(518)

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.o_published = 1  AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1  GROUP BY dacco.oo_id  ORDER BY  RAND(518) ;