Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

84 Database Queries

27 Different statements

403.21 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
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
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
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
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
select o_id,contentScore,priority,bookable  from object_8 where o_published = 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
SELECT name FROM classes WHERE id = ?
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
select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT * FROM translations_messages LIMIT 1;
SELECT name FROM classes WHERE id = ?
SELECT id FROM sites
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM settings_store WHERE scope = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM sites
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT id FROM sites
SELECT id FROM sites
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT name FROM classes WHERE id = ?

#▲	Time	Info
1	0.32 ms	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 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 SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.17 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.26 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.33 ms	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: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query 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 SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.08 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.45 ms	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/Schladming-Dachstein/Vacation-planning/Accommodations" "sourcePathQuery" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=324114&nearbySearchLat=47.3751&nearbySearchLong=14.2689&sorting=nearbySearchAsc&page=71&randSeed=388" "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=324114&nearbySearchLat=47.3751&nearbySearchLong=14.2689&page=71&randSeed=388&sorting=nearbySearchAsc" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"] View formatted query View runnable query Explain query 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 SELECT * FROM redirects WHERE ( (source = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=324114&nearbySearchLat=47.3751&nearbySearchLong=14.2689&sorting=nearbySearchAsc&page=71&randSeed=388' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=324114&nearbySearchLat=47.3751&nearbySearchLong=14.2689&page=71&randSeed=388&sorting=nearbySearchAsc' AND `type` = 'entire_uri') ) 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;
8	0.15 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
9	0.33 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Accommodations" "path" => "/steiermark.com/en/Schladming-Dachstein/Vacation-planning/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';
10	0.30 ms	SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites ORDER BY ( SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC ;
11	0.35 ms	SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND ( siteId = 6 OR siteId = 0 ) ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;
12	0.13 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
13	0.29 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
14	0.34 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`7930`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 7930;
15	0.29 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`7159`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 7159;
16	0.18 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"31"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '31';
17	0.18 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
18	47.22 ms	select o_id,contentScore,priority,bookable from object_8 where o_published = 1 Parameters: [] View formatted query View runnable query Explain query select o_id, contentScore, priority, bookable from object_8 where o_published = 1 select o_id,contentScore,priority,bookable from object_8 where o_published = 1;
19	0.50 ms	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: [`11189`] View formatted query View runnable query Explain query 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 SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11189 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
20	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
21	0.35 ms	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: [`11408`] View formatted query View runnable query Explain query 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 SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11408 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
22	32.77 ms	select o_id as id, position__longitude as lon, position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL Parameters: [] View formatted query View runnable query Explain query select o_id as id, position__longitude as lon, position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL select o_id as id, position__longitude as lon, position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL;
23	0.30 ms	SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
24	0.21 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
25	0.26 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"Region"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'Region';
26	0.25 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
27	0.18 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`7930`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 7930;
28	0.24 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7159 7930 7930`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(7159, 7930) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7930;
29	0.17 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7930 7930`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 7930 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7930;
30	0.16 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7159 7159`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 7159 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7159;
31	0.32 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Accommodations" "path" => "/en/Schladming-Dachstein/Vacation-planning/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';
32	0.12 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';
33	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Accommodations" "path" => "/en/Schladming-Dachstein/Vacation-planning/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';
34	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';
35	0.19 ms	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/Schladming-Dachstein/Vacation-planning/Accommodations"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';
36	0.11 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Vacation-planning" "path" => "/en/Schladming-Dachstein/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/' AND `key` = BINARY 'Vacation-planning';
37	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning';
38	0.15 ms	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/Schladming-Dachstein/Vacation-planning"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Schladming-Dachstein/Vacation-planning';
39	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Schladming-Dachstein" "path" => "/en/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/en/' AND `key` = BINARY 'Schladming-Dachstein';
40	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/Schladming-Dachstein"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein';
41	0.15 ms	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/Schladming-Dachstein"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Schladming-Dachstein';
42	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "en" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'en';
43	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en';
44	0.14 ms	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"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en';
45	0.15 ms	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/%" ""`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '';
46	0.11 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY '';
47	0.14 ms	SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
48	0.18 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';
49	0.13 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "1" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '1' AND scope = 'pimcore_staticroutes';
50	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "2" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '2' AND scope = 'pimcore_staticroutes';
51	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "3" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '3' AND scope = 'pimcore_staticroutes';
52	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "4" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '4' AND scope = 'pimcore_staticroutes';
53	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "5" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '5' AND scope = 'pimcore_staticroutes';
54	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "6" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '6' AND scope = 'pimcore_staticroutes';
55	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "7" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '7' AND scope = 'pimcore_staticroutes';
56	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "8" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '8' AND scope = 'pimcore_staticroutes';
57	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "9" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '9' AND scope = 'pimcore_staticroutes';
58	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "10" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '10' AND scope = 'pimcore_staticroutes';
59	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "11" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '11' AND scope = 'pimcore_staticroutes';
60	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "12" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '12' AND scope = 'pimcore_staticroutes';
61	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "13" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '13' AND scope = 'pimcore_staticroutes';
62	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "15" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '15' AND scope = 'pimcore_staticroutes';
63	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "16" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '16' AND scope = 'pimcore_staticroutes';
64	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "17" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '17' AND scope = 'pimcore_staticroutes';
65	0.11 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "18" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '18' AND scope = 'pimcore_staticroutes';
66	0.10 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "19" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '19' AND scope = 'pimcore_staticroutes';
67	0.11 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "20" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '20' AND scope = 'pimcore_staticroutes';
68	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "21" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '21' AND scope = 'pimcore_staticroutes';
69	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "22" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '22' AND scope = 'pimcore_staticroutes';
70	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "23" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '23' AND scope = 'pimcore_staticroutes';
71	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "24" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '24' AND scope = 'pimcore_staticroutes';
72	0.10 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "25" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '25' AND scope = 'pimcore_staticroutes';
73	0.10 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "26" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '26' AND scope = 'pimcore_staticroutes';
74	0.10 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "27" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '27' AND scope = 'pimcore_staticroutes';
75	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "28" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '28' AND scope = 'pimcore_staticroutes';
76	0.21 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
77	0.26 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1524019`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1524019;
78	0.24 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
79	0.18 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
80	0.33 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`16088`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 16088;
81	0.31 ms	SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`5882755 "datepickerInfoTexts"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 5882755 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;
82	0.24 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';

demi_vacancies connection

#▲	Time	Info
1	20.33 ms	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 (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409)) GROUP BY dacco.oo_id ORDER BY RAND(388) Parameters: [] View formatted query View runnable query Explain query 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 ( 11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409 ) ) GROUP BY dacco.oo_id ORDER BY RAND(388) 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 (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409)) GROUP BY dacco.oo_id ORDER BY RAND(388) ;
2	289.31 ms	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 (104583,138736,150752,383497,211808,224332,162100,193028,174737,98309,245886,160345,172317,220348,190401,418173,180007,257470,192523,88849,6771981,242014,135685,94222,264448,212929,384102,79343,205493,121533,14557855,87409,124237,170725,4061616,206198,120394,130799,182129,89456,9517247,193068,99420,21211748,108195,143950,129897,91299,253939,197648,166611,110467,261158,147531,3379819,195314,205753,213537,250696,26648317,38622028,46461361,107057,190546,211891,176007,124337,89549,249148,133887,17594470,246469,202588,205800,168744,84203,72773,171978,256865,202690,139252,202441,2367452,156680,186795,177333,141880,182335,126983,111651,185795,130049,186138,145685,262579,208746,213925,212164,255495,207430,101873,246836,38050667,161875,228572,18810410,9887645,157224,265826,130741,187530,171662,265378,220170,80083,227732,73395,43751656,177240,256037,87380,102372,6771978,101403,263799,174798,101745,33072197,192033,174583,13979961,95652,96924,191455,168676,27128134,162257,103348,150197,181569,187073,49539249,84306,90162,221094,132606,98639,219645,189123,1173892,91180,151636,143682,103526,149700,208516,179767,157521,119097,122810,222689,268647,103499,207463,82521,245352,250174,266243,210439,170491,240646,195537,238918,114734,130455,243209,202800,267501,252035,31419712,94738,382988,79610,22568743,148602,222898,4061468,135012,155523,1173254,198498,154180,87340,23184951,195918,101229,194960,7678621,193149,201863,168651,84542,267314,149455,195136,97682,107672,9700358,166529,218293,5160340,131839,38008495,135252,268989,205836,36278962,220403,154758,198380,87856,98352,105761,268951,96354,185439,224446,155228,31514436,177510,249413,145003,203617,139730,170704,4580718,262617,260387,149059,97550,144028,76033,268279,228288,248414,89565,187460,167986,165965,7780777,81527,75643,169959,204204,8695139,125266,173474,200283,102697,383375,93789,38723937,88688,172344,139070,15243082,37868209,122307,4061851,268162,124606,6797421,226049,96500,77540,178337,171224,100682,173543,150724,189797,78974,103592,171085,181966,134714,227046,263121,5160343,210612,383027,109827,256958,183196,227558,268917,84734,265965,8591193,267530,179886,1173491,118447,1173542,143351,3224898,141729,159064,8566620,174035,206894,83605,48897409,101813,223333,91843,185598,151587,251659,113160,80940,191937,156882,255407,260943,76116,139639,20972969,196032,198534,266691,226977,265878,163692,121033,193372,32979456,186088,143537,73556,139146,197746,194884,30765443,26684056,11213840,203729,220655,128992,261287,132156,227647,172618,120883,136417,27808352,41214843,171431,223355,23945599,214433,244970,114017,176637,212689,219686,147191,142897,22892603,108520,94404,99678,190504,95043,189226,191047,192804,176897,75190,115545,247180,402843,138437,73689,48897791,178599,13400949,223044,149098,78233,91812,99228,8722785,82604,176727,142948,188477,212729,72244,169525,218042,207780,252859,1173693,146288,122838,207763,204651,22892606,269023,261823,243839,181278,104153,254574,199099,138609,221593,225114,152590,126485,246756,8388408,91914,243956,245240,10655859,163153,227270,268304,188963,192660,134133,166123,119054,108664,267623,81316,79926,107594,106347,202099,227134,170037,1173653,269445,265305,382743,109291,241860,191428,9700382,178215,11367104,218076,7016779,180306,157359,208674,222491,110338,203308,242260,210702,111233,154116,84439,120314,189598,22882595,106287,142776,77600,134094,204973,195225,75898,204855,78857,240386,122101,14669428,241670,105369,101798,75009,39558144,201319,138331,219804,29311567,263186,175902,27076239,189670,208902,129250,212394,151492,205629,31719532,109374,73318,179680,13723644,76562,218032,199295,194713,179813,160168,147609,210522,172278,7599993,114251,113751,218829,176200,120483,190150,145614,32742951,228314,125952,187911,211155,186176,161033,17275737,126658,220238,189988,249733,242815,266360,268424,207573,267700,245784,214015,127946,44224029,204745,202479,91479,37366700,42105593,91777,110677,240404,156225,129206,128526,96781,133247,41634802,203577,156310,80793,128141,227481,76091,119809,221211,5957902,17877742,114609,169666,150268,141656,219157,173849,148975,233730,186109,151225,44404593,102508,192842,122718,185065,246306,148079,26244429,8618578,116102,211256,186209,206641,145409,31665450,134322,175690,128321,252258,223652,187757,2470567,183391,108780,77357,164234,95383,143448,195347,90285,179242,124113,154873,1173742,87518,214160,90081,110842,195022,256818,95803,1173603,89349,15668814,176068,266442,173602,15659243,90791,147332,156556,101167,147869,101590,174941,34219679,164042,176992,146572,199850,177439,138939,212715,180460,226215,204827,266661,245060,27807955,85117,199934,10039806,204161,21237158,128777,104781,251064,252403,84906,146983,205724,1845849,128052,202896,218375,265768,81346,245659,165005,165025,262446,242072,4442181,201732,199538,188894,245836,98143,150349,226339,178072,39225141,73343,260508,79212,1173121,210887,190920,73900,179735,108052,142528,96544,145830,254246,202554,182441,115484,142376,3379718,20627345,33664677,225374,122139,147221,138273,197310,240120,86746,176975,209921,112984,147033,185888,260687,154301,207109,90363,218235,111003,164627,211866,213047,170790,122580,244711,157541,191407,196249,34719290,100623,31077769,265255,117486,194797,142256,263995,176296,262167,171549,158731,132963,122780,36566491,37667633,134210,106040,383360,88601,120627,189617,171164,135829,129096,187180,87012,102558,135403,224773,125055,130026,155984,220546,80881,109732,131135,228789,31789631,23220930,51503593,97982,163958,260291,20512295,134439,193518,195113,159538,111370,18332685,1173158,1173161,196171,181045,91679,3379737,118221,97116,114925,201425,157428,9700325,384050,119873,146486,118621,207942,111341,267023,125397,96112,38670305,148779,178677,107364,177255,3118747,197713,99548,110779,228081,175792,74757,128254,261224,102814,175319,83126,383256,176244,87970,106770,192306,171586,259359,128888,136200,241089,103365,198187,18810400,260577,31215812,5315068,106445,225967,198814,217376,94129,81720,29649833,117438,164573,213358,145494,27224568,113085,205897,163032,113392,260788,74091,18323640,78602,77134,101260,174181,242919,209807,158905,136526,7217358,172217,223395,39355239,17058949,383494,257803,90325,87124,88772,208831,261005,135730,157283,222266,129501,153833,267186,143038,84693,146703,96266,162327,250658,210718,3224895,96619,87314,85536,3029831,262061,220200,225007,198307,114505,178500,131018,225305,144833,193204,222990,242964,243999,220914,160845,133017,111742,9290160,107333,150874,141995,208109,255905,143260,262837,37868894,35522295,72611,115150,180106,228944,89745,253165,185698,134831,267915,181441,30148041,220948,105712,173273,86879,260555,23106643,192003,139196,142318,261487,46237639,198994,264897,74030,75853,74880,168114,254732,221442,383578,209483,245591,76900,171353,170382,85437,164128,249659,104513,227892,27199439,138703,268018,219299,103833,154821,218423,49169351,178544,128612,2566227,173880,255823,113626,114786,205199,240971,87071,110254,74427,5957896,250060,267580,157109,177852,95872,241967,107023,82308,47294199,4442184,180136,265468,89972,235840,90455,190210,221512,223285,87899,100829,41024653,190634,115132,136555,129814,208002,262206,268711,151031,122527,106657,203901,231694,269773,79494,382826,174544,155492,268827,88890,38621717,188297,115902,27808178,81639,124000,241827,80315,114041,75482,199742,171964,201789,115416,218521,50388225,209292,266888,106889,89709,203131,256266,89261,164198,141272,266112,155356,179118,223733,92309,191266,246876,162891,169612,192497,265066,199275,163837,132556,196083,150701,41796413,220483,45539296,174091,129031,140833,174338,383286,174987,193693,88121,191516,198592,144248,151300,151568,178916,204342,129533,197835,157061,204528,46904829,90672,164670,170902,267678,265584,110435,135205,195558,136496,262376,81753,97423,132704,266061,144062,98382,4442214,182314,147399,74297,261338,146397,195386,118332,7941416,186869,131774,98180,9290146,180387,147969,81217,177157,223466,91582,81094,158547,206854,111091,135953,1904411,51216654,218149,108105,132281,190061,243765,117646,124694,174680,75414,162361,383292,88291,28138429,220531,244217,240534,4791488,94373,199364,263716,27808362,259918,146183,116231,224525,143736,159639,200906,166027,164436,109501,257732,180717,261943,4442187,92184,156464,213869,139584,121638,228125,9395965,383672,10261747,109234,247967,241209,20708505,210751,176111,8388337,121323,194023,259974,247473,102266,242786,383118,222748,220877,194565,206591,141037,200435,2977929,43581664,178962,81984,110374,73135,74347,140245,200126,225195,157466,168470,267851,100061,165937,176457,149155,150070,384186,209194,248735,170765,154608,219012,136066,189166,144112,240156,99114,145447,261973,242703,250829,148562,7715980,199700,156762,221382,223613,108989,34636746,162948,80345,257010,9700322,194471,106094,229040,136181,34037741,37038521,220693,7967625,225267,185864,16306657,218867,240436,162969,74473,83792,44869050,383021,95945,97625,22840856,119029,203636,266341,77798,166311,119718,223510,12253627,244648,193721,2655510,142725,107555,114320,80548,190819,197250,263626,251539,83429,172512,251865,208378,85349,8722782,209213,244552,35700277,114455,256504,260733,384041,79763,98441,105748,162656,194917,217510,247897,42358761,175610,209351,219501,78778,156120,255713,229144,265930,384128,154226,212470,222458,383826,154051,227765,263334,125739,160614,23185284,160801,213843,82419,124718,33267404,148211,160274,18355899,135345,120959,73645,105395,199975,27486615,213132,260613,261585,162820,98121,173923,49539259,80509,245508,140325,165805,239438,84605,156724,3176489,192284,101969,211686,158481,161664,108003,201802,186236,200772,155681,142573,140362,26970115,219765,154459,43349109,213326,4061656,93903,163235,131179,6614248,7599929,4149175,13818591,27808188,251348,131085,269401,126702,183531,150008,75680,148376,195752,87219,149216,75959,193837,33072200,146129,15050850,21273299,192120,143202,167765,191815,247088,131790,212066,128649,91149,227190,228246,100207,9517217,156053,203147,73764,383006,268384,146150,121463,227403,75106,4791485,182482,118392,98021,193952,79701,213283,74121,4791491,239049,141562,226395,250387,162146,5315087,113819,209589,77069,203485,197379,251478,130324,223447,12371222,113462,83176,125661,155598,179201,229314,149007,185208,169799,89886,199831,98451,82805,107859,97583,173082,86586,156617,266814,250245,156918,160120,203882,168606,181736,77403,146259,244042,6775934,241513,169035,3411816,166076,187883,221136,164711,5315084,115353,181329,72528,111521,157401,4061962,4061766,229645,264308,139042,175232,113408,123820,124829,214424,208283,259576,7186183,102868,132768,166413,115753,135519,191210,204776,127993,139824,259830,250318,170268,211759,117916,158648,89073,21308116,7541413,14623690,46236871,245926,144556,261884,252832,229397,269658,26898515,186259,78111,7599407,224600,47202201,91383,145258,115223,182728,39995931,185961,105154,85808,87467,210768,9282725,254301,187408,242085,147152,241752,259743,170518,140059,244956,1173251,149642,266549,212576,249871,188242,212320,229470,127120,197565,227572,191155,383139,149400,139875,102976,23455826,115604,261090,151676,41752708,1173353,72285,4061779,177391,94870,187735,167903,234239,77676,209054,86366,86434,190874,98483,91521,256553,130955,101549,253709,139974,141808,21161019,151257,141472,8870626,111604,263240,179171,1173124,136036,96059,74534,255957,203394,20059276,79424,226499,160247,9129444,269473,144860,116132,175147,181884,143596,161406,103051,205363,13377190,164309,148899,257550,23106697,139671,185045,190383,22452518,47158244,39599857,108881,147915,144517,157149,194307,162295,35241603,5957905,150639,202202,209445,208932,144374,210638,180504,38300874,9700388,223960,254825,77223,189874,171766,159735,117877,160203,105477,228197,188200,183075,228856,220755,200595,100524,161142,170874,176678,76427,2853495,199572,41680612,221173,183290,209859,187810,111071,188163,241333,229095,4061812,79030,103317,108551,117802,90830,75600,227604,202332,189271,171116,212020,9872791,92398,206964,135125,97332,243243,168086,186921,145352,178433,263475,168884,130267,124869,192391,200867,143785,213063) 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 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 ( 104583, 138736, 150752, 383497, 211808, 224332, 162100, 193028, 174737, 98309, 245886, 160345, 172317, 220348, 190401, 418173, 180007, 257470, 192523, 88849, 6771981, 242014, 135685, 94222, 264448, 212929, 384102, 79343, 205493, 121533, 14557855, 87409, 124237, 170725, 4061616, 206198, 120394, 130799, 182129, 89456, 9517247, 193068, 99420, 21211748, 108195, 143950, 129897, 91299, 253939, 197648, 166611, 110467, 261158, 147531, 3379819, 195314, 205753, 213537, 250696, 26648317, 38622028, 46461361, 107057, 190546, 211891, 176007, 124337, 89549, 249148, 133887, 17594470, 246469, 202588, 205800, 168744, 84203, 72773, 171978, 256865, 202690, 139252, 202441, 2367452, 156680, 186795, 177333, 141880, 182335, 126983, 111651, 185795, 130049, 186138, 145685, 262579, 208746, 213925, 212164, 255495, 207430, 101873, 246836, 38050667, 161875, 228572, 18810410, 9887645, 157224, 265826, 130741, 187530, 171662, 265378, 220170, 80083, 227732, 73395, 43751656, 177240, 256037, 87380, 102372, 6771978, 101403, 263799, 174798, 101745, 33072197, 192033, 174583, 13979961, 95652, 96924, 191455, 168676, 27128134, 162257, 103348, 150197, 181569, 187073, 49539249, 84306, 90162, 221094, 132606, 98639, 219645, 189123, 1173892, 91180, 151636, 143682, 103526, 149700, 208516, 179767, 157521, 119097, 122810, 222689, 268647, 103499, 207463, 82521, 245352, 250174, 266243, 210439, 170491, 240646, 195537, 238918, 114734, 130455, 243209, 202800, 267501, 252035, 31419712, 94738, 382988, 79610, 22568743, 148602, 222898, 4061468, 135012, 155523, 1173254, 198498, 154180, 87340, 23184951, 195918, 101229, 194960, 7678621, 193149, 201863, 168651, 84542, 267314, 149455, 195136, 97682, 107672, 9700358, 166529, 218293, 5160340, 131839, 38008495, 135252, 268989, 205836, 36278962, 220403, 154758, 198380, 87856, 98352, 105761, 268951, 96354, 185439, 224446, 155228, 31514436, 177510, 249413, 145003, 203617, 139730, 170704, 4580718, 262617, 260387, 149059, 97550, 144028, 76033, 268279, 228288, 248414, 89565, 187460, 167986, 165965, 7780777, 81527, 75643, 169959, 204204, 8695139, 125266, 173474, 200283, 102697, 383375, 93789, 38723937, 88688, 172344, 139070, 15243082, 37868209, 122307, 4061851, 268162, 124606, 6797421, 226049, 96500, 77540, 178337, 171224, 100682, 173543, 150724, 189797, 78974, 103592, 171085, 181966, 134714, 227046, 263121, 5160343, 210612, 383027, 109827, 256958, 183196, 227558, 268917, 84734, 265965, 8591193, 267530, 179886, 1173491, 118447, 1173542, 143351, 3224898, 141729, 159064, 8566620, 174035, 206894, 83605, 48897409, 101813, 223333, 91843, 185598, 151587, 251659, 113160, 80940, 191937, 156882, 255407, 260943, 76116, 139639, 20972969, 196032, 198534, 266691, 226977, 265878, 163692, 121033, 193372, 32979456, 186088, 143537, 73556, 139146, 197746, 194884, 30765443, 26684056, 11213840, 203729, 220655, 128992, 261287, 132156, 227647, 172618, 120883, 136417, 27808352, 41214843, 171431, 223355, 23945599, 214433, 244970, 114017, 176637, 212689, 219686, 147191, 142897, 22892603, 108520, 94404, 99678, 190504, 95043, 189226, 191047, 192804, 176897, 75190, 115545, 247180, 402843, 138437, 73689, 48897791, 178599, 13400949, 223044, 149098, 78233, 91812, 99228, 8722785, 82604, 176727, 142948, 188477, 212729, 72244, 169525, 218042, 207780, 252859, 1173693, 146288, 122838, 207763, 204651, 22892606, 269023, 261823, 243839, 181278, 104153, 254574, 199099, 138609, 221593, 225114, 152590, 126485, 246756, 8388408, 91914, 243956, 245240, 10655859, 163153, 227270, 268304, 188963, 192660, 134133, 166123, 119054, 108664, 267623, 81316, 79926, 107594, 106347, 202099, 227134, 170037, 1173653, 269445, 265305, 382743, 109291, 241860, 191428, 9700382, 178215, 11367104, 218076, 7016779, 180306, 157359, 208674, 222491, 110338, 203308, 242260, 210702, 111233, 154116, 84439, 120314, 189598, 22882595, 106287, 142776, 77600, 134094, 204973, 195225, 75898, 204855, 78857, 240386, 122101, 14669428, 241670, 105369, 101798, 75009, 39558144, 201319, 138331, 219804, 29311567, 263186, 175902, 27076239, 189670, 208902, 129250, 212394, 151492, 205629, 31719532, 109374, 73318, 179680, 13723644, 76562, 218032, 199295, 194713, 179813, 160168, 147609, 210522, 172278, 7599993, 114251, 113751, 218829, 176200, 120483, 190150, 145614, 32742951, 228314, 125952, 187911, 211155, 186176, 161033, 17275737, 126658, 220238, 189988, 249733, 242815, 266360, 268424, 207573, 267700, 245784, 214015, 127946, 44224029, 204745, 202479, 91479, 37366700, 42105593, 91777, 110677, 240404, 156225, 129206, 128526, 96781, 133247, 41634802, 203577, 156310, 80793, 128141, 227481, 76091, 119809, 221211, 5957902, 17877742, 114609, 169666, 150268, 141656, 219157, 173849, 148975, 233730, 186109, 151225, 44404593, 102508, 192842, 122718, 185065, 246306, 148079, 26244429, 8618578, 116102, 211256, 186209, 206641, 145409, 31665450, 134322, 175690, 128321, 252258, 223652, 187757, 2470567, 183391, 108780, 77357, 164234, 95383, 143448, 195347, 90285, 179242, 124113, 154873, 1173742, 87518, 214160, 90081, 110842, 195022, 256818, 95803, 1173603, 89349, 15668814, 176068, 266442, 173602, 15659243, 90791, 147332, 156556, 101167, 147869, 101590, 174941, 34219679, 164042, 176992, 146572, 199850, 177439, 138939, 212715, 180460, 226215, 204827, 266661, 245060, 27807955, 85117, 199934, 10039806, 204161, 21237158, 128777, 104781, 251064, 252403, 84906, 146983, 205724, 1845849, 128052, 202896, 218375, 265768, 81346, 245659, 165005, 165025, 262446, 242072, 4442181, 201732, 199538, 188894, 245836, 98143, 150349, 226339, 178072, 39225141, 73343, 260508, 79212, 1173121, 210887, 190920, 73900, 179735, 108052, 142528, 96544, 145830, 254246, 202554, 182441, 115484, 142376, 3379718, 20627345, 33664677, 225374, 122139, 147221, 138273, 197310, 240120, 86746, 176975, 209921, 112984, 147033, 185888, 260687, 154301, 207109, 90363, 218235, 111003, 164627, 211866, 213047, 170790, 122580, 244711, 157541, 191407, 196249, 34719290, 100623, 31077769, 265255, 117486, 194797, 142256, 263995, 176296, 262167, 171549, 158731, 132963, 122780, 36566491, 37667633, 134210, 106040, 383360, 88601, 120627, 189617, 171164, 135829, 129096, 187180, 87012, 102558, 135403, 224773, 125055, 130026, 155984, 220546, 80881, 109732, 131135, 228789, 31789631, 23220930, 51503593, 97982, 163958, 260291, 20512295, 134439, 193518, 195113, 159538, 111370, 18332685, 1173158, 1173161, 196171, 181045, 91679, 3379737, 118221, 97116, 114925, 201425, 157428, 9700325, 384050, 119873, 146486, 118621, 207942, 111341, 267023, 125397, 96112, 38670305, 148779, 178677, 107364, 177255, 3118747, 197713, 99548, 110779, 228081, 175792, 74757, 128254, 261224, 102814, 175319, 83126, 383256, 176244, 87970, 106770, 192306, 171586, 259359, 128888, 136200, 241089, 103365, 198187, 18810400, 260577, 31215812, 5315068, 106445, 225967, 198814, 217376, 94129, 81720, 29649833, 117438, 164573, 213358, 145494, 27224568, 113085, 205897, 163032, 113392, 260788, 74091, 18323640, 78602, 77134, 101260, 174181, 242919, 209807, 158905, 136526, 7217358, 172217, 223395, 39355239, 17058949, 383494, 257803, 90325, 87124, 88772, 208831, 261005, 135730, 157283, 222266, 129501, 153833, 267186, 143038, 84693, 146703, 96266, 162327, 250658, 210718, 3224895, 96619, 87314, 85536, 3029831, 262061, 220200, 225007, 198307, 114505, 178500, 131018, 225305, 144833, 193204, 222990, 242964, 243999, 220914, 160845, 133017, 111742, 9290160, 107333, 150874, 141995, 208109, 255905, 143260, 262837, 37868894, 35522295, 72611, 115150, 180106, 228944, 89745, 253165, 185698, 134831, 267915, 181441, 30148041, 220948, 105712, 173273, 86879, 260555, 23106643, 192003, 139196, 142318, 261487, 46237639, 198994, 264897, 74030, 75853, 74880, 168114, 254732, 221442, 383578, 209483, 245591, 76900, 171353, 170382, 85437, 164128, 249659, 104513, 227892, 27199439, 138703, 268018, 219299, 103833, 154821, 218423, 49169351, 178544, 128612, 2566227, 173880, 255823, 113626, 114786, 205199, 240971, 87071, 110254, 74427, 5957896, 250060, 267580, 157109, 177852, 95872, 241967, 107023, 82308, 47294199, 4442184, 180136, 265468, 89972, 235840, 90455, 190210, 221512, 223285, 87899, 100829, 41024653, 190634, 115132, 136555, 129814, 208002, 262206, 268711, 151031, 122527, 106657, 203901, 231694, 269773, 79494, 382826, 174544, 155492, 268827, 88890, 38621717, 188297, 115902, 27808178, 81639, 124000, 241827, 80315, 114041, 75482, 199742, 171964, 201789, 115416, 218521, 50388225, 209292, 266888, 106889, 89709, 203131, 256266, 89261, 164198, 141272, 266112, 155356, 179118, 223733, 92309, 191266, 246876, 162891, 169612, 192497, 265066, 199275, 163837, 132556, 196083, 150701, 41796413, 220483, 45539296, 174091, 129031, 140833, 174338, 383286, 174987, 193693, 88121, 191516, 198592, 144248, 151300, 151568, 178916, 204342, 129533, 197835, 157061, 204528, 46904829, 90672, 164670, 170902, 267678, 265584, 110435, 135205, 195558, 136496, 262376, 81753, 97423, 132704, 266061, 144062, 98382, 4442214, 182314, 147399, 74297, 261338, 146397, 195386, 118332, 7941416, 186869, 131774, 98180, 9290146, 180387, 147969, 81217, 177157, 223466, 91582, 81094, 158547, 206854, 111091, 135953, 1904411, 51216654, 218149, 108105, 132281, 190061, 243765, 117646, 124694, 174680, 75414, 162361, 383292, 88291, 28138429, 220531, 244217, 240534, 4791488, 94373, 199364, 263716, 27808362, 259918, 146183, 116231, 224525, 143736, 159639, 200906, 166027, 164436, 109501, 257732, 180717, 261943, 4442187, 92184, 156464, 213869, 139584, 121638, 228125, 9395965, 383672, 10261747, 109234, 247967, 241209, 20708505, 210751, 176111, 8388337, 121323, 194023, 259974, 247473, 102266, 242786, 383118, 222748, 220877, 194565, 206591, 141037, 200435, 2977929, 43581664, 178962, 81984, 110374, 73135, 74347, 140245, 200126, 225195, 157466, 168470, 267851, 100061, 165937, 176457, 149155, 150070, 384186, 209194, 248735, 170765, 154608, 219012, 136066, 189166, 144112, 240156, 99114, 145447, 261973, 242703, 250829, 148562, 7715980, 199700, 156762, 221382, 223613, 108989, 34636746, 162948, 80345, 257010, 9700322, 194471, 106094, 229040, 136181, 34037741, 37038521, 220693, 7967625, 225267, 185864, 16306657, 218867, 240436, 162969, 74473, 83792, 44869050, 383021, 95945, 97625, 22840856, 119029, 203636, 266341, 77798, 166311, 119718, 223510, 12253627, 244648, 193721, 2655510, 142725, 107555, 114320, 80548, 190819, 197250, 263626, 251539, 83429, 172512, 251865, 208378, 85349, 8722782, 209213, 244552, 35700277, 114455, 256504, 260733, 384041, 79763, 98441, 105748, 162656, 194917, 217510, 247897, 42358761, 175610, 209351, 219501, 78778, 156120, 255713, 229144, 265930, 384128, 154226, 212470, 222458, 383826, 154051, 227765, 263334, 125739, 160614, 23185284, 160801, 213843, 82419, 124718, 33267404, 148211, 160274, 18355899, 135345, 120959, 73645, 105395, 199975, 27486615, 213132, 260613, 261585, 162820, 98121, 173923, 49539259, 80509, 245508, 140325, 165805, 239438, 84605, 156724, 3176489, 192284, 101969, 211686, 158481, 161664, 108003, 201802, 186236, 200772, 155681, 142573, 140362, 26970115, 219765, 154459, 43349109, 213326, 4061656, 93903, 163235, 131179, 6614248, 7599929, 4149175, 13818591, 27808188, 251348, 131085, 269401, 126702, 183531, 150008, 75680, 148376, 195752, 87219, 149216, 75959, 193837, 33072200, 146129, 15050850, 21273299, 192120, 143202, 167765, 191815, 247088, 131790, 212066, 128649, 91149, 227190, 228246, 100207, 9517217, 156053, 203147, 73764, 383006, 268384, 146150, 121463, 227403, 75106, 4791485, 182482, 118392, 98021, 193952, 79701, 213283, 74121, 4791491, 239049, 141562, 226395, 250387, 162146, 5315087, 113819, 209589, 77069, 203485, 197379, 251478, 130324, 223447, 12371222, 113462, 83176, 125661, 155598, 179201, 229314, 149007, 185208, 169799, 89886, 199831, 98451, 82805, 107859, 97583, 173082, 86586, 156617, 266814, 250245, 156918, 160120, 203882, 168606, 181736, 77403, 146259, 244042, 6775934, 241513, 169035, 3411816, 166076, 187883, 221136, 164711, 5315084, 115353, 181329, 72528, 111521, 157401, 4061962, 4061766, 229645, 264308, 139042, 175232, 113408, 123820, 124829, 214424, 208283, 259576, 7186183, 102868, 132768, 166413, 115753, 135519, 191210, 204776, 127993, 139824, 259830, 250318, 170268, 211759, 117916, 158648, 89073, 21308116, 7541413, 14623690, 46236871, 245926, 144556, 261884, 252832, 229397, 269658, 26898515, 186259, 78111, 7599407, 224600, 47202201, 91383, 145258, 115223, 182728, 39995931, 185961, 105154, 85808, 87467, 210768, 9282725, 254301, 187408, 242085, 147152, 241752, 259743, 170518, 140059, 244956, 1173251, 149642, 266549, 212576, 249871, 188242, 212320, 229470, 127120, 197565, 227572, 191155, 383139, 149400, 139875, 102976, 23455826, 115604, 261090, 151676, 41752708, 1173353, 72285, 4061779, 177391, 94870, 187735, 167903, 234239, 77676, 209054, 86366, 86434, 190874, 98483, 91521, 256553, 130955, 101549, 253709, 139974, 141808, 21161019, 151257, 141472, 8870626, 111604, 263240, 179171, 1173124, 136036, 96059, 74534, 255957, 203394, 20059276, 79424, 226499, 160247, 9129444, 269473, 144860, 116132, 175147, 181884, 143596, 161406, 103051, 205363, 13377190, 164309, 148899, 257550, 23106697, 139671, 185045, 190383, 22452518, 47158244, 39599857, 108881, 147915, 144517, 157149, 194307, 162295, 35241603, 5957905, 150639, 202202, 209445, 208932, 144374, 210638, 180504, 38300874, 9700388, 223960, 254825, 77223, 189874, 171766, 159735, 117877, 160203, 105477, 228197, 188200, 183075, 228856, 220755, 200595, 100524, 161142, 170874, 176678, 76427, 2853495, 199572, 41680612, 221173, 183290, 209859, 187810, 111071, 188163, 241333, 229095, 4061812, 79030, 103317, 108551, 117802, 90830, 75600, 227604, 202332, 189271, 171116, 212020, 9872791, 92398, 206964, 135125, 97332, 243243, 168086, 186921, 145352, 178433, 263475, 168884, 130267, 124869, 192391, 200867, 143785, 213063 ) 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 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 (104583,138736,150752,383497,211808,224332,162100,193028,174737,98309,245886,160345,172317,220348,190401,418173,180007,257470,192523,88849,6771981,242014,135685,94222,264448,212929,384102,79343,205493,121533,14557855,87409,124237,170725,4061616,206198,120394,130799,182129,89456,9517247,193068,99420,21211748,108195,143950,129897,91299,253939,197648,166611,110467,261158,147531,3379819,195314,205753,213537,250696,26648317,38622028,46461361,107057,190546,211891,176007,124337,89549,249148,133887,17594470,246469,202588,205800,168744,84203,72773,171978,256865,202690,139252,202441,2367452,156680,186795,177333,141880,182335,126983,111651,185795,130049,186138,145685,262579,208746,213925,212164,255495,207430,101873,246836,38050667,161875,228572,18810410,9887645,157224,265826,130741,187530,171662,265378,220170,80083,227732,73395,43751656,177240,256037,87380,102372,6771978,101403,263799,174798,101745,33072197,192033,174583,13979961,95652,96924,191455,168676,27128134,162257,103348,150197,181569,187073,49539249,84306,90162,221094,132606,98639,219645,189123,1173892,91180,151636,143682,103526,149700,208516,179767,157521,119097,122810,222689,268647,103499,207463,82521,245352,250174,266243,210439,170491,240646,195537,238918,114734,130455,243209,202800,267501,252035,31419712,94738,382988,79610,22568743,148602,222898,4061468,135012,155523,1173254,198498,154180,87340,23184951,195918,101229,194960,7678621,193149,201863,168651,84542,267314,149455,195136,97682,107672,9700358,166529,218293,5160340,131839,38008495,135252,268989,205836,36278962,220403,154758,198380,87856,98352,105761,268951,96354,185439,224446,155228,31514436,177510,249413,145003,203617,139730,170704,4580718,262617,260387,149059,97550,144028,76033,268279,228288,248414,89565,187460,167986,165965,7780777,81527,75643,169959,204204,8695139,125266,173474,200283,102697,383375,93789,38723937,88688,172344,139070,15243082,37868209,122307,4061851,268162,124606,6797421,226049,96500,77540,178337,171224,100682,173543,150724,189797,78974,103592,171085,181966,134714,227046,263121,5160343,210612,383027,109827,256958,183196,227558,268917,84734,265965,8591193,267530,179886,1173491,118447,1173542,143351,3224898,141729,159064,8566620,174035,206894,83605,48897409,101813,223333,91843,185598,151587,251659,113160,80940,191937,156882,255407,260943,76116,139639,20972969,196032,198534,266691,226977,265878,163692,121033,193372,32979456,186088,143537,73556,139146,197746,194884,30765443,26684056,11213840,203729,220655,128992,261287,132156,227647,172618,120883,136417,27808352,41214843,171431,223355,23945599,214433,244970,114017,176637,212689,219686,147191,142897,22892603,108520,94404,99678,190504,95043,189226,191047,192804,176897,75190,115545,247180,402843,138437,73689,48897791,178599,13400949,223044,149098,78233,91812,99228,8722785,82604,176727,142948,188477,212729,72244,169525,218042,207780,252859,1173693,146288,122838,207763,204651,22892606,269023,261823,243839,181278,104153,254574,199099,138609,221593,225114,152590,126485,246756,8388408,91914,243956,245240,10655859,163153,227270,268304,188963,192660,134133,166123,119054,108664,267623,81316,79926,107594,106347,202099,227134,170037,1173653,269445,265305,382743,109291,241860,191428,9700382,178215,11367104,218076,7016779,180306,157359,208674,222491,110338,203308,242260,210702,111233,154116,84439,120314,189598,22882595,106287,142776,77600,134094,204973,195225,75898,204855,78857,240386,122101,14669428,241670,105369,101798,75009,39558144,201319,138331,219804,29311567,263186,175902,27076239,189670,208902,129250,212394,151492,205629,31719532,109374,73318,179680,13723644,76562,218032,199295,194713,179813,160168,147609,210522,172278,7599993,114251,113751,218829,176200,120483,190150,145614,32742951,228314,125952,187911,211155,186176,161033,17275737,126658,220238,189988,249733,242815,266360,268424,207573,267700,245784,214015,127946,44224029,204745,202479,91479,37366700,42105593,91777,110677,240404,156225,129206,128526,96781,133247,41634802,203577,156310,80793,128141,227481,76091,119809,221211,5957902,17877742,114609,169666,150268,141656,219157,173849,148975,233730,186109,151225,44404593,102508,192842,122718,185065,246306,148079,26244429,8618578,116102,211256,186209,206641,145409,31665450,134322,175690,128321,252258,223652,187757,2470567,183391,108780,77357,164234,95383,143448,195347,90285,179242,124113,154873,1173742,87518,214160,90081,110842,195022,256818,95803,1173603,89349,15668814,176068,266442,173602,15659243,90791,147332,156556,101167,147869,101590,174941,34219679,164042,176992,146572,199850,177439,138939,212715,180460,226215,204827,266661,245060,27807955,85117,199934,10039806,204161,21237158,128777,104781,251064,252403,84906,146983,205724,1845849,128052,202896,218375,265768,81346,245659,165005,165025,262446,242072,4442181,201732,199538,188894,245836,98143,150349,226339,178072,39225141,73343,260508,79212,1173121,210887,190920,73900,179735,108052,142528,96544,145830,254246,202554,182441,115484,142376,3379718,20627345,33664677,225374,122139,147221,138273,197310,240120,86746,176975,209921,112984,147033,185888,260687,154301,207109,90363,218235,111003,164627,211866,213047,170790,122580,244711,157541,191407,196249,34719290,100623,31077769,265255,117486,194797,142256,263995,176296,262167,171549,158731,132963,122780,36566491,37667633,134210,106040,383360,88601,120627,189617,171164,135829,129096,187180,87012,102558,135403,224773,125055,130026,155984,220546,80881,109732,131135,228789,31789631,23220930,51503593,97982,163958,260291,20512295,134439,193518,195113,159538,111370,18332685,1173158,1173161,196171,181045,91679,3379737,118221,97116,114925,201425,157428,9700325,384050,119873,146486,118621,207942,111341,267023,125397,96112,38670305,148779,178677,107364,177255,3118747,197713,99548,110779,228081,175792,74757,128254,261224,102814,175319,83126,383256,176244,87970,106770,192306,171586,259359,128888,136200,241089,103365,198187,18810400,260577,31215812,5315068,106445,225967,198814,217376,94129,81720,29649833,117438,164573,213358,145494,27224568,113085,205897,163032,113392,260788,74091,18323640,78602,77134,101260,174181,242919,209807,158905,136526,7217358,172217,223395,39355239,17058949,383494,257803,90325,87124,88772,208831,261005,135730,157283,222266,129501,153833,267186,143038,84693,146703,96266,162327,250658,210718,3224895,96619,87314,85536,3029831,262061,220200,225007,198307,114505,178500,131018,225305,144833,193204,222990,242964,243999,220914,160845,133017,111742,9290160,107333,150874,141995,208109,255905,143260,262837,37868894,35522295,72611,115150,180106,228944,89745,253165,185698,134831,267915,181441,30148041,220948,105712,173273,86879,260555,23106643,192003,139196,142318,261487,46237639,198994,264897,74030,75853,74880,168114,254732,221442,383578,209483,245591,76900,171353,170382,85437,164128,249659,104513,227892,27199439,138703,268018,219299,103833,154821,218423,49169351,178544,128612,2566227,173880,255823,113626,114786,205199,240971,87071,110254,74427,5957896,250060,267580,157109,177852,95872,241967,107023,82308,47294199,4442184,180136,265468,89972,235840,90455,190210,221512,223285,87899,100829,41024653,190634,115132,136555,129814,208002,262206,268711,151031,122527,106657,203901,231694,269773,79494,382826,174544,155492,268827,88890,38621717,188297,115902,27808178,81639,124000,241827,80315,114041,75482,199742,171964,201789,115416,218521,50388225,209292,266888,106889,89709,203131,256266,89261,164198,141272,266112,155356,179118,223733,92309,191266,246876,162891,169612,192497,265066,199275,163837,132556,196083,150701,41796413,220483,45539296,174091,129031,140833,174338,383286,174987,193693,88121,191516,198592,144248,151300,151568,178916,204342,129533,197835,157061,204528,46904829,90672,164670,170902,267678,265584,110435,135205,195558,136496,262376,81753,97423,132704,266061,144062,98382,4442214,182314,147399,74297,261338,146397,195386,118332,7941416,186869,131774,98180,9290146,180387,147969,81217,177157,223466,91582,81094,158547,206854,111091,135953,1904411,51216654,218149,108105,132281,190061,243765,117646,124694,174680,75414,162361,383292,88291,28138429,220531,244217,240534,4791488,94373,199364,263716,27808362,259918,146183,116231,224525,143736,159639,200906,166027,164436,109501,257732,180717,261943,4442187,92184,156464,213869,139584,121638,228125,9395965,383672,10261747,109234,247967,241209,20708505,210751,176111,8388337,121323,194023,259974,247473,102266,242786,383118,222748,220877,194565,206591,141037,200435,2977929,43581664,178962,81984,110374,73135,74347,140245,200126,225195,157466,168470,267851,100061,165937,176457,149155,150070,384186,209194,248735,170765,154608,219012,136066,189166,144112,240156,99114,145447,261973,242703,250829,148562,7715980,199700,156762,221382,223613,108989,34636746,162948,80345,257010,9700322,194471,106094,229040,136181,34037741,37038521,220693,7967625,225267,185864,16306657,218867,240436,162969,74473,83792,44869050,383021,95945,97625,22840856,119029,203636,266341,77798,166311,119718,223510,12253627,244648,193721,2655510,142725,107555,114320,80548,190819,197250,263626,251539,83429,172512,251865,208378,85349,8722782,209213,244552,35700277,114455,256504,260733,384041,79763,98441,105748,162656,194917,217510,247897,42358761,175610,209351,219501,78778,156120,255713,229144,265930,384128,154226,212470,222458,383826,154051,227765,263334,125739,160614,23185284,160801,213843,82419,124718,33267404,148211,160274,18355899,135345,120959,73645,105395,199975,27486615,213132,260613,261585,162820,98121,173923,49539259,80509,245508,140325,165805,239438,84605,156724,3176489,192284,101969,211686,158481,161664,108003,201802,186236,200772,155681,142573,140362,26970115,219765,154459,43349109,213326,4061656,93903,163235,131179,6614248,7599929,4149175,13818591,27808188,251348,131085,269401,126702,183531,150008,75680,148376,195752,87219,149216,75959,193837,33072200,146129,15050850,21273299,192120,143202,167765,191815,247088,131790,212066,128649,91149,227190,228246,100207,9517217,156053,203147,73764,383006,268384,146150,121463,227403,75106,4791485,182482,118392,98021,193952,79701,213283,74121,4791491,239049,141562,226395,250387,162146,5315087,113819,209589,77069,203485,197379,251478,130324,223447,12371222,113462,83176,125661,155598,179201,229314,149007,185208,169799,89886,199831,98451,82805,107859,97583,173082,86586,156617,266814,250245,156918,160120,203882,168606,181736,77403,146259,244042,6775934,241513,169035,3411816,166076,187883,221136,164711,5315084,115353,181329,72528,111521,157401,4061962,4061766,229645,264308,139042,175232,113408,123820,124829,214424,208283,259576,7186183,102868,132768,166413,115753,135519,191210,204776,127993,139824,259830,250318,170268,211759,117916,158648,89073,21308116,7541413,14623690,46236871,245926,144556,261884,252832,229397,269658,26898515,186259,78111,7599407,224600,47202201,91383,145258,115223,182728,39995931,185961,105154,85808,87467,210768,9282725,254301,187408,242085,147152,241752,259743,170518,140059,244956,1173251,149642,266549,212576,249871,188242,212320,229470,127120,197565,227572,191155,383139,149400,139875,102976,23455826,115604,261090,151676,41752708,1173353,72285,4061779,177391,94870,187735,167903,234239,77676,209054,86366,86434,190874,98483,91521,256553,130955,101549,253709,139974,141808,21161019,151257,141472,8870626,111604,263240,179171,1173124,136036,96059,74534,255957,203394,20059276,79424,226499,160247,9129444,269473,144860,116132,175147,181884,143596,161406,103051,205363,13377190,164309,148899,257550,23106697,139671,185045,190383,22452518,47158244,39599857,108881,147915,144517,157149,194307,162295,35241603,5957905,150639,202202,209445,208932,144374,210638,180504,38300874,9700388,223960,254825,77223,189874,171766,159735,117877,160203,105477,228197,188200,183075,228856,220755,200595,100524,161142,170874,176678,76427,2853495,199572,41680612,221173,183290,209859,187810,111071,188163,241333,229095,4061812,79030,103317,108551,117802,90830,75600,227604,202332,189271,171116,212020,9872791,92398,206964,135125,97332,243243,168086,186921,145352,178433,263475,168884,130267,124869,192391,200867,143785,213063) 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 ;

#▲

Time

Info

20.33 ms

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 (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409))  GROUP BY dacco.oo_id  ORDER BY  RAND(388)

Parameters:

[]

View formatted query View runnable query Explain query

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 (
      11195, 11196, 11191, 11194, 11190, 3192509,
      11197, 11409
    )
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(388)

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 (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409))  GROUP BY dacco.oo_id  ORDER BY  RAND(388) ;

289.31 ms

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 (104583,138736,150752,383497,211808,224332,162100,193028,174737,98309,245886,160345,172317,220348,190401,418173,180007,257470,192523,88849,6771981,242014,135685,94222,264448,212929,384102,79343,205493,121533,14557855,87409,124237,170725,4061616,206198,120394,130799,182129,89456,9517247,193068,99420,21211748,108195,143950,129897,91299,253939,197648,166611,110467,261158,147531,3379819,195314,205753,213537,250696,26648317,38622028,46461361,107057,190546,211891,176007,124337,89549,249148,133887,17594470,246469,202588,205800,168744,84203,72773,171978,256865,202690,139252,202441,2367452,156680,186795,177333,141880,182335,126983,111651,185795,130049,186138,145685,262579,208746,213925,212164,255495,207430,101873,246836,38050667,161875,228572,18810410,9887645,157224,265826,130741,187530,171662,265378,220170,80083,227732,73395,43751656,177240,256037,87380,102372,6771978,101403,263799,174798,101745,33072197,192033,174583,13979961,95652,96924,191455,168676,27128134,162257,103348,150197,181569,187073,49539249,84306,90162,221094,132606,98639,219645,189123,1173892,91180,151636,143682,103526,149700,208516,179767,157521,119097,122810,222689,268647,103499,207463,82521,245352,250174,266243,210439,170491,240646,195537,238918,114734,130455,243209,202800,267501,252035,31419712,94738,382988,79610,22568743,148602,222898,4061468,135012,155523,1173254,198498,154180,87340,23184951,195918,101229,194960,7678621,193149,201863,168651,84542,267314,149455,195136,97682,107672,9700358,166529,218293,5160340,131839,38008495,135252,268989,205836,36278962,220403,154758,198380,87856,98352,105761,268951,96354,185439,224446,155228,31514436,177510,249413,145003,203617,139730,170704,4580718,262617,260387,149059,97550,144028,76033,268279,228288,248414,89565,187460,167986,165965,7780777,81527,75643,169959,204204,8695139,125266,173474,200283,102697,383375,93789,38723937,88688,172344,139070,15243082,37868209,122307,4061851,268162,124606,6797421,226049,96500,77540,178337,171224,100682,173543,150724,189797,78974,103592,171085,181966,134714,227046,263121,5160343,210612,383027,109827,256958,183196,227558,268917,84734,265965,8591193,267530,179886,1173491,118447,1173542,143351,3224898,141729,159064,8566620,174035,206894,83605,48897409,101813,223333,91843,185598,151587,251659,113160,80940,191937,156882,255407,260943,76116,139639,20972969,196032,198534,266691,226977,265878,163692,121033,193372,32979456,186088,143537,73556,139146,197746,194884,30765443,26684056,11213840,203729,220655,128992,261287,132156,227647,172618,120883,136417,27808352,41214843,171431,223355,23945599,214433,244970,114017,176637,212689,219686,147191,142897,22892603,108520,94404,99678,190504,95043,189226,191047,192804,176897,75190,115545,247180,402843,138437,73689,48897791,178599,13400949,223044,149098,78233,91812,99228,8722785,82604,176727,142948,188477,212729,72244,169525,218042,207780,252859,1173693,146288,122838,207763,204651,22892606,269023,261823,243839,181278,104153,254574,199099,138609,221593,225114,152590,126485,246756,8388408,91914,243956,245240,10655859,163153,227270,268304,188963,192660,134133,166123,119054,108664,267623,81316,79926,107594,106347,202099,227134,170037,1173653,269445,265305,382743,109291,241860,191428,9700382,178215,11367104,218076,7016779,180306,157359,208674,222491,110338,203308,242260,210702,111233,154116,84439,120314,189598,22882595,106287,142776,77600,134094,204973,195225,75898,204855,78857,240386,122101,14669428,241670,105369,101798,75009,39558144,201319,138331,219804,29311567,263186,175902,27076239,189670,208902,129250,212394,151492,205629,31719532,109374,73318,179680,13723644,76562,218032,199295,194713,179813,160168,147609,210522,172278,7599993,114251,113751,218829,176200,120483,190150,145614,32742951,228314,125952,187911,211155,186176,161033,17275737,126658,220238,189988,249733,242815,266360,268424,207573,267700,245784,214015,127946,44224029,204745,202479,91479,37366700,42105593,91777,110677,240404,156225,129206,128526,96781,133247,41634802,203577,156310,80793,128141,227481,76091,119809,221211,5957902,17877742,114609,169666,150268,141656,219157,173849,148975,233730,186109,151225,44404593,102508,192842,122718,185065,246306,148079,26244429,8618578,116102,211256,186209,206641,145409,31665450,134322,175690,128321,252258,223652,187757,2470567,183391,108780,77357,164234,95383,143448,195347,90285,179242,124113,154873,1173742,87518,214160,90081,110842,195022,256818,95803,1173603,89349,15668814,176068,266442,173602,15659243,90791,147332,156556,101167,147869,101590,174941,34219679,164042,176992,146572,199850,177439,138939,212715,180460,226215,204827,266661,245060,27807955,85117,199934,10039806,204161,21237158,128777,104781,251064,252403,84906,146983,205724,1845849,128052,202896,218375,265768,81346,245659,165005,165025,262446,242072,4442181,201732,199538,188894,245836,98143,150349,226339,178072,39225141,73343,260508,79212,1173121,210887,190920,73900,179735,108052,142528,96544,145830,254246,202554,182441,115484,142376,3379718,20627345,33664677,225374,122139,147221,138273,197310,240120,86746,176975,209921,112984,147033,185888,260687,154301,207109,90363,218235,111003,164627,211866,213047,170790,122580,244711,157541,191407,196249,34719290,100623,31077769,265255,117486,194797,142256,263995,176296,262167,171549,158731,132963,122780,36566491,37667633,134210,106040,383360,88601,120627,189617,171164,135829,129096,187180,87012,102558,135403,224773,125055,130026,155984,220546,80881,109732,131135,228789,31789631,23220930,51503593,97982,163958,260291,20512295,134439,193518,195113,159538,111370,18332685,1173158,1173161,196171,181045,91679,3379737,118221,97116,114925,201425,157428,9700325,384050,119873,146486,118621,207942,111341,267023,125397,96112,38670305,148779,178677,107364,177255,3118747,197713,99548,110779,228081,175792,74757,128254,261224,102814,175319,83126,383256,176244,87970,106770,192306,171586,259359,128888,136200,241089,103365,198187,18810400,260577,31215812,5315068,106445,225967,198814,217376,94129,81720,29649833,117438,164573,213358,145494,27224568,113085,205897,163032,113392,260788,74091,18323640,78602,77134,101260,174181,242919,209807,158905,136526,7217358,172217,223395,39355239,17058949,383494,257803,90325,87124,88772,208831,261005,135730,157283,222266,129501,153833,267186,143038,84693,146703,96266,162327,250658,210718,3224895,96619,87314,85536,3029831,262061,220200,225007,198307,114505,178500,131018,225305,144833,193204,222990,242964,243999,220914,160845,133017,111742,9290160,107333,150874,141995,208109,255905,143260,262837,37868894,35522295,72611,115150,180106,228944,89745,253165,185698,134831,267915,181441,30148041,220948,105712,173273,86879,260555,23106643,192003,139196,142318,261487,46237639,198994,264897,74030,75853,74880,168114,254732,221442,383578,209483,245591,76900,171353,170382,85437,164128,249659,104513,227892,27199439,138703,268018,219299,103833,154821,218423,49169351,178544,128612,2566227,173880,255823,113626,114786,205199,240971,87071,110254,74427,5957896,250060,267580,157109,177852,95872,241967,107023,82308,47294199,4442184,180136,265468,89972,235840,90455,190210,221512,223285,87899,100829,41024653,190634,115132,136555,129814,208002,262206,268711,151031,122527,106657,203901,231694,269773,79494,382826,174544,155492,268827,88890,38621717,188297,115902,27808178,81639,124000,241827,80315,114041,75482,199742,171964,201789,115416,218521,50388225,209292,266888,106889,89709,203131,256266,89261,164198,141272,266112,155356,179118,223733,92309,191266,246876,162891,169612,192497,265066,199275,163837,132556,196083,150701,41796413,220483,45539296,174091,129031,140833,174338,383286,174987,193693,88121,191516,198592,144248,151300,151568,178916,204342,129533,197835,157061,204528,46904829,90672,164670,170902,267678,265584,110435,135205,195558,136496,262376,81753,97423,132704,266061,144062,98382,4442214,182314,147399,74297,261338,146397,195386,118332,7941416,186869,131774,98180,9290146,180387,147969,81217,177157,223466,91582,81094,158547,206854,111091,135953,1904411,51216654,218149,108105,132281,190061,243765,117646,124694,174680,75414,162361,383292,88291,28138429,220531,244217,240534,4791488,94373,199364,263716,27808362,259918,146183,116231,224525,143736,159639,200906,166027,164436,109501,257732,180717,261943,4442187,92184,156464,213869,139584,121638,228125,9395965,383672,10261747,109234,247967,241209,20708505,210751,176111,8388337,121323,194023,259974,247473,102266,242786,383118,222748,220877,194565,206591,141037,200435,2977929,43581664,178962,81984,110374,73135,74347,140245,200126,225195,157466,168470,267851,100061,165937,176457,149155,150070,384186,209194,248735,170765,154608,219012,136066,189166,144112,240156,99114,145447,261973,242703,250829,148562,7715980,199700,156762,221382,223613,108989,34636746,162948,80345,257010,9700322,194471,106094,229040,136181,34037741,37038521,220693,7967625,225267,185864,16306657,218867,240436,162969,74473,83792,44869050,383021,95945,97625,22840856,119029,203636,266341,77798,166311,119718,223510,12253627,244648,193721,2655510,142725,107555,114320,80548,190819,197250,263626,251539,83429,172512,251865,208378,85349,8722782,209213,244552,35700277,114455,256504,260733,384041,79763,98441,105748,162656,194917,217510,247897,42358761,175610,209351,219501,78778,156120,255713,229144,265930,384128,154226,212470,222458,383826,154051,227765,263334,125739,160614,23185284,160801,213843,82419,124718,33267404,148211,160274,18355899,135345,120959,73645,105395,199975,27486615,213132,260613,261585,162820,98121,173923,49539259,80509,245508,140325,165805,239438,84605,156724,3176489,192284,101969,211686,158481,161664,108003,201802,186236,200772,155681,142573,140362,26970115,219765,154459,43349109,213326,4061656,93903,163235,131179,6614248,7599929,4149175,13818591,27808188,251348,131085,269401,126702,183531,150008,75680,148376,195752,87219,149216,75959,193837,33072200,146129,15050850,21273299,192120,143202,167765,191815,247088,131790,212066,128649,91149,227190,228246,100207,9517217,156053,203147,73764,383006,268384,146150,121463,227403,75106,4791485,182482,118392,98021,193952,79701,213283,74121,4791491,239049,141562,226395,250387,162146,5315087,113819,209589,77069,203485,197379,251478,130324,223447,12371222,113462,83176,125661,155598,179201,229314,149007,185208,169799,89886,199831,98451,82805,107859,97583,173082,86586,156617,266814,250245,156918,160120,203882,168606,181736,77403,146259,244042,6775934,241513,169035,3411816,166076,187883,221136,164711,5315084,115353,181329,72528,111521,157401,4061962,4061766,229645,264308,139042,175232,113408,123820,124829,214424,208283,259576,7186183,102868,132768,166413,115753,135519,191210,204776,127993,139824,259830,250318,170268,211759,117916,158648,89073,21308116,7541413,14623690,46236871,245926,144556,261884,252832,229397,269658,26898515,186259,78111,7599407,224600,47202201,91383,145258,115223,182728,39995931,185961,105154,85808,87467,210768,9282725,254301,187408,242085,147152,241752,259743,170518,140059,244956,1173251,149642,266549,212576,249871,188242,212320,229470,127120,197565,227572,191155,383139,149400,139875,102976,23455826,115604,261090,151676,41752708,1173353,72285,4061779,177391,94870,187735,167903,234239,77676,209054,86366,86434,190874,98483,91521,256553,130955,101549,253709,139974,141808,21161019,151257,141472,8870626,111604,263240,179171,1173124,136036,96059,74534,255957,203394,20059276,79424,226499,160247,9129444,269473,144860,116132,175147,181884,143596,161406,103051,205363,13377190,164309,148899,257550,23106697,139671,185045,190383,22452518,47158244,39599857,108881,147915,144517,157149,194307,162295,35241603,5957905,150639,202202,209445,208932,144374,210638,180504,38300874,9700388,223960,254825,77223,189874,171766,159735,117877,160203,105477,228197,188200,183075,228856,220755,200595,100524,161142,170874,176678,76427,2853495,199572,41680612,221173,183290,209859,187810,111071,188163,241333,229095,4061812,79030,103317,108551,117802,90830,75600,227604,202332,189271,171116,212020,9872791,92398,206964,135125,97332,243243,168086,186921,145352,178433,263475,168884,130267,124869,192391,200867,143785,213063)
                  
                   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

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 (
    104583,
    138736,
    150752,
    383497,
    211808,
    224332,
    162100,
    193028,
    174737,
    98309,
    245886,
    160345,
    172317,
    220348,
    190401,
    418173,
    180007,
    257470,
    192523,
    88849,
    6771981,
    242014,
    135685,
    94222,
    264448,
    212929,
    384102,
    79343,
    205493,
    121533,
    14557855,
    87409,
    124237,
    170725,
    4061616,
    206198,
    120394,
    130799,
    182129,
    89456,
    9517247,
    193068,
    99420,
    21211748,
    108195,
    143950,
    129897,
    91299,
    253939,
    197648,
    166611,
    110467,
    261158,
    147531,
    3379819,
    195314,
    205753,
    213537,
    250696,
    26648317,
    38622028,
    46461361,
    107057,
    190546,
    211891,
    176007,
    124337,
    89549,
    249148,
    133887,
    17594470,
    246469,
    202588,
    205800,
    168744,
    84203,
    72773,
    171978,
    256865,
    202690,
    139252,
    202441,
    2367452,
    156680,
    186795,
    177333,
    141880,
    182335,
    126983,
    111651,
    185795,
    130049,
    186138,
    145685,
    262579,
    208746,
    213925,
    212164,
    255495,
    207430,
    101873,
    246836,
    38050667,
    161875,
    228572,
    18810410,
    9887645,
    157224,
    265826,
    130741,
    187530,
    171662,
    265378,
    220170,
    80083,
    227732,
    73395,
    43751656,
    177240,
    256037,
    87380,
    102372,
    6771978,
    101403,
    263799,
    174798,
    101745,
    33072197,
    192033,
    174583,
    13979961,
    95652,
    96924,
    191455,
    168676,
    27128134,
    162257,
    103348,
    150197,
    181569,
    187073,
    49539249,
    84306,
    90162,
    221094,
    132606,
    98639,
    219645,
    189123,
    1173892,
    91180,
    151636,
    143682,
    103526,
    149700,
    208516,
    179767,
    157521,
    119097,
    122810,
    222689,
    268647,
    103499,
    207463,
    82521,
    245352,
    250174,
    266243,
    210439,
    170491,
    240646,
    195537,
    238918,
    114734,
    130455,
    243209,
    202800,
    267501,
    252035,
    31419712,
    94738,
    382988,
    79610,
    22568743,
    148602,
    222898,
    4061468,
    135012,
    155523,
    1173254,
    198498,
    154180,
    87340,
    23184951,
    195918,
    101229,
    194960,
    7678621,
    193149,
    201863,
    168651,
    84542,
    267314,
    149455,
    195136,
    97682,
    107672,
    9700358,
    166529,
    218293,
    5160340,
    131839,
    38008495,
    135252,
    268989,
    205836,
    36278962,
    220403,
    154758,
    198380,
    87856,
    98352,
    105761,
    268951,
    96354,
    185439,
    224446,
    155228,
    31514436,
    177510,
    249413,
    145003,
    203617,
    139730,
    170704,
    4580718,
    262617,
    260387,
    149059,
    97550,
    144028,
    76033,
    268279,
    228288,
    248414,
    89565,
    187460,
    167986,
    165965,
    7780777,
    81527,
    75643,
    169959,
    204204,
    8695139,
    125266,
    173474,
    200283,
    102697,
    383375,
    93789,
    38723937,
    88688,
    172344,
    139070,
    15243082,
    37868209,
    122307,
    4061851,
    268162,
    124606,
    6797421,
    226049,
    96500,
    77540,
    178337,
    171224,
    100682,
    173543,
    150724,
    189797,
    78974,
    103592,
    171085,
    181966,
    134714,
    227046,
    263121,
    5160343,
    210612,
    383027,
    109827,
    256958,
    183196,
    227558,
    268917,
    84734,
    265965,
    8591193,
    267530,
    179886,
    1173491,
    118447,
    1173542,
    143351,
    3224898,
    141729,
    159064,
    8566620,
    174035,
    206894,
    83605,
    48897409,
    101813,
    223333,
    91843,
    185598,
    151587,
    251659,
    113160,
    80940,
    191937,
    156882,
    255407,
    260943,
    76116,
    139639,
    20972969,
    196032,
    198534,
    266691,
    226977,
    265878,
    163692,
    121033,
    193372,
    32979456,
    186088,
    143537,
    73556,
    139146,
    197746,
    194884,
    30765443,
    26684056,
    11213840,
    203729,
    220655,
    128992,
    261287,
    132156,
    227647,
    172618,
    120883,
    136417,
    27808352,
    41214843,
    171431,
    223355,
    23945599,
    214433,
    244970,
    114017,
    176637,
    212689,
    219686,
    147191,
    142897,
    22892603,
    108520,
    94404,
    99678,
    190504,
    95043,
    189226,
    191047,
    192804,
    176897,
    75190,
    115545,
    247180,
    402843,
    138437,
    73689,
    48897791,
    178599,
    13400949,
    223044,
    149098,
    78233,
    91812,
    99228,
    8722785,
    82604,
    176727,
    142948,
    188477,
    212729,
    72244,
    169525,
    218042,
    207780,
    252859,
    1173693,
    146288,
    122838,
    207763,
    204651,
    22892606,
    269023,
    261823,
    243839,
    181278,
    104153,
    254574,
    199099,
    138609,
    221593,
    225114,
    152590,
    126485,
    246756,
    8388408,
    91914,
    243956,
    245240,
    10655859,
    163153,
    227270,
    268304,
    188963,
    192660,
    134133,
    166123,
    119054,
    108664,
    267623,
    81316,
    79926,
    107594,
    106347,
    202099,
    227134,
    170037,
    1173653,
    269445,
    265305,
    382743,
    109291,
    241860,
    191428,
    9700382,
    178215,
    11367104,
    218076,
    7016779,
    180306,
    157359,
    208674,
    222491,
    110338,
    203308,
    242260,
    210702,
    111233,
    154116,
    84439,
    120314,
    189598,
    22882595,
    106287,
    142776,
    77600,
    134094,
    204973,
    195225,
    75898,
    204855,
    78857,
    240386,
    122101,
    14669428,
    241670,
    105369,
    101798,
    75009,
    39558144,
    201319,
    138331,
    219804,
    29311567,
    263186,
    175902,
    27076239,
    189670,
    208902,
    129250,
    212394,
    151492,
    205629,
    31719532,
    109374,
    73318,
    179680,
    13723644,
    76562,
    218032,
    199295,
    194713,
    179813,
    160168,
    147609,
    210522,
    172278,
    7599993,
    114251,
    113751,
    218829,
    176200,
    120483,
    190150,
    145614,
    32742951,
    228314,
    125952,
    187911,
    211155,
    186176,
    161033,
    17275737,
    126658,
    220238,
    189988,
    249733,
    242815,
    266360,
    268424,
    207573,
    267700,
    245784,
    214015,
    127946,
    44224029,
    204745,
    202479,
    91479,
    37366700,
    42105593,
    91777,
    110677,
    240404,
    156225,
    129206,
    128526,
    96781,
    133247,
    41634802,
    203577,
    156310,
    80793,
    128141,
    227481,
    76091,
    119809,
    221211,
    5957902,
    17877742,
    114609,
    169666,
    150268,
    141656,
    219157,
    173849,
    148975,
    233730,
    186109,
    151225,
    44404593,
    102508,
    192842,
    122718,
    185065,
    246306,
    148079,
    26244429,
    8618578,
    116102,
    211256,
    186209,
    206641,
    145409,
    31665450,
    134322,
    175690,
    128321,
    252258,
    223652,
    187757,
    2470567,
    183391,
    108780,
    77357,
    164234,
    95383,
    143448,
    195347,
    90285,
    179242,
    124113,
    154873,
    1173742,
    87518,
    214160,
    90081,
    110842,
    195022,
    256818,
    95803,
    1173603,
    89349,
    15668814,
    176068,
    266442,
    173602,
    15659243,
    90791,
    147332,
    156556,
    101167,
    147869,
    101590,
    174941,
    34219679,
    164042,
    176992,
    146572,
    199850,
    177439,
    138939,
    212715,
    180460,
    226215,
    204827,
    266661,
    245060,
    27807955,
    85117,
    199934,
    10039806,
    204161,
    21237158,
    128777,
    104781,
    251064,
    252403,
    84906,
    146983,
    205724,
    1845849,
    128052,
    202896,
    218375,
    265768,
    81346,
    245659,
    165005,
    165025,
    262446,
    242072,
    4442181,
    201732,
    199538,
    188894,
    245836,
    98143,
    150349,
    226339,
    178072,
    39225141,
    73343,
    260508,
    79212,
    1173121,
    210887,
    190920,
    73900,
    179735,
    108052,
    142528,
    96544,
    145830,
    254246,
    202554,
    182441,
    115484,
    142376,
    3379718,
    20627345,
    33664677,
    225374,
    122139,
    147221,
    138273,
    197310,
    240120,
    86746,
    176975,
    209921,
    112984,
    147033,
    185888,
    260687,
    154301,
    207109,
    90363,
    218235,
    111003,
    164627,
    211866,
    213047,
    170790,
    122580,
    244711,
    157541,
    191407,
    196249,
    34719290,
    100623,
    31077769,
    265255,
    117486,
    194797,
    142256,
    263995,
    176296,
    262167,
    171549,
    158731,
    132963,
    122780,
    36566491,
    37667633,
    134210,
    106040,
    383360,
    88601,
    120627,
    189617,
    171164,
    135829,
    129096,
    187180,
    87012,
    102558,
    135403,
    224773,
    125055,
    130026,
    155984,
    220546,
    80881,
    109732,
    131135,
    228789,
    31789631,
    23220930,
    51503593,
    97982,
    163958,
    260291,
    20512295,
    134439,
    193518,
    195113,
    159538,
    111370,
    18332685,
    1173158,
    1173161,
    196171,
    181045,
    91679,
    3379737,
    118221,
    97116,
    114925,
    201425,
    157428,
    9700325,
    384050,
    119873,
    146486,
    118621,
    207942,
    111341,
    267023,
    125397,
    96112,
    38670305,
    148779,
    178677,
    107364,
    177255,
    3118747,
    197713,
    99548,
    110779,
    228081,
    175792,
    74757,
    128254,
    261224,
    102814,
    175319,
    83126,
    383256,
    176244,
    87970,
    106770,
    192306,
    171586,
    259359,
    128888,
    136200,
    241089,
    103365,
    198187,
    18810400,
    260577,
    31215812,
    5315068,
    106445,
    225967,
    198814,
    217376,
    94129,
    81720,
    29649833,
    117438,
    164573,
    213358,
    145494,
    27224568,
    113085,
    205897,
    163032,
    113392,
    260788,
    74091,
    18323640,
    78602,
    77134,
    101260,
    174181,
    242919,
    209807,
    158905,
    136526,
    7217358,
    172217,
    223395,
    39355239,
    17058949,
    383494,
    257803,
    90325,
    87124,
    88772,
    208831,
    261005,
    135730,
    157283,
    222266,
    129501,
    153833,
    267186,
    143038,
    84693,
    146703,
    96266,
    162327,
    250658,
    210718,
    3224895,
    96619,
    87314,
    85536,
    3029831,
    262061,
    220200,
    225007,
    198307,
    114505,
    178500,
    131018,
    225305,
    144833,
    193204,
    222990,
    242964,
    243999,
    220914,
    160845,
    133017,
    111742,
    9290160,
    107333,
    150874,
    141995,
    208109,
    255905,
    143260,
    262837,
    37868894,
    35522295,
    72611,
    115150,
    180106,
    228944,
    89745,
    253165,
    185698,
    134831,
    267915,
    181441,
    30148041,
    220948,
    105712,
    173273,
    86879,
    260555,
    23106643,
    192003,
    139196,
    142318,
    261487,
    46237639,
    198994,
    264897,
    74030,
    75853,
    74880,
    168114,
    254732,
    221442,
    383578,
    209483,
    245591,
    76900,
    171353,
    170382,
    85437,
    164128,
    249659,
    104513,
    227892,
    27199439,
    138703,
    268018,
    219299,
    103833,
    154821,
    218423,
    49169351,
    178544,
    128612,
    2566227,
    173880,
    255823,
    113626,
    114786,
    205199,
    240971,
    87071,
    110254,
    74427,
    5957896,
    250060,
    267580,
    157109,
    177852,
    95872,
    241967,
    107023,
    82308,
    47294199,
    4442184,
    180136,
    265468,
    89972,
    235840,
    90455,
    190210,
    221512,
    223285,
    87899,
    100829,
    41024653,
    190634,
    115132,
    136555,
    129814,
    208002,
    262206,
    268711,
    151031,
    122527,
    106657,
    203901,
    231694,
    269773,
    79494,
    382826,
    174544,
    155492,
    268827,
    88890,
    38621717,
    188297,
    115902,
    27808178,
    81639,
    124000,
    241827,
    80315,
    114041,
    75482,
    199742,
    171964,
    201789,
    115416,
    218521,
    50388225,
    209292,
    266888,
    106889,
    89709,
    203131,
    256266,
    89261,
    164198,
    141272,
    266112,
    155356,
    179118,
    223733,
    92309,
    191266,
    246876,
    162891,
    169612,
    192497,
    265066,
    199275,
    163837,
    132556,
    196083,
    150701,
    41796413,
    220483,
    45539296,
    174091,
    129031,
    140833,
    174338,
    383286,
    174987,
    193693,
    88121,
    191516,
    198592,
    144248,
    151300,
    151568,
    178916,
    204342,
    129533,
    197835,
    157061,
    204528,
    46904829,
    90672,
    164670,
    170902,
    267678,
    265584,
    110435,
    135205,
    195558,
    136496,
    262376,
    81753,
    97423,
    132704,
    266061,
    144062,
    98382,
    4442214,
    182314,
    147399,
    74297,
    261338,
    146397,
    195386,
    118332,
    7941416,
    186869,
    131774,
    98180,
    9290146,
    180387,
    147969,
    81217,
    177157,
    223466,
    91582,
    81094,
    158547,
    206854,
    111091,
    135953,
    1904411,
    51216654,
    218149,
    108105,
    132281,
    190061,
    243765,
    117646,
    124694,
    174680,
    75414,
    162361,
    383292,
    88291,
    28138429,
    220531,
    244217,
    240534,
    4791488,
    94373,
    199364,
    263716,
    27808362,
    259918,
    146183,
    116231,
    224525,
    143736,
    159639,
    200906,
    166027,
    164436,
    109501,
    257732,
    180717,
    261943,
    4442187,
    92184,
    156464,
    213869,
    139584,
    121638,
    228125,
    9395965,
    383672,
    10261747,
    109234,
    247967,
    241209,
    20708505,
    210751,
    176111,
    8388337,
    121323,
    194023,
    259974,
    247473,
    102266,
    242786,
    383118,
    222748,
    220877,
    194565,
    206591,
    141037,
    200435,
    2977929,
    43581664,
    178962,
    81984,
    110374,
    73135,
    74347,
    140245,
    200126,
    225195,
    157466,
    168470,
    267851,
    100061,
    165937,
    176457,
    149155,
    150070,
    384186,
    209194,
    248735,
    170765,
    154608,
    219012,
    136066,
    189166,
    144112,
    240156,
    99114,
    145447,
    261973,
    242703,
    250829,
    148562,
    7715980,
    199700,
    156762,
    221382,
    223613,
    108989,
    34636746,
    162948,
    80345,
    257010,
    9700322,
    194471,
    106094,
    229040,
    136181,
    34037741,
    37038521,
    220693,
    7967625,
    225267,
    185864,
    16306657,
    218867,
    240436,
    162969,
    74473,
    83792,
    44869050,
    383021,
    95945,
    97625,
    22840856,
    119029,
    203636,
    266341,
    77798,
    166311,
    119718,
    223510,
    12253627,
    244648,
    193721,
    2655510,
    142725,
    107555,
    114320,
    80548,
    190819,
    197250,
    263626,
    251539,
    83429,
    172512,
    251865,
    208378,
    85349,
    8722782,
    209213,
    244552,
    35700277,
    114455,
    256504,
    260733,
    384041,
    79763,
    98441,
    105748,
    162656,
    194917,
    217510,
    247897,
    42358761,
    175610,
    209351,
    219501,
    78778,
    156120,
    255713,
    229144,
    265930,
    384128,
    154226,
    212470,
    222458,
    383826,
    154051,
    227765,
    263334,
    125739,
    160614,
    23185284,
    160801,
    213843,
    82419,
    124718,
    33267404,
    148211,
    160274,
    18355899,
    135345,
    120959,
    73645,
    105395,
    199975,
    27486615,
    213132,
    260613,
    261585,
    162820,
    98121,
    173923,
    49539259,
    80509,
    245508,
    140325,
    165805,
    239438,
    84605,
    156724,
    3176489,
    192284,
    101969,
    211686,
    158481,
    161664,
    108003,
    201802,
    186236,
    200772,
    155681,
    142573,
    140362,
    26970115,
    219765,
    154459,
    43349109,
    213326,
    4061656,
    93903,
    163235,
    131179,
    6614248,
    7599929,
    4149175,
    13818591,
    27808188,
    251348,
    131085,
    269401,
    126702,
    183531,
    150008,
    75680,
    148376,
    195752,
    87219,
    149216,
    75959,
    193837,
    33072200,
    146129,
    15050850,
    21273299,
    192120,
    143202,
    167765,
    191815,
    247088,
    131790,
    212066,
    128649,
    91149,
    227190,
    228246,
    100207,
    9517217,
    156053,
    203147,
    73764,
    383006,
    268384,
    146150,
    121463,
    227403,
    75106,
    4791485,
    182482,
    118392,
    98021,
    193952,
    79701,
    213283,
    74121,
    4791491,
    239049,
    141562,
    226395,
    250387,
    162146,
    5315087,
    113819,
    209589,
    77069,
    203485,
    197379,
    251478,
    130324,
    223447,
    12371222,
    113462,
    83176,
    125661,
    155598,
    179201,
    229314,
    149007,
    185208,
    169799,
    89886,
    199831,
    98451,
    82805,
    107859,
    97583,
    173082,
    86586,
    156617,
    266814,
    250245,
    156918,
    160120,
    203882,
    168606,
    181736,
    77403,
    146259,
    244042,
    6775934,
    241513,
    169035,
    3411816,
    166076,
    187883,
    221136,
    164711,
    5315084,
    115353,
    181329,
    72528,
    111521,
    157401,
    4061962,
    4061766,
    229645,
    264308,
    139042,
    175232,
    113408,
    123820,
    124829,
    214424,
    208283,
    259576,
    7186183,
    102868,
    132768,
    166413,
    115753,
    135519,
    191210,
    204776,
    127993,
    139824,
    259830,
    250318,
    170268,
    211759,
    117916,
    158648,
    89073,
    21308116,
    7541413,
    14623690,
    46236871,
    245926,
    144556,
    261884,
    252832,
    229397,
    269658,
    26898515,
    186259,
    78111,
    7599407,
    224600,
    47202201,
    91383,
    145258,
    115223,
    182728,
    39995931,
    185961,
    105154,
    85808,
    87467,
    210768,
    9282725,
    254301,
    187408,
    242085,
    147152,
    241752,
    259743,
    170518,
    140059,
    244956,
    1173251,
    149642,
    266549,
    212576,
    249871,
    188242,
    212320,
    229470,
    127120,
    197565,
    227572,
    191155,
    383139,
    149400,
    139875,
    102976,
    23455826,
    115604,
    261090,
    151676,
    41752708,
    1173353,
    72285,
    4061779,
    177391,
    94870,
    187735,
    167903,
    234239,
    77676,
    209054,
    86366,
    86434,
    190874,
    98483,
    91521,
    256553,
    130955,
    101549,
    253709,
    139974,
    141808,
    21161019,
    151257,
    141472,
    8870626,
    111604,
    263240,
    179171,
    1173124,
    136036,
    96059,
    74534,
    255957,
    203394,
    20059276,
    79424,
    226499,
    160247,
    9129444,
    269473,
    144860,
    116132,
    175147,
    181884,
    143596,
    161406,
    103051,
    205363,
    13377190,
    164309,
    148899,
    257550,
    23106697,
    139671,
    185045,
    190383,
    22452518,
    47158244,
    39599857,
    108881,
    147915,
    144517,
    157149,
    194307,
    162295,
    35241603,
    5957905,
    150639,
    202202,
    209445,
    208932,
    144374,
    210638,
    180504,
    38300874,
    9700388,
    223960,
    254825,
    77223,
    189874,
    171766,
    159735,
    117877,
    160203,
    105477,
    228197,
    188200,
    183075,
    228856,
    220755,
    200595,
    100524,
    161142,
    170874,
    176678,
    76427,
    2853495,
    199572,
    41680612,
    221173,
    183290,
    209859,
    187810,
    111071,
    188163,
    241333,
    229095,
    4061812,
    79030,
    103317,
    108551,
    117802,
    90830,
    75600,
    227604,
    202332,
    189271,
    171116,
    212020,
    9872791,
    92398,
    206964,
    135125,
    97332,
    243243,
    168086,
    186921,
    145352,
    178433,
    263475,
    168884,
    130267,
    124869,
    192391,
    200867,
    143785,
    213063
  )
  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

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 (104583,138736,150752,383497,211808,224332,162100,193028,174737,98309,245886,160345,172317,220348,190401,418173,180007,257470,192523,88849,6771981,242014,135685,94222,264448,212929,384102,79343,205493,121533,14557855,87409,124237,170725,4061616,206198,120394,130799,182129,89456,9517247,193068,99420,21211748,108195,143950,129897,91299,253939,197648,166611,110467,261158,147531,3379819,195314,205753,213537,250696,26648317,38622028,46461361,107057,190546,211891,176007,124337,89549,249148,133887,17594470,246469,202588,205800,168744,84203,72773,171978,256865,202690,139252,202441,2367452,156680,186795,177333,141880,182335,126983,111651,185795,130049,186138,145685,262579,208746,213925,212164,255495,207430,101873,246836,38050667,161875,228572,18810410,9887645,157224,265826,130741,187530,171662,265378,220170,80083,227732,73395,43751656,177240,256037,87380,102372,6771978,101403,263799,174798,101745,33072197,192033,174583,13979961,95652,96924,191455,168676,27128134,162257,103348,150197,181569,187073,49539249,84306,90162,221094,132606,98639,219645,189123,1173892,91180,151636,143682,103526,149700,208516,179767,157521,119097,122810,222689,268647,103499,207463,82521,245352,250174,266243,210439,170491,240646,195537,238918,114734,130455,243209,202800,267501,252035,31419712,94738,382988,79610,22568743,148602,222898,4061468,135012,155523,1173254,198498,154180,87340,23184951,195918,101229,194960,7678621,193149,201863,168651,84542,267314,149455,195136,97682,107672,9700358,166529,218293,5160340,131839,38008495,135252,268989,205836,36278962,220403,154758,198380,87856,98352,105761,268951,96354,185439,224446,155228,31514436,177510,249413,145003,203617,139730,170704,4580718,262617,260387,149059,97550,144028,76033,268279,228288,248414,89565,187460,167986,165965,7780777,81527,75643,169959,204204,8695139,125266,173474,200283,102697,383375,93789,38723937,88688,172344,139070,15243082,37868209,122307,4061851,268162,124606,6797421,226049,96500,77540,178337,171224,100682,173543,150724,189797,78974,103592,171085,181966,134714,227046,263121,5160343,210612,383027,109827,256958,183196,227558,268917,84734,265965,8591193,267530,179886,1173491,118447,1173542,143351,3224898,141729,159064,8566620,174035,206894,83605,48897409,101813,223333,91843,185598,151587,251659,113160,80940,191937,156882,255407,260943,76116,139639,20972969,196032,198534,266691,226977,265878,163692,121033,193372,32979456,186088,143537,73556,139146,197746,194884,30765443,26684056,11213840,203729,220655,128992,261287,132156,227647,172618,120883,136417,27808352,41214843,171431,223355,23945599,214433,244970,114017,176637,212689,219686,147191,142897,22892603,108520,94404,99678,190504,95043,189226,191047,192804,176897,75190,115545,247180,402843,138437,73689,48897791,178599,13400949,223044,149098,78233,91812,99228,8722785,82604,176727,142948,188477,212729,72244,169525,218042,207780,252859,1173693,146288,122838,207763,204651,22892606,269023,261823,243839,181278,104153,254574,199099,138609,221593,225114,152590,126485,246756,8388408,91914,243956,245240,10655859,163153,227270,268304,188963,192660,134133,166123,119054,108664,267623,81316,79926,107594,106347,202099,227134,170037,1173653,269445,265305,382743,109291,241860,191428,9700382,178215,11367104,218076,7016779,180306,157359,208674,222491,110338,203308,242260,210702,111233,154116,84439,120314,189598,22882595,106287,142776,77600,134094,204973,195225,75898,204855,78857,240386,122101,14669428,241670,105369,101798,75009,39558144,201319,138331,219804,29311567,263186,175902,27076239,189670,208902,129250,212394,151492,205629,31719532,109374,73318,179680,13723644,76562,218032,199295,194713,179813,160168,147609,210522,172278,7599993,114251,113751,218829,176200,120483,190150,145614,32742951,228314,125952,187911,211155,186176,161033,17275737,126658,220238,189988,249733,242815,266360,268424,207573,267700,245784,214015,127946,44224029,204745,202479,91479,37366700,42105593,91777,110677,240404,156225,129206,128526,96781,133247,41634802,203577,156310,80793,128141,227481,76091,119809,221211,5957902,17877742,114609,169666,150268,141656,219157,173849,148975,233730,186109,151225,44404593,102508,192842,122718,185065,246306,148079,26244429,8618578,116102,211256,186209,206641,145409,31665450,134322,175690,128321,252258,223652,187757,2470567,183391,108780,77357,164234,95383,143448,195347,90285,179242,124113,154873,1173742,87518,214160,90081,110842,195022,256818,95803,1173603,89349,15668814,176068,266442,173602,15659243,90791,147332,156556,101167,147869,101590,174941,34219679,164042,176992,146572,199850,177439,138939,212715,180460,226215,204827,266661,245060,27807955,85117,199934,10039806,204161,21237158,128777,104781,251064,252403,84906,146983,205724,1845849,128052,202896,218375,265768,81346,245659,165005,165025,262446,242072,4442181,201732,199538,188894,245836,98143,150349,226339,178072,39225141,73343,260508,79212,1173121,210887,190920,73900,179735,108052,142528,96544,145830,254246,202554,182441,115484,142376,3379718,20627345,33664677,225374,122139,147221,138273,197310,240120,86746,176975,209921,112984,147033,185888,260687,154301,207109,90363,218235,111003,164627,211866,213047,170790,122580,244711,157541,191407,196249,34719290,100623,31077769,265255,117486,194797,142256,263995,176296,262167,171549,158731,132963,122780,36566491,37667633,134210,106040,383360,88601,120627,189617,171164,135829,129096,187180,87012,102558,135403,224773,125055,130026,155984,220546,80881,109732,131135,228789,31789631,23220930,51503593,97982,163958,260291,20512295,134439,193518,195113,159538,111370,18332685,1173158,1173161,196171,181045,91679,3379737,118221,97116,114925,201425,157428,9700325,384050,119873,146486,118621,207942,111341,267023,125397,96112,38670305,148779,178677,107364,177255,3118747,197713,99548,110779,228081,175792,74757,128254,261224,102814,175319,83126,383256,176244,87970,106770,192306,171586,259359,128888,136200,241089,103365,198187,18810400,260577,31215812,5315068,106445,225967,198814,217376,94129,81720,29649833,117438,164573,213358,145494,27224568,113085,205897,163032,113392,260788,74091,18323640,78602,77134,101260,174181,242919,209807,158905,136526,7217358,172217,223395,39355239,17058949,383494,257803,90325,87124,88772,208831,261005,135730,157283,222266,129501,153833,267186,143038,84693,146703,96266,162327,250658,210718,3224895,96619,87314,85536,3029831,262061,220200,225007,198307,114505,178500,131018,225305,144833,193204,222990,242964,243999,220914,160845,133017,111742,9290160,107333,150874,141995,208109,255905,143260,262837,37868894,35522295,72611,115150,180106,228944,89745,253165,185698,134831,267915,181441,30148041,220948,105712,173273,86879,260555,23106643,192003,139196,142318,261487,46237639,198994,264897,74030,75853,74880,168114,254732,221442,383578,209483,245591,76900,171353,170382,85437,164128,249659,104513,227892,27199439,138703,268018,219299,103833,154821,218423,49169351,178544,128612,2566227,173880,255823,113626,114786,205199,240971,87071,110254,74427,5957896,250060,267580,157109,177852,95872,241967,107023,82308,47294199,4442184,180136,265468,89972,235840,90455,190210,221512,223285,87899,100829,41024653,190634,115132,136555,129814,208002,262206,268711,151031,122527,106657,203901,231694,269773,79494,382826,174544,155492,268827,88890,38621717,188297,115902,27808178,81639,124000,241827,80315,114041,75482,199742,171964,201789,115416,218521,50388225,209292,266888,106889,89709,203131,256266,89261,164198,141272,266112,155356,179118,223733,92309,191266,246876,162891,169612,192497,265066,199275,163837,132556,196083,150701,41796413,220483,45539296,174091,129031,140833,174338,383286,174987,193693,88121,191516,198592,144248,151300,151568,178916,204342,129533,197835,157061,204528,46904829,90672,164670,170902,267678,265584,110435,135205,195558,136496,262376,81753,97423,132704,266061,144062,98382,4442214,182314,147399,74297,261338,146397,195386,118332,7941416,186869,131774,98180,9290146,180387,147969,81217,177157,223466,91582,81094,158547,206854,111091,135953,1904411,51216654,218149,108105,132281,190061,243765,117646,124694,174680,75414,162361,383292,88291,28138429,220531,244217,240534,4791488,94373,199364,263716,27808362,259918,146183,116231,224525,143736,159639,200906,166027,164436,109501,257732,180717,261943,4442187,92184,156464,213869,139584,121638,228125,9395965,383672,10261747,109234,247967,241209,20708505,210751,176111,8388337,121323,194023,259974,247473,102266,242786,383118,222748,220877,194565,206591,141037,200435,2977929,43581664,178962,81984,110374,73135,74347,140245,200126,225195,157466,168470,267851,100061,165937,176457,149155,150070,384186,209194,248735,170765,154608,219012,136066,189166,144112,240156,99114,145447,261973,242703,250829,148562,7715980,199700,156762,221382,223613,108989,34636746,162948,80345,257010,9700322,194471,106094,229040,136181,34037741,37038521,220693,7967625,225267,185864,16306657,218867,240436,162969,74473,83792,44869050,383021,95945,97625,22840856,119029,203636,266341,77798,166311,119718,223510,12253627,244648,193721,2655510,142725,107555,114320,80548,190819,197250,263626,251539,83429,172512,251865,208378,85349,8722782,209213,244552,35700277,114455,256504,260733,384041,79763,98441,105748,162656,194917,217510,247897,42358761,175610,209351,219501,78778,156120,255713,229144,265930,384128,154226,212470,222458,383826,154051,227765,263334,125739,160614,23185284,160801,213843,82419,124718,33267404,148211,160274,18355899,135345,120959,73645,105395,199975,27486615,213132,260613,261585,162820,98121,173923,49539259,80509,245508,140325,165805,239438,84605,156724,3176489,192284,101969,211686,158481,161664,108003,201802,186236,200772,155681,142573,140362,26970115,219765,154459,43349109,213326,4061656,93903,163235,131179,6614248,7599929,4149175,13818591,27808188,251348,131085,269401,126702,183531,150008,75680,148376,195752,87219,149216,75959,193837,33072200,146129,15050850,21273299,192120,143202,167765,191815,247088,131790,212066,128649,91149,227190,228246,100207,9517217,156053,203147,73764,383006,268384,146150,121463,227403,75106,4791485,182482,118392,98021,193952,79701,213283,74121,4791491,239049,141562,226395,250387,162146,5315087,113819,209589,77069,203485,197379,251478,130324,223447,12371222,113462,83176,125661,155598,179201,229314,149007,185208,169799,89886,199831,98451,82805,107859,97583,173082,86586,156617,266814,250245,156918,160120,203882,168606,181736,77403,146259,244042,6775934,241513,169035,3411816,166076,187883,221136,164711,5315084,115353,181329,72528,111521,157401,4061962,4061766,229645,264308,139042,175232,113408,123820,124829,214424,208283,259576,7186183,102868,132768,166413,115753,135519,191210,204776,127993,139824,259830,250318,170268,211759,117916,158648,89073,21308116,7541413,14623690,46236871,245926,144556,261884,252832,229397,269658,26898515,186259,78111,7599407,224600,47202201,91383,145258,115223,182728,39995931,185961,105154,85808,87467,210768,9282725,254301,187408,242085,147152,241752,259743,170518,140059,244956,1173251,149642,266549,212576,249871,188242,212320,229470,127120,197565,227572,191155,383139,149400,139875,102976,23455826,115604,261090,151676,41752708,1173353,72285,4061779,177391,94870,187735,167903,234239,77676,209054,86366,86434,190874,98483,91521,256553,130955,101549,253709,139974,141808,21161019,151257,141472,8870626,111604,263240,179171,1173124,136036,96059,74534,255957,203394,20059276,79424,226499,160247,9129444,269473,144860,116132,175147,181884,143596,161406,103051,205363,13377190,164309,148899,257550,23106697,139671,185045,190383,22452518,47158244,39599857,108881,147915,144517,157149,194307,162295,35241603,5957905,150639,202202,209445,208932,144374,210638,180504,38300874,9700388,223960,254825,77223,189874,171766,159735,117877,160203,105477,228197,188200,183075,228856,220755,200595,100524,161142,170874,176678,76427,2853495,199572,41680612,221173,183290,209859,187810,111071,188163,241333,229095,4061812,79030,103317,108551,117802,90830,75600,227604,202332,189271,171116,212020,9872791,92398,206964,135125,97332,243243,168086,186921,145352,178433,263475,168884,130267,124869,192391,200867,143785,213063)
                  
                   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
        ;

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.

Symfony Profiler

https://stage.steiermark.com/_fragment?_path=_locale%3Den%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AdefaultAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

demi_vacancies connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

portal_engine entity manager

pimcore_direct_edit entity manager

statistics_explorer entity manager