Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

126 Database Queries

41 Different statements

177.17 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/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' 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/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT * FROM translations_messages LIMIT 1;
SELECT name FROM classes WHERE id = ?
SELECT id FROM sites
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT * FROM object_url_slugs WHERE slug = '/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM settings_store WHERE scope = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM sites
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT id FROM sites
SELECT id FROM sites
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_store_AlpsteinTour WHERE oo_id = ?
SELECT * FROM object_localized_data_AlpsteinTour WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_relations_AlpsteinTour WHERE src_id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT * FROM object_store_8 WHERE oo_id = ?
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
SELECT * FROM object_relations_8 WHERE src_id = ?
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT * FROM object_store_8 WHERE oo_id = ?
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
SELECT * FROM object_relations_8 WHERE src_id = ?
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT * FROM object_store_8 WHERE oo_id = ?
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
SELECT * FROM object_relations_8 WHERE src_id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
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

#▲	Time	Info
1	0.32 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.07 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.22 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.28 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.10 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.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.44 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/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen" "sourcePathQuery" => "/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen?nearbySearchId=1430661&nearbySearchLat=47.39234&nearbySearchLong=14.20394&sorting=nearbySearchAsc" "sourceEntireUri" => "https://stage.steiermark.com/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen?nearbySearchId=1430661&nearbySearchLat=47.39234&nearbySearchLong=14.20394&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/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen?nearbySearchId=1430661&nearbySearchLat=47.39234&nearbySearchLong=14.20394&sorting=nearbySearchAsc' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen?nearbySearchId=1430661&nearbySearchLat=47.39234&nearbySearchLong=14.20394&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.13 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.19 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Unterkuenfte-suchen-und-buchen" "path" => "/steiermark.com/de/Murau/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/Murau/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte-suchen-und-buchen';
10	0.19 ms	SELECT * FROM object_url_slugs WHERE slug = '/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' 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/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND ( siteId = 6 OR siteId = 0 ) ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;
11	0.14 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
12	0.22 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.21 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6681`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6681;
14	0.09 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.08 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	48.03 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.41 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: [`11893`] 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 = 11893 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
18	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.22 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`29785441`] 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 = 29785441 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
20	33.80 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.23 ms	SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' 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/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
22	0.13 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.14 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.11 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
25	0.13 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`6681`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 6681;
26	0.17 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`6681 6681 6681`] 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(6681, 6681) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 6681;
27	0.12 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`9789 9789`] 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 = 9789 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 9789;
28	0.13 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Unterkuenfte-suchen-und-buchen" "path" => "/de/Murau/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/Murau/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte-suchen-und-buchen';
29	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen';
30	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Unterkuenfte-suchen-und-buchen" "path" => "/de/Murau/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/Murau/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte-suchen-und-buchen';
31	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen';
32	0.17 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen"`] 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/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen';
33	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Urlaub-planen" "path" => "/de/Murau/"`] 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/Murau/' AND `key` = BINARY 'Urlaub-planen';
34	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/Murau/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/Murau/Urlaub-planen';
35	0.14 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/de/Murau/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/Murau/Urlaub-planen';
36	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Murau" "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 'Murau';
37	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/Murau"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de/Murau';
38	0.14 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/de/Murau"`] 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/Murau';
39	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "de" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'de';
40	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de';
41	0.14 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/de"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de';
42	0.14 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" ""`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '';
43	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY '';
44	0.11 ms	SELECT * FROM object_url_slugs WHERE slug = '/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' 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/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
45	0.09 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';
46	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "1" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '1' AND scope = 'pimcore_staticroutes';
47	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "2" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '2' AND scope = 'pimcore_staticroutes';
48	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "3" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '3' AND scope = 'pimcore_staticroutes';
49	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "4" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '4' AND scope = 'pimcore_staticroutes';
50	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "5" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '5' AND scope = 'pimcore_staticroutes';
51	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "6" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '6' AND scope = 'pimcore_staticroutes';
52	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "7" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '7' AND scope = 'pimcore_staticroutes';
53	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "8" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '8' AND scope = 'pimcore_staticroutes';
54	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "9" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '9' AND scope = 'pimcore_staticroutes';
55	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "10" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '10' AND scope = 'pimcore_staticroutes';
56	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "11" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '11' AND scope = 'pimcore_staticroutes';
57	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "12" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '12' AND scope = 'pimcore_staticroutes';
58	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "13" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '13' AND scope = 'pimcore_staticroutes';
59	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "15" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '15' AND scope = 'pimcore_staticroutes';
60	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "16" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '16' AND scope = 'pimcore_staticroutes';
61	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "17" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '17' AND scope = 'pimcore_staticroutes';
62	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "18" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '18' AND scope = 'pimcore_staticroutes';
63	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "19" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '19' AND scope = 'pimcore_staticroutes';
64	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "20" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '20' AND scope = 'pimcore_staticroutes';
65	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "21" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '21' AND scope = 'pimcore_staticroutes';
66	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "22" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '22' AND scope = 'pimcore_staticroutes';
67	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "23" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '23' AND scope = 'pimcore_staticroutes';
68	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "24" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '24' AND scope = 'pimcore_staticroutes';
69	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "25" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '25' AND scope = 'pimcore_staticroutes';
70	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "26" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '26' AND scope = 'pimcore_staticroutes';
71	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "27" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '27' AND scope = 'pimcore_staticroutes';
72	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "28" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '28' AND scope = 'pimcore_staticroutes';
73	0.08 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
74	0.16 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1039116`] 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 = 1039116;
75	0.09 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
76	0.08 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
77	0.12 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`1430661`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 1430661;
78	0.15 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`1430661`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 1430661;
79	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"AlpsteinTour"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'AlpsteinTour';
80	0.49 ms	SELECT * FROM object_store_AlpsteinTour WHERE oo_id = ? Parameters: [`1430661`] View formatted query View runnable query Explain query SELECT * FROM object_store_AlpsteinTour WHERE oo_id = ? SELECT * FROM object_store_AlpsteinTour WHERE oo_id = 1430661;
81	0.47 ms	SELECT * FROM object_localized_data_AlpsteinTour WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk') Parameters: [`1430661`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_AlpsteinTour WHERE ooo_id = ? AND language IN ( 'de', 'en', 'hu', 'cs', 'pl', 'nl', 'it', 'sk' ) SELECT * FROM object_localized_data_AlpsteinTour WHERE ooo_id = 1430661 AND language IN ('de','en','hu','cs','pl','nl','it','sk');
82	0.16 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`477025`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 477025;
83	0.13 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`477025`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 477025;
84	0.20 ms	SELECT * FROM object_relations_AlpsteinTour WHERE src_id = ? Parameters: [`1430661`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AlpsteinTour WHERE src_id = ? SELECT * FROM object_relations_AlpsteinTour WHERE src_id = 1430661;
85	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"8"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '8';
86	0.11 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';
87	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"30"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '30';
88	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"51"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '51';
89	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"20"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '20';
90	0.20 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`1948522`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 1948522;
91	0.13 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`1948522`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 1948522;
92	0.13 ms	SELECT * FROM object_store_8 WHERE oo_id = ? Parameters: [`1948522`] View formatted query View runnable query Explain query SELECT * FROM object_store_8 WHERE oo_id = ? SELECT * FROM object_store_8 WHERE oo_id = 1948522;
93	0.20 ms	SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1948522 "facilities"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = 1948522 AND fieldname = 'facilities' ORDER BY `index` ASC;
94	0.09 ms	SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1948522 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = 1948522 AND fieldname = 'demiExtension';
95	0.08 ms	SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1948522 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = 1948522 AND fieldname = 'demiExtension';
96	0.07 ms	SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1948522 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = 1948522 AND fieldname = 'demiExtension';
97	0.07 ms	SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1948522 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = 1948522 AND fieldname = 'demiExtension';
98	0.19 ms	SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk') Parameters: [`1948522`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ( 'de', 'en', 'hu', 'cs', 'pl', 'nl', 'it', 'sk' ) SELECT * FROM object_localized_data_8 WHERE ooo_id = 1948522 AND language IN ('de','en','hu','cs','pl','nl','it','sk');
99	0.59 ms	SELECT * FROM object_relations_8 WHERE src_id = ? Parameters: [`1948522`] View formatted query View runnable query Explain query SELECT * FROM object_relations_8 WHERE src_id = ? SELECT * FROM object_relations_8 WHERE src_id = 1948522;
100	0.29 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`1952040`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 1952040;
101	0.11 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`1952040`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 1952040;
102	0.11 ms	SELECT * FROM object_store_8 WHERE oo_id = ? Parameters: [`1952040`] View formatted query View runnable query Explain query SELECT * FROM object_store_8 WHERE oo_id = ? SELECT * FROM object_store_8 WHERE oo_id = 1952040;
103	0.39 ms	SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1952040 "facilities"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = 1952040 AND fieldname = 'facilities' ORDER BY `index` ASC;
104	0.08 ms	SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1952040 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = 1952040 AND fieldname = 'demiExtension';
105	0.05 ms	SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1952040 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = 1952040 AND fieldname = 'demiExtension';
106	0.05 ms	SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1952040 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = 1952040 AND fieldname = 'demiExtension';
107	0.05 ms	SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1952040 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = 1952040 AND fieldname = 'demiExtension';
108	0.18 ms	SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk') Parameters: [`1952040`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ( 'de', 'en', 'hu', 'cs', 'pl', 'nl', 'it', 'sk' ) SELECT * FROM object_localized_data_8 WHERE ooo_id = 1952040 AND language IN ('de','en','hu','cs','pl','nl','it','sk');
109	0.24 ms	SELECT * FROM object_relations_8 WHERE src_id = ? Parameters: [`1952040`] View formatted query View runnable query Explain query SELECT * FROM object_relations_8 WHERE src_id = ? SELECT * FROM object_relations_8 WHERE src_id = 1952040;
110	0.24 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`1952204`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 1952204;
111	0.12 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`1952204`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 1952204;
112	0.11 ms	SELECT * FROM object_store_8 WHERE oo_id = ? Parameters: [`1952204`] View formatted query View runnable query Explain query SELECT * FROM object_store_8 WHERE oo_id = ? SELECT * FROM object_store_8 WHERE oo_id = 1952204;
113	0.17 ms	SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1952204 "facilities"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = 1952204 AND fieldname = 'facilities' ORDER BY `index` ASC;
114	0.07 ms	SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1952204 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = 1952204 AND fieldname = 'demiExtension';
115	0.06 ms	SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1952204 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = 1952204 AND fieldname = 'demiExtension';
116	0.08 ms	SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1952204 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = 1952204 AND fieldname = 'demiExtension';
117	0.08 ms	SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ? Parameters: [`1952204 "demiExtension"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = 1952204 AND fieldname = 'demiExtension';
118	0.27 ms	SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk') Parameters: [`1952204`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ( 'de', 'en', 'hu', 'cs', 'pl', 'nl', 'it', 'sk' ) SELECT * FROM object_localized_data_8 WHERE ooo_id = 1952204 AND language IN ('de','en','hu','cs','pl','nl','it','sk');
119	0.35 ms	SELECT * FROM object_relations_8 WHERE src_id = ? Parameters: [`1952204`] View formatted query View runnable query Explain query SELECT * FROM object_relations_8 WHERE src_id = ? SELECT * FROM object_relations_8 WHERE src_id = 1952204;
120	0.25 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`9382`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 9382;
121	0.13 ms	SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`5882752 "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 = 5882752 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;
122	0.18 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6888`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6888;
123	0.21 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "footer-logo" "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 = 'footer-logo' AND scope = 'pimcore_image_thumbnails';
124	0.22 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3189171`] 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 = 3189171;

demi_vacancies connection

#▲	Time	Info
1	9.20 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 (11959, 11948, 11910, 11909, 11965, 11963, 11947, 11922, 11921, 11950, 11914, 11920, 11946, 11937, 29785444, 29785442)) GROUP BY dacco.oo_id ORDER BY RAND(379) Parameters: [] View formatted query View runnable query Explain query SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.o_published = 1 AND ( dacco.town__id IN ( 11959, 11948, 11910, 11909, 11965, 11963, 11947, 11922, 11921, 11950, 11914, 11920, 11946, 11937, 29785444, 29785442 ) ) GROUP BY dacco.oo_id ORDER BY RAND(379) SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.o_published = 1 AND (dacco.town__id IN (11959, 11948, 11910, 11909, 11965, 11963, 11947, 11922, 11921, 11950, 11914, 11920, 11946, 11937, 29785444, 29785442)) GROUP BY dacco.oo_id ORDER BY RAND(379) ;
2	69.08 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 (1829206,9629644,1951749,1936689,1941684,30205115,1734194,1733491,1931829,1947843,1735575,1750906,22870909,1947826,1738191,1957246,1949676,1947886,1828794,33623528,1955685,1730342,1946671,1947728,1732918,1950667,1735975,1736889,1946839,1955322,42144620,1824754,1939045,1933417,1733775,1930778,1939108,1954995,1955738,1952143,11862006,1734569,31788832,1947958,1938936,1733186,1948700,1823552,1952246,2673544,1934252,4062830,1825793,1936897,1951414,21824738,1828062,1941039,1736862,1823597,1738037,1938835,1732510,1955094,1955415,50200137,1951116,21577455,26021709,6648868,1732419,1733811,1735734,1826626,2673903,1942274,1824536,1954889,1949501,1954551,1727813,1939308,1930481,1932966,1733120,1824854,1736723,1730031,1950645,1946502,1946470,27178461,1932776,48564332,41365379,1739120,21984508,1829134,1737328,1941538,1827779,1734240,1750909,1736761,1731437,28929422,1948977,11618312,1750647,31261223,27142048,1750841,8382758,1943182,1957280,4062676,1955624,1826473,1733028,12149352,1953774,1940590,15498026,1951695,2664006,1933433,43399592,1955042,1729848,27066902,1938100,49874948,1735488,1824068,1729604,1739660,4062757,1737642,1734086,2669577,41458409,1826136,1948065,1730858,1732017,1728765,1827242,1823127,41278917,31747387,1942882,1730678,1930447,1739074,22680304,1739032,1737555,1942503,1728547,1946528,1828920,1825448,1950128,43822465,1733016,41704397,1824253,1954353,1932526,1946065,25215728,4442305,1954488,2673541,1730694,1931733,1953092,13770777,31159141,1735985,1729762,1729176,1935741,2670885,1823376,1733525,1730586,1948321,1946806,1747740,1956007,1750860,39811619,1730598,1737654,1735385,1948710,1932817,1738785,1823444,1823171,1938339,23107117,1937367,1942686,18250396,3283074,1829797,1730919,1824494,1733379,1729000,1946951,1936326,21862384,1955919,1733965,1955046,1948303,1737436,4062912,1733355,1729389,4062806,1937469,1828360,11245625,47196812,1934294,31077191,1952166,1733826,1954921,1947283,1931758,1951232,1829617,1947615,29789097,1823239,1952062,1825713,1948900,2664864,1732645,1736773,9576144,1829510,33363840,1733744,41453473,29819550,27972191,1728707,1829458,33294335,1737602,1739008,15118655,1948414,1943137,19928947,1933801,1955952,1826686,1823539,31823031,1949966,1937824,1939806,1955476,2663977,1947435,2673915,1952340,1940778,1950062,22680298,1951458,1823609,1736830,1826326,1952501,1947469,1951986,1732163,1828194,1955197,48417638,2669983,4062921,1750679,1737987,1948401,1946098,1947373,1952424,2673689,1730704,1729870,1828871,1729645,29787925,22621551,1955936,1749936,1733895,1829408,1736675,1737668,17364709,1940444,44433919,1728417,1947083,15419107,1947036,1951927,38290359,1948827,1946296,3089986,1750798,1935804,1731831,7757553,1829479,2666152,1829164,2674068,1946582,1735663,1955268,1733241,1735505,1826556,1950333,1950174,1942441,29789889,1735710,1943508,2673648,1954391,1828133,1732250,1829900,2670355,1948260,5554733,1825179,1943973,1949915,9629647,1731875,1828716,2663247,1727855,1824745,1824952,1953052,2670783,1934349,1947387,1738986,1948847,1828510,1824605,1732231,1946746,39908198,1951065,27866430,1738996,1750660,11928644,1949421,29263800,1733471,1823090,3238663,35658710,1825677,1943201,49917837,1823654,1955705,29788089,1930954,1737106,1955956,1827613,2670240,1943105,1940920,41108210,1824347,1954604,37911918,27066899,1949573,40707377,46852469,1730657,30525605,1942177,1952204,1948234,25984203,1951675,1732862,1951313,27066893,2670158,1952101,1953156,1935486,9576135,1827525,1828221,1948646,29788817,1825011,1942388,1736055,2663894,25089373,1729120,1728976,1826193,1949004,15419098,2674170,2669356,1824908,1931440,1933865,1953810,1823467,1943475,1943815,1823037,1931251,1955377,1955273,1732456,1935963,1830603,1826269,1734285,1933088,2674018,1829717,1953112,22680310,1950873,2673848,1943997,1737009,10374087,1730546,1829934,1830434,1731019,1823715,1934672,1951179,1937692,1750628,1729658,1823959,1952040,1954644,1937544,8844791,1939951,4062700,1957306,13873463,1948441,1730377,1955349,26306220,1736624,1949730,1949818,1824146,50929972,1825302,9258388,1954471,1941268,1949614,1733314,1938764,35313684,1932702,1953959,1940948,1737274,1948291,1950703,1949028,1734343,1737844,1933727,1954958,1823821,43826963,1946779,37868363,1955319,3402151,27947163,22680313,1735424,1731048,2674009,47930787,1955972,1824363,1823886,1728156,2674013,2670780,1942813,1952996,1750052,1948486,1950256,1932470,1729443,1737589,2674165,1952542,2670053,1955508,1950753,1950811,47978187,1946548,9886762,1828318,1828934,29789987,1823188,16605043,1826175,17071511,1827458,2669496,1948166,1955017,1954696,1952660,1936218,1827876,1738782,1954411,1825612,1737665,1930577,22680307,1950224,23899160,4062709,42444600,1937978,1942414,1735334,1941470,1738871,50010802,1931105,1948505,31896277,1948108,1950095,1947355,2674021,1735857,1730727,1729325,1953997,1823052,1731339,1825519,2669164,29789564,1737234,1950988,1730951,1943586,1954907,1827922,1955577,1733212,1938666,1732394,1947551,1728448,1826683,2853529,1729347,1952359,1737173,8745860,20962005,1736996,1934723,1942484,1947198,1734330,33905433,1734130,22680295,1955200,1830380,1954940,1932213,1728960,1955727,1949477,1727824,1824813,1957212,1750886,1954524,30841045,1739372,8746207,41064007,1739062,1951622,1949086,1731471,40707373,1948687,1941076,1948522) 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 ( 1829206, 9629644, 1951749, 1936689, 1941684, 30205115, 1734194, 1733491, 1931829, 1947843, 1735575, 1750906, 22870909, 1947826, 1738191, 1957246, 1949676, 1947886, 1828794, 33623528, 1955685, 1730342, 1946671, 1947728, 1732918, 1950667, 1735975, 1736889, 1946839, 1955322, 42144620, 1824754, 1939045, 1933417, 1733775, 1930778, 1939108, 1954995, 1955738, 1952143, 11862006, 1734569, 31788832, 1947958, 1938936, 1733186, 1948700, 1823552, 1952246, 2673544, 1934252, 4062830, 1825793, 1936897, 1951414, 21824738, 1828062, 1941039, 1736862, 1823597, 1738037, 1938835, 1732510, 1955094, 1955415, 50200137, 1951116, 21577455, 26021709, 6648868, 1732419, 1733811, 1735734, 1826626, 2673903, 1942274, 1824536, 1954889, 1949501, 1954551, 1727813, 1939308, 1930481, 1932966, 1733120, 1824854, 1736723, 1730031, 1950645, 1946502, 1946470, 27178461, 1932776, 48564332, 41365379, 1739120, 21984508, 1829134, 1737328, 1941538, 1827779, 1734240, 1750909, 1736761, 1731437, 28929422, 1948977, 11618312, 1750647, 31261223, 27142048, 1750841, 8382758, 1943182, 1957280, 4062676, 1955624, 1826473, 1733028, 12149352, 1953774, 1940590, 15498026, 1951695, 2664006, 1933433, 43399592, 1955042, 1729848, 27066902, 1938100, 49874948, 1735488, 1824068, 1729604, 1739660, 4062757, 1737642, 1734086, 2669577, 41458409, 1826136, 1948065, 1730858, 1732017, 1728765, 1827242, 1823127, 41278917, 31747387, 1942882, 1730678, 1930447, 1739074, 22680304, 1739032, 1737555, 1942503, 1728547, 1946528, 1828920, 1825448, 1950128, 43822465, 1733016, 41704397, 1824253, 1954353, 1932526, 1946065, 25215728, 4442305, 1954488, 2673541, 1730694, 1931733, 1953092, 13770777, 31159141, 1735985, 1729762, 1729176, 1935741, 2670885, 1823376, 1733525, 1730586, 1948321, 1946806, 1747740, 1956007, 1750860, 39811619, 1730598, 1737654, 1735385, 1948710, 1932817, 1738785, 1823444, 1823171, 1938339, 23107117, 1937367, 1942686, 18250396, 3283074, 1829797, 1730919, 1824494, 1733379, 1729000, 1946951, 1936326, 21862384, 1955919, 1733965, 1955046, 1948303, 1737436, 4062912, 1733355, 1729389, 4062806, 1937469, 1828360, 11245625, 47196812, 1934294, 31077191, 1952166, 1733826, 1954921, 1947283, 1931758, 1951232, 1829617, 1947615, 29789097, 1823239, 1952062, 1825713, 1948900, 2664864, 1732645, 1736773, 9576144, 1829510, 33363840, 1733744, 41453473, 29819550, 27972191, 1728707, 1829458, 33294335, 1737602, 1739008, 15118655, 1948414, 1943137, 19928947, 1933801, 1955952, 1826686, 1823539, 31823031, 1949966, 1937824, 1939806, 1955476, 2663977, 1947435, 2673915, 1952340, 1940778, 1950062, 22680298, 1951458, 1823609, 1736830, 1826326, 1952501, 1947469, 1951986, 1732163, 1828194, 1955197, 48417638, 2669983, 4062921, 1750679, 1737987, 1948401, 1946098, 1947373, 1952424, 2673689, 1730704, 1729870, 1828871, 1729645, 29787925, 22621551, 1955936, 1749936, 1733895, 1829408, 1736675, 1737668, 17364709, 1940444, 44433919, 1728417, 1947083, 15419107, 1947036, 1951927, 38290359, 1948827, 1946296, 3089986, 1750798, 1935804, 1731831, 7757553, 1829479, 2666152, 1829164, 2674068, 1946582, 1735663, 1955268, 1733241, 1735505, 1826556, 1950333, 1950174, 1942441, 29789889, 1735710, 1943508, 2673648, 1954391, 1828133, 1732250, 1829900, 2670355, 1948260, 5554733, 1825179, 1943973, 1949915, 9629647, 1731875, 1828716, 2663247, 1727855, 1824745, 1824952, 1953052, 2670783, 1934349, 1947387, 1738986, 1948847, 1828510, 1824605, 1732231, 1946746, 39908198, 1951065, 27866430, 1738996, 1750660, 11928644, 1949421, 29263800, 1733471, 1823090, 3238663, 35658710, 1825677, 1943201, 49917837, 1823654, 1955705, 29788089, 1930954, 1737106, 1955956, 1827613, 2670240, 1943105, 1940920, 41108210, 1824347, 1954604, 37911918, 27066899, 1949573, 40707377, 46852469, 1730657, 30525605, 1942177, 1952204, 1948234, 25984203, 1951675, 1732862, 1951313, 27066893, 2670158, 1952101, 1953156, 1935486, 9576135, 1827525, 1828221, 1948646, 29788817, 1825011, 1942388, 1736055, 2663894, 25089373, 1729120, 1728976, 1826193, 1949004, 15419098, 2674170, 2669356, 1824908, 1931440, 1933865, 1953810, 1823467, 1943475, 1943815, 1823037, 1931251, 1955377, 1955273, 1732456, 1935963, 1830603, 1826269, 1734285, 1933088, 2674018, 1829717, 1953112, 22680310, 1950873, 2673848, 1943997, 1737009, 10374087, 1730546, 1829934, 1830434, 1731019, 1823715, 1934672, 1951179, 1937692, 1750628, 1729658, 1823959, 1952040, 1954644, 1937544, 8844791, 1939951, 4062700, 1957306, 13873463, 1948441, 1730377, 1955349, 26306220, 1736624, 1949730, 1949818, 1824146, 50929972, 1825302, 9258388, 1954471, 1941268, 1949614, 1733314, 1938764, 35313684, 1932702, 1953959, 1940948, 1737274, 1948291, 1950703, 1949028, 1734343, 1737844, 1933727, 1954958, 1823821, 43826963, 1946779, 37868363, 1955319, 3402151, 27947163, 22680313, 1735424, 1731048, 2674009, 47930787, 1955972, 1824363, 1823886, 1728156, 2674013, 2670780, 1942813, 1952996, 1750052, 1948486, 1950256, 1932470, 1729443, 1737589, 2674165, 1952542, 2670053, 1955508, 1950753, 1950811, 47978187, 1946548, 9886762, 1828318, 1828934, 29789987, 1823188, 16605043, 1826175, 17071511, 1827458, 2669496, 1948166, 1955017, 1954696, 1952660, 1936218, 1827876, 1738782, 1954411, 1825612, 1737665, 1930577, 22680307, 1950224, 23899160, 4062709, 42444600, 1937978, 1942414, 1735334, 1941470, 1738871, 50010802, 1931105, 1948505, 31896277, 1948108, 1950095, 1947355, 2674021, 1735857, 1730727, 1729325, 1953997, 1823052, 1731339, 1825519, 2669164, 29789564, 1737234, 1950988, 1730951, 1943586, 1954907, 1827922, 1955577, 1733212, 1938666, 1732394, 1947551, 1728448, 1826683, 2853529, 1729347, 1952359, 1737173, 8745860, 20962005, 1736996, 1934723, 1942484, 1947198, 1734330, 33905433, 1734130, 22680295, 1955200, 1830380, 1954940, 1932213, 1728960, 1955727, 1949477, 1727824, 1824813, 1957212, 1750886, 1954524, 30841045, 1739372, 8746207, 41064007, 1739062, 1951622, 1949086, 1731471, 40707373, 1948687, 1941076, 1948522 ) 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 (1829206,9629644,1951749,1936689,1941684,30205115,1734194,1733491,1931829,1947843,1735575,1750906,22870909,1947826,1738191,1957246,1949676,1947886,1828794,33623528,1955685,1730342,1946671,1947728,1732918,1950667,1735975,1736889,1946839,1955322,42144620,1824754,1939045,1933417,1733775,1930778,1939108,1954995,1955738,1952143,11862006,1734569,31788832,1947958,1938936,1733186,1948700,1823552,1952246,2673544,1934252,4062830,1825793,1936897,1951414,21824738,1828062,1941039,1736862,1823597,1738037,1938835,1732510,1955094,1955415,50200137,1951116,21577455,26021709,6648868,1732419,1733811,1735734,1826626,2673903,1942274,1824536,1954889,1949501,1954551,1727813,1939308,1930481,1932966,1733120,1824854,1736723,1730031,1950645,1946502,1946470,27178461,1932776,48564332,41365379,1739120,21984508,1829134,1737328,1941538,1827779,1734240,1750909,1736761,1731437,28929422,1948977,11618312,1750647,31261223,27142048,1750841,8382758,1943182,1957280,4062676,1955624,1826473,1733028,12149352,1953774,1940590,15498026,1951695,2664006,1933433,43399592,1955042,1729848,27066902,1938100,49874948,1735488,1824068,1729604,1739660,4062757,1737642,1734086,2669577,41458409,1826136,1948065,1730858,1732017,1728765,1827242,1823127,41278917,31747387,1942882,1730678,1930447,1739074,22680304,1739032,1737555,1942503,1728547,1946528,1828920,1825448,1950128,43822465,1733016,41704397,1824253,1954353,1932526,1946065,25215728,4442305,1954488,2673541,1730694,1931733,1953092,13770777,31159141,1735985,1729762,1729176,1935741,2670885,1823376,1733525,1730586,1948321,1946806,1747740,1956007,1750860,39811619,1730598,1737654,1735385,1948710,1932817,1738785,1823444,1823171,1938339,23107117,1937367,1942686,18250396,3283074,1829797,1730919,1824494,1733379,1729000,1946951,1936326,21862384,1955919,1733965,1955046,1948303,1737436,4062912,1733355,1729389,4062806,1937469,1828360,11245625,47196812,1934294,31077191,1952166,1733826,1954921,1947283,1931758,1951232,1829617,1947615,29789097,1823239,1952062,1825713,1948900,2664864,1732645,1736773,9576144,1829510,33363840,1733744,41453473,29819550,27972191,1728707,1829458,33294335,1737602,1739008,15118655,1948414,1943137,19928947,1933801,1955952,1826686,1823539,31823031,1949966,1937824,1939806,1955476,2663977,1947435,2673915,1952340,1940778,1950062,22680298,1951458,1823609,1736830,1826326,1952501,1947469,1951986,1732163,1828194,1955197,48417638,2669983,4062921,1750679,1737987,1948401,1946098,1947373,1952424,2673689,1730704,1729870,1828871,1729645,29787925,22621551,1955936,1749936,1733895,1829408,1736675,1737668,17364709,1940444,44433919,1728417,1947083,15419107,1947036,1951927,38290359,1948827,1946296,3089986,1750798,1935804,1731831,7757553,1829479,2666152,1829164,2674068,1946582,1735663,1955268,1733241,1735505,1826556,1950333,1950174,1942441,29789889,1735710,1943508,2673648,1954391,1828133,1732250,1829900,2670355,1948260,5554733,1825179,1943973,1949915,9629647,1731875,1828716,2663247,1727855,1824745,1824952,1953052,2670783,1934349,1947387,1738986,1948847,1828510,1824605,1732231,1946746,39908198,1951065,27866430,1738996,1750660,11928644,1949421,29263800,1733471,1823090,3238663,35658710,1825677,1943201,49917837,1823654,1955705,29788089,1930954,1737106,1955956,1827613,2670240,1943105,1940920,41108210,1824347,1954604,37911918,27066899,1949573,40707377,46852469,1730657,30525605,1942177,1952204,1948234,25984203,1951675,1732862,1951313,27066893,2670158,1952101,1953156,1935486,9576135,1827525,1828221,1948646,29788817,1825011,1942388,1736055,2663894,25089373,1729120,1728976,1826193,1949004,15419098,2674170,2669356,1824908,1931440,1933865,1953810,1823467,1943475,1943815,1823037,1931251,1955377,1955273,1732456,1935963,1830603,1826269,1734285,1933088,2674018,1829717,1953112,22680310,1950873,2673848,1943997,1737009,10374087,1730546,1829934,1830434,1731019,1823715,1934672,1951179,1937692,1750628,1729658,1823959,1952040,1954644,1937544,8844791,1939951,4062700,1957306,13873463,1948441,1730377,1955349,26306220,1736624,1949730,1949818,1824146,50929972,1825302,9258388,1954471,1941268,1949614,1733314,1938764,35313684,1932702,1953959,1940948,1737274,1948291,1950703,1949028,1734343,1737844,1933727,1954958,1823821,43826963,1946779,37868363,1955319,3402151,27947163,22680313,1735424,1731048,2674009,47930787,1955972,1824363,1823886,1728156,2674013,2670780,1942813,1952996,1750052,1948486,1950256,1932470,1729443,1737589,2674165,1952542,2670053,1955508,1950753,1950811,47978187,1946548,9886762,1828318,1828934,29789987,1823188,16605043,1826175,17071511,1827458,2669496,1948166,1955017,1954696,1952660,1936218,1827876,1738782,1954411,1825612,1737665,1930577,22680307,1950224,23899160,4062709,42444600,1937978,1942414,1735334,1941470,1738871,50010802,1931105,1948505,31896277,1948108,1950095,1947355,2674021,1735857,1730727,1729325,1953997,1823052,1731339,1825519,2669164,29789564,1737234,1950988,1730951,1943586,1954907,1827922,1955577,1733212,1938666,1732394,1947551,1728448,1826683,2853529,1729347,1952359,1737173,8745860,20962005,1736996,1934723,1942484,1947198,1734330,33905433,1734130,22680295,1955200,1830380,1954940,1932213,1728960,1955727,1949477,1727824,1824813,1957212,1750886,1954524,30841045,1739372,8746207,41064007,1739062,1951622,1949086,1731471,40707373,1948687,1941076,1948522) 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

9.20 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 (11959, 11948, 11910, 11909, 11965, 11963, 11947, 11922, 11921, 11950, 11914, 11920, 11946, 11937, 29785444, 29785442))  GROUP BY dacco.oo_id  ORDER BY  RAND(379)

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  dacco.isTop,
  dacco.bookable,
  dacco.oo_id oo_id
FROM
  `steiermark`.object_8 dacco
WHERE
  dacco.o_published = 1
  AND (
    dacco.town__id IN (
      11959, 11948, 11910, 11909, 11965, 11963,
      11947, 11922, 11921, 11950, 11914,
      11920, 11946, 11937, 29785444, 29785442
    )
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(379)

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.o_published = 1  AND (dacco.town__id IN (11959, 11948, 11910, 11909, 11965, 11963, 11947, 11922, 11921, 11950, 11914, 11920, 11946, 11937, 29785444, 29785442))  GROUP BY dacco.oo_id  ORDER BY  RAND(379) ;

69.08 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 (1829206,9629644,1951749,1936689,1941684,30205115,1734194,1733491,1931829,1947843,1735575,1750906,22870909,1947826,1738191,1957246,1949676,1947886,1828794,33623528,1955685,1730342,1946671,1947728,1732918,1950667,1735975,1736889,1946839,1955322,42144620,1824754,1939045,1933417,1733775,1930778,1939108,1954995,1955738,1952143,11862006,1734569,31788832,1947958,1938936,1733186,1948700,1823552,1952246,2673544,1934252,4062830,1825793,1936897,1951414,21824738,1828062,1941039,1736862,1823597,1738037,1938835,1732510,1955094,1955415,50200137,1951116,21577455,26021709,6648868,1732419,1733811,1735734,1826626,2673903,1942274,1824536,1954889,1949501,1954551,1727813,1939308,1930481,1932966,1733120,1824854,1736723,1730031,1950645,1946502,1946470,27178461,1932776,48564332,41365379,1739120,21984508,1829134,1737328,1941538,1827779,1734240,1750909,1736761,1731437,28929422,1948977,11618312,1750647,31261223,27142048,1750841,8382758,1943182,1957280,4062676,1955624,1826473,1733028,12149352,1953774,1940590,15498026,1951695,2664006,1933433,43399592,1955042,1729848,27066902,1938100,49874948,1735488,1824068,1729604,1739660,4062757,1737642,1734086,2669577,41458409,1826136,1948065,1730858,1732017,1728765,1827242,1823127,41278917,31747387,1942882,1730678,1930447,1739074,22680304,1739032,1737555,1942503,1728547,1946528,1828920,1825448,1950128,43822465,1733016,41704397,1824253,1954353,1932526,1946065,25215728,4442305,1954488,2673541,1730694,1931733,1953092,13770777,31159141,1735985,1729762,1729176,1935741,2670885,1823376,1733525,1730586,1948321,1946806,1747740,1956007,1750860,39811619,1730598,1737654,1735385,1948710,1932817,1738785,1823444,1823171,1938339,23107117,1937367,1942686,18250396,3283074,1829797,1730919,1824494,1733379,1729000,1946951,1936326,21862384,1955919,1733965,1955046,1948303,1737436,4062912,1733355,1729389,4062806,1937469,1828360,11245625,47196812,1934294,31077191,1952166,1733826,1954921,1947283,1931758,1951232,1829617,1947615,29789097,1823239,1952062,1825713,1948900,2664864,1732645,1736773,9576144,1829510,33363840,1733744,41453473,29819550,27972191,1728707,1829458,33294335,1737602,1739008,15118655,1948414,1943137,19928947,1933801,1955952,1826686,1823539,31823031,1949966,1937824,1939806,1955476,2663977,1947435,2673915,1952340,1940778,1950062,22680298,1951458,1823609,1736830,1826326,1952501,1947469,1951986,1732163,1828194,1955197,48417638,2669983,4062921,1750679,1737987,1948401,1946098,1947373,1952424,2673689,1730704,1729870,1828871,1729645,29787925,22621551,1955936,1749936,1733895,1829408,1736675,1737668,17364709,1940444,44433919,1728417,1947083,15419107,1947036,1951927,38290359,1948827,1946296,3089986,1750798,1935804,1731831,7757553,1829479,2666152,1829164,2674068,1946582,1735663,1955268,1733241,1735505,1826556,1950333,1950174,1942441,29789889,1735710,1943508,2673648,1954391,1828133,1732250,1829900,2670355,1948260,5554733,1825179,1943973,1949915,9629647,1731875,1828716,2663247,1727855,1824745,1824952,1953052,2670783,1934349,1947387,1738986,1948847,1828510,1824605,1732231,1946746,39908198,1951065,27866430,1738996,1750660,11928644,1949421,29263800,1733471,1823090,3238663,35658710,1825677,1943201,49917837,1823654,1955705,29788089,1930954,1737106,1955956,1827613,2670240,1943105,1940920,41108210,1824347,1954604,37911918,27066899,1949573,40707377,46852469,1730657,30525605,1942177,1952204,1948234,25984203,1951675,1732862,1951313,27066893,2670158,1952101,1953156,1935486,9576135,1827525,1828221,1948646,29788817,1825011,1942388,1736055,2663894,25089373,1729120,1728976,1826193,1949004,15419098,2674170,2669356,1824908,1931440,1933865,1953810,1823467,1943475,1943815,1823037,1931251,1955377,1955273,1732456,1935963,1830603,1826269,1734285,1933088,2674018,1829717,1953112,22680310,1950873,2673848,1943997,1737009,10374087,1730546,1829934,1830434,1731019,1823715,1934672,1951179,1937692,1750628,1729658,1823959,1952040,1954644,1937544,8844791,1939951,4062700,1957306,13873463,1948441,1730377,1955349,26306220,1736624,1949730,1949818,1824146,50929972,1825302,9258388,1954471,1941268,1949614,1733314,1938764,35313684,1932702,1953959,1940948,1737274,1948291,1950703,1949028,1734343,1737844,1933727,1954958,1823821,43826963,1946779,37868363,1955319,3402151,27947163,22680313,1735424,1731048,2674009,47930787,1955972,1824363,1823886,1728156,2674013,2670780,1942813,1952996,1750052,1948486,1950256,1932470,1729443,1737589,2674165,1952542,2670053,1955508,1950753,1950811,47978187,1946548,9886762,1828318,1828934,29789987,1823188,16605043,1826175,17071511,1827458,2669496,1948166,1955017,1954696,1952660,1936218,1827876,1738782,1954411,1825612,1737665,1930577,22680307,1950224,23899160,4062709,42444600,1937978,1942414,1735334,1941470,1738871,50010802,1931105,1948505,31896277,1948108,1950095,1947355,2674021,1735857,1730727,1729325,1953997,1823052,1731339,1825519,2669164,29789564,1737234,1950988,1730951,1943586,1954907,1827922,1955577,1733212,1938666,1732394,1947551,1728448,1826683,2853529,1729347,1952359,1737173,8745860,20962005,1736996,1934723,1942484,1947198,1734330,33905433,1734130,22680295,1955200,1830380,1954940,1932213,1728960,1955727,1949477,1727824,1824813,1957212,1750886,1954524,30841045,1739372,8746207,41064007,1739062,1951622,1949086,1731471,40707373,1948687,1941076,1948522)
                  
                   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 (
    1829206,
    9629644,
    1951749,
    1936689,
    1941684,
    30205115,
    1734194,
    1733491,
    1931829,
    1947843,
    1735575,
    1750906,
    22870909,
    1947826,
    1738191,
    1957246,
    1949676,
    1947886,
    1828794,
    33623528,
    1955685,
    1730342,
    1946671,
    1947728,
    1732918,
    1950667,
    1735975,
    1736889,
    1946839,
    1955322,
    42144620,
    1824754,
    1939045,
    1933417,
    1733775,
    1930778,
    1939108,
    1954995,
    1955738,
    1952143,
    11862006,
    1734569,
    31788832,
    1947958,
    1938936,
    1733186,
    1948700,
    1823552,
    1952246,
    2673544,
    1934252,
    4062830,
    1825793,
    1936897,
    1951414,
    21824738,
    1828062,
    1941039,
    1736862,
    1823597,
    1738037,
    1938835,
    1732510,
    1955094,
    1955415,
    50200137,
    1951116,
    21577455,
    26021709,
    6648868,
    1732419,
    1733811,
    1735734,
    1826626,
    2673903,
    1942274,
    1824536,
    1954889,
    1949501,
    1954551,
    1727813,
    1939308,
    1930481,
    1932966,
    1733120,
    1824854,
    1736723,
    1730031,
    1950645,
    1946502,
    1946470,
    27178461,
    1932776,
    48564332,
    41365379,
    1739120,
    21984508,
    1829134,
    1737328,
    1941538,
    1827779,
    1734240,
    1750909,
    1736761,
    1731437,
    28929422,
    1948977,
    11618312,
    1750647,
    31261223,
    27142048,
    1750841,
    8382758,
    1943182,
    1957280,
    4062676,
    1955624,
    1826473,
    1733028,
    12149352,
    1953774,
    1940590,
    15498026,
    1951695,
    2664006,
    1933433,
    43399592,
    1955042,
    1729848,
    27066902,
    1938100,
    49874948,
    1735488,
    1824068,
    1729604,
    1739660,
    4062757,
    1737642,
    1734086,
    2669577,
    41458409,
    1826136,
    1948065,
    1730858,
    1732017,
    1728765,
    1827242,
    1823127,
    41278917,
    31747387,
    1942882,
    1730678,
    1930447,
    1739074,
    22680304,
    1739032,
    1737555,
    1942503,
    1728547,
    1946528,
    1828920,
    1825448,
    1950128,
    43822465,
    1733016,
    41704397,
    1824253,
    1954353,
    1932526,
    1946065,
    25215728,
    4442305,
    1954488,
    2673541,
    1730694,
    1931733,
    1953092,
    13770777,
    31159141,
    1735985,
    1729762,
    1729176,
    1935741,
    2670885,
    1823376,
    1733525,
    1730586,
    1948321,
    1946806,
    1747740,
    1956007,
    1750860,
    39811619,
    1730598,
    1737654,
    1735385,
    1948710,
    1932817,
    1738785,
    1823444,
    1823171,
    1938339,
    23107117,
    1937367,
    1942686,
    18250396,
    3283074,
    1829797,
    1730919,
    1824494,
    1733379,
    1729000,
    1946951,
    1936326,
    21862384,
    1955919,
    1733965,
    1955046,
    1948303,
    1737436,
    4062912,
    1733355,
    1729389,
    4062806,
    1937469,
    1828360,
    11245625,
    47196812,
    1934294,
    31077191,
    1952166,
    1733826,
    1954921,
    1947283,
    1931758,
    1951232,
    1829617,
    1947615,
    29789097,
    1823239,
    1952062,
    1825713,
    1948900,
    2664864,
    1732645,
    1736773,
    9576144,
    1829510,
    33363840,
    1733744,
    41453473,
    29819550,
    27972191,
    1728707,
    1829458,
    33294335,
    1737602,
    1739008,
    15118655,
    1948414,
    1943137,
    19928947,
    1933801,
    1955952,
    1826686,
    1823539,
    31823031,
    1949966,
    1937824,
    1939806,
    1955476,
    2663977,
    1947435,
    2673915,
    1952340,
    1940778,
    1950062,
    22680298,
    1951458,
    1823609,
    1736830,
    1826326,
    1952501,
    1947469,
    1951986,
    1732163,
    1828194,
    1955197,
    48417638,
    2669983,
    4062921,
    1750679,
    1737987,
    1948401,
    1946098,
    1947373,
    1952424,
    2673689,
    1730704,
    1729870,
    1828871,
    1729645,
    29787925,
    22621551,
    1955936,
    1749936,
    1733895,
    1829408,
    1736675,
    1737668,
    17364709,
    1940444,
    44433919,
    1728417,
    1947083,
    15419107,
    1947036,
    1951927,
    38290359,
    1948827,
    1946296,
    3089986,
    1750798,
    1935804,
    1731831,
    7757553,
    1829479,
    2666152,
    1829164,
    2674068,
    1946582,
    1735663,
    1955268,
    1733241,
    1735505,
    1826556,
    1950333,
    1950174,
    1942441,
    29789889,
    1735710,
    1943508,
    2673648,
    1954391,
    1828133,
    1732250,
    1829900,
    2670355,
    1948260,
    5554733,
    1825179,
    1943973,
    1949915,
    9629647,
    1731875,
    1828716,
    2663247,
    1727855,
    1824745,
    1824952,
    1953052,
    2670783,
    1934349,
    1947387,
    1738986,
    1948847,
    1828510,
    1824605,
    1732231,
    1946746,
    39908198,
    1951065,
    27866430,
    1738996,
    1750660,
    11928644,
    1949421,
    29263800,
    1733471,
    1823090,
    3238663,
    35658710,
    1825677,
    1943201,
    49917837,
    1823654,
    1955705,
    29788089,
    1930954,
    1737106,
    1955956,
    1827613,
    2670240,
    1943105,
    1940920,
    41108210,
    1824347,
    1954604,
    37911918,
    27066899,
    1949573,
    40707377,
    46852469,
    1730657,
    30525605,
    1942177,
    1952204,
    1948234,
    25984203,
    1951675,
    1732862,
    1951313,
    27066893,
    2670158,
    1952101,
    1953156,
    1935486,
    9576135,
    1827525,
    1828221,
    1948646,
    29788817,
    1825011,
    1942388,
    1736055,
    2663894,
    25089373,
    1729120,
    1728976,
    1826193,
    1949004,
    15419098,
    2674170,
    2669356,
    1824908,
    1931440,
    1933865,
    1953810,
    1823467,
    1943475,
    1943815,
    1823037,
    1931251,
    1955377,
    1955273,
    1732456,
    1935963,
    1830603,
    1826269,
    1734285,
    1933088,
    2674018,
    1829717,
    1953112,
    22680310,
    1950873,
    2673848,
    1943997,
    1737009,
    10374087,
    1730546,
    1829934,
    1830434,
    1731019,
    1823715,
    1934672,
    1951179,
    1937692,
    1750628,
    1729658,
    1823959,
    1952040,
    1954644,
    1937544,
    8844791,
    1939951,
    4062700,
    1957306,
    13873463,
    1948441,
    1730377,
    1955349,
    26306220,
    1736624,
    1949730,
    1949818,
    1824146,
    50929972,
    1825302,
    9258388,
    1954471,
    1941268,
    1949614,
    1733314,
    1938764,
    35313684,
    1932702,
    1953959,
    1940948,
    1737274,
    1948291,
    1950703,
    1949028,
    1734343,
    1737844,
    1933727,
    1954958,
    1823821,
    43826963,
    1946779,
    37868363,
    1955319,
    3402151,
    27947163,
    22680313,
    1735424,
    1731048,
    2674009,
    47930787,
    1955972,
    1824363,
    1823886,
    1728156,
    2674013,
    2670780,
    1942813,
    1952996,
    1750052,
    1948486,
    1950256,
    1932470,
    1729443,
    1737589,
    2674165,
    1952542,
    2670053,
    1955508,
    1950753,
    1950811,
    47978187,
    1946548,
    9886762,
    1828318,
    1828934,
    29789987,
    1823188,
    16605043,
    1826175,
    17071511,
    1827458,
    2669496,
    1948166,
    1955017,
    1954696,
    1952660,
    1936218,
    1827876,
    1738782,
    1954411,
    1825612,
    1737665,
    1930577,
    22680307,
    1950224,
    23899160,
    4062709,
    42444600,
    1937978,
    1942414,
    1735334,
    1941470,
    1738871,
    50010802,
    1931105,
    1948505,
    31896277,
    1948108,
    1950095,
    1947355,
    2674021,
    1735857,
    1730727,
    1729325,
    1953997,
    1823052,
    1731339,
    1825519,
    2669164,
    29789564,
    1737234,
    1950988,
    1730951,
    1943586,
    1954907,
    1827922,
    1955577,
    1733212,
    1938666,
    1732394,
    1947551,
    1728448,
    1826683,
    2853529,
    1729347,
    1952359,
    1737173,
    8745860,
    20962005,
    1736996,
    1934723,
    1942484,
    1947198,
    1734330,
    33905433,
    1734130,
    22680295,
    1955200,
    1830380,
    1954940,
    1932213,
    1728960,
    1955727,
    1949477,
    1727824,
    1824813,
    1957212,
    1750886,
    1954524,
    30841045,
    1739372,
    8746207,
    41064007,
    1739062,
    1951622,
    1949086,
    1731471,
    40707373,
    1948687,
    1941076,
    1948522
  )
  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 (1829206,9629644,1951749,1936689,1941684,30205115,1734194,1733491,1931829,1947843,1735575,1750906,22870909,1947826,1738191,1957246,1949676,1947886,1828794,33623528,1955685,1730342,1946671,1947728,1732918,1950667,1735975,1736889,1946839,1955322,42144620,1824754,1939045,1933417,1733775,1930778,1939108,1954995,1955738,1952143,11862006,1734569,31788832,1947958,1938936,1733186,1948700,1823552,1952246,2673544,1934252,4062830,1825793,1936897,1951414,21824738,1828062,1941039,1736862,1823597,1738037,1938835,1732510,1955094,1955415,50200137,1951116,21577455,26021709,6648868,1732419,1733811,1735734,1826626,2673903,1942274,1824536,1954889,1949501,1954551,1727813,1939308,1930481,1932966,1733120,1824854,1736723,1730031,1950645,1946502,1946470,27178461,1932776,48564332,41365379,1739120,21984508,1829134,1737328,1941538,1827779,1734240,1750909,1736761,1731437,28929422,1948977,11618312,1750647,31261223,27142048,1750841,8382758,1943182,1957280,4062676,1955624,1826473,1733028,12149352,1953774,1940590,15498026,1951695,2664006,1933433,43399592,1955042,1729848,27066902,1938100,49874948,1735488,1824068,1729604,1739660,4062757,1737642,1734086,2669577,41458409,1826136,1948065,1730858,1732017,1728765,1827242,1823127,41278917,31747387,1942882,1730678,1930447,1739074,22680304,1739032,1737555,1942503,1728547,1946528,1828920,1825448,1950128,43822465,1733016,41704397,1824253,1954353,1932526,1946065,25215728,4442305,1954488,2673541,1730694,1931733,1953092,13770777,31159141,1735985,1729762,1729176,1935741,2670885,1823376,1733525,1730586,1948321,1946806,1747740,1956007,1750860,39811619,1730598,1737654,1735385,1948710,1932817,1738785,1823444,1823171,1938339,23107117,1937367,1942686,18250396,3283074,1829797,1730919,1824494,1733379,1729000,1946951,1936326,21862384,1955919,1733965,1955046,1948303,1737436,4062912,1733355,1729389,4062806,1937469,1828360,11245625,47196812,1934294,31077191,1952166,1733826,1954921,1947283,1931758,1951232,1829617,1947615,29789097,1823239,1952062,1825713,1948900,2664864,1732645,1736773,9576144,1829510,33363840,1733744,41453473,29819550,27972191,1728707,1829458,33294335,1737602,1739008,15118655,1948414,1943137,19928947,1933801,1955952,1826686,1823539,31823031,1949966,1937824,1939806,1955476,2663977,1947435,2673915,1952340,1940778,1950062,22680298,1951458,1823609,1736830,1826326,1952501,1947469,1951986,1732163,1828194,1955197,48417638,2669983,4062921,1750679,1737987,1948401,1946098,1947373,1952424,2673689,1730704,1729870,1828871,1729645,29787925,22621551,1955936,1749936,1733895,1829408,1736675,1737668,17364709,1940444,44433919,1728417,1947083,15419107,1947036,1951927,38290359,1948827,1946296,3089986,1750798,1935804,1731831,7757553,1829479,2666152,1829164,2674068,1946582,1735663,1955268,1733241,1735505,1826556,1950333,1950174,1942441,29789889,1735710,1943508,2673648,1954391,1828133,1732250,1829900,2670355,1948260,5554733,1825179,1943973,1949915,9629647,1731875,1828716,2663247,1727855,1824745,1824952,1953052,2670783,1934349,1947387,1738986,1948847,1828510,1824605,1732231,1946746,39908198,1951065,27866430,1738996,1750660,11928644,1949421,29263800,1733471,1823090,3238663,35658710,1825677,1943201,49917837,1823654,1955705,29788089,1930954,1737106,1955956,1827613,2670240,1943105,1940920,41108210,1824347,1954604,37911918,27066899,1949573,40707377,46852469,1730657,30525605,1942177,1952204,1948234,25984203,1951675,1732862,1951313,27066893,2670158,1952101,1953156,1935486,9576135,1827525,1828221,1948646,29788817,1825011,1942388,1736055,2663894,25089373,1729120,1728976,1826193,1949004,15419098,2674170,2669356,1824908,1931440,1933865,1953810,1823467,1943475,1943815,1823037,1931251,1955377,1955273,1732456,1935963,1830603,1826269,1734285,1933088,2674018,1829717,1953112,22680310,1950873,2673848,1943997,1737009,10374087,1730546,1829934,1830434,1731019,1823715,1934672,1951179,1937692,1750628,1729658,1823959,1952040,1954644,1937544,8844791,1939951,4062700,1957306,13873463,1948441,1730377,1955349,26306220,1736624,1949730,1949818,1824146,50929972,1825302,9258388,1954471,1941268,1949614,1733314,1938764,35313684,1932702,1953959,1940948,1737274,1948291,1950703,1949028,1734343,1737844,1933727,1954958,1823821,43826963,1946779,37868363,1955319,3402151,27947163,22680313,1735424,1731048,2674009,47930787,1955972,1824363,1823886,1728156,2674013,2670780,1942813,1952996,1750052,1948486,1950256,1932470,1729443,1737589,2674165,1952542,2670053,1955508,1950753,1950811,47978187,1946548,9886762,1828318,1828934,29789987,1823188,16605043,1826175,17071511,1827458,2669496,1948166,1955017,1954696,1952660,1936218,1827876,1738782,1954411,1825612,1737665,1930577,22680307,1950224,23899160,4062709,42444600,1937978,1942414,1735334,1941470,1738871,50010802,1931105,1948505,31896277,1948108,1950095,1947355,2674021,1735857,1730727,1729325,1953997,1823052,1731339,1825519,2669164,29789564,1737234,1950988,1730951,1943586,1954907,1827922,1955577,1733212,1938666,1732394,1947551,1728448,1826683,2853529,1729347,1952359,1737173,8745860,20962005,1736996,1934723,1942484,1947198,1734330,33905433,1734130,22680295,1955200,1830380,1954940,1932213,1728960,1955727,1949477,1727824,1824813,1957212,1750886,1954524,30841045,1739372,8746207,41064007,1739062,1951622,1949086,1731471,40707373,1948687,1941076,1948522)
                  
                   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/de/Murau/Urlaub-planen/Unterkuenfte-suchen-und-buchen?nearbySearchId=1430661&nearbySearchLat=47.39234&nearbySearchLong=14.20394&sorting=nearbySearchAsc

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