https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?_=1731456000000&nearbySearchId=324853&nearbySearchLat=47.43205&nearbySearchLong=13.71834&randSeed=223

Method
GET
HTTP Status
200
IP
66.249.66.6
Profiled on
Token
5e72c5

Query Metrics

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

Grouped Statements

Show all queries

default connection

Time▼ Count Info
1.31 ms
(0.01%) 		11 
SELECT name FROM classes WHERE id = ?
Parameters: 
[
  "SiteConfig"
]
View formatted query    View runnable query    Explain query
1.05 ms
(0.01%) 		4 
SELECT * FROM documents_editables WHERE documentId = ?
Parameters: 
[
  9789
]
View formatted query    View runnable query    Explain query
1.02 ms
(0.01%) 		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.80 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.60 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=223&nearbySearchId=324853&nearbySearchLat=47.43205&nearbySearchLong=13.71834&_=1731456000000"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?_=1731456000000&nearbySearchId=324853&nearbySearchLat=47.43205&nearbySearchLong=13.71834&randSeed=223"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
View formatted query    View runnable query    Explain query
0.25 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.17 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
0.16 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.12 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

demi_vacancies connection

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

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.