Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

84 Database Queries

27 Different statements

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

16.11 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(173)

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(173)

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(173) ;

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