Symfony Profiler

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 8385;

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/Gesaeuse/Plan-your-holidays/Accommodations/bubbles' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Gesaeuse/Plan-your-holidays/Accommodations/bubbles?randSeed=800&nearbySearchId=324603&nearbySearchLat=47.62187&nearbySearchLong=13.82845' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Gesaeuse/Plan-your-holidays/Accommodations/bubbles?nearbySearchId=324603&nearbySearchLat=47.62187&nearbySearchLong=13.82845&randSeed=800' 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
  *
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
  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 = 11420 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Gesaeuse/Plan-your-holidays/Accommodations/' AND `key` = BINARY 'bubbles';

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

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

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

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/Gesaeuse/Plan-your-holidays/Accommodations/bubbles';

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
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Gesaeuse/Plan-your-holidays/Accommodations/bubbles';

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 (
    19359405, 273143, 1603030, 1605324,
    30576713, 47247486, 1602438, 7512292,
    272908, 27187816, 1600619, 1605354,
    39225314, 1605052, 31341359, 44080159,
    1603799, 3259752, 271621, 8694081,
    272624, 1600797, 16648129, 26647560,
    271832, 1603635, 1604437, 31341209,
    1601806, 31050826, 1604752, 1604964,
    1601300, 5160398, 272273, 272587,
    1600537, 1604712, 1599977, 6110063,
    28875683, 272389, 1604586, 1604920,
    1604675, 1602757, 1602702, 3402215,
    4061376, 272451, 1627443, 1601456,
    1601128, 1601381, 1602028, 1603875,
    271807, 1603081, 273030, 36619529,
    1601631, 1600091, 47247472, 1599922,
    1600895, 1603557, 1603697, 31341041,
    1605293, 9520223, 1603143, 1600028,
    1603255, 1904712, 48897445, 1601222,
    1605263, 1601425, 1600513, 1600709,
    1602987, 1603434, 45233699, 1603751,
    1602100, 1602287, 10368361, 1602156,
    3413534, 1602235, 1602560, 1601151,
    1603350, 1604133
  )
  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 (19359405,273143,1603030,1605324,30576713,47247486,1602438,7512292,272908,27187816,1600619,1605354,39225314,1605052,31341359,44080159,1603799,3259752,271621,8694081,272624,1600797,16648129,26647560,271832,1603635,1604437,31341209,1601806,31050826,1604752,1604964,1601300,5160398,272273,272587,1600537,1604712,1599977,6110063,28875683,272389,1604586,1604920,1604675,1602757,1602702,3402215,4061376,272451,1627443,1601456,1601128,1601381,1602028,1603875,271807,1603081,273030,36619529,1601631,1600091,47247472,1599922,1600895,1603557,1603697,31341041,1605293,9520223,1603143,1600028,1603255,1904712,48897445,1601222,1605263,1601425,1600513,1600709,1602987,1603434,45233699,1603751,1602100,1602287,10368361,1602156,3413534,1602235,1602560,1601151,1603350,1604133)
                  
                   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.oo_id IN (
    19359405, 273143, 1603030, 1605324,
    30576713, 47247486, 1602438, 7512292,
    272908, 27187816, 1600619, 1605354,
    39225314, 1605052, 31341359, 44080159,
    1603799, 3259752, 271621, 8694081,
    272624, 1600797, 16648129, 26647560,
    271832, 1603635, 1604437, 31341209,
    1601806, 31050826, 1604752, 1604964,
    1601300, 5160398, 272273, 272587,
    1600537, 1604712, 1599977, 6110063,
    28875683, 272389, 1604586, 1604920,
    1604675, 1602757, 1602702, 3402215,
    4061376, 272451, 1627443, 1601456,
    1601128, 1601381, 1602028, 1603875,
    271807, 1603081, 273030, 36619529,
    1601631, 1600091, 47247472, 1599922,
    1600895, 1603557, 1603697, 31341041,
    1605293, 9520223, 1603143, 1600028,
    1603255, 1904712, 48897445, 1601222,
    1605263, 1601425, 1600513, 1600709,
    1602987, 1603434, 45233699, 1603751,
    1602100, 1602287, 10368361, 1602156,
    3413534, 1602235, 1602560, 1601151,
    1603350, 1604133
  )
  AND dacco.o_published = 1
  AND (
    dacco.town__id IN (
      11431, 11422, 11423, 11541, 11430, 3192505,
      3192507, 3192504, 3192506, 11426,
      3192508, 11434
    )
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(800)

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (19359405,273143,1603030,1605324,30576713,47247486,1602438,7512292,272908,27187816,1600619,1605354,39225314,1605052,31341359,44080159,1603799,3259752,271621,8694081,272624,1600797,16648129,26647560,271832,1603635,1604437,31341209,1601806,31050826,1604752,1604964,1601300,5160398,272273,272587,1600537,1604712,1599977,6110063,28875683,272389,1604586,1604920,1604675,1602757,1602702,3402215,4061376,272451,1627443,1601456,1601128,1601381,1602028,1603875,271807,1603081,273030,36619529,1601631,1600091,47247472,1599922,1600895,1603557,1603697,31341041,1605293,9520223,1603143,1600028,1603255,1904712,48897445,1601222,1605263,1601425,1600513,1600709,1602987,1603434,45233699,1603751,1602100,1602287,10368361,1602156,3413534,1602235,1602560,1601151,1603350,1604133)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11431, 11422, 11423, 11541, 11430, 3192505, 3192507, 3192504, 3192506, 11426, 3192508, 11434))  GROUP BY dacco.oo_id  ORDER BY  RAND(800) ;

SELECT
  dest_id,
  count(src_id) as accoCount
FROM
  `steiermark`.object_relations_8 daccorel
WHERE
  dest_id IN (
    6815, 6813, 6825, 6809, 6831, 6806, 6839,
    6807, 6838, 6817, 6816
  )
  AND src_id IN (
    select
      id
    from
      `steiermark`.accoIdsTowns
  )
group by
  dest_id

SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6815, 6813, 6825, 6809, 6831, 6806, 6839, 6807, 6838, 6817, 6816)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id ;

SELECT
  dest_id,
  count(src_id) as accoCount
FROM
  `steiermark`.object_relations_8 daccorel
WHERE
  dest_id IN (7999, 8127, 8006, 8045)
  AND src_id IN (
    select
      id
    from
      `steiermark`.accoIdsTowns
  )
group by
  dest_id

SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (7999, 8127, 8006, 8045)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id ;

SELECT
  dest_id,
  count(src_id) as accoCount
FROM
  `steiermark`.object_relations_8 daccorel
WHERE
  dest_id IN (9640, 9648, 9707)
  AND src_id IN (
    select
      id
    from
      `steiermark`.accoIdsTowns
  )
group by
  dest_id

SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9640, 9648, 9707)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id ;

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 (
      11431, 11422, 11423, 11541, 11430, 3192505,
      3192507, 3192504, 3192506, 11426,
      3192508, 11434
    )
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(800)

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 (11431, 11422, 11423, 11541, 11430, 3192505, 3192507, 3192504, 3192506, 11426, 3192508, 11434))  GROUP BY dacco.oo_id  ORDER BY  RAND(800) ;

SELECT
  dest_id,
  count(src_id) as accoCount
FROM
  `steiermark`.object_relations_8 daccorel
WHERE
  dest_id IN (
    11431, 11423, 11541, 11430, 3192505,
    3192507, 3192504, 11426, 11434
  )
  AND src_id IN (
    select
      id
    from
      `steiermark`.accoIdsTowns
  )
group by
  dest_id

SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11431, 11423, 11541, 11430, 3192505, 3192507, 3192504, 11426, 11434)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id ;

create TEMPORARY table `steiermark`.accoIdsTowns(
  id int(11) NOT NULL,
  PRIMARY KEY (`id`)
) engine = memory; insert into `steiermark`.accoIdsTowns (id)
values
  (31341209),
  (272273),
  (1604675),
  (30576713),
  (3402215),
  (36619529),
  (1603799),
  (47247486),
  (1600537),
  (1599922),
  (272908),
  (31050826),
  (271832),
  (26647560),
  (1599977),
  (4061376),
  (6110063),
  (1605324),
  (1602702),
  (45233699),
  (271807),
  (1603255),
  (1904712),
  (1602100),
  (1602987),
  (1604964),
  (1601631),
  (3413534),
  (1600797),
  (1602156),
  (10368361),
  (19359405),
  (1603557),
  (1602028),
  (271621),
  (1600513),
  (272624),
  (9520223),
  (1603081),
  (44080159),
  (3259752),
  (1600028),
  (1601806),
  (16648129),
  (8694081),
  (1604437),
  (1604133),
  (31341041),
  (1605354),
  (1600091),
  (39225314),
  (1603751),
  (1603350),
  (1603635),
  (1600895),
  (1605263),
  (1602757),
  (1604712),
  (1600619),
  (1602287),
  (1600709),
  (272451),
  (31341359),
  (1603030),
  (273030),
  (1601456),
  (1605052),
  (1602235),
  (28875683),
  (48897445),
  (1604752),
  (272389),
  (1601381),
  (1605293),
  (1602560),
  (273143),
  (27187816),
  (1603697),
  (272587),
  (1603143),
  (1604586),
  (1604920),
  (1602438),
  (5160398),
  (1601128),
  (1601300),
  (1627443),
  (1601151),
  (47247472),
  (1601222),
  (1603875),
  (1603434),
  (1601425),
  (7512292)

create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (31341209),(272273),(1604675),(30576713),(3402215),(36619529),(1603799),(47247486),(1600537),(1599922),(272908),(31050826),(271832),(26647560),(1599977),(4061376),(6110063),(1605324),(1602702),(45233699),(271807),(1603255),(1904712),(1602100),(1602987),(1604964),(1601631),(3413534),(1600797),(1602156),(10368361),(19359405),(1603557),(1602028),(271621),(1600513),(272624),(9520223),(1603081),(44080159),(3259752),(1600028),(1601806),(16648129),(8694081),(1604437),(1604133),(31341041),(1605354),(1600091),(39225314),(1603751),(1603350),(1603635),(1600895),(1605263),(1602757),(1604712),(1600619),(1602287),(1600709),(272451),(31341359),(1603030),(273030),(1601456),(1605052),(1602235),(28875683),(48897445),(1604752),(272389),(1601381),(1605293),(1602560),(273143),(27187816),(1603697),(272587),(1603143),(1604586),(1604920),(1602438),(5160398),(1601128),(1601300),(1627443),(1601151),(47247472),(1601222),(1603875),(1603434),(1601425),(7512292);

DROP
  TABLE IF EXISTS `steiermark`.accoIdsTowns;
DROP
  TABLE IF EXISTS `steiermark`.productIdsTowns;

DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;;