https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?_=1736640000000&nearbySearchId=1580587&nearbySearchLat=47.18552&nearbySearchLong=14.80935&randSeed=552

Method
GET
HTTP Status
200
IP
66.249.75.3
Profiled on
Token
ac975e

Query Metrics

139 Database Queries
44 Different statements
18085.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
2.07 ms
(0.01%) 		11 
SELECT name FROM classes WHERE id = ?
Parameters: 
[
  "SiteConfig"
]
View formatted query    View runnable query    Explain query
1.08 ms
(0.01%) 		4 
SELECT * FROM documents_editables WHERE documentId = ?
Parameters: 
[
  9789
]
View formatted query    View runnable query    Explain query
0.85 ms
(0.00%) 		2 
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: 
[
  11893
]
View formatted query    View runnable query    Explain query
0.68 ms
(0.00%) 		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.52 ms
(0.00%) 		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/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles"
  "sourcePathQuery" => "/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?randSeed=552&nearbySearchId=1580587&nearbySearchLat=47.18552&nearbySearchLong=14.80935&_=1736640000000"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?_=1736640000000&nearbySearchId=1580587&nearbySearchLat=47.18552&nearbySearchLong=14.80935&randSeed=552"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
View formatted query    View runnable query    Explain query
0.37 ms
(0.00%) 		2 
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters: 
[
  "key" => "bubbles"
  "path" => "/steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/"
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.00%) 		2 
SELECT * FROM website_settings WHERE id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.14 ms
(0.00%) 		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/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles"
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.00%) 		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.13 ms
(0.00%) 		1 
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters: 
[
  "prettyUrl" => "/steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles"
]
View formatted query    View runnable query    Explain query
0.12 ms
(0.00%) 		1 
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters: 
[
  "id" => "reports"
  "scope" => "pimcore"
]
View formatted query    View runnable query    Explain query

demi_vacancies connection

Time▼ Count Info
17846.56 ms
(98.68%) 		13 
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (25984203,11618312,1950873,1952359,1827458,1932817,13770777,1830380,1733028,1825793,30205115,1735505,1728976,1933417,1948505,1946528,1736830,28929422,1936897,1950667,21984508,1951179,2663977,1739372,1824536,1953052,1827525,37868363,1823552,1947469,1739008,1931733,1946502,1731339,1829797,1829934,1738996,1730377,1750660,1947826,1949086,1954524,1823609,1952101,1735488,1950645,1827779,1943508,1954411,1737328,1828360,1728707,29819550,1937544,1735334,1934252,1739032,1955349,27947163,10374087,1936326,1734330,20962005,1941470,1954907,1729658,1955936,1953959,1825011,2664006,1731019,1733965,1942882,1732510,1730919,1954604,1940778,1955972,1830603,1737987,1943105,2670240,1942177,1829479,1948441,1949915,26306220,49874948,1738785,1826269,1733525,1937367,1728448,1949730,1733241,1737106,2664864,1828794,1827922,1954958,1734086,1828871,1931829,1828318,1932702,1949966,1941076,33905433,1947886,1730678,1952246,1826626,3238663,1749936,1729347,4062676,1730342,17364709,1947551,1735663,1828716,1935486,1825612,1732394,1940444,1933727,1948710,38290359,1955577,1953774,1947036,1943997,1827613,1954644,1728960,1729870,1957246,2670783,9629644,1730598,1948847,1946296,1729325,1943475,1738037,1939108,1947083,1938339,4442305,2670053,1734130,1943182,2669356,1739074,1948166,1943815,1948700,1933865,1824146,1930577,1950256,1729604,1826193,1824908,1739062,1737555,1823821,1823467,1733212,1823188,15419107,1951232,1827242,1946065,1939045,1937692,1731471,1946746,1943137,2853529,2670885,27866430,1939308,1950128,1941538,1729000,1823886,1737654,2663894,2669983,12149352,1940590,1828934,1823239,1729848,1736996,1828920,1943201,1948321,46852469,1955200,1937824,1828194,3283074,1727824,1823090,31159141,15118655,1823539,1823444,1750886,1931105,1952542,1952501,1736889,1736773,1823171,1823715,1732918,1957306,35658710,1951927,1949676,43826963,1941684,7757553,1951749,1736723,1942686,1829408,1829900,1733016,1950062,1933433,1732017,1948522,1946671,1825179,1735424,16605043,1938936,1738871,1750841,9258388,1932213,1729176,1934723,1931758,1948234,1733811,1737602,1947843,1952062,1733186,1950753,1739660,1953112,1947958,1938666,1940948,44433919,1730727,1942813,1730586,41458409,1942484,1825713,1736055,1737274,1949501,1735975,23899160,1950174,1948260,1824813,1949818,31747387,1951675,1951313,1946806,1825448,1735710,1933088,1935963,3402151,1732862,29788089,29789889,1955273,1955738,1828133,1826136,1727855,1950224,1949421,1824854,31823031,1930481,1940920,1736624,1733775,1730694,1942503,33363840,1750647,1750909,1947355,1934294,1939951,1956007,1729645,5554733,1734285,1949028,1951695,21824738,1951116,1943586,1955377,1750679,1947198,1948414,1732456,1943973,1938764,1942388,1829510,1750628,8745860,1938100,1728417,1829717,1736675,1942441,1729443,1954488,1949573,1949477,1733826,1732231,1949004,1733379,1828510,1737009,1946582,1732419,1733491,1953997,1938835,1730031,1936689,1949614,1824253,1827876,1951622,1951065,1950811,29787925,1823037,1947435,1823052,29789564,1934349,1829458,1829617,1824952,1733120,1729120,1728765,1932776,1731437,1734343,1934672,1937469,1951414,1935741,1733471,1829164,37911918,1955046,1941268,1941039,29788817,1932526,11862006,43399592,29789987,1729762,1950095,1730546,1952204,1735385,1948401,1826556,1734194,1750860,1930778,1946470,1825519,1824494,1952040,1735985,1955415,1732645,1946839,1730657,1948827,8844791,1950333,1823959,1933801,1826175,1732163,15419098,1947387,1735857,1727813,1733895,1733744,1951986,1828062,1737234,25089373,1952660,1932470,1731875,1830434,1732250,1825677,1948646,1730704,1946098,1735575,1955017,1954696,1737173,1750798,33294335,1824605,1733314,1826326,1953156,1826473,1955094,1826686,2670355,1731048,1952424,1948977,1948065,1948486,21862384,1955624,11928644,6648868,1942414,1952996,1823376,1737668,1932966,1728547,1738191,1737436,1950703,1730858,1947615,1939806,1739120,1823654,1824347,1950988,1824068,1930954,1954921,1935804,1946548,1952143,1931440,1936218,1937978,1824363,15498026,1951458,8382758,1729389,1947728,39908198,29789097,1734240,1737844,1825302,1954353,1954391,50929972,48564332,1955956,2673689,2663247,1823597,2669577,1735734,1955476,4062830,1955508,2673848,1947373,22680304,50200137,41108210,31261223,2666152,2674009,1955705,1948291,1737665,1930447,1955197,2674013,1824745,1931251,47978187,50010802,1734569,41365379,40707373,1955042,27142048,42444600,1828221,31077191,30841045,1947283,1955322,41064007,1946779,1946951,8746207,22621551,1955268,19928947,1736761,1948687,2669496,27972191,9629647,1954471,1948303,1954940,9576144,1942274,31896277,41704397,48417638,1957280,4062912,22680307,49917837,2673903,27066893,1824754,1954551,9886762,2674018,11245625,2674170,1952166,1953092,2670158,1829206,1954889,13873463,22680295,27066902,35313684,1731831,41278917,1747740,39811619,40707377,1957212,1955727,43822465,22680313,26021709,1728156,1955952,1954995,2674068,4062806,47196812,1826683,23107117,42144620,2673648,18250396,1952340,4062709,30525605,41453473,1737589,22680298,27178461,1750906,4062757,22870909,1955685,1738782,21577455,22680310,33623528,17071511,1955319,31788832,2673541,2674021,2673544,2669164,47930787,1750052,1733355,1737642,1738986,3089986,25215728,29263800,1736862,1730951,1829134,2674165,2673915,4062921,1823127,1948900,4062700,1955919,1953810,2670780,9576135,27066899,1948108)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11959, 11948, 11910, 11909, 11965, 11963, 11947, 11922, 11921, 11950, 11914, 11920, 11946, 11937, 29785444, 29785442))  GROUP BY dacco.oo_id  ORDER BY  RAND(552)
Parameters: 
[]
View formatted query    View runnable query    Explain query
108.72 ms
(0.60%) 		14 
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (25984203,11618312,1950873,1952359,1827458,1932817,13770777,1830380,1733028,1825793,30205115,1735505,1728976,1933417,1948505,1946528,1736830,28929422,1936897,1950667,21984508,1951179,2663977,1739372,1824536,1953052,1827525,37868363,1823552,1947469,1739008,1931733,1946502,1731339,1829797,1829934,1738996,1730377,1750660,1947826,1949086,1954524,1823609,1952101,1735488,1950645,1827779,1943508,1954411,1737328,1828360,1728707,29819550,1937544,1735334,1934252,1739032,1955349,27947163,10374087,1936326,1734330,20962005,1941470,1954907,1729658,1955936,1953959,1825011,2664006,1731019,1733965,1942882,1732510,1730919,1954604,1940778,1955972,1830603,1737987,1943105,2670240,1942177,1829479,1948441,1949915,26306220,49874948,1738785,1826269,1733525,1937367,1728448,1949730,1733241,1737106,2664864,1828794,1827922,1954958,1734086,1828871,1931829,1828318,1932702,1949966,1941076,33905433,1947886,1730678,1952246,1826626,3238663,1749936,1729347,4062676,1730342,17364709,1947551,1735663,1828716,1935486,1825612,1732394,1940444,1933727,1948710,38290359,1955577,1953774,1947036,1943997,1827613,1954644,1728960,1729870,1957246,2670783,9629644,1730598,1948847,1946296,1729325,1943475,1738037,1939108,1947083,1938339,4442305,2670053,1734130,1943182,2669356,1739074,1948166,1943815,1948700,1933865,1824146,1930577,1950256,1729604,1826193,1824908,1739062,1737555,1823821,1823467,1733212,1823188,15419107,1951232,1827242,1946065,1939045,1937692,1731471,1946746,1943137,2853529,2670885,27866430,1939308,1950128,1941538,1729000,1823886,1737654,2663894,2669983,12149352,1940590,1828934,1823239,1729848,1736996,1828920,1943201,1948321,46852469,1955200,1937824,1828194,3283074,1727824,1823090,31159141,15118655,1823539,1823444,1750886,1931105,1952542,1952501,1736889,1736773,1823171,1823715,1732918,1957306,35658710,1951927,1949676,43826963,1941684,7757553,1951749,1736723,1942686,1829408,1829900,1733016,1950062,1933433,1732017,1948522,1946671,1825179,1735424,16605043,1938936,1738871,1750841,9258388,1932213,1729176,1934723,1931758,1948234,1733811,1737602,1947843,1952062,1733186,1950753,1739660,1953112,1947958,1938666,1940948,44433919,1730727,1942813,1730586,41458409,1942484,1825713,1736055,1737274,1949501,1735975,23899160,1950174,1948260,1824813,1949818,31747387,1951675,1951313,1946806,1825448,1735710,1933088,1935963,3402151,1732862,29788089,29789889,1955273,1955738,1828133,1826136,1727855,1950224,1949421,1824854,31823031,1930481,1940920,1736624,1733775,1730694,1942503,33363840,1750647,1750909,1947355,1934294,1939951,1956007,1729645,5554733,1734285,1949028,1951695,21824738,1951116,1943586,1955377,1750679,1947198,1948414,1732456,1943973,1938764,1942388,1829510,1750628,8745860,1938100,1728417,1829717,1736675,1942441,1729443,1954488,1949573,1949477,1733826,1732231,1949004,1733379,1828510,1737009,1946582,1732419,1733491,1953997,1938835,1730031,1936689,1949614,1824253,1827876,1951622,1951065,1950811,29787925,1823037,1947435,1823052,29789564,1934349,1829458,1829617,1824952,1733120,1729120,1728765,1932776,1731437,1734343,1934672,1937469,1951414,1935741,1733471,1829164,37911918,1955046,1941268,1941039,29788817,1932526,11862006,43399592,29789987,1729762,1950095,1730546,1952204,1735385,1948401,1826556,1734194,1750860,1930778,1946470,1825519,1824494,1952040,1735985,1955415,1732645,1946839,1730657,1948827,8844791,1950333,1823959,1933801,1826175,1732163,15419098,1947387,1735857,1727813,1733895,1733744,1951986,1828062,1737234,25089373,1952660,1932470,1731875,1830434,1732250,1825677,1948646,1730704,1946098,1735575,1955017,1954696,1737173,1750798,33294335,1824605,1733314,1826326,1953156,1826473,1955094,1826686,2670355,1731048,1952424,1948977,1948065,1948486,21862384,1955624,11928644,6648868,1942414,1952996,1823376,1737668,1932966,1728547,1738191,1737436,1950703,1730858,1947615,1939806,1739120,1823654,1824347,1950988,1824068,1930954,1954921,1935804,1946548,1952143,1931440,1936218,1937978,1824363,15498026,1951458,8382758,1729389,1947728,39908198,29789097,1734240,1737844,1825302,1954353,1954391,50929972,48564332,1955956,2673689,2663247,1823597,2669577,1735734,1955476,4062830,1955508,2673848,1947373,22680304,50200137,41108210,31261223,2666152,2674009,1955705,1948291,1737665,1930447,1955197,2674013,1824745,1931251,47978187,50010802,1734569,41365379,40707373,1955042,27142048,42444600,1828221,31077191,30841045,1947283,1955322,41064007,1946779,1946951,8746207,22621551,1955268,19928947,1736761,1948687,2669496,27972191,9629647,1954471,1948303,1954940,9576144,1942274,31896277,41704397,48417638,1957280,4062912,22680307,49917837,2673903,27066893,1824754,1954551,9886762,2674018,11245625,2674170,1952166,1953092,2670158,1829206,1954889,13873463,22680295,27066902,35313684,1731831,41278917,1747740,39811619,40707377,1957212,1955727,43822465,22680313,26021709,1728156,1955952,1954995,2674068,4062806,47196812,1826683,23107117,42144620,2673648,18250396,1952340,4062709,30525605,41453473,1737589,22680298,27178461,1750906,4062757,22870909,1955685,1738782,21577455,22680310,33623528,17071511,1955319,31788832,2673541,2674021,2673544,2669164,47930787,1750052,1733355,1737642,1738986,3089986,25215728,29263800,1736862,1730951,1829134,2674165,2673915,4062921,1823127,1948900,4062700,1955919,1953810,2670780,9576135,27066899,1948108)  AND  dacco.o_published = 1   GROUP BY dacco.oo_id  ORDER BY  RAND(552)
Parameters: 
[]
View formatted query    View runnable query    Explain query
53.57 ms
(0.30%) 		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 (25984203,11618312,1950873,1954353,1952359,1827458,1932817,13770777,1830380,1733028,1825793,1954391,30205115,1735505,50929972,1728976,1933417,48564332,1948505,1946528,1955956,1736830,28929422,1936897,1950667,21984508,1951179,2663977,1739372,1824536,1953052,2673689,1827525,37868363,1823552,1947469,1739008,1931733,1946502,1731339,1829797,1829934,2663247,1738996,1730377,1750660,1947826,1949086,1954524,1823609,1952101,1735488,1823597,1950645,1827779,1943508,1954411,1737328,1828360,1728707,2669577,1735734,1955476,29819550,4062830,1937544,1735334,1934252,1739032,1955349,1955508,27947163,10374087,1936326,1734330,20962005,1941470,1954907,1729658,1955936,1953959,1825011,2664006,1731019,2673848,1947373,1733965,1942882,1732510,1730919,1954604,1940778,1955972,1830603,1737987,22680304,1943105,2670240,1942177,1829479,1948441,50200137,41108210,1949915,26306220,49874948,1738785,1826269,1733525,1937367,1728448,31261223,1949730,1733241,1737106,2664864,1828794,1827922,1954958,1734086,1828871,1931829,1828318,1932702,2666152,1949966,1941076,2674009,33905433,1947886,1955705,1730678,1948291,1952246,1826626,1737665,3238663,1930447,1955197,2674013,1749936,1824745,1729347,4062676,1730342,17364709,1947551,1735663,1828716,1935486,1825612,1732394,1940444,1933727,1948710,1931251,47978187,38290359,1955577,1953774,50010802,1734569,1947036,1943997,1827613,41365379,1954644,1728960,1729870,1957246,2670783,9629644,1730598,40707373,1955042,1948847,1946296,27142048,1729325,1943475,1738037,1939108,42444600,1947083,1828221,1938339,4442305,2670053,1734130,1943182,2669356,31077191,30841045,1739074,1948166,1947283,1943815,1948700,1933865,1824146,1930577,1955322,41064007,1950256,1729604,1946779,1826193,1824908,1739062,1737555,1946951,1823821,8746207,1823467,1733212,1823188,15419107,1951232,1827242,22621551,1946065,1939045,1937692,1731471,1946746,1943137,2853529,2670885,27866430,1939308,1955268,19928947,1950128,1941538,1729000,1823886,1736761,1737654,2663894,2669983,12149352,1948687,2669496,1940590,27972191,1828934,9629647,1823239,1729848,1954471,1736996,1828920,1943201,1948321,46852469,1955200,1948303,1937824,1828194,3283074,1954940,1727824,1823090,31159141,15118655,1823539,1823444,9576144,1750886,1942274,1931105,31896277,1952542,1952501,1736889,1736773,1823171,41704397,48417638,1823715,1732918,1957306,35658710,1951927,1949676,1957280,43826963,4062912,1941684,7757553,22680307,49917837,1951749,2673903,1736723,1942686,1829408,1829900,1733016,1950062,1933433,1732017,1948522,1946671,1825179,27066893,1735424,16605043,1938936,1824754,1738871,1750841,9258388,1932213,1729176,1934723,1954551,1931758,1948234,1733811,1737602,1947843,9886762,1952062,1733186,1950753,1739660,1953112,2674018,1947958,1938666,11245625,1940948,44433919,1730727,1942813,1730586,41458409,2674170,1942484,1825713,1736055,1737274,1949501,1735975,1952166,23899160,1950174,1948260,1824813,1953092,2670158,1829206,1949818,31747387,1951675,1954889,1951313,13873463,1946806,1825448,22680295,1735710,1933088,27066902,1935963,3402151,1732862,29788089,35313684,29789889,1955273,1955738,1828133,1731831,1826136,1727855,1950224,41278917,1949421,1824854,31823031,1930481,1940920,1736624,1733775,1730694,1747740,1942503,33363840,1750647,1750909,1947355,1934294,1939951,39811619,40707377,1956007,1729645,5554733,1734285,1949028,1951695,1957212,21824738,1951116,1943586,1955377,1750679,1947198,1948414,1732456,1943973,1938764,1942388,1955727,1829510,43822465,22680313,1750628,8745860,1938100,1728417,1829717,1736675,1942441,1729443,1954488,1949573,1949477,1733826,1732231,1949004,1733379,1828510,1737009,1946582,1732419,26021709,1733491,1953997,1938835,1730031,1936689,1728156,1955952,1949614,1954995,2674068,4062806,47196812,1824253,1827876,1951622,1951065,1950811,1826683,29787925,1823037,1947435,1823052,29789564,1934349,1829458,23107117,1829617,1824952,1733120,1729120,1728765,42144620,1932776,2673648,1731437,18250396,1734343,1934672,1937469,1952340,1951414,4062709,30525605,1935741,1733471,1829164,37911918,1955046,1941268,1941039,29788817,1932526,11862006,43399592,29789987,1729762,1950095,1730546,41453473,1952204,1735385,1948401,1737589,22680298,1826556,1734194,1750860,27178461,1750906,1930778,4062757,1946470,1825519,22870909,1955685,1738782,21577455,1824494,1952040,1735985,1955415,1732645,22680310,1946839,1730657,33623528,1948827,8844791,1950333,17071511,1823959,1955319,1933801,1826175,31788832,1732163,15419098,1947387,1735857,1727813,1733895,1733744,1951986,1828062,1737234,2673541,25089373,1952660,2674021,1932470,1731875,2673544,1830434,1732250,1825677,2669164,1948646,47930787,1730704,1946098,1750052,1733355,1735575,1955017,1954696,1737642,1737173,1750798,33294335,1738986,1824605,1733314,1826326,1953156,1826473,1955094,1826686,2670355,1731048,1952424,3089986,1948977,1948065,25215728,1948486,21862384,29263800,1955624,1736862,1730951,11928644,6648868,1942414,1952996,1829134,2674165,1823376,2673915,1737668,1932966,1728547,1738191,1737436,1950703,4062921,1730858,1823127,1947615,1939806,1739120,1823654,1948900,1824347,1950988,1824068,1930954,1954921,1935804,4062700,1946548,1952143,1931440,1936218,1937978,1955919,1824363,15498026,1951458,1953810,8382758,1729389,1947728,39908198,2670780,29789097,1734240,9576135,1737844,1825302,27066899,1948108)
                  
                   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
19.57 ms
(0.11%) 		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, 6807, 6838, 6824, 6826, 6817, 6816, 6832)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
18.24 ms
(0.10%) 		1 
SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (8006, 8127, 8045, 7556, 7319)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
6.97 ms
(0.04%) 		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 (11959, 11948, 11910, 11909, 11965, 11963, 11947, 11922, 11921, 11950, 11914, 11920, 11946, 11937, 29785444, 29785442))  GROUP BY dacco.oo_id  ORDER BY  RAND(552)
Parameters: 
[]
View formatted query    View runnable query    Explain query
4.73 ms
(0.03%) 		27 
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (2670783),(1935963),(29789564),(1827242),(39811619),(1946548),(1951414),(1941538),(1950062),(1730657),(1943475),(1827458),(1732510),(1736761),(1948710),(1727824),(1951675),(1948646),(21824738),(3283074),(1931251),(1738871),(1948321),(1952660),(29787925),(2669356),(30205115),(1733826),(1823539),(1942274),(41278917),(1932817),(1946582),(47930787),(1826326),(8844791),(1823609),(1950811),(3238663),(1729176),(1949818),(1949966),(1732394),(1823597),(1733355),(1824745),(9629644),(22680313),(1827876),(1938764),(33905433),(1736723),(1826473),(29263800),(1946746),(1955685),(1827525),(1739660),(1947283),(1735385),(1947728),(1736889),(1829900),(18250396),(1957246),(1953092),(1736055),(1952040),(1823654),(1829617),(1829934),(47196812),(1737589),(1952501),(1735857),(43826963),(1955017),(1828318),(1733120),(1930954),(1826683),(1942503),(1733895),(1729000),(1932966),(8382758),(1732163),(1955415),(1730342),(1728960),(1828062),(1954889),(1931440),(1950128),(1823090),(2670053),(1955476),(1955727),(1955094),(1949573),(20962005),(1948700),(1937544),(27066893),(46852469),(1938666),(1823239),(1943973),(1731339),(1952996),(1734569),(1937367),(26021709),(1730727),(1739062),(1737173),(1948900),(1946806),(1828716),(1732231),(1948977),(1950988),(1947198),(1951232),(1750798),(27066899),(1954958),(1933433),(2673848),(9886762),(1930447),(1733744),(13770777),(37911918),(1946296),(1750647),(1737274),(1950174),(1829164),(1933727),(1824363),(1942414),(1735505),(1947958),(1733314),(43822465),(9258388),(1736830),(1948847),(1952204),(1943137),(1729848),(1954644),(1951749),(21984508),(1950703),(1938339),(1948414),(1830380),(1826556),(1948687),(1735985),(4062921),(1947551),(1946671),(2674013),(1828133),(1727813),(1728448),(1931829),(1955936),(1737436),(1733491),(2673915),(1828920),(22680295),(2853529),(1948291),(1735488),(1947373),(1823127),(1954488),(1737665),(4442305),(1947083),(1953959),(2663247),(1955705),(1735575),(1955577),(1941039),(1750860),(19928947),(1823821),(11862006),(6648868),(1947435),(17071511),(1951986),(1939951),(1950256),(1829510),(1948486),(27972191),(1733016),(4062757),(1943815),(1940920),(1823715),(1749936),(4062912),(1939045),(2663977),(1826193),(1730704),(1825713),(43399592),(30525605),(1946528),(2669496),(2674165),(1954471),(1953112),(1729347),(4062709),(1955508),(1737234),(1955952),(2673541),(1954524),(1829408),(2666152),(27178461),(1955042),(1727855),(1939108),(1738782),(1750628),(1733811),(1947826),(1941470),(16605043),(1947615),(1954696),(1936897),(1949028),(1737555),(1825793),(1733212),(1827613),(1739008),(1949004),(1955624),(15118655),(1937978),(1829206),(13873463),(1953156),(1947036),(17364709),(1828510),(1734240),(1825519),(1732645),(1948108),(1826269),(1826175),(1948065),(1824952),(1955197),(1950667),(1737602),(40707377),(40707373),(1738996),(1738785),(1825677),(1937824),(1737844),(1938936),(1730586),(1932470),(1750909),(31896277),(25984203),(1932213),(2674018),(1957280),(1955046),(1823552),(2670158),(2674021),(31823031),(1933088),(1738191),(1955349),(1949477),(1949915),(1730598),(27066902),(1951695),(1729604),(21862384),(4062700),(1942686),(1733965),(1736675),(1824068),(1954411),(1942441),(1823376),(1824854),(1934723),(1951065),(1728417),(1952166),(1827922),(1950873),(11928644),(1731831),(1823052),(9629647),(1935741),(33623528),(1730694),(29788817),(1823886),(41453473),(1933801),(10374087),(1953997),(1935804),(1954921),(1824253),(1728707),(1955377),(1733471),(1737654),(1934349),(1955319),(1943201),(1737106),(1739372),(23899160),(1732250),(35658710),(1948260),(27866430),(12149352),(1940590),(41365379),(1947843),(1949421),(26306220),(1750886),(31747387),(1828221),(30841045),(1936218),(4062806),(1942882),(2669577),(1736862),(1951622),(1734130),(1952359),(1947886),(1730546),(48564332),(2673903),(50200137),(1829458),(1930577),(1946951),(1729389),(1943508),(1734285),(27947163),(1937692),(22870909),(1940778),(1824146),(1950224),(1954907),(1737987),(1731471),(1733775),(1823959),(1955322),(2673648),(1824605),(1825179),(7757553),(1952062),(1954604),(1948441),(2674009),(1931733),(1733028),(1941268),(1735734),(22680310),(31788832),(1931758),(2669164),(29819550),(1947387),(1829717),(1824754),(5554733),(15419107),(1730031),(1947469),(1954353),(1955200),(1930481),(1949614),(1948522),(2670355),(1824536),(2663894),(1953810),(1734343),(1949730),(1738037),(1955273),(1732918),(1827779),(25089373),(23107117),(1731875),(1729658),(22680307),(1730951),(1948827),(1739032),(4062676),(1729870),(2670885),(1731048),(1826686),(1954391),(1733241),(1952542),(1734330),(1931105),(25215728),(1828794),(1934252),(1957212),(1938100),(1940444),(1946779),(31261223),(29789987),(29789097),(1946470),(48417638),(1825302),(8746207),(1825448),(50010802),(1952101),(1949501),(1936326),(1949676),(1942484),(1730678),(1728156),(1735424),(1948505),(1951313),(1932776),(1729325),(2664864),(1735975),(1952143),(1953052),(38290359),(31077191),(1955972),(2673544),(1952246),(1731019),(1949086),(1937469),(1828934),(1954995),(1954940),(49874948),(1951179),(2664006),(1824347),(50929972),(1733186),(27142048),(1733379),(1737642),(37868363),(1736624),(15419098),(1823037),(2669983),(1946098),(1735663),(1824908),(1948303),(1825011),(1950333),(1956007),(3089986),(1943105),(2670780),(1830603),(1823188),(1948234),(1942177),(33363840),(1737009),(1829797),(1730377),(2670240),(4062830),(1733525),(2673689),(22621551),(1934672),(28929422),(1948166),(1939308),(1829479),(1951927),(1943586),(1750906),(1729645),(42444600),(8745860),(1736996),(1734194),(1732017),(1731437),(33294335),(1946839),(1739120),(1932526),(1732419),(41064007),(1933865),(1951116),(1729443),(1932702),(1950095),(1729762),(1943182),(1940948),(15498026),(1737668),(1728547),(2674170),(1824494),(1730919),(1736773),(1828871),(1828194),(1750052),(1739074),(1824813),(1948401),(1823444),(1942388),(1730858),(1943997),(41458409),(1946065),(1829134),(1946502),(1955738),(1729120),(39908198),(1941076),(22680304),(11245625),(1936689),(21577455),(44433919),(1732456),(1830434),(1738986),(1728976),(42144620),(41704397),(1955268),(41108210),(1947355),(1934294),(1826136),(1933417),(1750660),(1951458),(1735334),(1823171),(1747740),(29788089),(1957306),(1728765),(1825612),(9576135),(1954551),(1823467),(1938835),(22680298),(2674068),(29789889),(1939806),(1950645),(1828360),(1952340),(1955956),(3402151),(35313684),(1950753),(1952424),(1953774),(1930778),(1941684),(1750841),(31159141),(1826626),(1737328),(1732862),(9576144),(47978187),(1955919),(49917837),(1735710),(1935486),(1750679),(1942813),(1734086),(11618312)
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.57 ms
(0.01%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11959, 11948, 11910, 11909, 11965, 11963, 11947, 11922, 11921, 11950, 11914, 11920, 11946, 11937)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.34 ms
(0.01%) 		1 
SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9616, 9655, 9691, 9707, 9669, 23413274)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.11 ms
(0.01%) 		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.90 ms
(0.01%) 		27 
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.60 ms
(0.01%) 		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
1.04 ms
(0.01%) 		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.88 ms
(0.00%) 		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.68 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11950)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.63 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11946)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.60 ms
(0.00%) 		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.59 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11963)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.51 ms
(0.00%) 		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.47 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11909)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.46 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11948)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.43 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11914)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.41 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11959)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.41 ms
(0.00%) 		2 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (29785444, 29785442)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.40 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11920)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.39 ms
(0.00%) 		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.34 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11910)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.32 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11947)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.31 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11921)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.31 ms
(0.00%) 		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.30 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11922)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.29 ms
(0.00%) 		1 
SELECT  count(DISTINCT src_id) as accoCount
                                  FROM `steiermark`.object_relations_8 daccorel
                                 WHERE
                                    dest_id IN (11937)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.28 ms
(0.00%) 		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.