Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

97 Database Queries

36 Different statements

438.63 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT name FROM classes WHERE id = ?
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT * FROM translations_messages LIMIT 1;
SELECT name FROM classes WHERE id = ?
SELECT id FROM sites
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM settings_store WHERE scope = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM sites
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT id FROM sites
SELECT id FROM sites
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT * FROM object_store_8 WHERE oo_id = ?
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
SELECT * FROM object_relations_8 WHERE src_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC

#▲	Time	Info
1	0.24 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.10 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.24 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.11 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	2.16 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC Parameters: ["sourcePath" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte" "sourcePathQuery" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=324880&nearbySearchLat=47.31628&nearbySearchLong=13.88886&page=18&randSeed=379&sorting=nearbySearchAsc" "sourceEntireUri" => "https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=324880&nearbySearchLat=47.31628&nearbySearchLong=13.88886&page=18&randSeed=379&sorting=nearbySearchAsc" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=324880&nearbySearchLat=47.31628&nearbySearchLong=13.88886&page=18&randSeed=379&sorting=nearbySearchAsc' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=324880&nearbySearchLat=47.31628&nearbySearchLong=13.88886&page=18&randSeed=379&sorting=nearbySearchAsc' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;
8	0.17 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.30 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.18 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.14 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.11 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.15 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`7159`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 7159;
14	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"31"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '31';
15	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
16	32.25 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.42 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`11189`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11189 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
18	0.07 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.13 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	47.57 ms	select o_id as id, position__longitude as lon, position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL Parameters: [] View formatted query View runnable query Explain query select o_id as id, position__longitude as lon, position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL select o_id as id, position__longitude as lon, position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL;
21	0.21 ms	SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
22	0.10 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
23	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"Region"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'Region';
24	0.09 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
25	0.12 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`7159`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 7159;
26	0.20 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7159 7159 7159`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(7159, 7159) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7159;
27	0.16 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7930 7930`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 7930 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7930;
28	0.12 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Unterkuenfte" "path" => "/de/Schladming-Dachstein/Urlaub-planen/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/de/Schladming-Dachstein/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte';
29	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte';
30	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Unterkuenfte" "path" => "/de/Schladming-Dachstein/Urlaub-planen/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/de/Schladming-Dachstein/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte';
31	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte';
32	0.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/Unterkuenfte"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte';
33	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Urlaub-planen" "path" => "/de/Schladming-Dachstein/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/de/Schladming-Dachstein/' AND `key` = BINARY 'Urlaub-planen';
34	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen';
35	0.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/Schladming-Dachstein/Urlaub-planen"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen';
36	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Schladming-Dachstein" "path" => "/de/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/de/' AND `key` = BINARY 'Schladming-Dachstein';
37	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/Schladming-Dachstein"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein';
38	0.14 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/de/Schladming-Dachstein"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Schladming-Dachstein';
39	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "de" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'de';
40	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de';
41	0.14 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/de"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de';
42	0.15 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" ""`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '';
43	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY '';
44	0.11 ms	SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
45	0.09 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';
46	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "1" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '1' AND scope = 'pimcore_staticroutes';
47	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "2" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '2' AND scope = 'pimcore_staticroutes';
48	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "3" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '3' AND scope = 'pimcore_staticroutes';
49	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "4" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '4' AND scope = 'pimcore_staticroutes';
50	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "5" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '5' AND scope = 'pimcore_staticroutes';
51	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "6" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '6' AND scope = 'pimcore_staticroutes';
52	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "7" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '7' AND scope = 'pimcore_staticroutes';
53	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "8" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '8' AND scope = 'pimcore_staticroutes';
54	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "9" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '9' AND scope = 'pimcore_staticroutes';
55	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "10" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '10' AND scope = 'pimcore_staticroutes';
56	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "11" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '11' AND scope = 'pimcore_staticroutes';
57	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "12" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '12' AND scope = 'pimcore_staticroutes';
58	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "13" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '13' AND scope = 'pimcore_staticroutes';
59	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "15" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '15' AND scope = 'pimcore_staticroutes';
60	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "16" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '16' AND scope = 'pimcore_staticroutes';
61	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "17" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '17' AND scope = 'pimcore_staticroutes';
62	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "18" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '18' AND scope = 'pimcore_staticroutes';
63	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "19" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '19' AND scope = 'pimcore_staticroutes';
64	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "20" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '20' AND scope = 'pimcore_staticroutes';
65	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "21" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '21' AND scope = 'pimcore_staticroutes';
66	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "22" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '22' AND scope = 'pimcore_staticroutes';
67	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "23" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '23' AND scope = 'pimcore_staticroutes';
68	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "24" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '24' AND scope = 'pimcore_staticroutes';
69	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "25" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '25' AND scope = 'pimcore_staticroutes';
70	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "26" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '26' AND scope = 'pimcore_staticroutes';
71	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "27" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '27' AND scope = 'pimcore_staticroutes';
72	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "28" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '28' AND scope = 'pimcore_staticroutes';
73	0.08 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
74	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1524019`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1524019;
75	0.08 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
76	0.08 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
77	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"AlpsteinTour"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'AlpsteinTour';
78	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"8"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '8';
79	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';
80	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"20"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '20';
81	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"51"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '51';
82	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"30"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '30';
83	0.16 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`171964`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 171964;
84	0.16 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`171964`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 171964;
85	0.16 ms	SELECT * FROM object_store_8 WHERE oo_id = ? Parameters: [`171964`] View formatted query View runnable query Explain query SELECT * FROM object_store_8 WHERE oo_id = ? SELECT * FROM object_store_8 WHERE oo_id = 171964;
86	0.22 ms	SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`171964 "facilities"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = 171964 AND fieldname = 'facilities' ORDER BY `index` ASC;
87	0.11 ms	SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ? Parameters: [`171964 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = 171964 AND fieldname = 'demiExtension';
88	0.08 ms	SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ? Parameters: [`171964 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = 171964 AND fieldname = 'demiExtension';
89	0.07 ms	SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ? Parameters: [`171964 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = 171964 AND fieldname = 'demiExtension';
90	0.07 ms	SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ? Parameters: [`171964 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = 171964 AND fieldname = 'demiExtension';
91	0.25 ms	SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk') Parameters: [`171964`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ( 'de', 'en', 'hu', 'cs', 'pl', 'nl', 'it', 'sk' ) SELECT * FROM object_localized_data_8 WHERE ooo_id = 171964 AND language IN ('de','en','hu','cs','pl','nl','it','sk');
92	0.25 ms	SELECT * FROM object_relations_8 WHERE src_id = ? Parameters: [`171964`] View formatted query View runnable query Explain query SELECT * FROM object_relations_8 WHERE src_id = ? SELECT * FROM object_relations_8 WHERE src_id = 171964;
93	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"68"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '68';
94	0.17 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;
95	0.15 ms	SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`5882755 "datepickerInfoTexts"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 5882755 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;

demi_vacancies connection

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

#▲

Time

Info

21.33 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(379)

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

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

324.75 ms

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