Query Metrics
160
Database Queries
50
Different statements
3447.18 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
1.13 ms (0.03%) |
9 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
0.46 ms (0.01%) |
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.36 ms (0.01%) |
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/Murtal/Plan-Holiday/Room-Categories/Hotels/bubbles" "sourcePathQuery" => "/en/Murtal/Plan-Holiday/Room-Categories/Hotels/bubbles?randSeed=952" "sourceEntireUri" => "https://stage.steiermark.com/en/Murtal/Plan-Holiday/Room-Categories/Hotels/bubbles?randSeed=952" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
0.26 ms (0.01%) |
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:
[
11886
]
|
0.25 ms (0.01%) |
2 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
34013
]
|
0.20 ms (0.01%) |
2 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "bubbles" "path" => "/steiermark.com/en/Murtal/Plan-Holiday/Room-Categories/Hotels/" ] |
0.16 ms (0.00%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
0.13 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/Murtal/Plan-Holiday/Room-Categories/Hotels/bubbles" ] |
0.11 ms (0.00%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
0.11 ms (0.00%) |
1 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
0.09 ms (0.00%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/steiermark.com/en/Murtal/Plan-Holiday/Room-Categories/Hotels/bubbles" ] |
demi_vacancies connection
Time▼ | Count | Info |
---|---|---|
2790.52 ms (80.95%) |
2 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (45344641,2671474,6497550,27795127,33611480,1953708,4791435,1746105,7542353,1743121,9394208,1954031,1739422,1736122,1745037,7364155,4525596,1736444,1741720,1746188,26956680,25577919,4062673,1743804,1747672,3190322,16942941,1945097,1744000,1739695,1744741,1749206,6553921,1750182,9665940,9491906,1743861,31820476,9919871,1748682,2458698,7571608,1745277,1747013,1953538,1748469,31406343,18175240,48981906,1742580,38928823,10106915,48563833,1944638,4553064,48981909,1748796,1741179,1946351,1954000,15419089,48891241,45430771,1742632,9798794,48313371,1746933,1750076,26059963,2667097,11758096,47693113,48313374,6553969,1736268,1743364,1744087,17574337,4062628,47240616,1740354,49345132,32570989,49580925,1953843,1740503,6553917,1743927,1743691,1743288,1953564,42442514,2673150,8925967,1741277,1745175,1741900,1740105,1745311,45830452,4062845,1953633,1749371,1744299,41406325,1945680,1740280,1745374,1739920,1739846,1735817,1741019,1735769,1953230,1742817,1739830,15432854,1943381,48804066,1742903,1742891,1944971,13468660,6494431,26899206,1749921,30522747,1945182,48610530,6497577,48563836,1746869,15176332,4062328,46896212,12216039,48265993,1748874,1748326,1746456,1744492,15116614,1740164,17517682,1746266,1743089,1748053,1747203,1952711,6493635,46409417,9923960,11892410,40661069,1741314,4062640,22149472,13768757,1748280,1742670,49029361,2668546,4062431,47929048,1945937,1739806,22166841,32570986,1736356,1742867,1736174,2566254,4062664,2978039,1744231,6553925,1736412,1741842,1742553,1945485,25086439,11329889,4062381,5732976,48933696,1745085,47644592,4525581,4580781,1740843,33321369,6553977,1741616,6497583,1745878,15176277,31775662,46409424,1743212,16329832,8695297,2667581,2542786,1944935,34168343,1746888,1748970,2587898,15465861,1745650,3429558,24767422,22868106,1944324,1744565,1953332,36985954,1736068,1945227,23898669,1742316,6497598,1736352,1944590,1749264,12894895,27436656,6497634,2668273,42396774,1748613,47644595,1946429,33321359,1944200,31613769,1944467,48265977,1742419,3283083,1744680,1750061,31406340,45479665,6497526,35908675,1748466,1740806,4062502,1945531,1944279,1742970,1744810,15399861,3045210,1946327,1750211,1744618,34012809,7364158,1747963,1746966,1945387,1742732,1749742,1741776,15103887,1742445,49299937,10672408,6553923,49534198,1742341,1747228,5612896,36022010,1745241,1953506,1742539,2458797,1954287,35562327,48804069,1744654,26848408,1748634,6497563,1742525,1744760,1944896,1743604,12894885,17184421,1741041,1744099,1739520,1749288,1744456,1741980,1736494,12963484,1944838,1740630,22786995,32449058,48313377,24896602,1945611,1945724,29311463,2611644,24767419,49345129,15399851,45532997,1952871,1944389,26477859,1747444,14012385,41655076,4761786,48891238,41909293,11432158,16943153,30564071,41655080,1945246,1744374,30838280,1749431,1746508,1750146,1745913,1743226,4062685,1743173,1745754,1749855,47601194,1740988,1945464,3022806,1944069,1748239,1744268,1743486,1742359,22149479,1746070,6497553,1745839,31820473,1823225,1743467,1739549,16349108,34372366,1743243,50341773,49253798,1743384,1742389,1743705,4704486,1741295) AND dacco.o_published = 1 AND (dacco.town__id IN (11956, 11929, 11935, 11923, 11936, 11926, 11927, 11918, 11966, 11971, 11972, 11931, 11928, 11953, 11930, 11924, 11954, 11955, 11942, 11932)) GROUP BY dacco.oo_id ORDER BY RAND(952)
Parameters:
[] |
548.33 ms (15.91%) |
32 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (45344641,2671474,6497550,27795127,33611480,1953708,4791435,1746105,7542353,1743121,9394208,1954031,1739422,1736122,1745037,7364155,4525596,1736444,1741720,1746188,26956680,25577919,4062673,1743804,1747672,3190322,16942941,1945097,1744000,1739695,1744741,1749206,6553921,1750182,9665940,9491906,1743861,31820476,9919871,1748682,2458698,7571608,1745277,1747013,1953538,1748469,31406343,18175240,48981906,1742580,38928823,10106915,48563833,1944638,4553064,48981909,1748796,1741179,1946351,1954000,15419089,48891241,45430771,1742632,9798794,48313371,1746933,1750076,26059963,2667097,11758096,47693113,48313374,6553969,1736268,1743364,1744087,17574337,4062628,47240616,1740354,49345132,32570989,49580925,1953843,1740503,6553917,1743927,1743691,1743288,1953564,42442514,2673150,8925967,1741277,1745175,1741900,1740105,1745311,45830452,4062845,1953633,1749371,1744299,41406325,1945680,1740280,1745374,1739920,1739846,1735817,1741019,1735769,1953230,1742817,1739830,15432854,1943381,48804066,1742903,1742891,1944971,13468660,6494431,26899206,1749921,30522747,1945182,48610530,6497577,48563836,1746869,15176332,4062328,46896212,12216039,48265993,1748874,1748326,1746456,1744492,15116614,1740164,17517682,1746266,1743089,1748053,1747203,1952711,6493635,46409417,9923960,11892410,40661069,1741314,4062640,22149472,13768757,1748280,1742670,49029361,2668546,4062431,47929048,1945937,1739806,22166841,32570986,1736356,1742867,1736174,2566254,4062664,2978039,1744231,6553925,1736412,1741842,1742553,1945485,25086439,11329889,4062381,5732976,48933696,1745085,47644592,4525581,4580781,1740843,33321369,6553977,1741616,6497583,1745878,15176277,31775662,46409424,1743212,16329832,8695297,2667581,2542786,1944935,34168343,1746888,1748970,2587898,15465861,1745650,3429558,24767422,22868106,1944324,1744565,1953332,36985954,1736068,1945227,23898669,1742316,6497598,1736352,1944590,1749264,12894895,27436656,6497634,2668273,42396774,1748613,47644595,1946429,33321359,1944200,31613769,1944467,48265977,1742419,3283083,1744680,1750061,31406340,45479665,6497526,35908675,1748466,1740806,4062502,1945531,1944279,1742970,1744810,15399861,3045210,1946327,1750211,1744618,34012809,7364158,1747963,1746966,1945387,1742732,1749742,1741776,15103887,1742445,49299937,10672408,6553923,49534198,1742341,1747228,5612896,36022010,1745241,1953506,1742539,2458797,1954287,35562327,48804069,1744654,26848408,1748634,6497563,1742525,1744760,1944896,1743604,12894885,17184421,1741041,1744099,1739520,1749288,1744456,1741980,1736494,12963484,1944838,1740630,22786995,32449058,48313377,24896602,1945611,1945724,29311463,2611644,24767419,49345129,15399851,45532997,1952871,1944389,26477859,1747444,14012385,41655076,4761786,48891238,41909293,11432158,16943153,30564071,41655080,1945246,1744374,30838280,1749431,1746508,1750146,1745913,1743226,4062685,1743173,1745754,1749855,47601194,1740988,1945464,3022806,1944069,1748239,1744268,1743486,1742359,22149479,1746070,6497553,1745839,31820473,1823225,1743467,1739549,16349108,34372366,1743243,50341773,49253798,1743384,1742389,1743705,4704486,1741295) AND dacco.o_published = 1 AND (dacco.town__id IN (11956, 11929, 11935, 11923, 11936, 11926, 11927, 11918, 11966, 11971, 11972, 11931, 11928, 11953, 11930, 11924, 11954, 11955, 11942, 11932)) AND EXISTS ( SELECT 1 FROM `steiermark`.object_relations_8 subfacrel WHERE subfacrel.src_id = dacco.o_id AND subfacrel.dest_id IN (6806,6814,6807,6830,6831,6824,29785451,10896433,6817) AND subfacrel.fieldname = 'categories' ) GROUP BY dacco.oo_id ORDER BY RAND(952)
Parameters:
[] |
61.13 ms (1.77%) |
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 (45344641,2671474,1743243,6497550,27795127,33611480,1953708,4791435,1746105,7542353,1743121,9394208,1954031,1739422,1736122,1745037,7364155,4525596,1736444,1741720,1746188,26956680,25577919,4062673,1743804,1747672,3190322,16942941,1945097,1744000,1739695,1744741,1749206,6553921,1750182,9665940,9491906,1743861,31820476,9919871,1748682,50341773,2458698,7571608,1745277,1747013,1953538,1748469,31406343,18175240,48981906,1742580,38928823,10106915,48563833,1944638,4553064,48981909,1748796,1741179,1946351,1954000,15419089,48891241,45430771,1742632,9798794,48313371,1746933,1750076,26059963,2667097,11758096,47693113,48313374,49253798,6553969,1736268,1743364,1744087,17574337,4062628,47240616,1740354,49345132,32570989,49580925,1953843,1740503,6553917,1743927,1743691,1743288,1953564,42442514,2673150,8925967,1741277,1745175,1741900,1740105,1745311,45830452,4062845,1953633,1749371,1744299,41406325,1945680,1740280,1745374,1739920,1739846,1735817,1743384,1741019,1735769,1953230,1742817,1739830,15432854,1943381,48804066,1742903,1742891,1944971,13468660,6494431,26899206,1749921,30522747,1945182,48610530,6497577,48563836,1746869,15176332,4062328,46896212,12216039,48265993,1748874,1748326,1746456,1744492,15116614,1740164,17517682,1746266,1743089,1748053,1747203,1952711,6493635,46409417,9923960,11892410,40661069,1741314,4062640,22149472,13768757,1748280,1742670,49029361,2668546,4062431,47929048,1945937,1739806,22166841,32570986,1736356,1742867,1736174,2566254,4062664,2978039,1744231,6553925,1736412,1741842,1742553,1945485,25086439,11329889,1742389,4062381,5732976,48933696,1745085,47644592,4525581,4580781,1740843,33321369,6553977,1741616,6497583,1745878,15176277,31775662,46409424,1743212,16329832,8695297,2667581,2542786,1944935,34168343,1746888,1748970,2587898,15465861,1745650,3429558,24767422,22868106,1944324,1744565,1953332,36985954,1736068,1945227,23898669,1742316,6497598,1736352,1944590,1749264,12894895,27436656,6497634,2668273,42396774,1748613,47644595,1946429,33321359,1944200,31613769,1944467,48265977,1742419,3283083,1744680,1750061,31406340,45479665,6497526,35908675,1748466,1740806,4062502,1945531,1944279,1742970,1744810,15399861,3045210,1946327,1750211,1744618,34012809,7364158,1747963,1746966,1945387,1742732,1749742,1741776,15103887,1742445,49299937,10672408,6553923,49534198,1742341,1743705,1747228,5612896,36022010,1745241,1953506,1742539,2458797,1954287,35562327,48804069,1744654,26848408,1748634,6497563,1742525,1744760,1944896,1743604,12894885,17184421,1741041,1744099,1739520,1749288,1744456,4704486,1741980,1736494,12963484,1944838,1740630,22786995,32449058,48313377,24896602,1945611,1741295,1945724,29311463,2611644,24767419,49345129,15399851,45532997,1952871,1944389,26477859,1747444,14012385,41655076,4761786,48891238,41909293,11432158,16943153,30564071,41655080,1945246,1744374,30838280,1749431,1746508,1750146,1745913,1743226,4062685,1743173,1745754,1749855,47601194,1740988,1945464,3022806,1944069,1748239,1744268,1743486,1742359,22149479,1746070,6497553,1745839,31820473,1823225,1743467,1739549,16349108,34372366) 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:
[] |
14.73 ms (0.43%) |
2 |
SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (6830, 6806, 6814, 6807, 6831, 6824, 29785451, 10896433, 6817) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id
Parameters:
[] |
4.93 ms (0.14%) |
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 (11956, 11929, 11935, 11923, 11936, 11926, 11927, 11918, 11966, 11971, 11972, 11931, 11928, 11953, 11930, 11924, 11954, 11955, 11942, 11932)) GROUP BY dacco.oo_id ORDER BY RAND(952)
Parameters:
[] |
4.53 ms (0.13%) |
32 |
create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1744654),(7571608),(23898669),(1739830),(1736412),(7364158),(1746105),(1741842),(41655080),(1944467),(1745913),(1945531),(1739806),(1944200),(11329889),(1736494),(1739520),(1953538),(1735769),(1945182),(1944069),(1945724),(1749371),(3190322),(1945097),(1742867),(1736122),(6553917),(4525581),(1742632),(1746266),(1742970),(32449058),(1749742),(1945937),(1741980),(1747228),(4062328),(1736444),(1741720),(1745175),(1745878),(2542786),(2587898),(1743173),(1736174),(1739422),(1823225),(1749206),(1943381),(4062673),(1744268),(5732976),(1750061),(1749264),(1750146),(1740164),(1744231),(1746966),(2458698),(1953564),(11758096),(6497583),(1749921),(1741314),(1745374),(2458797),(1749855),(1740503),(1953633)
Parameters:
[] |
2.26 ms (0.07%) |
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:
[] |
2.20 ms (0.06%) |
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:
[] |
2.16 ms (0.06%) |
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:
[] |
2.11 ms (0.06%) |
34 |
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[] |
1.96 ms (0.06%) |
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.52 ms (0.02%) |
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.50 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11935) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.47 ms (0.01%) |
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.46 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11956) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.44 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11936) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.43 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11928) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.39 ms (0.01%) |
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.37 ms (0.01%) |
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.37 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11923) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.36 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11918) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.35 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11927) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.34 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11924) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.32 ms (0.01%) |
2 |
create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (16349108),(1739422),(1746456),(1739846),(23898669),(1742341),(48265977),(48981906),(1953843),(22868106),(1746070),(15176277),(48313374),(1740843),(1736122),(1944590),(1739920),(1739695),(1736444),(1743604),(1953332),(47601194),(2671474),(8695297),(1747444),(4062628),(48804069),(15399861),(27795127),(1747672),(1742445),(1945246),(6497634),(13468660),(12894885),(1744087),(1945724),(1750182),(1741980),(45344641),(4704486),(4062431),(41655076),(17184421),(1945531),(2542786),(47693113),(4525596),(9798794),(1740164),(1750061),(1745175),(45430771),(1744099),(1749921),(26477859),(48891241),(1740806),(4761786),(1743364),(32570989),(48313371),(6497550),(36022010),(1749431),(1745241),(1748634),(1744374),(2458698),(11892410),(49345132),(1944638),(1748682),(1749855),(1744456),(1743089),(15103887),(1736268),(1746869),(1747963),(1944896),(1748613),(1740630),(1742632),(1750076),(1749264),(22149472),(48265993),(1742670),(12963484),(1750211),(1747203),(1746508),(45532997),(1953564),(45830452),(1740105),(1743384),(1945464),(1743804),(1742539),(1945611),(1742389),(48891238),(47929048),(6553923),(1748326),(6497598),(31820473),(1742580),(1946429),(1742525),(1741277),(1735817),(1746888),(1743243),(1735769),(45479665),(1745374),(1741179),(49345129),(16943153),(3429558),(1745839),(1745754),(27436656),(6494431),(41909293),(1741900),(11432158),(35562327),(29311463),(1742970),(1741776),(1742419),(1954287),(1744231),(1743927),(1945182),(9491906),(11329889),(4791435),(4062845),(1954000),(1944069),(1748796),(1742553),(1748970),(1953506),(1745913),(4062664),(2566254),(40661069),(49029361),(10106915),(17574337),(9394208),(1945097),(1744492),(7542353),(15419089),(6497526),(4062685),(1745277),(36985954),(6493635),(1744000),(35908675),(32449058),(1741041),(6497553),(1742316),(1736356),(1745650),(1736174),(7364155),(7571608),(48610530),(1748239),(14012385),(1736412),(1743705),(1745085),(31406343),(1749206),(2667097),(1744680),(1739520),(48981909),(18175240),(1945387),(3045210),(1739549),(46409417),(1742732),(15465861),(15116614),(1743486),(22166841),(1953633),(1748874),(1946327),(10672408),(1746188),(1744268),(17517682),(2611644),(1741295),(26956680),(1744299),(1748466),(5612896),(48563836),(1945937),(1952711),(7364158),(2668546),(47240616),(24896602),(1944200),(47644592),(1944971),(1736068),(30522747),(2668273),(1744565),(46896212),(1736352),(26059963),(6553917),(15176332),(2673150),(49253798),(5732976),(1749371),(4553064),(3190322),(33321359),(3022806),(22149479),(9919871),(25577919),(3283083),(1744741),(1741616),(1945227),(11758096),(9665940),(1742359),(1739830),(1749288),(4525581),(1743173),(1741720),(31613769),(24767422),(1745878),(1944467),(1742891),(48804066),(32570986),(12894895),(1944279),(16329832),(22786995),(4062640),(2458797),(30838280),(1745311),(6553969),(1743691),(33321369),(1744760),(38928823),(1944838),(13768757),(1750146),(1744618),(1747228),(2587898),(1739806),(6497583),(1945485),(47644595),(1745037),(48563833),(48313377),(1743212),(4062328),(1944324),(34372366),(4580781),(42442514),(1744810),(1944389),(26899206),(1747013),(2667581),(33611480),(1743288),(1748053),(1740988),(6553921),(1943381),(46409424),(1743861),(1736494),(49299937),(26848408),(1743121),(6497563),(1944935),(50341773),(1740280),(31775662),(1743467),(31820476),(6497577),(1741314),(34012809),(16942941),(1742867),(9923960),(41406325),(25086439),(34168343),(4062502),(1742817),(49534198),(48933696),(4062381),(1742903),(1741842),(1953538),(2978039),(49580925),(30564071),(1823225),(1740354),(6553925),(1954031),(12216039),(1953708),(1746266),(8925967),(1746105),(1952871),(6553977),(1749742),(1743226),(31406340),(41655080),(24767419),(4062673),(1748280),(1746966),(1744654),(15432854),(1953230),(42396774),(1945680),(1946351),(1748469),(1746933),(1741019),(15399851),(1740503)
Parameters:
[] |
0.32 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11932) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.30 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11930) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.28 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11931) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.28 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11972) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.27 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11926) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.27 ms (0.01%) |
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:
[] |
0.27 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11929) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.25 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11971) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.24 ms (0.01%) |
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.24 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11954) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.24 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11953) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.22 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11942) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.21 ms (0.01%) |
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.18 ms (0.01%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11966) AND src_id IN (select id from `steiermark`.accoIdsTowns)
Parameters:
[] |
0.16 ms (0.00%) |
1 |
SELECT count(DISTINCT src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (11955) 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.