Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

82 Database Queries

25 Different statements

365.28 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 * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT * FROM translations_messages LIMIT 1;
SELECT id FROM sites
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM settings_store WHERE scope = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM sites
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT id FROM sites
SELECT id FROM sites
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT name FROM classes WHERE id = ?

#▲	Time	Info
1	0.39 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.13 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.23 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.10 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.10 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.41 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?page=4&randSeed=769" "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?page=4&randSeed=769" "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?page=4&randSeed=769' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?page=4&randSeed=769' 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.16 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.14 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.20 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.16 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.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
13	0.19 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.17 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.12 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.10 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	42.85 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.39 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.10 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.17 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	0.24 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;
22	0.19 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';
23	0.10 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.09 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
25	0.13 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;
26	0.15 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;
27	0.15 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;
28	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;
29	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';
30	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';
31	0.08 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Accommodations" "path" => "/en/Schladming-Dachstein/Vacation-planning/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';
32	0.08 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';
33	0.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';
34	0.09 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';
35	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';
36	0.23 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';
37	0.09 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';
38	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';
39	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';
40	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';
41	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';
42	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"`] 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';
43	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/%" ""`] 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 = '';
44	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 '';
45	0.09 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;
46	0.08 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';
47	0.08 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';
48	0.07 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';
49	0.07 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';
50	0.07 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';
51	0.07 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';
52	0.07 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';
53	0.07 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';
54	0.07 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';
55	0.07 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';
56	0.07 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';
57	0.07 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';
58	0.07 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';
59	0.07 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';
60	0.07 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';
61	0.07 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';
62	0.07 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';
63	0.07 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';
64	0.07 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';
65	0.07 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';
66	0.07 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';
67	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';
68	0.07 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';
69	0.07 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';
70	0.07 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';
71	0.07 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';
72	0.07 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';
73	0.07 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';
74	0.08 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
75	0.13 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;
76	0.10 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
77	0.07 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
78	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;
79	0.13 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;
80	0.23 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';

demi_vacancies connection

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

18.73 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(769)

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

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

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