Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

81 Database Queries

25 Different statements

327.90 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

#▲	Time	Info
1	0.36 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.09 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.08 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.27 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.07 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.06 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.47 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=24&randSeed=60" "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?page=24&randSeed=60" "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=24&randSeed=60' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?page=24&randSeed=60' 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.11 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.11 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.16 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.12 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.21 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.27 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.10 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.07 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.06 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	35.84 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.42 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.08 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.29 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.25 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.10 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.10 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
25	0.12 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.18 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.13 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.13 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.23 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.07 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.08 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Vacation-planning" "path" => "/en/Schladming-Dachstein/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/' AND `key` = BINARY 'Vacation-planning';
35	0.07 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.11 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/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.07 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.07 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.11 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/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.07 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.11 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en';
43	0.11 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" ""`] 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.08 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.06 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.06 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.06 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.06 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.06 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.06 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.06 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.06 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.06 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.06 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.06 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.07 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.06 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.06 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.06 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.06 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.08 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.13 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.12 ms	SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`5882755 "datepickerInfoTexts"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 5882755 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;

demi_vacancies connection

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

12.23 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(60)

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

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

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