Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

131 Database Queries

26 Different statements

450.95 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 * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
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 * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT id FROM sites
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT id FROM sites
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT id FROM sites
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT name FROM classes WHERE id = ?

#▲	Time	Info
1	0.40 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.08 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.30 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.53 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.13 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.11 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	1.13 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=324138&nearbySearchLat=47.36039&nearbySearchLong=13.63936&sorting=nearbySearchAsc&page=4&randSeed=224" "sourceEntireUri" => "https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=324138&nearbySearchLat=47.36039&nearbySearchLong=13.63936&page=4&randSeed=224&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=324138&nearbySearchLat=47.36039&nearbySearchLong=13.63936&sorting=nearbySearchAsc&page=4&randSeed=224' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=324138&nearbySearchLat=47.36039&nearbySearchLong=13.63936&page=4&randSeed=224&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.52 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.51 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.52 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.46 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
12	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
13	0.37 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.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"31"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '31';
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	47.81 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.78 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.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.24 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	36.33 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.31 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.14 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.11 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.23 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`8955`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 8955;
25	0.25 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1816863`] 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 = 1816863;
26	0.29 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 452066`] 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 = 452066;
27	0.16 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9026`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9026;
28	0.10 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1816864`] 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 = 1816864;
29	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 2404654`] 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 = 2404654;
30	0.09 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
31	0.11 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;
32	0.15 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7159 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;
33	0.10 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;
34	0.11 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';
35	0.07 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';
36	0.06 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';
37	0.06 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';
38	0.11 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/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';
39	0.06 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';
40	0.06 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';
41	0.09 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';
42	0.06 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';
43	0.06 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';
44	0.09 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';
45	0.06 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';
46	0.06 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';
47	0.08 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';
48	0.09 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 = '';
49	0.07 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 '';
50	0.07 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;
51	0.07 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';
52	0.07 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';
53	0.06 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';
54	0.06 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';
55	0.05 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';
56	0.05 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';
57	0.05 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';
58	0.05 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';
59	0.05 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';
60	0.06 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';
61	0.06 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "10" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '10' AND scope = 'pimcore_staticroutes';
62	0.05 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';
63	0.05 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';
64	0.05 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';
65	0.06 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';
66	0.06 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "16" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '16' AND scope = 'pimcore_staticroutes';
67	0.05 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';
68	0.05 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';
69	0.05 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';
70	0.05 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';
71	0.05 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';
72	0.05 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';
73	0.05 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';
74	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';
75	0.05 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';
76	0.05 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';
77	0.05 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';
78	0.05 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';
79	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9029`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9029;
80	0.15 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`27400`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 27400;
81	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "img-teaser-square" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'img-teaser-square' AND scope = 'pimcore_image_thumbnails';
82	0.08 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3337646`] 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 = 3337646;
83	0.09 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1519`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1519;
84	0.12 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9043`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9043;
85	0.33 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 486927`] 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 = 486927;
86	0.15 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9044`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9044;
87	0.26 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 541989`] 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 = 541989;
88	0.15 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9046`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9046;
89	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 472126`] 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 = 472126;
90	0.14 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9045`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9045;
91	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1816842`] 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 = 1816842;
92	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9048`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9048;
93	0.12 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3337643`] 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 = 3337643;
94	0.19 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`27402`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 27402;
95	0.26 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 397334`] 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 = 397334;
96	0.14 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9049`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9049;
97	0.11 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 556954`] 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 = 556954;
98	0.12 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9042`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9042;
99	0.10 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 541208`] 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 = 541208;
100	0.12 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9052`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9052;
101	0.11 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 920613`] 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 = 920613;
102	0.15 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
103	0.12 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;
104	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`8957`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 8957;
105	0.11 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`8131`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 8131;
106	0.10 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "content-teaser--square" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'content-teaser--square' AND scope = 'pimcore_image_thumbnails';
107	0.09 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3337906`] 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 = 3337906;
108	0.10 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9268`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9268;
109	0.10 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 859138`] 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 = 859138;
110	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1447`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1447;
111	0.10 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 397330`] 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 = 397330;
112	0.12 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9267`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9267;
113	0.25 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 397339`] 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 = 397339;
114	0.14 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1449`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1449;
115	0.11 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 920610`] 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 = 920610;
116	0.10 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1448`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1448;
117	0.11 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 541207`] 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 = 541207;
118	0.11 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`8135`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 8135;
119	0.12 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3337944`] 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 = 3337944;
120	0.11 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`8138`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 8138;
121	0.12 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
122	0.14 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`8974`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 8974;
123	0.10 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 141103`] 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 = 141103;
124	0.11 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1979`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1979;
125	0.11 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 266338`] 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 = 266338;
126	0.09 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
127	0.13 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;
128	0.12 ms	SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`5882755 "datepickerInfoTexts"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 5882755 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;
129	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';

demi_vacancies connection

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

23.77 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(224)

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

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

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