Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

102 Database Queries

41 Different statements

152.12 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 * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT objectRelations.src_id FROM object_relations_55 objectRelations WHERE (objectRelations.dest_id IN (SELECT objectRelationsPSection.src_id FROM object_relations_57 objectRelationsPSection WHERE (objectRelationsPSection.dest_id = :dcValue1) AND (objectRelationsPSection.fieldname = :dcValue2))) AND (objectRelations.fieldname = :dcValue3)
SELECT * FROM translations_messages LIMIT 1;
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT COUNT(*) FROM object_localized_Region_en 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_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1
SELECT object_localized_Region_en.o_id as o_id, object_localized_Region_en.o_type as o_type FROM object_localized_Region_en 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_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1 LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT id FROM sites
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM sites
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT id FROM sites
SELECT id FROM sites
SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT name FROM classes WHERE id = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,5815,5673,5670) AND inheritable = 1) OR cid = ? ) AND ctype='object'
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_store_58 WHERE oo_id = ?
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_relations_58 WHERE src_id = ?
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1)
SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM documents_editables WHERE documentId = ?
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 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` = 'en'  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.40 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.11 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.15 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.49 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.11 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.10 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.71 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" => "/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546" "sourcePathQuery" => "/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546?nearbySearchId=324432&nearbySearchLat=47.0748&nearbySearchLong=15.3903&sorting=nearbySearchAsc" "sourceEntireUri" => "https://stage.steiermark.com/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546?nearbySearchId=324432&nearbySearchLat=47.0748&nearbySearchLong=15.3903&sorting=nearbySearchAsc" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546?nearbySearchId=324432&nearbySearchLat=47.0748&nearbySearchLong=15.3903&sorting=nearbySearchAsc' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546?nearbySearchId=324432&nearbySearchLat=47.0748&nearbySearchLong=15.3903&sorting=nearbySearchAsc' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;
8	0.27 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.16 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546" "path" => "/steiermark.com/en/Region-Graz/Vacation-planning/Accommodation/"`] 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/en/Region-Graz/Vacation-planning/Accommodation/' AND `key` = BINARY 'Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546';
10	0.12 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546"`] 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/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546';
11	0.16 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546"`] 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 = '/en/Region-Graz/Vacation-planning/Accommodation/Austria-Trend-Hotel-Europa-Graz-hotel-Graz_ad-26739546';
12	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Accommodation" "path" => "/steiermark.com/en/Region-Graz/Vacation-planning/"`] 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/en/Region-Graz/Vacation-planning/' AND `key` = BINARY 'Accommodation';
13	0.13 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.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.15 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.16 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.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';
18	0.07 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';
19	0.37 ms	SELECT * FROM object_collection_demiLink_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`26739546 "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 = 26739546 AND fieldname = 'links' ORDER BY `index` ASC;
20	0.17 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';
21	0.22 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';
22	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
23	0.16 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`13974`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 13974;
24	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';
25	0.24 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';
26	0.43 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" => 26739546 "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 = 26739546) AND (objectRelationsPSection.fieldname = 'serviceProvider'))) AND (objectRelations.fieldname = 'sections');
27	0.39 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;;
28	0.28 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';
29	0.27 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';
30	0.30 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';
31	1.20 ms	SELECT COUNT() FROM object_localized_Region_en 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_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1 Parameters: [`"demiRegionId" => "%,11467%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_localized_Region_en 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_en.o_type IN ('object', 'folder') ) AND object_localized_Region_en.o_published = 1 SELECT COUNT(*) FROM object_localized_Region_en WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE '%,11467%' AND o_key != "Steiermark")) AND object_localized_Region_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1;
32	0.79 ms	SELECT object_localized_Region_en.o_id as o_id, object_localized_Region_en.o_type as o_type FROM object_localized_Region_en 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_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1 LIMIT 1 Parameters: [`"demiRegionId" => "%,11467%"`] View formatted query View runnable query Explain query SELECT object_localized_Region_en.o_id as o_id, object_localized_Region_en.o_type as o_type FROM object_localized_Region_en 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_en.o_type IN ('object', 'folder') ) AND object_localized_Region_en.o_published = 1 LIMIT 1 SELECT object_localized_Region_en.o_id as o_id, object_localized_Region_en.o_type as o_type FROM object_localized_Region_en WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id from object_31 where filterElements LIKE '%,11467%' AND o_key != "Steiermark")) AND object_localized_Region_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1 LIMIT 1;
33	0.13 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';
34	0.30 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
35	0.39 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`13974`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 13974;
36	0.23 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`5970 13974 13974`] 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(5970, 13974) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 13974;
37	0.16 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`13974 13974`] 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 = 13974 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 13974;
38	0.17 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`5970 5970`] 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 = 5970 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 5970;
39	0.30 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
40	0.24 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 1058282`] 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 = 1058282;
41	0.30 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
42	0.11 ms	SELECT id FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites SELECT id FROM sites;
43	0.36 ms	SELECT * FROM object_collection_demiAddress_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`26739546 "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 = 26739546 AND fieldname = 'addresses' ORDER BY `index` ASC;
44	0.15 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.20 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';
46	0.20 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5507668`] 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 = 5507668;
47	0.26 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-mobile-header-img" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'demi-mobile-header-img' AND scope = 'pimcore_image_thumbnails';
48	0.34 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: [`26739546`] 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 = 26739546 ) AND ctype='object';
49	0.18 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`49857654`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 49857654;
50	0.11 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`49857654`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 49857654;
51	0.06 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"58"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '58';
52	0.09 ms	SELECT * FROM object_store_58 WHERE oo_id = ? Parameters: [`49857654`] View formatted query View runnable query Explain query SELECT * FROM object_store_58 WHERE oo_id = ? SELECT * FROM object_store_58 WHERE oo_id = 49857654;
53	0.18 ms	SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`49857654 "mealTypes"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = 49857654 AND fieldname = 'mealTypes' ORDER BY `index` ASC;
54	0.14 ms	SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`49857654 "periods"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = 49857654 AND fieldname = 'periods' ORDER BY `index` ASC;
55	0.14 ms	SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`49857654 "prices"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = 49857654 AND fieldname = 'prices' ORDER BY `index` ASC;
56	0.12 ms	SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`49857654 "prices"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = 49857654 AND fieldname = 'prices' ORDER BY `index` ASC;
57	0.31 ms	SELECT * FROM object_relations_58 WHERE src_id = ? Parameters: [`49857654`] View formatted query View runnable query Explain query SELECT * FROM object_relations_58 WHERE src_id = ? SELECT * FROM object_relations_58 WHERE src_id = 49857654;
58	0.89 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: [`"dcValue1" => "Standard" ":templateIds" => [ 51735889 51575013 51575022 51525218 51525222 51525226 51431458 51401774 51334521 51287189 51334522 51334523 51334525 51141784 50951756 50755233 50614212 49857651 49857654 49857656 49664835 49664836 49664838 49570079 48552285 48014324 43241046 43283379 42722586 42722588 42722591 42722593 43853077 42722603 42722604 42722608 42722611 42722614 42722618 42722625 42722627 42722631 42722637 30723631 51810591 51810592 51810593 51869141 51869143 51923733 ]`] 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');
59	0.12 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 30256072`] 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 = 30256072;
60	0.11 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-mobile-room-teaser" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'demi-mobile-room-teaser' AND scope = 'pimcore_image_thumbnails';
61	0.37 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3586944`] 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 = 3586944;
62	0.36 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`30256069 "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 = 30256069 AND fieldname = 'facilities' ORDER BY `index` ASC;
63	0.23 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "demi-responsive-detail-big" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'demi-responsive-detail-big' AND scope = 'pimcore_image_thumbnails';
64	0.30 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3586945`] 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 = 3586945;
65	0.26 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3586946`] 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 = 3586946;
66	0.52 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3586947`] 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 = 3586947;
67	1.02 ms	SELECT objectClass.o_id FROM object_58 objectClass WHERE (o_id IN (:templateIds)) AND (objectClass.name = :dcValue1) Parameters: ["dcValue1" => "Standard" ":templateIds" => [ 51735893 51735895 51525233 51525235 51431488 51401777 51401782 51334536 51401784 51334539 51334540 51334544 51287221 51192021 50951778 50951781 50565622 50518774 50189076 50236068 49857670 49811590 49857674 49723512 49664845 49570103 49290265 48972223 48552309 47778554 47778563 42722656 42722664 42722669 42722687 42722698 42722700 42722701 42722702 42722703 42722705 42722714 44972428 42722722 42722728 42722729 42722730 42722731 42722736 30806706 51810603 51869161 51869162 51923743 51923744 51923745 51923746 ]] 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');
68	0.12 ms	SELECT objectRelations.src_id FROM object_relations_44 objectRelations WHERE objectRelations.dest_id = :dcValue1 Parameters: [`"dcValue1" => 30724259`] 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 = 30724259;
69	0.37 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3587001`] 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 = 3587001;
70	0.22 ms	SELECT * FROM object_collection_demiFacilityRelation_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`30724250 "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 = 30724250 AND fieldname = 'facilities' ORDER BY `index` ASC;
71	0.28 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3587002`] 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 = 3587002;
72	0.17 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3587003`] 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 = 3587003;
73	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3587004`] 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 = 3587004;
74	0.20 ms	SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`5882750 "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 = 5882750 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;
75	0.17 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`13960`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 13960;
76	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"31"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '31';
77	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5507669`] 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 = 5507669;
78	0.41 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5507670`] 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 = 5507670;
79	0.30 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5507671`] 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 = 5507671;
80	0.33 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5507672`] 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 = 5507672;
81	0.34 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5507673`] 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 = 5507673;
82	0.37 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 5507674`] 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 = 5507674;
83	0.57 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3418431`] 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 = 3418431;
84	0.44 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3418432`] 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 = 3418432;
85	0.34 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3418433`] 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 = 3418433;
86	0.40 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3418434`] 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 = 3418434;
87	0.44 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3418435`] 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 = 3418435;
88	0.35 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3418436`] 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 = 3418436;
89	0.39 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3418437`] 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 = 3418437;
90	0.30 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 3586940`] 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 = 3586940;
91	0.29 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';
92	0.51 ms	SELECT object_62.o_id as o_id, object_62.o_type as o_type FROM object_62 WHERE (`salutationLanguage` = 'en' 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` = 'en' 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` = 'en' AND object_62.o_type IN ('object','folder')) AND object_62.o_published = 1;
93	0.44 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`13959`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 13959;
94	0.16 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';
95	0.20 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 (30256072,30724259) AND dacco.oo_id IN (26739546)  AND  dacco.o_published = 1  AND (products.o_published = 1  AND products.productType = 'Accommodation') AND (dacco.town__id IN (11475))  GROUP BY product_id  ORDER BY  RAND(89)
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 (26739546)
                  
                   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 (30256072,30724259) AND dacco.oo_id IN (26739546)  AND  dacco.o_published = 1  AND (products.o_published = 1  AND products.productType = 'Accommodation') AND (dacco.town__id IN (11475))  GROUP BY product_id  ORDER BY  RAND(89)
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 (30256072,30724259)
                       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 (26739546)
                  AND pt.product_id IN (30256072,30724259)
                   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 (26739546)  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 (26739546)
                  
                   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.96 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 (30256072,30724259) AND dacco.oo_id IN (26739546) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11475)) GROUP BY product_id ORDER BY RAND(89) 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 (30256072, 30724259) AND dacco.oo_id IN (26739546) AND dacco.o_published = 1 AND ( products.o_published = 1 AND products.productType = 'Accommodation' ) AND ( dacco.town__id IN (11475) ) GROUP BY product_id ORDER BY RAND(89) 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 (30256072,30724259) AND dacco.oo_id IN (26739546) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11475)) GROUP BY product_id ORDER BY RAND(89) ;
2	36.47 ms	SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights FROM `steiermark_vacancies`.price_template pt INNER JOIN `steiermark_vacancies`.price_template_base_prices bp ON bp.price_template_id = pt.id WHERE pt.acco_id IN (26739546) 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 (26739546) 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 (26739546) 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.01 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 (30256072,30724259) AND dacco.oo_id IN (26739546) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11475)) GROUP BY product_id ORDER BY RAND(89) 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 (30256072, 30724259) AND dacco.oo_id IN (26739546) AND dacco.o_published = 1 AND ( products.o_published = 1 AND products.productType = 'Accommodation' ) AND ( dacco.town__id IN (11475) ) GROUP BY product_id ORDER BY RAND(89) 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 (30256072,30724259) AND dacco.oo_id IN (26739546) AND dacco.o_published = 1 AND (products.o_published = 1 AND products.productType = 'Accommodation') AND (dacco.town__id IN (11475)) GROUP BY product_id ORDER BY RAND(89) ;
4	28.63 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 (30256072,30724259) 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 (30256072, 30724259) 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 (30256072,30724259) AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id) order by minPrice ;
5	29.05 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 (26739546) AND pt.product_id IN (30256072,30724259) 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 (26739546) AND pt.product_id IN (30256072, 30724259) 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 (26739546) AND pt.product_id IN (30256072,30724259) 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.64 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (26739546) 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 (26739546) 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 (26739546) AND dacco.o_published = 1 GROUP BY dacco.oo_id ;
7	28.72 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 (26739546) 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 (26739546) 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 (26739546) AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id) order by minPrice ;

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

demi_vacancies connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

portal_engine entity manager

pimcore_direct_edit entity manager

statistics_explorer entity manager