https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?_=1728864000000&nearbySearchId=324603&nearbySearchLat=47.62187&nearbySearchLong=13.82845&randSeed=622

Method
GET
HTTP Status
200
IP
66.249.66.7
Profiled on
Token
d603d5

Query Metrics

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

Grouped Statements

Show all queries

default connection

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

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.