https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation/bubbles?_=1728864000000&nearbySearchId=854426&nearbySearchLat=47.108&nearbySearchLong=14.4569&randSeed=614

Method
GET
HTTP Status
200
IP
66.249.79.1
Profiled on
Token
197c74

Query Metrics

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

Grouped Statements

Show all queries

default connection

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

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

             group by dest_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.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.00 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.75 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.14 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.96 ms
(0.00%) 		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.82 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 (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 (11950)
                                    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 (11963)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.50 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 (11946)
                                    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 (9939)
                        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.42 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.42 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 (11910)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.33 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.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.31 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.28 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 (11914)
                                    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 (11921)
                                    AND
                                        src_id IN
                                          (select id from `steiermark`.accoIdsTowns)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.24 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.16 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.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

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.