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