Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

80 Database Queries

25 Different statements

331.71 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 * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT * FROM translations_messages LIMIT 1;
SELECT id FROM sites
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id 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 * FROM documents_editables WHERE documentId = ?
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT name FROM classes WHERE id = ?

#▲	Time	Info
1	0.40 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.09 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.20 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.23 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.07 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.47 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte" "sourcePathQuery" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?page=62&randSeed=367" "sourceEntireUri" => "https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?page=62&randSeed=367" "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?page=62&randSeed=367' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?page=62&randSeed=367' 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.10 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.09 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.13 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.10 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
12	0.21 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
13	0.27 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`7159`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 7159;
14	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"31"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '31';
15	0.06 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
16	32.99 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.44 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.21 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.34 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	0.30 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;
21	0.21 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';
22	0.15 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.10 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
24	0.31 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;
25	0.23 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;
26	0.17 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;
27	0.30 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';
28	0.14 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';
29	0.13 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';
30	0.12 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';
31	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';
32	0.12 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';
33	0.12 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';
34	0.17 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/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';
35	0.12 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';
36	0.16 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';
37	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"`] 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';
38	0.12 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';
39	0.12 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';
40	0.16 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/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';
41	0.16 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" ""`] 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 = '';
42	0.13 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 '';
43	0.14 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;
44	0.13 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';
45	0.13 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';
46	0.11 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';
47	0.11 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';
48	0.11 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';
49	0.11 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';
50	0.11 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';
51	0.11 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';
52	0.11 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';
53	0.11 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';
54	0.11 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';
55	0.11 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';
56	0.11 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';
57	0.11 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';
58	0.13 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';
59	0.13 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';
60	0.15 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';
61	0.15 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';
62	0.12 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';
63	0.10 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';
64	0.19 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';
65	0.13 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';
66	0.15 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';
67	0.12 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';
68	0.11 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';
69	0.11 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';
70	0.12 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';
71	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "28" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '28' AND scope = 'pimcore_staticroutes';
72	0.11 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
73	0.17 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;
74	0.11 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
75	0.16 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
76	0.30 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;
77	0.16 ms	SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`5882755 "datepickerInfoTexts"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 5882755 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;
78	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';

demi_vacancies connection

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

11.98 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(367)

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

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

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