Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

189 Database Queries

36 Different statements

166.51 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 * 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 = ? 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 = ? 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 = ? 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 = ? 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 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 name FROM classes WHERE id = ?
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 * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT name FROM classes WHERE id = ?
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 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 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 settings_store WHERE id = :id AND scope = :scope
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE (fid='' AND  object_52.o_type IN ('object')) AND object_52.o_published = 1 ORDER BY `o_published` DESC   LIMIT 2
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
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 * 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 * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
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 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 * 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 name FROM classes WHERE id = ?
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 * 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 * 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 * 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 * 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 * 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 * 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 * 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 * 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 * 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 * 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 * 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 * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds))
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
SELECT name FROM classes WHERE id = ?
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 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 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 objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds))
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
SELECT name FROM classes WHERE id = ?
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 objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds))
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
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 objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
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 objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds))
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
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 objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
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 objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE (fid='' AND  object_52.o_type IN ('object')) AND object_52.o_published = 1 ORDER BY `o_published` DESC   LIMIT 2
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT object_62.o_id as o_id, object_62.o_type as o_type FROM object_62 WHERE (`salutationLanguage` = 'de'  AND  object_62.o_type IN ('object','folder')) AND object_62.o_published = 1
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.35 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.08 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.09 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.30 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.42 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC Parameters: ["sourcePath" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939" "sourcePathQuery" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939" "sourceEntireUri" => "https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939' 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.12 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" => "Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939" "path" => "/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/' AND `key` = BINARY 'Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939';
10	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939"`] 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/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939';
11	0.12 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939';
12	0.08 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Unterkuenfte" "path" => "/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte';
13	0.11 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.11 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.12 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.13 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.09 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.07 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.06 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.25 ms	SELECT * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`253939 "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 = 253939 AND fieldname = 'links' ORDER BY `index` ASC;
21	0.41 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: [`253939 "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 = 253939 AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = 'links' AND `index` = 0;
22	0.37 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: [`253939 "links" 1`] 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 = 253939 AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = 'links' AND `index` = 1;
23	0.36 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: [`253939 "links" 2`] 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 = 253939 AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = 'links' AND `index` = 2;
24	0.36 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: [`253939 "links" 3`] 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 = 253939 AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = 'links' AND `index` = 3;
25	0.37 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: [`253939 "links" 4`] 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 = 253939 AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = 'links' AND `index` = 4;
26	0.36 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: [`253939 "links" 5`] 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 = 253939 AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = 'links' AND `index` = 5;
27	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';
28	0.07 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';
29	0.13 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';
30	0.15 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`7159`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 7159;
31	0.08 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';
32	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';
33	0.20 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"44"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '44';
34	0.30 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" => 253939 "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 = 253939) AND (objectRelationsPSection.fieldname = 'serviceProvider'))) AND (objectRelations.fieldname = 'sections');
35	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"55"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '55';
36	0.18 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;;
37	0.13 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';
38	0.08 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';
39	0.19 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';
40	0.92 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" => "%,11408%"`] 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 '%,11408%' AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1;
41	0.60 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" => "%,11408%"`] 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 '%,11408%' AND o_key != "Steiermark")) AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1 LIMIT 1;
42	0.08 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';
43	0.25 ms	SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`253939 "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 = 253939 AND fieldname = 'addresses' ORDER BY `index` ASC;
44	0.24 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';
45	0.13 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';
46	0.11 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "slider-main" "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 = 'slider-main' AND scope = 'pimcore_image_thumbnails';
47	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530205`] 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 = 5530205;
48	0.13 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';
49	0.13 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`7159`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 7159;
50	0.16 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7159 7159 7159`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(7159, 7159) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7159;
51	0.12 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7930 7930`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 7930 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7930;
52	0.10 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
53	0.10 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`7159`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 7159;
54	0.16 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7159 7159 7159`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(7159, 7159) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7159;
55	0.12 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`7930 7930`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 7930 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7930;
56	0.09 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
57	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1524019`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1524019;
58	0.09 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
59	0.09 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
60	0.12 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-full-img-header" "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-full-img-header' AND scope = 'pimcore_image_thumbnails';
61	0.14 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`8152`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 8152;
62	0.13 ms	SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`5882755 "datepickerInfoTexts"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 5882755 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;
63	0.39 ms	SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE (fid='' AND object_52.o_type IN ('object')) AND object_52.o_published = 1 ORDER BY `o_published` DESC LIMIT 2 Parameters: [] View formatted query View runnable query Explain query SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE ( fid = '' AND object_52.o_type IN ('object') ) AND object_52.o_published = 1 ORDER BY `o_published` DESC LIMIT 2 SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE (fid='' AND object_52.o_type IN ('object')) AND object_52.o_published = 1 ORDER BY `o_published` DESC LIMIT 2;
64	0.12 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-host-info" "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-host-info' AND scope = 'pimcore_image_thumbnails';
65	0.12 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1906398`] 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 = 1906398;
66	0.20 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: [`253939`] 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 = 253939 ) AND ctype='object';
67	0.13 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-gallery-overlay" "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-overlay' AND scope = 'pimcore_image_thumbnails';
68	0.18 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530206`] 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 = 5530206;
69	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-gallery-2" "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-2' AND scope = 'pimcore_image_thumbnails';
70	0.28 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530216`] 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 = 5530216;
71	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530217`] 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 = 5530217;
72	0.09 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-gallery-3" "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-3' AND scope = 'pimcore_image_thumbnails';
73	0.10 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530218`] 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 = 5530218;
74	0.40 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530219`] 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 = 5530219;
75	0.13 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-gallery-4" "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-4' AND scope = 'pimcore_image_thumbnails';
76	0.36 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530220`] 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 = 5530220;
77	0.14 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-gallery-5" "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-5' AND scope = 'pimcore_image_thumbnails';
78	0.41 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530174`] 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 = 5530174;
79	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530176`] 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 = 5530176;
80	0.47 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530177`] 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 = 5530177;
81	0.27 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';
82	0.17 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530178`] 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 = 5530178;
83	0.38 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530179`] 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 = 5530179;
84	0.35 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530180`] 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 = 5530180;
85	0.20 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530181`] 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 = 5530181;
86	0.12 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530182`] 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 = 5530182;
87	0.39 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530183`] 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 = 5530183;
88	0.40 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530184`] 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 = 5530184;
89	0.21 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530185`] 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 = 5530185;
90	0.21 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530186`] 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 = 5530186;
91	0.37 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530187`] 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 = 5530187;
92	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530188`] 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 = 5530188;
93	0.28 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530189`] 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 = 5530189;
94	0.31 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530190`] 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 = 5530190;
95	0.35 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530191`] 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 = 5530191;
96	0.09 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530192`] 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 = 5530192;
97	0.09 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530193`] 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 = 5530193;
98	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530194`] 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 = 5530194;
99	0.48 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530195`] 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 = 5530195;
100	0.17 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530196`] 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 = 5530196;
101	0.30 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530197`] 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 = 5530197;
102	0.33 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530198`] 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 = 5530198;
103	0.36 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530199`] 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 = 5530199;
104	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530200`] 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 = 5530200;
105	0.47 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530201`] 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 = 5530201;
106	0.37 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530202`] 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 = 5530202;
107	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530203`] 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 = 5530203;
108	0.45 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530204`] 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 = 5530204;
109	0.34 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530207`] 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 = 5530207;
110	0.26 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530208`] 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 = 5530208;
111	0.25 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530209`] 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 = 5530209;
112	0.10 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530210`] 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 = 5530210;
113	0.34 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530211`] 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 = 5530211;
114	0.36 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530212`] 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 = 5530212;
115	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530213`] 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 = 5530213;
116	0.31 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530214`] 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 = 5530214;
117	0.29 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530215`] 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 = 5530215;
118	0.16 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530221`] 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 = 5530221;
119	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530222`] 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 = 5530222;
120	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530223`] 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 = 5530223;
121	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530224`] 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 = 5530224;
122	0.31 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530225`] 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 = 5530225;
123	0.28 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530226`] 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 = 5530226;
124	0.16 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530227`] 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 = 5530227;
125	0.16 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530228`] 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 = 5530228;
126	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530229`] 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 = 5530229;
127	0.17 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530230`] 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 = 5530230;
128	0.16 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530231`] 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 = 5530231;
129	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530232`] 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 = 5530232;
130	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530233`] 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 = 5530233;
131	0.24 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5530234`] 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 = 5530234;
132	0.16 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 254050`] 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 = 254050;
133	1.25 ms	SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds)) Parameters: ["dcValue1" => 1732950561 ":templateIds" => [ 51661982 51616905 51616906 51519653 51519654 51519655 51519656 51398264 51398265 51398266 51398267 51091177 51091178 50904212 50904215 50904216 50853164 50853167 50853172 50853175 50747287 50747288 50557517 50463353 50276201 50276203 50088683 50088684 49898475 49656949 49612072 49515171 49422228 49233906 49142864 49142866 48636747 48636752 48636754 48408920 48006994 48006995 46162264 46069998 45514820 45514823 44843123 44498711 44544297 44544298 41156187 40996848 40465119 40059821 40059826 40059829 40465105 22997095 24832748 30549666 24832750 15428846 254082 51758991 51758992 51758993 51758994 51860026 51860028 51917578 51917579 ]] View formatted query View runnable query Explain query SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE ( :dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo ) AND ( o_id IN (:templateIds) ) SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (1732950561 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds));
134	1.02 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: ["dcValue1" => "Standard" ":templateIds" => [ 51661982 51616905 51616906 51519653 51519654 51519655 51519656 51398264 51398265 51398266 51398267 51091177 51091178 50904212 50904215 50904216 50853164 50853167 50853172 50853175 50747287 50747288 50557517 50463353 50276201 50276203 50088683 50088684 49898475 49656949 49612072 49515171 49422228 49233906 49142864 49142866 48636747 48636752 48636754 48408920 48006994 48006995 46162264 46069998 45514820 45514823 44843123 44498711 44544297 44544298 41156187 40996848 40465119 40059821 40059826 40059829 40465105 22997095 24832748 30549666 24832750 15428846 254082 51758991 51758992 51758993 51758994 51860026 51860028 51917578 51917579 ]] 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');
135	0.10 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';
136	0.25 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`254038 "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 = 254038 AND fieldname = 'facilities' ORDER BY `index` ASC;
137	0.11 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-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-desktop-room-teaser' AND scope = 'pimcore_image_thumbnails';
138	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869942`] 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 = 1869942;
139	0.14 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 254050`] 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 = 254050;
140	0.10 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-gallery-small" "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-small' AND scope = 'pimcore_image_thumbnails';
141	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-room-details" "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-room-details' AND scope = 'pimcore_image_thumbnails';
142	0.11 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869943`] 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 = 1869943;
143	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869944`] 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 = 1869944;
144	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869945`] 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 = 1869945;
145	0.13 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 254110`] 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 = 254110;
146	0.39 ms	SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds)) Parameters: [`"dcValue1" => 1732950561 ":templateIds" => [ 51519668 50802428 50802429 50802431 50802433 49898497 39242928 36633622 22741230 20683678 23824004 254128 51804274 51917576 ]`] View formatted query View runnable query Explain query SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE ( :dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo ) AND ( o_id IN (:templateIds) ) SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (1732950561 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds));
147	0.51 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: [`"dcValue1" => "Standard" ":templateIds" => [ 51519668 50802428 50802429 50802431 50802433 49898497 39242928 36633622 22741230 20683678 23824004 254128 51804274 51917576 ]`] 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');
148	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';
149	0.22 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`254098 "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 = 254098 AND fieldname = 'facilities' ORDER BY `index` ASC;
150	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869947`] 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 = 1869947;
151	0.14 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 254110`] 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 = 254110;
152	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869948`] 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 = 1869948;
153	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869949`] 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 = 1869949;
154	0.12 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 254143`] 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 = 254143;
155	0.73 ms	SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds)) Parameters: [`"dcValue1" => 1732950561 ":templateIds" => [ 51732009 51519662 51519666 51425023 51398280 51328850 51061273 50802466 50802467 50802468 50802469 50802470 50802475 50802476 50802477 50802478 50802479 50802480 50802481 50802482 50802483 50802485 50802486 50802488 50715257 44708258 44544355 44498823 44498828 44498831 44498841 44498869 44498888 254178 51758999 51860043 51860045 51860046 51860047 ]`] View formatted query View runnable query Explain query SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE ( :dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo ) AND ( o_id IN (:templateIds) ) SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (1732950561 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds));
156	0.71 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: [`"dcValue1" => "Standard" ":templateIds" => [ 51732009 51519662 51519666 51425023 51398280 51328850 51061273 50802466 50802467 50802468 50802469 50802470 50802475 50802476 50802477 50802478 50802479 50802480 50802481 50802482 50802483 50802485 50802486 50802488 50715257 44708258 44544355 44498823 44498828 44498831 44498841 44498869 44498888 254178 51758999 51860043 51860045 51860046 51860047 ]`] 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');
157	0.23 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`254129 "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 = 254129 AND fieldname = 'facilities' ORDER BY `index` ASC;
158	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869936`] 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 = 1869936;
159	0.14 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 254143`] 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 = 254143;
160	0.12 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869937`] 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 = 1869937;
161	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869938`] 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 = 1869938;
162	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869939`] 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 = 1869939;
163	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869940`] 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 = 1869940;
164	0.13 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 254194`] 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 = 254194;
165	0.36 ms	SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (:dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds)) Parameters: [`"dcValue1" => 1732950561 ":templateIds" => [ 51091187 50802500 50802501 50802502 50802503 50802504 50802506 49898500 44498769 44498792 44498794 254228 51860051 ]`] View formatted query View runnable query Explain query SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE ( :dcValue1 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo ) AND ( o_id IN (:templateIds) ) SELECT objectCollection.o_id FROM object_collection_demiPeriod_58 objectCollection WHERE (1732950561 BETWEEN objectCollection.dateFrom AND objectCollection.dateTo) AND (o_id IN (:templateIds));
166	0.48 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: [`"dcValue1" => "Standard" ":templateIds" => [ 51091187 50802500 50802501 50802502 50802503 50802504 50802506 49898500 44498769 44498792 44498794 254228 51860051 ]`] 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');
167	0.24 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`254179 "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 = 254179 AND fieldname = 'facilities' ORDER BY `index` ASC;
168	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869951`] 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 = 1869951;
169	0.15 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 254194`] 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 = 254194;
170	0.12 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869952`] 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 = 1869952;
171	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869953`] 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 = 1869953;
172	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869954`] 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 = 1869954;
173	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1869955`] 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 = 1869955;
174	0.13 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 254110`] 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 = 254110;
175	0.11 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-desktop-searchInfoBox-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-desktop-searchInfoBox-teaser' AND scope = 'pimcore_image_thumbnails';
176	0.48 ms	SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE (fid='' AND object_52.o_type IN ('object')) AND object_52.o_published = 1 ORDER BY `o_published` DESC LIMIT 2 Parameters: [] View formatted query View runnable query Explain query SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE ( fid = '' AND object_52.o_type IN ('object') ) AND object_52.o_published = 1 ORDER BY `o_published` DESC LIMIT 2 SELECT object_52.o_id as o_id, object_52.o_type as o_type FROM object_52 WHERE (fid='' AND object_52.o_type IN ('object')) AND object_52.o_published = 1 ORDER BY `o_published` DESC LIMIT 2;
177	0.16 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`8847`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 8847;
178	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"62"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '62';
179	0.53 ms	SELECT object_62.o_id as o_id, object_62.o_type as o_type FROM object_62 WHERE (`salutationLanguage` = 'de' AND object_62.o_type IN ('object','folder')) AND object_62.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_62.o_id as o_id, object_62.o_type as o_type FROM object_62 WHERE ( `salutationLanguage` = 'de' AND object_62.o_type IN ('object', 'folder') ) AND object_62.o_published = 1 SELECT object_62.o_id as o_id, object_62.o_type as o_type FROM object_62 WHERE (`salutationLanguage` = 'de' AND object_62.o_type IN ('object','folder')) AND object_62.o_published = 1;
180	0.19 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6887`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6887;
181	0.13 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';
182	0.19 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


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 (254110,254050,17469330,19106891,17469324,254143,254194) AND dacco.oo_id IN (253939)  AND  dacco.o_published = 1  AND (products.o_published = 1  AND products.productType = 'Accommodation') AND (dacco.town__id IN (11409))  GROUP BY product_id  ORDER BY  RAND(979)
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 (253939)
                  
                   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 (254110,254050,17469330,19106891,17469324,254143,254194) AND dacco.oo_id IN (253939)  AND  dacco.o_published = 1  AND (products.o_published = 1  AND products.productType = 'Accommodation') AND (dacco.town__id IN (11409))  GROUP BY product_id  ORDER BY  RAND(979)
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 (254050,254110,254143,254194)
                       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 (253939)
                  AND pt.product_id IN (254050,254110,254143,254194)
                   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 (253939)  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 (253939)
                  
                   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	0.82 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 (254110,254050,17469330,19106891,17469324,254143,254194) AND dacco.oo_id IN (253939) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11409)) GROUP BY product_id ORDER BY RAND(979) 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 ( 254110, 254050, 17469330, 19106891, 17469324, 254143, 254194 ) AND dacco.oo_id IN (253939) AND dacco.o_published = 1 AND ( products.o_published = 1 AND products.productType = 'Accommodation' ) AND ( dacco.town__id IN (11409) ) GROUP BY product_id ORDER BY RAND(979) 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 (254110,254050,17469330,19106891,17469324,254143,254194) AND dacco.oo_id IN (253939) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11409)) GROUP BY product_id ORDER BY RAND(979) ;
2	31.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 (253939) 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 (253939) 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 (253939) 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.15 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 (254110,254050,17469330,19106891,17469324,254143,254194) AND dacco.oo_id IN (253939) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11409)) GROUP BY product_id ORDER BY RAND(979) 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 ( 254110, 254050, 17469330, 19106891, 17469324, 254143, 254194 ) AND dacco.oo_id IN (253939) AND dacco.o_published = 1 AND ( products.o_published = 1 AND products.productType = 'Accommodation' ) AND ( dacco.town__id IN (11409) ) GROUP BY product_id ORDER BY RAND(979) 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 (254110,254050,17469330,19106891,17469324,254143,254194) AND dacco.oo_id IN (253939) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11409)) GROUP BY product_id ORDER BY RAND(979) ;
4	33.43 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 (254050,254110,254143,254194) 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 (254050, 254110, 254143, 254194) 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 (254050,254110,254143,254194) 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	27.60 ms	SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights FROM `steiermark_vacancies`.price_template pt INNER JOIN `steiermark_vacancies`.price_template_base_prices bp ON bp.price_template_id = pt.id WHERE pt.acco_id IN (253939) AND pt.product_id IN (254050,254110,254143,254194) 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 (253939) AND pt.product_id IN (254050, 254110, 254143, 254194) 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 (253939) AND pt.product_id IN (254050,254110,254143,254194) 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.43 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (253939) 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 (253939) 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 (253939) AND dacco.o_published = 1 GROUP BY dacco.oo_id ;
7	30.53 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 (253939) 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 (253939) 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 (253939) 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/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/Naturhotel-Laerchenhof-Hotel-Ramsau-am-Dachstein_ad-253939

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