Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

82 Database Queries

26 Different statements

430.01 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 * 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

#▲	Time	Info
1	0.40 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.11 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.19 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.41 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.08 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.08 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.63 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=1263&nearbySearchLat=47.48556&nearbySearchLong=13.97307&sorting=nearbySearchAsc&page=4&randSeed=236" "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1263&nearbySearchLat=47.48556&nearbySearchLong=13.97307&page=4&randSeed=236&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=1263&nearbySearchLat=47.48556&nearbySearchLong=13.97307&sorting=nearbySearchAsc&page=4&randSeed=236' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1263&nearbySearchLat=47.48556&nearbySearchLong=13.97307&page=4&randSeed=236&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.24 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.37 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.41 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;
11	0.20 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;
12	0.27 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';
13	0.30 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;
14	0.15 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;
15	0.10 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';
16	0.09 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';
17	36.35 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;
18	0.49 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 ;
19	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';
20	0.19 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 ;
21	41.52 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;
22	0.27 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;
23	0.28 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;;
24	0.18 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';
25	0.14 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
26	0.17 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;
27	0.20 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;
28	0.12 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;
29	0.12 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;
30	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';
31	0.09 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';
32	0.09 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';
33	0.09 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';
34	0.14 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/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';
35	0.08 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';
36	0.08 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';
37	0.12 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';
38	0.08 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';
39	0.08 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';
40	0.12 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';
41	0.08 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';
42	0.08 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';
43	0.11 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';
44	0.11 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 = '';
45	0.09 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 '';
46	0.10 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;
47	0.09 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';
48	0.09 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';
49	0.08 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';
50	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "3" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '3' AND scope = 'pimcore_staticroutes';
51	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "4" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '4' AND scope = 'pimcore_staticroutes';
52	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "5" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '5' AND scope = 'pimcore_staticroutes';
53	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "6" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '6' AND scope = 'pimcore_staticroutes';
54	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "7" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '7' AND scope = 'pimcore_staticroutes';
55	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "8" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '8' AND scope = 'pimcore_staticroutes';
56	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "9" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '9' AND scope = 'pimcore_staticroutes';
57	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "10" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '10' AND scope = 'pimcore_staticroutes';
58	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "11" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '11' AND scope = 'pimcore_staticroutes';
59	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "12" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '12' AND scope = 'pimcore_staticroutes';
60	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "13" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '13' AND scope = 'pimcore_staticroutes';
61	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "15" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '15' AND scope = 'pimcore_staticroutes';
62	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "16" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '16' AND scope = 'pimcore_staticroutes';
63	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "17" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '17' AND scope = 'pimcore_staticroutes';
64	0.08 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';
65	0.08 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';
66	0.08 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';
67	0.08 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';
68	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "22" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '22' AND scope = 'pimcore_staticroutes';
69	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "23" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '23' AND scope = 'pimcore_staticroutes';
70	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "24" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '24' AND scope = 'pimcore_staticroutes';
71	0.08 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';
72	0.08 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';
73	0.08 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';
74	0.08 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';
75	0.10 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
76	0.14 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;
77	0.09 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
78	0.24 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
79	0.19 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;
80	0.14 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;

demi_vacancies connection

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

21.40 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(236)

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

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

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