Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

91 Database Queries

33 Different statements

182.45 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 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 targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_demiLink_localized_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = ? AND `index` = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT objectRelations.src_id FROM object_relations_55 objectRelations WHERE (objectRelations.dest_id IN (SELECT objectRelationsPSection.src_id FROM object_relations_57 objectRelationsPSection WHERE (objectRelationsPSection.dest_id = :dcValue1) AND (objectRelationsPSection.fieldname = :dcValue2))) AND (objectRelations.fieldname = :dcValue3)
SELECT * FROM translations_messages LIMIT 1;
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT COUNT(*) FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id
                              from object_31
                              where filterElements LIKE :demiRegionId AND o_key != "Steiermark"))  AND  object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id
                              from object_31
                              where filterElements LIKE :demiRegionId AND o_key != "Steiermark"))  AND  object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1 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 sites
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT id FROM sites
SELECT id FROM sites
SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT name FROM classes WHERE id = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,5815,5673,5670) AND inheritable = 1) OR cid = ? ) AND ctype='object'
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT name FROM classes WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM documents_editables WHERE documentId = ?

#▲	Time	Info
1	0.42 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.07 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.26 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.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: [`"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.08 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.57 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/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394" "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394?nearbySearchId=4092203&nearbySearchLat=46.89711&nearbySearchLong=15.26279&sorting=nearbySearchAsc" "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394?nearbySearchId=4092203&nearbySearchLat=46.89711&nearbySearchLong=15.26279&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/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394?nearbySearchId=4092203&nearbySearchLat=46.89711&nearbySearchLong=15.26279&sorting=nearbySearchAsc' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394?nearbySearchId=4092203&nearbySearchLat=46.89711&nearbySearchLong=15.26279&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.12 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Hotel-Stainzerhof-Hotel-Stainz_ad-1992394" "path" => "/steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen/"`] 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/Urlaub-planen/Unterkuenfte-suchen-buchen/' AND `key` = BINARY 'Hotel-Stainzerhof-Hotel-Stainz_ad-1992394';
10	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394';
11	0.15 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/de/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394"`] 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/Urlaub-planen/Unterkuenfte-suchen-buchen/Hotel-Stainzerhof-Hotel-Stainz_ad-1992394';
12	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Unterkuenfte-suchen-buchen" "path" => "/steiermark.com/de/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/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte-suchen-buchen';
13	0.13 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;
14	0.12 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "customer" "path" => "/deskline/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key SELECT o_id FROM objects WHERE o_path = '/deskline/' AND `o_key` = 'customer';
15	0.16 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';
16	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"69"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '69';
17	0.11 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';
18	0.10 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';
19	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"29"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '29';
20	0.36 ms	SELECT * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1992394 "links"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiLink_8 WHERE o_id = 1992394 AND fieldname = 'links' ORDER BY `index` ASC;
21	0.32 ms	SELECT * FROM object_collection_demiLink_localized_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = ? AND `index` = ? Parameters: [`1992394 "links" 0`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiLink_localized_8 WHERE ooo_id = ? AND language IN ( 'de', 'en', 'hu', 'cs', 'pl', 'nl', 'it', 'sk' ) AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_demiLink_localized_8 WHERE ooo_id = 1992394 AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = 'links' AND `index` = 0;
22	0.09 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';
23	0.25 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';
24	0.11 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';
25	0.24 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`115`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 115;
26	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"7"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '7';
27	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"6"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '6';
28	0.42 ms	SELECT objectRelations.src_id FROM object_relations_55 objectRelations WHERE (objectRelations.dest_id IN (SELECT objectRelationsPSection.src_id FROM object_relations_57 objectRelationsPSection WHERE (objectRelationsPSection.dest_id = :dcValue1) AND (objectRelationsPSection.fieldname = :dcValue2))) AND (objectRelations.fieldname = :dcValue3) Parameters: [`"dcValue1" => 1992394 "dcValue2" => "serviceProvider" "dcValue3" => "sections"`] View formatted query View runnable query Explain query SELECT objectRelations.src_id FROM object_relations_55 objectRelations WHERE ( objectRelations.dest_id IN ( SELECT objectRelationsPSection.src_id FROM object_relations_57 objectRelationsPSection WHERE ( objectRelationsPSection.dest_id = :dcValue1 ) AND ( objectRelationsPSection.fieldname = :dcValue2 ) ) ) AND ( objectRelations.fieldname = :dcValue3 ) SELECT objectRelations.src_id FROM object_relations_55 objectRelations WHERE (objectRelations.dest_id IN (SELECT objectRelationsPSection.src_id FROM object_relations_57 objectRelationsPSection WHERE (objectRelationsPSection.dest_id = 1992394) AND (objectRelationsPSection.fieldname = 'serviceProvider'))) AND (objectRelations.fieldname = 'sections');
29	0.33 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;;
30	0.23 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"68"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '68';
31	0.18 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"23"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '23';
32	0.14 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';
33	0.91 ms	SELECT COUNT() FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE :demiRegionId AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1 Parameters: [`"demiRegionId" => "%,6938%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_localized_Region_de WHERE ( ( IFNULL(isLive, 0) = 1 and demiFilterObject__id IN ( select o_id from object_31 where filterElements LIKE :demiRegionId AND o_key != "Steiermark" ) ) AND object_localized_Region_de.o_type IN ('object', 'folder') ) AND object_localized_Region_de.o_published = 1 SELECT COUNT(*) FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE '%,6938%' AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1;
34	0.46 ms	SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE :demiRegionId AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1 LIMIT 1 Parameters: [`"demiRegionId" => "%,6938%"`] View formatted query View runnable query Explain query SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ( ( IFNULL(isLive, 0) = 1 and demiFilterObject__id IN ( select o_id from object_31 where filterElements LIKE :demiRegionId AND o_key != "Steiermark" ) ) AND object_localized_Region_de.o_type IN ('object', 'folder') ) AND object_localized_Region_de.o_published = 1 LIMIT 1 SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE '%,6938%' AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1 LIMIT 1;
35	0.10 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';
36	0.31 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
37	0.32 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`115`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 115;
38	0.21 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`115 115 115`] 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(115, 115) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 115;
39	0.13 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`4084 4084`] 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 = 4084 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 4084;
40	0.20 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
41	0.21 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;
42	0.20 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
43	0.11 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
44	0.35 ms	SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1992394 "addresses"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiAddress_8 WHERE o_id = 1992394 AND fieldname = 'addresses' ORDER BY `index` ASC;
45	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"27"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '27';
46	0.41 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-gallery-wide-1" "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 = 'demi-desktop-gallery-wide-1' AND scope = 'pimcore_image_thumbnails';
47	0.22 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1222537`] 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 = 1222537;
48	0.49 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-mobile-header-img" "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 = 'demi-mobile-header-img' AND scope = 'pimcore_image_thumbnails';
49	0.59 ms	SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,5815,5673,5670) AND inheritable = 1) OR cid = ? ) AND ctype='object' Parameters: [`1992394`] View formatted query View runnable query Explain query SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( ( cid IN (1, 5815, 5673, 5670) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'object' SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,5815,5673,5670) AND inheritable = 1) OR cid = 1992394 ) AND ctype='object';
50	1.26 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: [`"dcValue1" => "Standard" ":templateIds" => [ 43656877 41198036 41126674 41126676 39697972 39697973 39190581 39190578 39190585 39030514 39606871 38512320 38060407 38060409 41126682 39079385 36918208 43656876 34643791 34562001 46470063 34561999 34562000 34561991 34561990 35330114 34561989 34561988 34561997 34561998 39190584 34561993 39079386 36328224 34562003 28241893 20816668 11215718 1992451 ]`] View formatted query View runnable query Explain query SELECT objectClass.o_id FROM object_58 objectClass WHERE ( o_id IN (:templateIds) ) AND (objectClass.name = :dcValue1) SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = 'Standard');
51	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"58"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '58';
52	0.11 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"52"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '52';
53	0.21 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 1992437`] View formatted query View runnable query Explain query SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = 1992437;
54	0.14 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-mobile-room-teaser" "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 = 'demi-mobile-room-teaser' AND scope = 'pimcore_image_thumbnails';
55	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1222460`] 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 = 1222460;
56	1.01 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1992428 "facilities"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = 1992428 AND fieldname = 'facilities' ORDER BY `index` ASC;
57	0.52 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-responsive-detail-big" "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 = 'demi-responsive-detail-big' AND scope = 'pimcore_image_thumbnails';
58	0.38 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 372782`] 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 = 372782;
59	0.36 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 372780`] 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 = 372780;
60	0.46 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1222463`] 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 = 1222463;
61	0.44 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 372779`] 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 = 372779;
62	1.37 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: [`"dcValue1" => "Standard" ":templateIds" => [ 45666841 43656886 43656885 41198052 41198053 41198054 41198055 41126700 42163123 41126702 41126703 41126704 40004241 39697981 39190601 39190605 45547874 39190595 39190600 40004240 39079395 39030529 39234395 38512328 34643802 34562021 36328234 34562024 34562023 34562027 34562028 34562020 34562016 35330124 34562031 34562032 34562030 34562034 34602395 34562033 28241911 20816679 1992548 ]`] View formatted query View runnable query Explain query SELECT objectClass.o_id FROM object_58 objectClass WHERE ( o_id IN (:templateIds) ) AND (objectClass.name = :dcValue1) SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = 'Standard');
63	0.17 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 1992528`] View formatted query View runnable query Explain query SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = 1992528;
64	0.17 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1222564`] 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 = 1222564;
65	0.97 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1992520 "facilities"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = 1992520 AND fieldname = 'facilities' ORDER BY `index` ASC;
66	0.68 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1222565`] 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 = 1222565;
67	0.65 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1222566`] 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 = 1222566;
68	0.58 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1222567`] 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 = 1222567;
69	0.78 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1222568`] 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 = 1222568;
70	1.45 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: [`"dcValue1" => "Standard" ":templateIds" => [ 43656867 43656868 42230977 41198021 41126723 40004224 40004225 39697962 39190568 39190570 39079402 39030499 38512312 38060426 38060427 38060428 41198020 38060430 38060431 41126731 34643776 34561962 34561963 39079403 34561964 34561965 34561966 34561967 34561970 35330104 34561972 36328214 34561974 34561975 34561976 35824487 28241882 20816656 20816657 11215708 6852998 1992619 ]`] View formatted query View runnable query Explain query SELECT objectClass.o_id FROM object_58 objectClass WHERE ( o_id IN (:templateIds) ) AND (objectClass.name = :dcValue1) SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = 'Standard');
71	0.16 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 1992605`] View formatted query View runnable query Explain query SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = 1992605;
72	0.19 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 372792`] 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 = 372792;
73	0.70 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1992597 "facilities"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = 1992597 AND fieldname = 'facilities' ORDER BY `index` ASC;
74	0.51 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"MediaCopyright"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'MediaCopyright';
75	0.31 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 372794`] 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 = 372794;
76	0.62 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1222570`] 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 = 1222570;
77	1.15 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: [`"dcValue1" => "Standard" ":templateIds" => [ 41198062 39697988 39277745 39190613 38512335 38060439 38060440 37877433 34602406 37719686 34562057 34562055 34562054 34562051 34562053 34562052 34562049 36328243 34562048 39190612 34562047 34602404 35330133 34562045 34562044 34562058 40004248 28241922 20816688 34643813 34562043 1992708 ]`] View formatted query View runnable query Explain query SELECT objectClass.o_id FROM object_58 objectClass WHERE ( o_id IN (:templateIds) ) AND (objectClass.name = :dcValue1) SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = 'Standard');
78	0.14 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 1992696`] View formatted query View runnable query Explain query SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = 1992696;
79	0.17 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 372800`] 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 = 372800;
80	0.48 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1992688 "facilities"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = 1992688 AND fieldname = 'facilities' ORDER BY `index` ASC;
81	0.65 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 372801`] 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 = 372801;
82	0.46 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 372802`] 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 = 372802;
83	0.63 ms	SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`6804 "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 = 6804 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;
84	0.48 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1406`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1406;

demi_vacancies connection


SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id  FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId  INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId  WHERE  products.oo_id IN (1992437,1992696,1992528,1992605) AND dacco.oo_id IN (1992394)  AND  dacco.o_published = 1  AND (products.o_published = 1  AND products.productType = 'Accommodation') AND (dacco.town__id IN (12318))  GROUP BY product_id  ORDER BY  RAND(893)
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 (1992394)
                  
                   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   dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id  FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId  INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId  WHERE  products.oo_id IN (1992437,1992696,1992528,1992605) AND dacco.oo_id IN (1992394)  AND  dacco.o_published = 1  AND (products.o_published = 1  AND products.productType = 'Accommodation') AND (dacco.town__id IN (12318))  GROUP BY product_id  ORDER BY  RAND(893)
SELECT 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.product_id IN (1992696,1992528,1992437,1992605)
                       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 (1992394)
                  AND pt.product_id IN (1992696,1992528,1992437,1992605)
                   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   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1992394)  AND  dacco.o_published = 1   GROUP BY dacco.oo_id
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 (1992394)
                  
                   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
1	1.50 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId WHERE products.oo_id IN (1992437,1992696,1992528,1992605) AND dacco.oo_id IN (1992394) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (12318)) GROUP BY product_id ORDER BY RAND(893) Parameters: [] View formatted query View runnable query Explain query SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId WHERE products.oo_id IN ( 1992437, 1992696, 1992528, 1992605 ) AND dacco.oo_id IN (1992394) AND dacco.o_published = 1 AND ( products.o_published = 1 AND products.productType = 'Accommodation' ) AND ( dacco.town__id IN (12318) ) GROUP BY product_id ORDER BY RAND(893) SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId WHERE products.oo_id IN (1992437,1992696,1992528,1992605) AND dacco.oo_id IN (1992394) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (12318)) GROUP BY product_id ORDER BY RAND(893) ;
2	42.47 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 (1992394) 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 (1992394) 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 (1992394) 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 ;
3	1.57 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId WHERE products.oo_id IN (1992437,1992696,1992528,1992605) AND dacco.oo_id IN (1992394) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (12318)) GROUP BY product_id ORDER BY RAND(893) Parameters: [] View formatted query View runnable query Explain query SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId WHERE products.oo_id IN ( 1992437, 1992696, 1992528, 1992605 ) AND dacco.oo_id IN (1992394) AND dacco.o_published = 1 AND ( products.o_published = 1 AND products.productType = 'Accommodation' ) AND ( dacco.town__id IN (12318) ) GROUP BY product_id ORDER BY RAND(893) SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId WHERE products.oo_id IN (1992437,1992696,1992528,1992605) AND dacco.oo_id IN (1992394) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (12318)) GROUP BY product_id ORDER BY RAND(893) ;
4	39.95 ms	SELECT 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.product_id IN (1992696,1992528,1992437,1992605) 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.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.product_id IN ( 1992696, 1992528, 1992437, 1992605 ) 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.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.product_id IN (1992696,1992528,1992437,1992605) 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 ;
5	29.77 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 (1992394) AND pt.product_id IN (1992696,1992528,1992437,1992605) 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 (1992394) AND pt.product_id IN ( 1992696, 1992528, 1992437, 1992605 ) 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 (1992394) AND pt.product_id IN (1992696,1992528,1992437,1992605) 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 ;
6	0.74 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (1992394) AND dacco.o_published = 1 GROUP BY dacco.oo_id 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.oo_id IN (1992394) AND dacco.o_published = 1 GROUP BY dacco.oo_id SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (1992394) AND dacco.o_published = 1 GROUP BY dacco.oo_id ;
7	36.28 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 (1992394) 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 (1992394) 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 (1992394) AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id) order by minPrice ;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
demi_vacancies	doctrine.dbal.demi_vacancies_connection

Entity Managers

Name	Service
portal_engine	doctrine.orm.portal_engine_entity_manager
pimcore_direct_edit	doctrine.orm.pimcore_direct_edit_entity_manager
statistics_explorer	doctrine.orm.statistics_explorer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/_fragment?_path=_locale%3Dde%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AdefaultAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

demi_vacancies connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

portal_engine entity manager

pimcore_direct_edit entity manager

statistics_explorer entity manager