Query Metrics
156
Database Queries
48
Different statements
46350.13 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
1.64 ms (0.00%) |
9 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
0.79 ms (0.00%) |
2 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
16433
]
|
0.68 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 ] |
0.55 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/Murtal/Plan-Holiday/Search-and-Book-Accommodation/bubbles" "sourcePathQuery" => "/en/Murtal/Plan-Holiday/Search-and-Book-Accommodation/bubbles?randSeed=242" "sourceEntireUri" => "https://stage.steiermark.com/en/Murtal/Plan-Holiday/Search-and-Book-Accommodation/bubbles?randSeed=242" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
0.50 ms (0.00%) |
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.31 ms (0.00%) |
2 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "bubbles" "path" => "/steiermark.com/en/Murtal/Plan-Holiday/Search-and-Book-Accommodation/" ] |
0.21 ms (0.00%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
0.20 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/Search-and-Book-Accommodation/bubbles" ] |
0.18 ms (0.00%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
0.15 ms (0.00%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/steiermark.com/en/Murtal/Plan-Holiday/Search-and-Book-Accommodation/bubbles" ] |
0.13 ms (0.00%) |
1 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
demi_vacancies connection
Time▼ | Count | Info |
---|---|---|
46238.49 ms (99.76%) |
33 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (1945182,26477859,8695297,42396774,1944971,1736444,1739846,6497526,30838280,1745085,1743467,1945485,1946351,38928823,1742732,6494431,1749855,11329889,1742817,6497598,15176277,1736122,1744299,1746266,1746188,1742580,1742903,41909293,1741041,13468660,45830452,29311463,48265977,7542353,1953564,1945531,1745650,1745037,1749431,1742316,1944838,6553917,1944896,1741720,1742867,16943153,1741616,24896602,1749264,34168343,2611644,1736174,9923960,1744456,1750146,15176332,22166841,1747013,35908675,10106915,48313374,1823225,4062845,1742525,12963484,1945097,9919871,2458797,15103887,1743288,1736356,2667097,1746508,16349108,1744492,22149472,1748796,11432158,4062664,9665940,1747228,47693113,27795127,1954031,15465861,1953332,1741776,26848408,1741277,1953538,1736494,4062673,1748613,1944935,31775662,1744087,30522747,1743364,1744268,1749742,1744760,1735817,1743604,1745175,1744741,1945937,1743121,41655080,1742632,26899206,9491906,16329832,49345132,4062431,1743173,49345129,2671474,1739806,1745754,4791435,6497553,1746105,1745241,48891241,40661069,45344641,1749288,1746966,45479665,33321359,1739920,1736352,25577919,36022010,41655076,49580925,1945227,1736068,33321369,31406343,1953843,47644592,1742670,48563836,1740806,1745374,4525581,4525596,12894885,1743089,1746070,15432854,1740843,2566254,17517682,24767422,1945611,1742341,12894895,1739422,1740503,1749371,1744231,1742539,4553064,1745913,1745839,1746456,1748874,1946429,1746888,48313377,42442514,4062628,1747963,3190322,1744618,4062328,1954000,15399861,26956680,1744680,1742891,1740630,1945387,34012809,1740988,45430771,49299937,26059963,11892410,1944467,48563833,35562327,1744654,18175240,5732976,46409417,47601194,2668546,1736268,48804069,1743861,1744000,24767419,41406325,1946327,27436656,1943381,1740164,1748280,1750211,4062502,6497577,6497550,1944200,2673150,1750182,32570989,1748053,1744565,2542786,4062640,3022806,17184421,47929048,1952871,31820473,12216039,1953230,1744099,6497563,1748970,1745311,1742419,9394208,31406340,4062685,1741900,2587898,1742553,1944590,46409424,1944279,1748239,1735769,45532997,1743226,1741980,6493635,1945464,1741179,36985954,1746869,1743927,15419089,6553969,2458698,49534198,1748466,1739695,46896212,48313371,1747444,10672408,22786995,32449058,1741314,22868106,4580781,1750076,1743212,1740280,4761786,1748634,1740105,3045210,32570986,1747203,2978039,48933696,7364158,16942941,1749206,48265993,15399851,48981909,34372366,1954287,1744810,13768757,1953506,3283083,1944324,22149479,14012385,1739830,1742359,47240616,1743691,30564071,1953708,1742445,1944638,1749921,1952711,1750061,6553921,1945680,5612896,1744374,47644595,6497634,1739520,9798794,8925967,6553925,1743804,1743486,1944069,1748469,6553923,1741842,4062381,1748682,1748326,1746933,2668273,11758096,48891238,6497583,33611480,1741019,49029361,1953633,1945246,1747672,1736412,1742970,1740354,7364155,23898669,31820476,1745277,2667581,7571608,15116614,6553977,1945724,1745878,31613769,17574337,48804066,25086439,3429558,1739549,48981906,48610530,1944389,1741295,1743243,1743705,49253798,1743384,1742389,4704486,50341773) 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(242)
Parameters:
[] |
60.75 ms (0.13%) |
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 (1945182,26477859,8695297,42396774,1944971,1736444,1739846,6497526,30838280,1745085,1743467,1945485,1946351,38928823,1742732,6494431,1749855,11329889,1742817,6497598,15176277,1736122,1744299,1746266,1746188,1742580,1742903,41909293,1741041,13468660,45830452,29311463,48265977,7542353,1953564,1945531,1745650,1745037,1749431,1742316,1944838,6553917,1944896,1741720,1742867,16943153,1741616,24896602,1749264,34168343,2611644,1736174,9923960,1744456,1750146,15176332,22166841,1747013,35908675,10106915,48313374,1823225,4062845,1741295,1742525,12963484,1945097,9919871,2458797,15103887,1743288,1736356,2667097,1746508,16349108,1744492,22149472,1748796,11432158,4062664,9665940,1747228,47693113,27795127,1954031,15465861,1953332,1741776,26848408,1743243,1741277,1953538,1743705,1736494,4062673,1748613,1944935,31775662,1744087,30522747,1743364,1744268,1749742,1744760,1735817,1743604,1745175,1744741,1945937,1743121,41655080,1742632,26899206,9491906,16329832,49345132,4062431,1743173,49345129,2671474,1739806,1745754,4791435,6497553,1746105,1745241,48891241,40661069,45344641,1749288,1746966,45479665,33321359,1739920,1736352,25577919,36022010,41655076,49580925,1945227,1736068,33321369,31406343,1953843,47644592,1742670,48563836,1740806,1745374,4525581,4525596,12894885,1743089,1746070,15432854,1740843,2566254,17517682,24767422,1945611,1742341,12894895,1739422,1740503,1749371,1744231,1742539,4553064,1745913,1745839,1746456,1748874,1946429,1746888,48313377,42442514,4062628,1747963,3190322,1744618,4062328,1954000,15399861,26956680,1744680,1742891,1740630,1945387,34012809,1740988,45430771,49299937,26059963,11892410,1944467,48563833,35562327,1744654,18175240,5732976,46409417,47601194,2668546,1736268,48804069,1743861,1744000,24767419,41406325,1946327,27436656,1943381,1740164,1748280,1750211,4062502,6497577,6497550,1944200,2673150,1750182,32570989,1748053,1744565,2542786,4062640,3022806,17184421,47929048,1952871,31820473,12216039,1953230,1744099,6497563,1748970,1745311,1742419,9394208,31406340,4062685,1741900,2587898,1742553,1944590,46409424,1944279,49253798,1748239,1735769,45532997,1743226,1741980,6493635,1945464,1741179,36985954,1746869,1743927,15419089,6553969,2458698,49534198,1748466,1739695,46896212,48313371,1747444,10672408,22786995,32449058,1741314,22868106,4580781,1750076,1743212,1740280,4761786,1748634,1740105,3045210,32570986,1747203,2978039,48933696,7364158,1743384,16942941,1749206,48265993,15399851,48981909,34372366,1954287,1744810,13768757,1953506,3283083,1944324,22149479,14012385,1739830,1742359,47240616,1742389,1743691,30564071,1953708,1742445,1944638,1749921,1952711,1750061,6553921,4704486,1945680,5612896,1744374,47644595,6497634,1739520,9798794,8925967,6553925,1743804,1743486,1944069,1748469,6553923,1741842,4062381,1748682,50341773,1748326,1746933,2668273,11758096,48891238,6497583,33611480,1741019,49029361,1953633,1945246,1747672,1736412,1742970,1740354,7364155,23898669,31820476,1745277,2667581,7571608,15116614,6553977,1945724,1745878,31613769,17574337,48804066,25086439,3429558,1739549,48981906,48610530,1944389) 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:
[] |
15.65 ms (0.03%) |
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) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id
Parameters:
[] |
7.45 ms (0.02%) |
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(242)
Parameters:
[] |
5.37 ms (0.01%) |
33 |
create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (29311463),(34168343),(17517682),(1749371),(27436656),(1736444),(1741277),(1739830),(1740354),(1945387),(1746933),(31406343),(32570989),(45430771),(1745311),(41909293),(6553977),(2667097),(1745374),(46896212),(1748874),(1736122),(1748326),(1953506),(1953332),(1745175),(1745839),(1742903),(1743288),(6494431),(1742389),(6497577),(3283083),(22868106),(45532997),(31613769),(1952711),(1944590),(6553925),(1744565),(26848408),(12963484),(26899206),(1743604),(1745650),(1953538),(1743486),(1740280),(6553917),(1744299),(1741314),(1736174),(17574337),(1943381),(12216039),(1744231),(6497553),(2542786),(1749288),(1744099),(1744456),(1748469),(48891238),(1743467),(1744810),(49299937),(27795127),(45344641),(48563833),(33321369),(1746508),(1736356),(1944638),(1954031),(15399851),(1944069),(15419089),(4761786),(1741842),(7571608),(1744087),(2587898),(1749855),(23898669),(48313374),(1945937),(47644592),(1743691),(34372366),(1746456),(1743384),(47693113),(1747228),(1736494),(8695297),(4553064),(26956680),(1946327),(1747963),(35562327),(1746869),(1748280),(6553969),(1944389),(1735817),(1747013),(1945464),(1945246),(32449058),(1746070),(49580925),(1745241),(1741900),(1945724),(1744268),(1750076),(1744000),(1746105),(16942941),(1739422),(1741041),(1952871),(48981906),(42396774),(1953843),(1945485),(36022010),(1945097),(16349108),(6553921),(2458797),(1742359),(3022806),(1742525),(1736352),(2671474),(6497583),(49534198),(22149472),(30522747),(1736068),(15465861),(9798794),(48265993),(3045210),(1745277),(1742419),(1743173),(1946429),(1739549),(1739695),(2667581),(1745913),(1953230),(49345129),(1742732),(7364155),(1748970),(2668546),(31775662),(1744618),(15176332),(1740843),(1742670),(6553923),(1748239),(1745037),(48891241),(1953708),(1945680),(1954000),(4791435),(33321359),(1748466),(50341773),(1953564),(1748613),(4062640),(48804069),(1944279),(1743927),(48313371),(1742891),(47601194),(1945227),(1745754),(1743121),(30838280),(16329832),(1743226),(1749431),(38928823),(49345132),(9394208),(25577919),(1749921),(1743212),(1944324),(1740164),(48981909),(10106915),(1749742),(6493635),(1736268),(4062328),(1750182),(1747672),(34012809),(6497598),(32570986),(2673150),(16943153),(1742553),(4062685),(12894895),(1741720),(1741776),(1739846),(22149479),(45830452),(12894885),(1749264),(4062664),(1944200),(1741295),(7542353),(41655080),(33611480),(35908675),(41406325),(1946351),(9491906),(45479665),(1748053),(42442514),(5612896),(1945611),(1744741),(15176277),(9665940),(8925967),(1743804),(48563836),(1745085),(26059963),(10672408),(24767422),(1743089),(4062673),(1735769),(9923960),(1746266),(1743861),(49029361),(31406340),(1743364),(1944971),(1954287),(1750211),(6497550),(15103887),(41655076),(1750146),(4525581),(1742445),(1945182),(1744374),(4062502),(1944838),(6497563),(1944935),(1744492),(47240616),(46409417),(11892410),(1746188),(1742580),(48933696),(4580781),(1742539),(48804066),(1742316),(2566254),(48610530),(18175240),(22786995),(1746888),(15399861),(6497634),(11329889),(1742867),(1740806),(1740503),(48313377),(1944467),(6497526),(47644595),(1741616),(24896602),(15432854),(1742817),(1741179),(1744654),(1740630),(1744680),(1747203),(2978039),(48265977),(1744760),(26477859),(11432158),(40661069),(11758096),(13468660),(46409424),(31820473),(1739806),(1823225),(3190322),(49253798),(1740988),(1748634),(1740105),(14012385),(1747444),(1746966),(24767419),(4525596),(13768757),(1743705),(1739520),(4704486),(4062431),(4062845),(2458698),(5732976),(1748682),(4062381),(22166841),(1742341),(1743243),(36985954),(47929048),(30564071),(4062628),(1736412),(1745878),(1742632),(1739920),(2668273),(1741980),(1945531),(2611644),(17184421),(1748796),(15116614),(31820476),(1953633),(9919871),(1944896),(3429558),(1749206),(7364158),(1741019),(1750061),(1742970),(25086439)
Parameters:
[] |
2.31 ms (0.00%) |
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.10 ms (0.00%) |
33 |
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[] |
1.14 ms (0.00%) |
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.89 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:
[] |
0.83 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:
[] |
0.70 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:
[] |
0.51 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:
[] |
0.51 ms (0.00%) |
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.51 ms (0.00%) |
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.48 ms (0.00%) |
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.47 ms (0.00%) |
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.44 ms (0.00%) |
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.42 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:
[] |
0.41 ms (0.00%) |
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.38 ms (0.00%) |
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.37 ms (0.00%) |
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.36 ms (0.00%) |
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.35 ms (0.00%) |
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.00%) |
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.32 ms (0.00%) |
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.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:
[] |
0.31 ms (0.00%) |
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.29 ms (0.00%) |
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.29 ms (0.00%) |
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.29 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:
[] |
0.28 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:
[] |
0.27 ms (0.00%) |
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.26 ms (0.00%) |
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.26 ms (0.00%) |
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.24 ms (0.00%) |
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.23 ms (0.00%) |
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.20 ms (0.00%) |
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.