https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?_=1726272000000&nearbySearchId=854095&nearbySearchLat=47.67982&nearbySearchLong=15.61216&randSeed=1000

Method
GET
HTTP Status
200
IP
66.249.72.162
Profiled on
Token
a4c434

Query Metrics

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

Grouped Statements

Show all queries

default connection

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