https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?_=1726272000000&nearbySearchId=324412&nearbySearchLat=47.18277&nearbySearchLong=14.01992&randSeed=904

Method
GET
HTTP Status
200
IP
66.249.72.162
Profiled on
Token
b7808b

Query Metrics

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

Grouped Statements

Show all queries

default connection

Time▼ Count Info
1.46 ms
(0.01%) 		11 
SELECT name FROM classes WHERE id = ?
Parameters: 
[
  "SiteConfig"
]
View formatted query    View runnable query    Explain query
1.17 ms
(0.01%) 		4 
SELECT * FROM documents_editables WHERE documentId = ?
Parameters: 
[
  9789
]
View formatted query    View runnable query    Explain query
0.75 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=904&nearbySearchId=324412&nearbySearchLat=47.18277&nearbySearchLong=14.01992&_=1726272000000"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?_=1726272000000&nearbySearchId=324412&nearbySearchLat=47.18277&nearbySearchLong=14.01992&randSeed=904"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
View formatted query    View runnable query    Explain query
0.49 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.28 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%) 		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.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.17 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.14 ms
(0.00%) 		2 
SELECT * FROM website_settings WHERE id = ?
Parameters: 
[
  1
]
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

demi_vacancies connection

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