Query Metrics
89
Database Queries
30
Different statements
240.15 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.00 ms (0.42%) |
11 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
|
0.49 ms (0.21%) |
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/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles" "sourcePathQuery" => "/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles?randSeed=322&_=1736640000000" "sourceEntireUri" => "https://stage.steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles?_=1736640000000&randSeed=322" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.47 ms (0.20%) |
2 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
9975
]
|
|
0.38 ms (0.16%) |
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 ] |
|
0.25 ms (0.10%) |
1 |
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:
[
11462
]
|
|
0.22 ms (0.09%) |
2 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "bubbles" "path" => "/steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/" ] |
|
0.15 ms (0.06%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
|
0.14 ms (0.06%) |
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/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles" ] |
|
0.13 ms (0.05%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.12 ms (0.05%) |
1 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
0.10 ms (0.04%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book/bubbles" ] |
demi_vacancies connection
| Time▼ | Count | Info |
|---|---|---|
|
128.07 ms (53.33%) |
16 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (18776659,7453044,2457632,3213244,31116285,39952681,7453058,8924349,1613127,32043296,1821791,4063709,1616414,18777644,7452925,18776417,1907399,1821779,31116306,7453030,13734739,48320437,2310556,27961045,2194150,1616483,7453176,2458339,32043299,47840451,18743289,2459254,1616103,4062128,7453169,18776174,2456226,1907248,1906561,11825924,2529904,2458779,1613214,1905927,47650472,18776567,21905908,16192461,47698722,7453183,18743447,18778011,1905902,7449751,7453114,19763596,1614803,7453218,2418919,1614713,2530025,14957863,2456499,11106490,1930178,7452946,1615749,2456895,2404244,18777967,40935234,2456108,2456739,2368223,2457187,31116608,7452918,32662482,2454304,1907111,18776639,7453107,2310269,1614785,2194032,2458035,18777655,1616081,2456321,1906263,1821748,47698731,1906079,18777978,2457463,18777677,2457665,7453065,18778000,1905966,2529883,1615279,2530049,18743300,9566396,1612687,18777721,12771836,2458981,18777688,1615125,38973570,1907362,1821868,1615080,1906916,31159117,18777710,1615005,7453225,2457137,2457844,17197373,7453197,7453204,7452967,1905939,27998615,2457450,2458412,18411811,1614854,7453037,18743311,18777666,31439157,2530034,7453135,7452960,1821963,2455688,7452890,1615966,27167031,1615580,41003922,13169002,1616174,18776406,1702924,22817521,1906621,31116495,1906838,39249742,1821596,2457556,34613565,1612895,1614871,47650481,18743469,1821641,6342564,2454629,1615190,30806616,27858937,1906696,7453002,2458503,15221891,2456405,7453051,12736708,7452995,1905995,2459142,2456727,2829775,1905888,7453128,18743458,34043087,2310272,2457383,2454119,2458073,1930330,1612739,31116045,21285943,7452953,2458228,1616447,1906454,18777956,6645761,7452876,2458180,7452883,9684290,35677466,2458151,7453072,45582974,1615164,1612643,30629016,46121793,1615308,18755389,1615601,1615872,39976679,1616259,44079175,7453079,16993556,1612971,31116650,2453987,1616323,7453016,9566387,7452988,1906343,30192336,2194142,7452974,41643929,1930243,4063767,2309430,2457650,1821686,7162763,18777989,19763638,11644081,18743480,18776428,2457153,46648161,45886154,7452939,1612986,3121111,10223870,19763617,44735018,7453211,18777699,1906356,31116629,1615234,12578470,50062232,2456969,1616614,6342567,1616557,1906002,1906009,1616423,2459068,26147003,4062325,2455657,25114536,1906028,2456436,1616225,2404275,1702996,1612964,50330123,50660470,2529898,4062249,2457960,15028571,2104791,1612870,2456765,1616249,2457393,12785402,1616374,1614837,11993543,12141175,35259362,1821772,2454613,11993491,12578480,2458323,51238225,48753192,1613013,1615743,1907420,1616159,1615674,29827678,13415036,3032193,43139185,9490401,1612950,1821899,2368235,1906202,2309712,2458389,1906035,1616514,7453009,40649956,1612780,2457171,1615773,2454032,1614910,40480657,2453876,1703009,1614778,1612635,11993553,2194164,40480654,1616498,19739002,32203081,2458552,2309544,1906873,1615509,16463906,6775712,38702048,1612993,1614616,1905920,49758724,2104865,29699643,1616477,1615985,11993564,2104851,3259747,1615295,39621948,34595469,2458788,2457692,1616053,2530028,2457241,2454097,2458159,2530031,2104811,42339673,1821716,1930304,1906719,1614830,1906635,1616360,2457950,1930130,1615272,1612831,1616459,1615202,2310347,1821730,45468398,2458424,1612889,1906189,1616197,1822005,2457980,1612855,7452869,9735393,16552093,1615503,2458331,2458294,1907413,1906852,1616064,31569228,29850681,2456579,1616601,1616117,1612937,44781292,1821635,32356610,1616507,1906766,12076233,1906052,2310359,1822022,1615695,1821861,2454173,14055216,1703035,18094541,2453840,2104688,27961048,1906249,23827352,1615619,2458275,1906788,2457291,1612807,4062044,48208705,1612621,2457417,1614903,1612655,2104901,2458404,1615178,24874128,2456271,2455301,1906901,49522274,1615663,2458315,27858940,2457782,1615991,2458533,1613183,1615738,1906305,1906747,51735516,1906328,2457536,1615997,2529880,15115425,13468069,1821762,7452932,2059036,18861848,15136325,2459044,25851748,1930324,1930161,1612675,2457118,2308760,2455815,1616381,11993576,51333826,1821849,2458065,1615533,4442120,2458255,2104824,2457968,2458128,2456775,9490392,4704521,1615228,2454904,8924340,2455138,1821737,1822030,2454764,1821698,49289508,1930168,27090024,1821814,2455620,1906119,2457804,2455321,2455960,1906044,1612661,4090781,6208703,1612876,2194020,1821979,32356605,1614918,1612861,1930118,7453121,42085312,1906432,2104401,1613053,2458566,1612882,1821807,1615547,1821723,2456747,1821836,1615522,2458026,2457442,49619462,12141191,2454461,2454859,4062035,49723102,1906073,1612667,4063718,1612786,7453190,9159056,2308773,46703369,50613474,1907143,50330126,1616296,1930310,1907427,1615731,2529886,2104878,2453896,1821955,1612628,1906209,15187823,2454738,2104885,1821629,1907049,1821623,1821692,1822011,1612819,2454161,2454264,2453569,44760927,1616532,20926241,1702984,2457214,4820748,24109335,2454928,1821580,1906546,24629767,1612798,1702930,1612792,45911208,18541017,7453023,1612615,2457195,30192347,4062193,2104833,1906418,2457931,2457621,1616440,13205136,46837228,45167318,2457353,2457048,1616313,2458381,2104858,2309376,1616351,9108294,1906508,1905954,1616205,2530046,1906795,1906171,1821740,2455156,2455852,1614767,4062004,2104726,50062229,34613539,1615159,1615196,1906816,1906859,1616284,15136578,2457774,1906601,46904062,25076569,1906802,1616235,2310457,1613190,1821823,1616087,1616336,1616585,12176479,40066879,2453808,1615208,4062000,2458357,2458372,1906297,8776246,1906157,2104798,11993589,40066871,2458171,6645739,2457590,2458494,2458008,2457745,32996115,1616047,2458107,1615680,2458056,32396816,9651389,4062019,42766841,1821893,1906066,9238291,2459391,2455032,1906112,1821680,1615721,4062067,2456978,7576136,2457105,1613197,2457179,1614843,38954139,12665315,4149203,6995557,22968535,1613120,2457544,2104698,1616367,1702966,48319918,37260090,2458220,2453674,18721781,1906059,1613038,4062032,1906196,15154165,12076227,1907004,1907329,41643953,10990613,12212021,2457275,1906021,1612928,50330129,1616142) AND dacco.o_published = 1 AND (dacco.town__id IN (11465, 11466, 11464, 11463, 1612603)) GROUP BY dacco.oo_id ORDER BY RAND(322)
Parameters:
[] |
|
71.56 ms (29.80%) |
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 (4062325,18776659,7453044,2455657,2457632,25114536,3213244,1906028,2456436,1616225,2404275,31116285,1702996,1612964,50330123,50660470,2529898,4062249,39952681,2457960,15028571,7453058,2104791,1612870,2456765,8924349,1616249,1613127,32043296,1821791,2457393,12785402,1616374,4063709,1614837,1616414,18777644,7452925,11993543,12141175,35259362,1821772,2454613,11993491,12578480,2458323,18776417,51238225,48753192,1613013,1615743,1907420,1616159,1615674,29827678,1907399,13415036,3032193,43139185,9490401,1612950,1821899,2368235,1821779,1906202,2309712,2458389,1906035,1616514,7453009,40649956,31116306,1612780,7453030,2457171,1615773,13734739,2454032,1614910,40480657,2453876,48320437,2310556,1703009,27961045,2194150,1616483,1614778,1612635,11993553,2194164,7453176,40480654,2458339,1616498,19739002,32043299,47840451,32203081,2458552,2309544,1906873,18743289,2459254,1616103,1615509,16463906,4062128,6775712,7453169,18776174,38702048,1612993,1614616,2456226,1905920,1907248,49758724,2104865,1906561,29699643,1616477,1615985,11993564,2104851,3259747,11825924,2529904,1615295,2458779,39621948,34595469,1613214,1905927,2458788,2457692,1616053,2530028,2457241,47650472,18776567,21905908,16192461,47698722,7453183,2454097,2458159,18743447,18778011,2530031,1905902,2104811,42339673,7449751,1821716,7453114,1930304,1906719,1614830,1906635,1616360,19763596,2457950,1614803,7453218,1930130,1615272,1612831,1616459,1615202,2418919,2310347,1821730,45468398,1614713,2458424,1612889,2530025,1906189,1616197,1822005,2457980,14957863,1612855,2456499,11106490,7452869,9735393,16552093,1930178,1615503,2458331,2458294,7452946,1907413,1615749,1906852,2456895,1616064,2404244,31569228,29850681,2456579,18777967,40935234,1616601,2456108,1616117,2456739,1612937,2368223,44781292,2457187,1821635,32356610,1616507,1906766,31116608,12076233,7452918,1906052,2310359,32662482,1822022,2454304,1907111,1615695,1821861,18776639,7453107,2454173,2310269,14055216,1614785,1703035,18094541,2194032,2453840,2458035,2104688,27961048,1906249,23827352,1615619,18777655,2458275,1616081,1906788,2457291,2456321,1906263,1612807,1821748,4062044,47698731,1906079,18777978,48208705,1612621,2457417,1614903,1612655,2104901,2457463,2458404,1615178,18777677,24874128,2457665,2456271,2455301,7453065,18778000,1905966,1906901,2529883,49522274,1615663,1615279,2458315,27858940,2530049,2457782,1615991,18743300,2458533,1613183,1615738,9566396,1906305,1612687,1906747,18777721,51735516,12771836,2458981,1906328,18777688,2457536,1615125,1615997,38973570,1907362,1821868,1615080,2529880,15115425,13468069,1906916,1821762,7452932,2059036,18861848,31159117,15136325,18777710,2459044,25851748,1615005,1930324,1930161,7453225,1612675,2457137,2457118,2308760,2455815,1616381,11993576,2457844,17197373,7453197,7453204,7452967,51333826,1821849,1905939,2458065,27998615,2457450,2458412,18411811,1615533,4442120,2458255,1614854,2104824,7453037,18743311,18777666,2457968,31439157,2458128,2530034,7453135,2456775,9490392,7452960,1821963,4704521,2455688,7452890,1615228,2454904,1615966,8924340,2455138,27167031,1615580,1821737,41003922,13169002,1822030,2454764,1821698,49289508,1616174,1930168,27090024,1821814,18776406,2455620,1702924,1906119,22817521,2457804,2455321,2455960,1906044,1906621,31116495,1906838,39249742,1612661,1821596,4090781,6208703,1612876,2194020,2457556,1821979,32356605,34613565,1612895,1614871,1614918,47650481,18743469,1612861,1821641,1930118,6342564,7453121,42085312,1906432,2104401,1613053,2458566,2454629,1612882,1615190,30806616,1821807,1615547,1821723,27858937,2456747,1821836,1906696,1615522,2458026,7453002,2457442,49619462,2458503,12141191,2454461,2454859,4062035,15221891,2456405,49723102,1906073,1612667,7453051,4063718,1612786,12736708,7453190,7452995,9159056,1905995,2308773,46703369,50613474,2459142,1907143,50330126,1616296,1930310,1907427,1615731,2456727,2529886,2104878,2829775,1905888,2453896,7453128,1821955,18743458,1612628,1906209,15187823,34043087,2310272,2454738,2104885,2457383,1821629,1907049,1821623,1821692,2454119,1822011,1612819,2454161,2458073,2454264,2453569,44760927,1930330,1616532,20926241,1612739,1702984,31116045,21285943,7452953,2457214,4820748,2458228,24109335,2454928,1821580,1906546,1616447,24629767,1612798,1906454,18777956,1702930,6645761,1612792,7452876,45911208,18541017,7453023,1612615,2458180,2457195,30192347,4062193,2104833,1906418,2457931,7452883,9684290,2457621,35677466,1616440,13205136,2458151,46837228,45167318,2457353,7453072,2457048,1616313,2458381,45582974,2104858,2309376,1616351,1615164,1612643,9108294,1906508,1905954,1616205,30629016,46121793,1615308,2530046,18755389,1906795,1615601,1906171,1821740,2455156,1615872,2455852,1614767,4062004,2104726,50062229,39976679,1616259,44079175,7453079,34613539,1615159,1615196,16993556,1612971,1906816,1906859,1616284,15136578,2457774,31116650,2453987,1616323,1906601,46904062,7453016,25076569,1906802,1616235,2310457,1613190,9566387,1821823,7452988,1906343,30192336,1616087,1616336,1616585,2194142,12176479,40066879,7452974,2453808,1615208,4062000,41643929,2458357,2458372,1930243,1906297,8776246,4063767,1906157,2104798,11993589,40066871,2458171,6645739,2457590,2458494,2458008,2457745,2309430,2457650,1821686,32996115,7162763,1616047,18777989,19763638,11644081,18743480,2458107,1615680,18776428,2457153,2458056,32396816,46648161,9651389,4062019,45886154,42766841,1821893,1906066,9238291,2459391,2455032,7452939,1612986,1906112,3121111,1821680,10223870,1615721,4062067,2456978,7576136,19763617,44735018,7453211,18777699,2457105,1613197,2457179,1614843,1906356,38954139,12665315,4149203,6995557,31116629,1615234,22968535,12578470,50062232,2456969,1613120,2457544,1616614,2104698,6342567,1616367,1702966,48319918,37260090,2458220,2453674,1616557,1906002,18721781,1906059,1613038,4062032,1906196,1906009,15154165,12076227,1907004,1907329,41643953,10990613,12212021,2457275,1616423,2459068,1906021,1612928,50330129,26147003,1616142) 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:
[] |
|
19.64 ms (8.18%) |
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, 12662, 6814, 6807, 6838, 6824, 6826, 6817, 6816, 6819, 6832, 6820) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id
Parameters:
[] |
|
5.89 ms (2.45%) |
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 (11465, 11466, 11464, 11463, 1612603)) GROUP BY dacco.oo_id ORDER BY RAND(322)
Parameters:
[] |
|
2.11 ms (0.88%) |
1 |
SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11465, 11466, 11464, 11463, 1612603) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id
Parameters:
[] |
|
1.96 ms (0.82%) |
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:
[] |
|
1.60 ms (0.67%) |
16 |
create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (7453197),(43139185),(1907362),(1906249),(4062004),(2458128),(7453135),(1614854),(2457153),(17197373),(27858940),(47698731),(2455815),(1616087),(14055216),(15028571),(7453058),(7453190),(1615966),(4063718),(2104698),(1907413),(21285943),(1612870),(2457241),(1930178),(18411811),(1616225),(11993553),(2529886),(2457774),(9490401),(18755389),(30806616),(2453896),(18776406),(44079175),(1906788),(34613539),(9108294),(12141175),(1616498),(1906052),(34595469),(38973570),(7452925),(41643953),(2453840),(2418919),(1616159),(2458566),(1821814),(16192461),(2455657),(47650481),(1821791),(9566387),(1615509),(49619462),(34043087),(1616081),(2530025),(1822022),(1616507),(1615208),(1821979),(7452967),(1614871),(18777677),(1907049),(12578470),(47840451),(1612780),(1907248),(2457536),(2458788),(1615680),(1905966),(2454161),(2310556),(1905927),(51333826),(1822005),(2455852),(2194164),(27090024),(18777644),(1616336),(1612635),(34613565),(27167031),(31569228),(2310457),(7452939),(18777655),(1615738),(11993564),(1616053),(2309544),(7453023),(1821963),(1821698),(39952681),(30192347),(15154165),(2458331),(2458065),(2457950),(1906561),(31439157),(41003922),(2310272),(1616142),(1616296),(2457048),(1614616),(1821762),(13734739),(24874128),(1702930),(11993491),(18776659),(2459068),(8924349),(24109335),(7453169),(2458026),(1615503),(2455301),(27961048),(2310359),(49289508),(1616284),(1614713),(27998615),(4062035),(2529880),(7453072),(2457632),(50330129),(42339673),(2458073),(2458056),(50660470),(32043296),(1905995),(6775712),(40066879),(46904062),(7453079),(1613214),(22817521),(2368223),(1906621),(1616414),(31159117),(2456579),(1703035),(1616367),(1702996),(18743469),(2104865),(4063709),(1616360),(32396816),(2530031),(2455138),(1612831),(18776639),(2454859),(27961045),(2456895),(1616440),(12785402),(1616313),(7452995),(1612889),(7453065),(1615196),(16552093),(18778011),(4090781),(2104688),(1612855),(2457171),(1930324),(1906635),(8924340),(2104811),(2530034),(2455620),(7452932),(7452890),(1906816),(1821807),(2458779),(1821686),(2457291),(15115425),(27858937),(2309430),(2308773),(2457179),(46121793),(2458228),(18777721),(1906343),(15187823),(2457195),(1612937),(1822011),(49758724),(2457556),(1613053),(11993589),(18777666),(1821596),(48319918),(38702048),(1906766),(1614910),(2456969),(2458220),(2530028),(1906035),(1821740),(2458494),(2529898),(42766841),(31116650),(1906021),(2456765),(9566396),(1616351),(2529883),(9651389),(2456747),(1905920),(4704521),(19763617),(2308760),(1616514),(2194032),(2458404),(44735018),(7452883),(15136325),(1821623),(2457665),(2457118),(1616532),(1612807),(1616477),(1906432),(51238225),(1615125),(46648161),(2404275),(1612621),(2457782),(2454119),(1612655),(25851748),(2829775),(7452974),(2454629),(44781292),(9735393),(4062032),(2457105),(1906196),(1907420),(46837228),(1614785),(1821716),(7453044),(2453569),(2458412),(2455156),(7452918),(11825924),(7453121),(4062128),(2459142),(39976679),(7453016),(1616235),(2458552),(8776246),(1615272),(1612687),(1821580),(45886154),(2458323),(9490392),(29699643),(1615279),(45167318),(3032193),(2454304),(2459254),(12176479),(1821779),(2529904),(2454264),(7453037),(2104726),(2104401),(1821723),(1616483),(1906795),(1821849),(2104858),(2309376),(1615695),(45582974),(29827678),(2194150),(1616374),(2456739),(2456436),(32662482),(1612675),(2457450),(2457442),(1821868),(1906297),(18776174),(35259362),(4062249),(2104824),(32203081),(32356605),(1906859),(2453876),(2456321),(1614767),(6208703),(2458159),(2530049),(7452988),(2104833),(2458357),(2457960),(7452876),(2454032),(22968535),(1907329),(40066871),(44760927),(4063767),(1615749),(6645739),(7453107),(1930161),(2457275),(32996115),(1906852),(18777989),(31116306),(1906263),(1906747),(2454928),(1906112),(2459044),(1930168),(1906171),(2458151),(2458381),(1616447),(2458255),(1615663),(19739002),(1906073),(1616381),(1616064),(16463906),(2456499),(11106490),(2456108),(41643929),(1906209),(1612950),(1615164),(2458107),(4062193),(1906202),(1906328),(1614903),(1702984),(48208705),(1821680),(49522274),(1612661),(1612993),(1906508),(7453218),(1612876),(1821861),(3213244),(18778000),(11993576),(12076233),(1612895),(2454097),(2454173),(50613474),(40480657),(1612861),(1613120),(2456405),(1615533),(1930118),(12665315),(1616585),(19763596),(1616197),(7453030),(1906059),(1612882),(2454738),(1615743),(2455960),(2458372),(1616423),(11644081),(2457214),(2456271),(1703009),(2458339),(4442120),(1907004),(2457804),(51735516),(7453009),(38954139),(1906044),(1906079),(1906418),(39249742),(2457137),(13468069),(1615080),(1612667),(1907399),(31116045),(1612786),(2059036),(32043299),(1906916),(1930304),(1614803),(1821893),(50330123),(14957863),(30192336),(1821748),(2453674),(18743289),(2456727),(1821823),(2458533),(2457187),(7453051),(25076569),(7453128),(1613197),(1905939),(1930130),(18777978),(40480654),(1612628),(1615228),(2104798),(1615773),(2456775),(1906066),(25114536),(2457745),(1613038),(1821737),(1613013),(1613190),(1906002),(18861848),(1612819),(1906009),(6342564),(1906028),(1822030),(2458275),(2530046),(18777688),(2104901),(1612739),(2455688),(47698722),(2194020),(1906838),(2457621),(7453211),(7452869),(9684290),(1906119),(1612986),(1702924),(18776567),(2194142),(1612798),(1616601),(45911208),(1612964),(7453225),(1612792),(1906696),(2368235),(1615731),(1907143),(1612615),(7162763),(2457590),(11993543),(7453183),(23827352),(1616557),(4062325),(1906719),(1615601),(4062000),(12141191),(18776428),(1615674),(6645761),(13205136),(50062229),(2457692),(1907427),(2457393),(18743300),(7452960),(1616047),(24629767),(1821899),(18743458),(2454613),(1612643),(1930243),(1616614),(1614778),(16993556),(2458180),(50062232),(2455321),(7453114),(40935234),(1821629),(2458389),(1615190),(1616459),(1906189),(2458981),(1906305),(1616323),(2457931),(20926241),(2458294),(1615985),(18541017),(12771836),(31116629),(1615872),(2454461),(2454764),(39621948),(1616103),(1821641),(1821692),(18721781),(1615721),(4062067),(48753192),(1905954),(18743311),(1702966),(50330126),(1907111),(10223870),(1821635),(18094541),(2456978),(1616249),(1930310),(2456226),(1906901),(1615295),(2458171),(15136578),(18743447),(18777710),(26147003),(9159056),(1615991),(1906873),(1905902),(2454904),(7453176),(1615997),(7452946),(7452953),(1821836),(1615234),(2457968),(31116285),(1615178),(21905908),(35677466),(12212021),(6995557),(31116495),(3259747),(7453002),(4149203),(4062044),(1821955),(4062019),(1613183),(2309712),(31116608),(2459391),(46703369),(2104885),(1930330),(40649956),(6342567),(2458424),(42085312),(2457463),(4820748),(12076227),(2404244),(1615580),(1906356),(13169002),(12736708),(18777967),(1615005),(7576136),(30629016),(1906157),(1906802),(1616117),(1615159),(2457844),(1613127),(2457980),(2458503),(1906454),(2457383),(1615547),(2104878),(49723102),(32356610),(45468398),(2457417),(1616259),(2457544),(2453987),(1615308),(2310347),(1615619),(7453204),(1906601),(48320437),(2455032),(47650472),(2458035),(2458315),(2457353),(1616205),(3121111),(18777956),(19763638),(1906546),(18743480),(1612971),(13415036),(2310269),(7449751),(1905888),(18777699),(1614830),(2104851),(1614918),(1616174),(1615522),(1615202),(1614837),(2104791),(37260090),(1821730),(1821772),(12578480),(2458008),(9238291),(2457650),(18776417),(29850681),(1614843),(1612928),(2453808),(10990613),(15221891)
Parameters:
[] |
|
1.09 ms (0.45%) |
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:
[] |
|
0.94 ms (0.39%) |
16 |
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[] |
|
0.79 ms (0.33%) |
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:
[] |
|
0.70 ms (0.29%) |
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:
[] |
|
0.50 ms (0.21%) |
1 |
SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11311, 9619) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id
Parameters:
[] |
|
0.39 ms (0.16%) |
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:
[] |
|
0.36 ms (0.15%) |
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:
[] |
|
0.32 ms (0.13%) |
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:
[] |
|
0.21 ms (0.09%) |
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:
[] |
|
0.20 ms (0.08%) |
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:
[] |
|
0.19 ms (0.08%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (9941) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
|
0.16 ms (0.07%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (6868) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
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.