Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

87 Database Queries

26 Different statements

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

15.69 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(159)

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

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

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