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