https://stage.steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles?_=1726272000000&nearbySearchId=1255&nearbySearchLat=47.55561&nearbySearchLong=13.92067&randSeed=194

Method
GET
HTTP Status
200
IP
66.249.75.10
Profiled on
Token
fc427d

Query Metrics

89 Database Queries
30 Different statements
241.22 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
2.12 ms
(0.88%) 		11 
SELECT name FROM classes WHERE id = ?
Parameters: 
[
  "SiteConfig"
]
View formatted query    View runnable query    Explain query
0.66 ms
(0.27%) 		2 
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
Parameters: 
[
  "defaultSiteConfig"
  null
  null
]
View formatted query    View runnable query    Explain query
0.43 ms
(0.18%) 		1 
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
Parameters: 
[
  "sourcePath" => "/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles"
  "sourcePathQuery" => "/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles?randSeed=194&nearbySearchId=1255&nearbySearchLat=47.55561&nearbySearchLong=13.92067&_=1726272000000"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles?_=1726272000000&nearbySearchId=1255&nearbySearchLat=47.55561&nearbySearchLong=13.92067&randSeed=194"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
View formatted query    View runnable query    Explain query
0.40 ms
(0.16%) 		2 
SELECT * FROM documents_editables WHERE documentId = ?
Parameters: 
[
  9975
]
View formatted query    View runnable query    Explain query
0.32 ms
(0.13%) 		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
Parameters: 
[
  11462
]
View formatted query    View runnable query    Explain query
0.27 ms
(0.11%) 		2 
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters: 
[
  "key" => "bubbles"
  "path" => "/steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/"
]
View formatted query    View runnable query    Explain query
0.24 ms
(0.10%) 		2 
SELECT * FROM website_settings WHERE id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.18 ms
(0.07%) 		1 
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters: 
[
  "/steiermark.com/%"
  "/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles"
]
View formatted query    View runnable query    Explain query
0.17 ms
(0.07%) 		1 
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(0.07%) 		1 
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters: 
[
  "id" => "reports"
  "scope" => "pimcore"
]
View formatted query    View runnable query    Explain query
0.11 ms
(0.04%) 		1 
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters: 
[
  "prettyUrl" => "/steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles"
]
View formatted query    View runnable query    Explain query

demi_vacancies connection

Time▼ Count Info
126.57 ms
(52.47%) 		16 
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1616423,2310272,1612895,1614854,18777721,1930243,41643929,1616259,7452883,2456108,18777710,1615164,19763638,1905995,2457463,1614785,31439157,2457450,9684290,18777699,41003922,1906838,1930330,1614803,1906454,2418919,6342567,27961045,31116285,1905927,1615966,45886154,1821868,1906916,1821963,44735018,2458228,2456499,32043299,18778011,1905966,21905908,1615125,2454629,7453176,2457187,12578470,2194150,3213244,1615601,22817521,2456895,2310269,1612986,1906696,47650481,7452890,2457844,7453051,47698722,7453058,18777677,1821641,32662482,2456321,1615234,7452925,3121111,1615749,7453225,7452967,2453987,7162763,1614871,17197373,18743289,1905902,1616323,34043087,31116629,8924349,2457632,1905939,7453037,2194032,39249742,7453079,2309430,18743469,2458779,18778000,31116045,1905888,2404244,7453204,1821791,2455688,18776659,7453135,2457650,2457153,1906621,9566387,47840451,7453002,7453211,1907111,18776639,46121793,1906561,2194142,1612643,18776417,2530034,31116306,2456969,21285943,13169002,7452995,2456739,7449751,1821686,7453065,12771836,2457137,2458412,30629016,26147003,9566396,1906263,39952681,2458180,19763617,47698731,1616447,18777989,2456727,1906343,2530025,1612971,18776567,7452960,31116650,15221891,2529883,1615190,18743311,4062128,16993556,7453016,7453183,27167031,18777644,7453072,2456405,7453030,7453044,2530049,1615279,1616414,1616103,7452876,14957863,6342564,11825924,2457383,2459142,39976679,2454119,1614713,1821779,18743300,45582974,13734739,4063767,35677466,1907248,27998615,7453128,2310556,7453169,2459254,18743447,2368223,30192336,18777967,2529904,18755389,46648161,2458035,2458073,18777978,1613214,2458503,7452939,1615308,4063709,44079175,7453107,18776428,7452974,2458339,1616614,1907362,18777688,18776406,40935234,1616557,1616174,1615872,1930178,7453197,18776174,11106490,7452953,1906079,7453114,16192461,2456226,1615005,18777666,7452946,2454304,2829775,19763596,34613565,1906002,12736708,1907399,10223870,48320437,11644081,27858937,31116495,1612739,2459068,1906356,1615080,1616483,18411811,1702924,7453218,2457665,18743458,32043296,1613127,50062232,1821596,18777655,47650472,2457556,7452988,2458981,18743480,38973570,6645761,18777956,1615580,2458151,31116608,1821748,1906009,7452918,1612687,30806616,1616081,31159117,50062229,2457950,4442120,1616064,2455620,23827352,2404275,3032193,2194020,1907420,2458056,10990613,1612675,2458323,15136325,1821680,44760927,2457621,2104878,50330126,1616053,1906066,2457291,1822030,9651389,1616313,2454859,1821849,1614918,1614778,1821737,1906189,2458566,2457536,1703009,2455657,2104688,1615159,2454173,48208705,2457745,1906028,15136578,48319918,1615721,1616440,1615731,1906601,18094541,2104726,30192347,1930324,1906852,1616249,12665315,2453569,50330123,1906052,2454928,2104858,2457968,1616142,2457195,1821692,2458552,46904062,2310457,1821762,12176479,12076233,41643953,51238225,1907143,2457393,45911208,1907004,4062019,12212021,49522274,2458171,1906073,1615985,4062000,1821814,1821955,2458026,1616459,1614830,1702966,1615547,1906795,1905954,2454764,43139185,2309376,27858940,2454264,1906171,1615738,45167318,1615663,1613120,2457960,1821740,2457544,4062249,2308773,40480657,2457214,1615228,2453674,1612628,1616205,1906035,1616336,1613190,4062004,46703369,25076569,1614843,11993589,1906432,2453876,1612621,2458494,2104833,1616367,34613539,6995557,1612928,7453023,4062325,1612780,42766841,1930168,1821893,2457275,48753192,1906202,1615680,1612661,7452932,1703035,1616360,6775712,11993576,2310359,37260090,2104798,32356610,1822005,2457118,2454738,1614903,1615208,3259747,32203081,1612937,1906157,9159056,15028571,6645739,2457692,1821698,1702984,1906209,1821730,2457353,1702930,2458331,2456579,1906112,8776246,2454461,2457105,42339673,1906788,2458788,2529898,18541017,1612667,13415036,1615674,2457171,1905920,1906859,12076227,1616381,7452869,1821716,2456436,7576136,1612993,1906021,1615522,1616117,1613053,1616351,2454161,1614767,2457774,1616532,1930310,25114536,2458008,1907427,40649956,1612635,2455852,1613013,1616159,1612831,1616514,4062044,1616374,9108294,29850681,1821629,1612792,2368235,2454613,1906635,11993491,1906305,2310347,1612861,2530028,1615272,4704521,1616601,1906747,9490401,1821807,2454032,39621948,1906119,18721781,1616477,2455815,1821823,51735516,16463906,7453190,1616197,2458389,1615503,2456271,12141175,1612882,2458294,2459044,2458424,7453009,2104885,38702048,29699643,1930118,1616585,1612855,42085312,2194164,1906766,1906508,2453840,2459391,2458275,1906328,1907049,1930130,24109335,2104851,1906873,1930161,1616507,2458404,4820748,24874128,2104901,2453896,1906719,1906546,2454097,13468069,19739002,2456978,1702996,2458357,12141191,15187823,1616047,2458381,22968535,40066871,14055216,9490392,2456747,2458128,1930304,1616296,1615991,1612870,50330129,2454904,2308760,49619462,32996115,2455321,27090024,1612798,2455960,31569228,2455032,8924340,1906059,1615533,12578480,4149203,50660470,1612615,1612655,4090781,1906196,7453121,20926241,1821635,1822022,2457804,2455156,1616225,1615997,1615295,1906816,27961048,1616284,1906418,32396816,12785402,11993553,15115425,2530031,1614837,2455301,2458107,2104811,1906901,2530046,34595469,1615509,2458255,1615743,15154165,1613183,49289508,24629767,2457782,2529886,1615202,13205136,40066879,1615695,4062035,1822011,4062067,2457241,1612964,2456775,1614910,2458159,50613474,2059036,11993564,1821772,11993543,1821861,35259362,38954139,1612950,1821623,1616498,16552093,49723102,2104401,2457048,51333826,29827678,1616235,18861848,1612786,9735393,2457179,2453808,9238291,45468398,2458533,1906802,1612819,2104698,46837228,1615196,2104865,25851748,1613197,1612876,2457417,1615773,1821580,1907413,1906249,1906297,2458372,44781292,1821723,1821836,1612889,2104824,2458220,1616087,1821979,2458315,2309712,2104791,49758724,1615178,2457931,32356605,40480654,1613038,4062032,1615619,2455138,2529880,6208703,2456765,4062193,2457980,2458065,1907329,2457590,1612807,1614616,1906044,2309544,4063718,2457442,1821899)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11465, 11466, 11464, 11463, 1612603))  GROUP BY dacco.oo_id  ORDER BY  RAND(194)
Parameters: 
[]
View formatted query    View runnable query    Explain query
71.73 ms
(29.74%) 		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 (1616423,2310272,50062229,1612895,2457950,4442120,1614854,1616064,18777721,2455620,1930243,41643929,23827352,2404275,3032193,1616259,2194020,1907420,2458056,10990613,1612675,2458323,7452883,15136325,1821680,2456108,18777710,44760927,2457621,1615164,19763638,2104878,50330126,1905995,2457463,1616053,1906066,2457291,1822030,1614785,31439157,9651389,1616313,2457450,9684290,2454859,1821849,18777699,1614918,1614778,41003922,1821737,1906838,1930330,1614803,1906189,2458566,1906454,2457536,1703009,2418919,2455657,6342567,27961045,31116285,2104688,1615159,2454173,1905927,48208705,2457745,1906028,15136578,1615966,45886154,48319918,1821868,1615721,1906916,1821963,1616440,1615731,44735018,1906601,2458228,18094541,2104726,30192347,1930324,2456499,1906852,1616249,12665315,2453569,50330123,32043299,1906052,18778011,2454928,2104858,2457968,1616142,1905966,21905908,2457195,1615125,1821692,2458552,2454629,7453176,46904062,2310457,2457187,12578470,1821762,2194150,3213244,12176479,1615601,12076233,22817521,41643953,51238225,2456895,1907143,2457393,45911208,1907004,4062019,2310269,12212021,49522274,2458171,1906073,1615985,4062000,1821814,1821955,1612986,1906696,2458026,47650481,1616459,1614830,1702966,1615547,1906795,1905954,2454764,43139185,2309376,7452890,27858940,2454264,1906171,1615738,2457844,7453051,47698722,45167318,7453058,1615663,1613120,18777677,2457960,1821740,2457544,4062249,1821641,32662482,2308773,2456321,40480657,1615234,2457214,1615228,2453674,1612628,7452925,3121111,1616205,1615749,1906035,1616336,1613190,7453225,4062004,46703369,25076569,1614843,11993589,1906432,7452967,2453987,2453876,1612621,7162763,2458494,2104833,1616367,34613539,6995557,1612928,7453023,1614871,17197373,4062325,18743289,1905902,1616323,1612780,42766841,34043087,31116629,1930168,1821893,8924349,2457275,48753192,1906202,1615680,1612661,7452932,2457632,1905939,1703035,7453037,1616360,6775712,2194032,11993576,2310359,37260090,39249742,7453079,2104798,32356610,1822005,2457118,2309430,18743469,2458779,2454738,1614903,1615208,3259747,18778000,31116045,32203081,1905888,1612937,1906157,9159056,15028571,2404244,7453204,6645739,1821791,2455688,2457692,18776659,7453135,2457650,1821698,2457153,1906621,1702984,1906209,1821730,2457353,9566387,1702930,2458331,47840451,7453002,2456579,1906112,8776246,2454461,2457105,42339673,7453211,1906788,2458788,2529898,18541017,1612667,13415036,1615674,1907111,18776639,2457171,46121793,1905920,1906859,12076227,1616381,7452869,1906561,2194142,1821716,1612643,2456436,7576136,18776417,1612993,1906021,1615522,1616117,1613053,1616351,2454161,1614767,2530034,2457774,1616532,1930310,25114536,2458008,31116306,1907427,40649956,1612635,2456969,2455852,21285943,1613013,13169002,1616159,1612831,7452995,2456739,1616514,4062044,1616374,7449751,9108294,29850681,1821629,1821686,1612792,2368235,2454613,1906635,11993491,7453065,1906305,12771836,2457137,2310347,1612861,2458412,2530028,1615272,30629016,4704521,1616601,1906747,9490401,1821807,2454032,39621948,26147003,1906119,18721781,9566396,1906263,39952681,1616477,2455815,2458180,1821823,19763617,51735516,47698731,16463906,1616447,7453190,18777989,1616197,2458389,2456727,1906343,1615503,2456271,2530025,1612971,12141175,1612882,18776567,7452960,31116650,15221891,2529883,2458294,2459044,2458424,1615190,7453009,2104885,18743311,38702048,29699643,1930118,1616585,1612855,42085312,2194164,4062128,1906766,1906508,2453840,2459391,16993556,2458275,7453016,1906328,1907049,7453183,1930130,24109335,2104851,1906873,1930161,27167031,1616507,18777644,2458404,4820748,24874128,2104901,2453896,1906719,7453072,1906546,2454097,2456405,7453030,7453044,13468069,2530049,19739002,2456978,1615279,1702996,2458357,12141191,1616414,1616103,15187823,7452876,14957863,6342564,1616047,11825924,2458381,22968535,2457383,40066871,2459142,14055216,9490392,2456747,2458128,1930304,39976679,2454119,1616296,1615991,1612870,50330129,2454904,2308760,49619462,32996115,2455321,27090024,1612798,2455960,31569228,2455032,1614713,8924340,1821779,18743300,45582974,1906059,13734739,1615533,4063767,35677466,12578480,4149203,50660470,1612615,1907248,1612655,27998615,7453128,2310556,4090781,7453169,1906196,2459254,18743447,2368223,7453121,20926241,1821635,30192336,18777967,2529904,1822022,18755389,2457804,2455156,1616225,46648161,2458035,1615997,1615295,2458073,18777978,1613214,1906816,2458503,7452939,27961048,1615308,4063709,44079175,7453107,1616284,18776428,7452974,2458339,1616614,1907362,18777688,1906418,18776406,32396816,12785402,40935234,11993553,1616557,15115425,1616174,1615872,2530031,1614837,2455301,1930178,2458107,2104811,7453197,1906901,2530046,34595469,1615509,2458255,18776174,1615743,11106490,15154165,7452953,1906079,1613183,7453114,16192461,49289508,24629767,2456226,1615005,2457782,2529886,1615202,18777666,13205136,40066879,1615695,4062035,1822011,7452946,4062067,2457241,2454304,2829775,1612964,2456775,1614910,2458159,50613474,2059036,19763596,34613565,11993564,1906002,1821772,11993543,1821861,12736708,35259362,38954139,1907399,10223870,48320437,1612950,1821623,11644081,1616498,16552093,27858937,49723102,31116495,2104401,1612739,2459068,2457048,51333826,29827678,1906356,1616235,18861848,1612786,9735393,2457179,2453808,1615080,1616483,18411811,9238291,45468398,2458533,1906802,1612819,2104698,46837228,1702924,7453218,1615196,2457665,2104865,18743458,25851748,32043296,1613127,1613197,1612876,2457417,50062232,1615773,1821580,1907413,1906249,1906297,2458372,44781292,1821596,1821723,1821836,1612889,18777655,2104824,2458220,1616087,1821979,2458315,47650472,2309712,2104791,49758724,1615178,2457556,2457931,7452988,2458981,32356605,18743480,40480654,1613038,4062032,38973570,1615619,6645761,2455138,2529880,6208703,18777956,1615580,2456765,2458151,4062193,2457980,2458065,31116608,1907329,1821748,2457590,1612807,1906009,1614616,1906044,7452918,2309544,4063718,1612687,30806616,2457442,1616081,31159117,1821899)
                  
                   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
Parameters: 
[]
View formatted query    View runnable query    Explain query
18.68 ms
(7.74%) 		1 
SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6812, 6815, 6830, 6813, 6825, 6809, 6831, 6806, 6839, 12662, 6814, 6807, 6838, 6824, 6826, 6817, 6816, 6819, 6832, 6820)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
7.55 ms
(3.13%) 		1 
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 (11465, 11466, 11464, 11463, 1612603))  GROUP BY dacco.oo_id  ORDER BY  RAND(194)
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.97 ms
(0.82%) 		1 
SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11465, 11466, 11464, 11463, 1612603)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.83 ms
(0.76%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9944)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.72 ms
(0.71%) 		16 
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (18776417),(2456775),(2458294),(1612895),(4063709),(2457960),(2454032),(15115425),(45886154),(1906209),(1821836),(1615997),(2194032),(27858940),(1615509),(18541017),(1821861),(1821814),(4820748),(2458008),(1612675),(7452925),(1906719),(1615695),(1613127),(1906343),(45582974),(2458275),(4062000),(2454613),(2104885),(25076569),(2453674),(1614803),(2829775),(2529880),(1615005),(2457665),(19739002),(1616351),(1615749),(1615580),(18743300),(2530049),(1615601),(1906079),(2456321),(45468398),(2454173),(1616336),(2458255),(1616447),(1821680),(2530046),(1616360),(1615196),(7453030),(1616601),(3032193),(2455852),(27961045),(1906249),(1906546),(2194164),(47698731),(19763617),(2454461),(1906021),(1614713),(2404275),(4062044),(1614854),(1615721),(2459044),(13169002),(13415036),(2529904),(2458503),(1821723),(18777989),(18776428),(2458533),(49723102),(1702966),(7452869),(9651389),(20926241),(11993543),(2456739),(2457171),(1821686),(18411811),(1615619),(1822030),(14055216),(11993564),(1614910),(46904062),(1906119),(24629767),(4063767),(15221891),(1614785),(2458073),(2457590),(2454304),(1613190),(7453023),(1906059),(31569228),(50330126),(2456978),(2457556),(2458035),(1616483),(27090024),(7453135),(9159056),(2458389),(38702048),(2458107),(12578480),(2453840),(2457291),(1821748),(2457774),(2368235),(1821730),(1906356),(2456765),(9238291),(2453569),(6995557),(1615080),(2459068),(7453176),(2456108),(18777978),(1616117),(1703009),(4442120),(50613474),(18776639),(1616367),(1612971),(2458372),(1821629),(1614778),(1906073),(49619462),(1821899),(1906747),(11825924),(1906028),(1615190),(2458552),(4062249),(1907399),(50660470),(50062229),(1907413),(2458412),(1616205),(44781292),(4063718),(1616459),(3121111),(7453190),(1613120),(2458220),(1821893),(2457118),(2310556),(2455032),(2457621),(2454928),(1905888),(1612628),(1906788),(2457844),(16993556),(2458779),(1614871),(18743447),(1616249),(32662482),(2457931),(50330123),(10223870),(2453987),(35677466),(1616585),(1906859),(1905954),(1905927),(1612621),(31116608),(7453002),(23827352),(18743480),(1615872),(1906601),(1612928),(1907143),(2454097),(2104824),(7453197),(39952681),(1613214),(18743311),(1612780),(12736708),(1615773),(48320437),(2456499),(18777967),(1930178),(2457650),(2418919),(1615208),(2458424),(1612661),(1906795),(4062004),(1614767),(2529883),(1907329),(18743469),(1906561),(2456747),(35259362),(2456969),(2310269),(49522274),(31116629),(21905908),(11993589),(18778011),(2457442),(1821955),(40480657),(27961048),(1906066),(2454119),(2454904),(7453169),(46837228),(47698722),(2309544),(1613197),(1612937),(1615178),(1930304),(2104698),(27858937),(32356605),(31116495),(2529886),(1906263),(4062035),(43139185),(1930161),(4062019),(1616381),(2457463),(1702984),(2455688),(1615228),(1616440),(2457692),(1930310),(1612964),(7452932),(1616053),(1907004),(2457179),(1615159),(2457968),(1906044),(2457417),(2368223),(32356610),(1821623),(27998615),(7453058),(1615731),(1612667),(9566387),(2455657),(1821740),(42766841),(2457536),(50062232),(1614616),(1821692),(37260090),(18776174),(1906635),(1702930),(26147003),(1616414),(1612643),(2457153),(1615547),(41643953),(1616142),(1614843),(2458339),(15187823),(1616197),(18743458),(1906009),(1616323),(7453107),(4062067),(18777688),(2456727),(2458128),(4149203),(47840451),(1821823),(12578470),(1612635),(2457353),(1906305),(2194020),(1616159),(1615663),(16192461),(1612831),(1906916),(2457195),(18777677),(1906432),(18755389),(1906621),(1930243),(2308773),(1613038),(1613183),(1612792),(1822022),(1906052),(1702996),(34595469),(1907420),(1615272),(9490392),(2457450),(2456895),(1612861),(7452988),(7453072),(2455138),(2458180),(31116306),(18777721),(1821580),(34043087),(2455960),(1905966),(2310359),(10990613),(1615164),(2104851),(8776246),(1616532),(1615966),(18776659),(1906297),(7162763),(2456226),(2104878),(2458323),(51238225),(2458065),(18776567),(32043299),(46703369),(16552093),(7452967),(2457187),(1615295),(2455620),(2457105),(7453065),(1616103),(9108294),(1612882),(42339673),(1906852),(48753192),(39249742),(7453044),(7452890),(29827678),(7452995),(2454738),(1907049),(25114536),(40066871),(2310272),(11993491),(2456405),(18777710),(1612855),(12665315),(27167031),(2457950),(1821596),(1616614),(1905920),(30629016),(39621948),(7452883),(1907111),(1615279),(1821737),(32043296),(2530031),(9684290),(24109335),(1821698),(2456436),(2458151),(18777666),(44079175),(7452974),(7453211),(9735393),(25851748),(1905939),(1703035),(1907427),(1702924),(1905995),(2457137),(1907248),(1907362),(2104401),(7453121),(1615738),(2457383),(2455156),(2455815),(7452946),(38954139),(18776406),(15154165),(2104798),(1906696),(2104688),(1615533),(2459391),(2458026),(7452960),(47650472),(2457745),(12212021),(30192336),(9566396),(32996115),(2457214),(6645739),(2456579),(1615985),(1906002),(18743289),(2459142),(1612870),(2453808),(1906112),(1821868),(51735516),(2309712),(1906202),(11106490),(1612798),(1906328),(2309430),(1906157),(1616313),(1930168),(1616507),(39976679),(1616047),(1614918),(1615680),(2458357),(31116285),(12141191),(38973570),(7453204),(15028571),(1612615),(1821762),(1612655),(2458159),(1930130),(1822005),(1906508),(31439157),(1615202),(30192347),(40066879),(1822011),(1930118),(2104901),(1613053),(2458171),(46121793),(1615503),(2530028),(40935234),(4062193),(1906189),(17197373),(2404244),(4704521),(2459254),(2455301),(6342564),(46648161),(1616284),(1821641),(7453009),(1906802),(2308760),(2455321),(30806616),(12771836),(31116650),(18721781),(42085312),(1906873),(7452939),(18777956),(1821779),(45167318),(1616557),(41643929),(12076227),(9490401),(2458228),(34613565),(18777699),(2104726),(16463906),(2458981),(7453079),(2453896),(1906196),(2530034),(6342567),(22817521),(32203081),(1821716),(7453114),(49289508),(2458331),(7452876),(41003922),(2458566),(1930324),(2104791),(1906838),(1615125),(1616235),(31159117),(2458056),(1616064),(2194142),(2457048),(1616374),(4062128),(7453051),(2454859),(44760927),(1615674),(1615991),(2458494),(1906418),(18861848),(1906816),(1906454),(2457632),(1906035),(7453128),(1616087),(2457275),(2454161),(6775712),(14957863),(1821849),(2104865),(12076233),(8924349),(1614830),(1616498),(34613539),(2529898),(2059036),(12141175),(2310347),(1821791),(2457980),(51333826),(1616081),(1613013),(1930330),(18777655),(2104811),(11644081),(13468069),(48208705),(19763596),(1612739),(29850681),(2457393),(2453876),(47650481),(1615308),(18094541),(2104858),(1612786),(8924340),(2457544),(1905902),(2454264),(18777644),(2104833),(7576136),(12785402),(7453016),(1821635),(1612819),(19763638),(13205136),(1612950),(32396816),(2454764),(4062032),(24874128),(40480654),(2194150),(11993553),(1616225),(1616259),(1612876),(2457782),(2458315),(2458788),(1612986),(1821807),(1616514),(1615234),(7452953),(49758724),(1612993),(1616423),(2456271),(1612889),(44735018),(22968535),(7449751),(15136578),(18778000),(7452918),(50330129),(1821979),(21285943),(13734739),(2454629),(3213244),(4062325),(1906901),(29699643),(11993576),(40649956),(2310457),(1616174),(1615522),(12176479),(2458404),(7453225),(1906171),(7453037),(7453218),(45911208),(2458381),(2457241),(6645761),(7453183),(4090781),(6208703),(48319918),(1821772),(1616477),(3259747),(1612807),(1614837),(1616296),(1614903),(1906766),(1821963),(31116045),(1612687),(1615743),(2457804),(15136325),(2309376),(2530025)
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.01 ms
(0.42%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9948)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.90 ms
(0.37%) 		16 
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.88 ms
(0.36%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6896)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.69 ms
(0.29%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6877)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.69 ms
(0.29%) 		1 
SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11311, 9619)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.39 ms
(0.16%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6859)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.38 ms
(0.16%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6898)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.27 ms
(0.11%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9941)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.27 ms
(0.11%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9943)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.24 ms
(0.10%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9939)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.19 ms
(0.08%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6868)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.19 ms
(0.08%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6925)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
demi_vacancies doctrine.dbal.demi_vacancies_connection

Entity Managers

Name Service
portal_engine doctrine.orm.portal_engine_entity_manager
pimcore_direct_edit doctrine.orm.pimcore_direct_edit_entity_manager
statistics_explorer doctrine.orm.statistics_explorer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.