https://stage.steiermark.com/de/Murtal/Urlaub-planen/Zimmerkategorien/Hotels-und-Gasth%C3%B6fe/bubbles?randSeed=386

Method
GET
HTTP Status
200
IP
95.108.213.198
Profiled on
Token
40979b

Query Metrics

156 Database Queries
50 Different statements
2268.71 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
0.99 ms
(0.04%) 		9 
SELECT name FROM classes WHERE id = ?
Parameters: 
[
  "SiteConfig"
]
View formatted query    View runnable query    Explain query
0.65 ms
(0.03%) 		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
]
View formatted query    View runnable query    Explain query
0.60 ms
(0.03%) 		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/Zimmerkategorien/Hotels-und-Gasthöfe/bubbles"
  "sourcePathQuery" => "/de/Murtal/Urlaub-planen/Zimmerkategorien/Hotels-und-Gasthöfe/bubbles?randSeed=386"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Murtal/Urlaub-planen/Zimmerkategorien/Hotels-und-Gasthöfe/bubbles?randSeed=386"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
View formatted query    View runnable query    Explain query
0.58 ms
(0.03%) 		2 
SELECT * FROM documents_editables WHERE documentId = ?
Parameters: 
[
  33938
]
View formatted query    View runnable query    Explain query
0.42 ms
(0.02%) 		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
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.01%) 		2 
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters: 
[
  "key" => "bubbles"
  "path" => "/steiermark.com/de/Murtal/Urlaub-planen/Zimmerkategorien/Hotels-und-Gasthöfe/"
]
View formatted query    View runnable query    Explain query
0.16 ms
(0.01%) 		2 
SELECT * FROM website_settings WHERE id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.14 ms
(0.01%) 		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/Zimmerkategorien/Hotels-und-Gasthöfe/bubbles"
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.01%) 		1 
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.12 ms
(0.01%) 		1 
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters: 
[
  "id" => "reports"
  "scope" => "pimcore"
]
View formatted query    View runnable query    Explain query
0.09 ms
(0.00%) 		1 
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters: 
[
  "prettyUrl" => "/steiermark.com/de/Murtal/Urlaub-planen/Zimmerkategorien/Hotels-und-Gasthöfe/bubbles"
]
View formatted query    View runnable query    Explain query

demi_vacancies connection

Time▼ Count Info
1603.98 ms
(70.70%) 		1 
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (6553925,34012809,1746869,1744760,1748280,1749921,48563836,4062328,4062628,1823225,49534198,1945680,16329832,1744456,1740503,6553969,3045210,48265993,1745913,3429558,9798794,47601194,2542786,1944279,1746456,6553921,1748634,3190322,48933696,3283083,1954000,1945937,29311463,1736444,1743288,15399851,7364155,8925967,48563833,1745175,3022806,1743226,1742867,1944324,22149479,45344641,6497550,1743173,1943381,49029361,1944935,24767422,48265977,1743691,1745037,1743927,32570986,4062431,17574337,1736268,2587898,1945387,1945611,34168343,1744299,11758096,9394208,1749288,1745878,12894895,45430771,1745311,1745241,18175240,45479665,6553917,1946429,1748239,2611644,30522747,1743467,48804069,1742632,6553977,1945097,17517682,1742580,48891241,1746966,33321369,1744492,12894885,11892410,47644595,26477859,1748326,1742525,4062664,1945531,15465861,1744374,1743212,1953506,1952711,4062845,47240616,4062685,1744565,1743804,4525581,42442514,4553064,1741277,1745754,6497598,15176332,42396774,9491906,48981909,36985954,1953633,1739846,6497577,1742553,1742316,1742359,25577919,1747203,10672408,1750211,22868106,1735817,1739920,40661069,47929048,1741842,1944896,27436656,1744268,1748053,1743089,34372366,1736174,1749742,1747444,1749855,1742891,1744810,12963484,1747013,1746508,1747672,1743364,4062673,16349108,1748469,1745085,7364158,1741776,1748466,15103887,48891238,1944389,1740354,13468660,1740164,1743121,13768757,1944638,1944590,1944200,22166841,12216039,1739695,35908675,48313377,1750076,6497634,31775662,22786995,2673150,1741041,33321359,5612896,1742670,1740630,1740105,27795127,2671474,1742970,31406343,35562327,1944971,1743486,6497526,45830452,15176277,1742445,49580925,33611480,10106915,41406325,4791435,1750182,1747228,2668273,1736494,1739830,38928823,1946327,2667097,1744099,1746070,11432158,1946351,30838280,1748796,31406340,17184421,1741019,24767419,1953564,48981906,48610530,1740806,26848408,16942941,7571608,1744231,48313374,2668546,1953332,9923960,1741900,6553923,1945724,1746105,1746933,1736412,1741314,31820473,1736352,2458698,1953538,15432854,47693113,9919871,6494431,5732976,4062640,1945246,1749371,4525596,25086439,8695297,1745650,6493635,1748874,4761786,49345129,1945182,2667581,1952871,1735769,32570989,1736356,2978039,1746888,4062502,4580781,1745374,1944069,1744741,1748970,1744680,2458797,1742817,1744000,46409424,1744087,1945227,1742903,1744618,1748682,1749264,47644592,1739422,32449058,1740280,1741179,31820476,1945485,1745277,49345132,6497583,1953708,22149472,1745839,23898669,1740843,1741616,1750146,9665940,41909293,16943153,1742419,1954031,15399861,15116614,1739806,1736068,1739520,48313371,1954287,1740988,1742539,1743861,1744654,24896602,1953230,1739549,1742732,2566254,1945464,41655080,11329889,1749206,1953843,1748613,1742341,14012385,46409417,1749431,1750061,31613769,26899206,6497563,45532997,1746266,1746188,1747963,48804066,30564071,49299937,1743604,26956680,41655076,1944838,36022010,1944467,1741720,1736122,7542353,15419089,6497553,26059963,4062381,1741980,46896212,4704486,1742389,1741295,50341773,49253798,1743243,1743384,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(386)
Parameters: 
[]
View formatted query    View runnable query    Explain query
561.00 ms
(24.73%) 		32 
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (6553925,34012809,1746869,1744760,1748280,1749921,48563836,4062328,4062628,1823225,49534198,1945680,16329832,1744456,1740503,6553969,3045210,48265993,1745913,3429558,9798794,47601194,2542786,1944279,1746456,6553921,1748634,3190322,48933696,3283083,1954000,1945937,29311463,1736444,1743288,15399851,7364155,8925967,48563833,1745175,3022806,1743226,1742867,1944324,22149479,45344641,6497550,1743173,1943381,49029361,1944935,24767422,48265977,1743691,1745037,1743927,32570986,4062431,17574337,1736268,2587898,1945387,1945611,34168343,1744299,11758096,9394208,1749288,1745878,12894895,45430771,1745311,1745241,18175240,45479665,6553917,1946429,1748239,2611644,30522747,1743467,48804069,1742632,6553977,1945097,17517682,1742580,48891241,1746966,33321369,1744492,12894885,11892410,47644595,26477859,1748326,1742525,4062664,1945531,15465861,1744374,1743212,1953506,1952711,4062845,47240616,4062685,1744565,1743804,4525581,42442514,4553064,1741277,1745754,6497598,15176332,42396774,9491906,48981909,36985954,1953633,1739846,6497577,1742553,1742316,1742359,25577919,1747203,10672408,1750211,22868106,1735817,1739920,40661069,47929048,1741842,1944896,27436656,1744268,1748053,1743089,34372366,1736174,1749742,1747444,1749855,1742891,1744810,12963484,1747013,1746508,1747672,1743364,4062673,16349108,1748469,1745085,7364158,1741776,1748466,15103887,48891238,1944389,1740354,13468660,1740164,1743121,13768757,1944638,1944590,1944200,22166841,12216039,1739695,35908675,48313377,1750076,6497634,31775662,22786995,2673150,1741041,33321359,5612896,1742670,1740630,1740105,27795127,2671474,1742970,31406343,35562327,1944971,1743486,6497526,45830452,15176277,1742445,49580925,33611480,10106915,41406325,4791435,1750182,1747228,2668273,1736494,1739830,38928823,1946327,2667097,1744099,1746070,11432158,1946351,30838280,1748796,31406340,17184421,1741019,24767419,1953564,48981906,48610530,1740806,26848408,16942941,7571608,1744231,48313374,2668546,1953332,9923960,1741900,6553923,1945724,1746105,1746933,1736412,1741314,31820473,1736352,2458698,1953538,15432854,47693113,9919871,6494431,5732976,4062640,1945246,1749371,4525596,25086439,8695297,1745650,6493635,1748874,4761786,49345129,1945182,2667581,1952871,1735769,32570989,1736356,2978039,1746888,4062502,4580781,1745374,1944069,1744741,1748970,1744680,2458797,1742817,1744000,46409424,1744087,1945227,1742903,1744618,1748682,1749264,47644592,1739422,32449058,1740280,1741179,31820476,1945485,1745277,49345132,6497583,1953708,22149472,1745839,23898669,1740843,1741616,1750146,9665940,41909293,16943153,1742419,1954031,15399861,15116614,1739806,1736068,1739520,48313371,1954287,1740988,1742539,1743861,1744654,24896602,1953230,1739549,1742732,2566254,1945464,41655080,11329889,1749206,1953843,1748613,1742341,14012385,46409417,1749431,1750061,31613769,26899206,6497563,45532997,1746266,1746188,1747963,48804066,30564071,49299937,1743604,26956680,41655076,1944838,36022010,1944467,1741720,1736122,7542353,15419089,6497553,26059963,4062381,1741980,46896212,4704486,1742389,1741295,50341773,49253798,1743243,1743384,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)) 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(386)
Parameters: 
[]
View formatted query    View runnable query    Explain query
57.96 ms
(2.55%) 		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 (6553925,34012809,1746869,1744760,1748280,1749921,48563836,4062328,4062628,1823225,49534198,1945680,16329832,1744456,1740503,6553969,3045210,48265993,1745913,3429558,9798794,47601194,2542786,1944279,1746456,6553921,1748634,3190322,48933696,3283083,1954000,1945937,29311463,1736444,1743288,4704486,15399851,7364155,8925967,48563833,1745175,3022806,1743226,1742867,1944324,22149479,45344641,6497550,1743173,1943381,49029361,1944935,24767422,48265977,1743691,1745037,1743927,32570986,4062431,17574337,1736268,1742389,2587898,1945387,1945611,34168343,1744299,11758096,9394208,1749288,1745878,12894895,45430771,1745311,1745241,18175240,45479665,6553917,1946429,1748239,2611644,30522747,1743467,48804069,1742632,6553977,1945097,17517682,1742580,48891241,1746966,33321369,1744492,12894885,11892410,47644595,26477859,1748326,1742525,4062664,1945531,15465861,1744374,1743212,1953506,1952711,4062845,47240616,4062685,1744565,1743804,4525581,42442514,4553064,1741277,1745754,6497598,15176332,42396774,9491906,48981909,36985954,1953633,1739846,6497577,1742553,1741295,1742316,1742359,25577919,1747203,10672408,1750211,22868106,1735817,1739920,40661069,47929048,1741842,1944896,27436656,1744268,1748053,1743089,34372366,1736174,1749742,1747444,1749855,1742891,1744810,12963484,1747013,1746508,1747672,1743364,4062673,16349108,1748469,1745085,7364158,1741776,1748466,15103887,48891238,1944389,1740354,13468660,1740164,1743121,13768757,1944638,1944590,1944200,22166841,12216039,1739695,35908675,48313377,1750076,6497634,31775662,22786995,2673150,1741041,33321359,5612896,1742670,1740630,1740105,27795127,2671474,1742970,31406343,35562327,1944971,1743486,6497526,45830452,15176277,1742445,49580925,33611480,10106915,41406325,4791435,1750182,50341773,1747228,2668273,1736494,1739830,38928823,1946327,2667097,1744099,1746070,11432158,1946351,30838280,1748796,31406340,17184421,1741019,24767419,1953564,48981906,48610530,1740806,26848408,16942941,7571608,1744231,48313374,2668546,1953332,9923960,1741900,6553923,1945724,1746105,1746933,1736412,1741314,31820473,1736352,2458698,1953538,15432854,47693113,9919871,6494431,5732976,49253798,4062640,1743243,1945246,1749371,4525596,25086439,8695297,1745650,6493635,1748874,4761786,49345129,1945182,2667581,1952871,1735769,32570989,1736356,2978039,1746888,4062502,4580781,1745374,1944069,1744741,1748970,1744680,2458797,1742817,1744000,46409424,1744087,1945227,1742903,1744618,1748682,1749264,47644592,1739422,32449058,1740280,1741179,31820476,1945485,1745277,49345132,6497583,1953708,22149472,1745839,23898669,1740843,1741616,1750146,9665940,41909293,16943153,1742419,1954031,15399861,15116614,1739806,1736068,1739520,48313371,1954287,1740988,1742539,1743861,1744654,24896602,1953230,1739549,1742732,2566254,1945464,41655080,11329889,1749206,1953843,1748613,1742341,14012385,46409417,1749431,1750061,31613769,26899206,1743384,6497563,45532997,1746266,1746188,1747963,48804066,30564071,49299937,1743604,1743705,26956680,41655076,1944838,36022010,1944467,1741720,1736122,7542353,15419089,6497553,26059963,4062381,1741980,46896212)
                  
                   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: 
[]
View formatted query    View runnable query    Explain query
9.05 ms
(0.40%) 		1 
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: 
[]
View formatted query    View runnable query    Explain query
7.65 ms
(0.34%) 		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(386)
Parameters: 
[]
View formatted query    View runnable query    Explain query
4.52 ms
(0.20%) 		32 
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1749742),(1735769),(1743173),(1823225),(1741842),(6497583),(7364158),(1945182),(7571608),(1747228),(1736494),(1945531),(1749206),(11758096),(1739520),(1745878),(1944069),(1739806),(1742867),(32449058),(1953564),(1736122),(1945097),(1953633),(1736444),(1953538),(1945937),(1944467),(1750146),(1750061),(1746966),(1945724),(1744654),(1749264),(1943381),(1749371),(23898669),(1744231),(1742632),(1745374),(2458797),(6553917),(1742970),(4062673),(1741720),(1739422),(11329889),(1746105),(4525581),(4062328),(1744268),(1739830),(3190322),(1944200),(1745913),(2542786),(2587898),(1741314),(5732976),(1741980),(1736174),(1740164),(1749855),(2458698),(1740503),(1749921),(1746266),(41655080),(1736412),(1745175)
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.61 ms
(0.12%) 		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: 
[]
View formatted query    View runnable query    Explain query
2.46 ms
(0.11%) 		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: 
[]
View formatted query    View runnable query    Explain query
2.25 ms
(0.10%) 		33 
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.04 ms
(0.09%) 		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: 
[]
View formatted query    View runnable query    Explain query
2.00 ms
(0.09%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.58 ms
(0.03%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.54 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: 
[]
View formatted query    View runnable query    Explain query
0.52 ms
(0.02%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.45 ms
(0.02%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.41 ms
(0.02%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.41 ms
(0.02%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.41 ms
(0.02%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.39 ms
(0.02%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.38 ms
(0.02%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.37 ms
(0.02%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.35 ms
(0.02%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.31 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: 
[]
View formatted query    View runnable query    Explain query
0.31 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: 
[]
View formatted query    View runnable query    Explain query
0.30 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: 
[]
View formatted query    View runnable query    Explain query
0.30 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: 
[]
View formatted query    View runnable query    Explain query
0.30 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: 
[]
View formatted query    View runnable query    Explain query
0.29 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: 
[]
View formatted query    View runnable query    Explain query
0.28 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: 
[]
View formatted query    View runnable query    Explain query
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: 
[]
View formatted query    View runnable query    Explain query
0.28 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: 
[]
View formatted query    View runnable query    Explain query
0.26 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: 
[]
View formatted query    View runnable query    Explain query
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: 
[]
View formatted query    View runnable query    Explain query
0.23 ms
(0.01%) 		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: 
[]
View formatted query    View runnable query    Explain query
0.21 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: 
[]
View formatted query    View runnable query    Explain query
0.21 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: 
[]
View formatted query    View runnable query    Explain query
0.19 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: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(0.01%) 		1 
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (14012385),(16329832),(1954287),(1944389),(4062685),(11432158),(1742419),(1743927),(1748613),(1748469),(1750146),(31820473),(1744268),(1943381),(1742670),(15103887),(48804066),(11329889),(1953708),(7364158),(1748634),(1749742),(1741295),(24767422),(1954000),(13468660),(4580781),(48804069),(18175240),(1741616),(48313371),(32449058),(6497577),(1736444),(1746508),(46409424),(1742867),(1739920),(1740105),(1749921),(1945464),(41655080),(1746266),(1745650),(24896602),(15432854),(16349108),(1739846),(1746105),(16943153),(36985954),(26956680),(2668546),(3283083),(1747203),(1944590),(1750211),(1742316),(1744000),(1944896),(1736268),(1744680),(48563836),(30838280),(31775662),(1744299),(1748326),(1748682),(15176277),(6553921),(1953633),(15176332),(1749431),(1945611),(1945485),(1740164),(1742359),(12963484),(33321359),(4062673),(1741314),(35562327),(1746933),(4062328),(1745241),(15116614),(27795127),(1748970),(1745175),(36022010),(2458797),(15465861),(1944069),(2667581),(9394208),(3190322),(34168343),(4062845),(1744810),(7571608),(31613769),(1945937),(1823225),(1746188),(47644595),(40661069),(48891238),(1740630),(8925967),(1944200),(1747444),(1739549),(1953564),(48891241),(1743384),(1952871),(46896212),(1744231),(1749371),(1945724),(1740806),(1944971),(47929048),(1741277),(1741776),(1745085),(1743467),(1744565),(1744654),(2671474),(2566254),(1944838),(12894895),(47240616),(1735817),(1742525),(1945097),(35908675),(1743705),(26899206),(2673150),(1748280),(4062664),(1745913),(1740503),(1736174),(6553969),(4062502),(6553977),(1745754),(1944467),(49299937),(2542786),(1954031),(4062628),(1746869),(8695297),(15399851),(4525596),(1945387),(22786995),(1743691),(4525581),(33321369),(4062381),(25086439),(1742632),(6494431),(1742553),(1746070),(6497526),(26477859),(26059963),(22149479),(6497553),(9491906),(1742445),(1749288),(50341773),(11892410),(49253798),(1946327),(6497563),(45830452),(1743288),(3022806),(1739806),(1745277),(1743121),(1742539),(23898669),(1739422),(1745878),(9798794),(1743212),(27436656),(1746966),(1739830),(1742389),(1748874),(1744760),(22149472),(1742341),(1744099),(6497598),(48981906),(12894885),(4062431),(2587898),(5732976),(1736494),(1741179),(45430771),(32570986),(1944638),(1748053),(1953230),(1741842),(32570989),(1740354),(4761786),(9665940),(33611480),(1743243),(34012809),(45532997),(1750061),(1742970),(1743173),(34372366),(15399861),(17184421),(1748239),(1744456),(6493635),(47644592),(17574337),(1743804),(13768757),(31820476),(1953843),(2458698),(1736412),(1744492),(1946351),(1736352),(41655076),(47693113),(49345129),(1749855),(45344641),(41909293),(48981909),(1743089),(7542353),(1746456),(30564071),(6553923),(1739695),(1749206),(17517682),(1952711),(49029361),(4791435),(48933696),(16942941),(29311463),(2611644),(41406325),(1735769),(1749264),(1736356),(48610530),(1748466),(1741720),(46409417),(1946429),(24767419),(1945246),(5612896),(1945227),(48563833),(1745374),(1747672),(10672408),(1747963),(30522747),(1745839),(1944279),(4704486),(6553917),(3045210),(1740843),(1944935),(1742580),(1743364),(1741980),(31406343),(1945531),(1750076),(22166841),(48265977),(15419089),(1945680),(2668273),(1742732),(1743486),(12216039),(1744087),(1742903),(1953538),(1744741),(48313374),(1742891),(1748796),(1741041),(1736068),(1740988),(1744374),(48313377),(1743226),(1745037),(1750182),(1944324),(1740280),(45479665),(1741019),(1745311),(7364155),(31406340),(49580925),(2667097),(6497634),(48265993),(4553064),(1744618),(1742817),(10106915),(6553925),(11758096),(9919871),(1741900),(1746888),(42442514),(9923960),(1953506),(1953332),(4062640),(3429558),(2978039),(38928823),(1747013),(1747228),(47601194),(49534198),(26848408),(6497583),(25577919),(1743604),(1736122),(22868106),(6497550),(42396774),(49345132),(1739520),(1743861),(1945182)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.15 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: 
[]
View formatted query    View runnable query    Explain query

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.