Symfony Profiler

Query Metrics

68 Database Queries

26 Different statements

21.92 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

default connection


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT * FROM tmp_store WHERE id = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
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 *
            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 *
            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 *
            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 id FROM tags WHERE LOWER(name) = ?  LIMIT 1
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags_assignment INNER JOIN objects el ON tags_assignment.cId = el.id WHERE (tags_assignment.ctype = ?) AND (tags_assignment.tagid = ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT object_localized_news_ca.id as id, object_localized_news_ca.type as `type` FROM object_localized_news_ca WHERE (oo_id IN (90) AND  object_localized_news_ca.type IN ('object','variant','folder')) AND object_localized_news_ca.published = 1 ORDER BY `date` DESC   LIMIT 10
SELECT COUNT(*) FROM object_localized_news_ca WHERE (oo_id IN (90) AND  object_localized_news_ca.type IN ('object','variant','folder')) AND object_localized_news_ca.published = 1
SELECT * FROM translations_messages LIMIT 1;
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT * FROM object_relations_news WHERE src_id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT r.dest_id, COUNT(*) FROM object_relations_news r
             WHERE r.fieldname = 'categories' GROUP BY r.dest_id
SELECT object_localized_news_category_ca.id as id, object_localized_news_category_ca.type as `type` FROM object_localized_news_category_ca WHERE ( object_localized_news_category_ca.type IN ('object','variant','folder')) AND object_localized_news_category_ca.published = 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT object_localized_news_ca.id as id, object_localized_news_ca.type as `type` FROM object_localized_news_ca WHERE ( object_localized_news_ca.type IN ('object','variant','folder')) AND object_localized_news_ca.published = 1 ORDER BY `date` DESC   LIMIT 5
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT YEAR(FROM_UNIXTIME(date)) AS any, MONTH(FROM_UNIXTIME(date)) AS mes,
                        COUNT(*) AS entrades
                 FROM object_store_news
                 WHERE date IS NOT NULL
                 GROUP BY any, mes
                 ORDER BY any DESC, mes DESC
SELECT t.name, COUNT(*) AS entrades
                 FROM tags_assignment a
                 JOIN tags t ON t.id = a.tagid
                 WHERE a.ctype = ?
                 GROUP BY t.id, t.name
                 HAVING entrades > 1
                 ORDER BY entrades DESC, t.name ASC
                 LIMIT 25

#▲	Time	Info
1	1.01 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648756 "site_domain_2f66a5d22a53d8f08d7ba98373a8f8c0"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648756 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_2f66a5d22a53d8f08d7ba98373a8f8c0');
2	0.25 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648756 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648756 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.25 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
4	0.39 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/blog/etiqueta/crisis de parella" "path" "auto_create" "/blog/etiqueta/crisis de parella" "path_query" "https://psicopnaturmolins.cat/blog/etiqueta/crisis de parella" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/blog/etiqueta/crisis de parella' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/blog/etiqueta/crisis de parella' AND `type` = 'path_query') OR (source = 'https://psicopnaturmolins.cat/blog/etiqueta/crisis de parella' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
5	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648756 "system_route_redirect"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648756 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1786648756 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648756 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.22 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
8	0.34 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/blog/etiqueta/" "crisis de parella"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/blog/etiqueta/' AND `key` = BINARY 'crisis de parella';
9	0.30 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/blog/etiqueta/crisis de parella"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/blog/etiqueta/crisis de parella';
10	0.17 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/blog/" "etiqueta"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/blog/' AND `key` = BINARY 'etiqueta';
11	0.17 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/blog/etiqueta"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/blog/etiqueta';
12	0.16 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "blog"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'blog';
13	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "document_18"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_18');
14	0.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "document_18\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_18tags');
15	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "document_properties_18"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_18');
16	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "document_properties\x01tags\x01" "document_18\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_18tags');
17	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: [`"coorporate_address" 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 = 'coorporate_address' 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;
18	0.21 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;
19	0.27 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: [`"coorporate_name" 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 = 'coorporate_name' 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;
20	0.18 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 2;
21	0.26 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: [`"telephone" 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 = 'telephone' 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;
22	0.14 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 10;
23	0.22 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: [`"mobile" 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 = 'mobile' 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;
24	0.19 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 9;
25	0.34 ms	SELECT id FROM tags WHERE LOWER(name) = ? LIMIT 1 Parameters: [`"crisis de parella"`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE LOWER(name) = ? LIMIT 1 SELECT id FROM tags WHERE LOWER(name) = 'crisis de parella' LIMIT 1;
26	0.24 ms	SELECT * FROM tags WHERE id = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 395;
27	0.35 ms	SELECT * FROM tags_assignment INNER JOIN objects el ON tags_assignment.cId = el.id WHERE (tags_assignment.ctype = ?) AND (tags_assignment.tagid = ?) Parameters: [`"object" 395`] View formatted query View runnable query Explain query SELECT * FROM tags_assignment INNER JOIN objects el ON tags_assignment.cId = el.id WHERE (tags_assignment.ctype = ?) AND (tags_assignment.tagid = ?) SELECT * FROM tags_assignment INNER JOIN objects el ON tags_assignment.cId = el.id WHERE (tags_assignment.ctype = 'object') AND (tags_assignment.tagid = 395);
28	0.27 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "object_90"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_90');
29	0.41 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"news"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'news';
30	0.30 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "object_90\x01tags\x01" "class_news\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_90tags', 'class_newstags');
31	0.71 ms	SELECT object_localized_news_ca.id as id, object_localized_news_ca.type as `type` FROM object_localized_news_ca WHERE (oo_id IN (90) AND object_localized_news_ca.type IN ('object','variant','folder')) AND object_localized_news_ca.published = 1 ORDER BY `date` DESC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_news_ca.id as id, object_localized_news_ca.type as `type` FROM object_localized_news_ca WHERE ( oo_id IN (90) AND object_localized_news_ca.type IN ('object', 'variant', 'folder') ) AND object_localized_news_ca.published = 1 ORDER BY `date` DESC LIMIT 10 SELECT object_localized_news_ca.id as id, object_localized_news_ca.type as `type` FROM object_localized_news_ca WHERE (oo_id IN (90) AND object_localized_news_ca.type IN ('object','variant','folder')) AND object_localized_news_ca.published = 1 ORDER BY `date` DESC LIMIT 10;
32	0.74 ms	SELECT COUNT() FROM object_localized_news_ca WHERE (oo_id IN (90) AND object_localized_news_ca.type IN ('object','variant','folder')) AND object_localized_news_ca.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM object_localized_news_ca WHERE ( oo_id IN (90) AND object_localized_news_ca.type IN ('object', 'variant', 'folder') ) AND object_localized_news_ca.published = 1 SELECT COUNT(*) FROM object_localized_news_ca WHERE (oo_id IN (90) AND object_localized_news_ca.type IN ('object','variant','folder')) AND object_localized_news_ca.published = 1;
33	0.45 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;;
34	0.26 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "translation_data_7dc9af60470c3b94dfbc21408c4c843a"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translation_data_7dc9af60470c3b94dfbc21408c4c843a');
35	0.25 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1786648757 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags');
36	0.36 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "document_1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
37	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "document_1\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags');
38	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "nav_5c4b242e936ff98d9730282bb67058e8"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('nav_5c4b242e936ff98d9730282bb67058e8');
39	0.56 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`1786648757 "output\x01tags\x01" "navigation\x01tags\x01" "document_2\x01tags\x01" "document_3\x01tags\x01" "document_5\x01tags\x01" "document_6\x01tags\x01" "document_7\x01tags\x01" "document_8\x01tags\x01" "document_9\x01tags\x01" "document_10\x01tags\x01" "document_11\x01tags\x01" "document_12\x01tags\x01" "document_13\x01tags\x01" "document_14\x01tags\x01" "document_15\x01tags\x01" "document_4\x01tags\x01" "document_18\x01tags\x01" "document_16\x01tags\x01" "document_22\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_2tags', 'document_3tags', 'document_5tags', 'document_6tags', 'document_7tags', 'document_8tags', 'document_9tags', 'document_10tags', 'document_11tags', 'document_12tags', 'document_13tags', 'document_14tags', 'document_15tags', 'document_4tags', 'document_18tags', 'document_16tags', 'document_22tags');
40	0.29 ms	SELECT * FROM object_relations_news WHERE src_id = ? Parameters: [`90`] View formatted query View runnable query Explain query SELECT * FROM object_relations_news WHERE src_id = ? SELECT * FROM object_relations_news WHERE src_id = 90;
41	0.27 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "asset_55"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_55');
42	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "asset_55\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_55tags');
43	0.20 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`55`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 55;
44	0.21 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`55`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 55;
45	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "imagick_format_avif"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_avif');
46	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "imagick_format_webp"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp');
47	0.65 ms	SELECT r.dest_id, COUNT() FROM object_relations_news r WHERE r.fieldname = 'categories' GROUP BY r.dest_id Parameters: [] View formatted query View runnable query Explain query SELECT r.dest_id, COUNT() FROM object_relations_news r WHERE r.fieldname = 'categories' GROUP BY r.dest_id SELECT r.dest_id, COUNT(*) FROM object_relations_news r WHERE r.fieldname = 'categories' GROUP BY r.dest_id;
48	0.60 ms	SELECT object_localized_news_category_ca.id as id, object_localized_news_category_ca.type as `type` FROM object_localized_news_category_ca WHERE ( object_localized_news_category_ca.type IN ('object','variant','folder')) AND object_localized_news_category_ca.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_news_category_ca.id as id, object_localized_news_category_ca.type as `type` FROM object_localized_news_category_ca WHERE ( object_localized_news_category_ca.type IN ('object', 'variant', 'folder') ) AND object_localized_news_category_ca.published = 1 SELECT object_localized_news_category_ca.id as id, object_localized_news_category_ca.type as `type` FROM object_localized_news_category_ca WHERE ( object_localized_news_category_ca.type IN ('object','variant','folder')) AND object_localized_news_category_ca.published = 1;
49	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "object_14"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_14');
50	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"news_category"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'news_category';
51	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "object_14\x01tags\x01" "class_news_category\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_14tags', 'class_news_categorytags');
52	0.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "object_15"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_15');
53	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "object_15\x01tags\x01" "class_news_category\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_15tags', 'class_news_categorytags');
54	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "object_16"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_16');
55	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "object_16\x01tags\x01" "class_news_category\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_16tags', 'class_news_categorytags');
56	0.53 ms	SELECT object_localized_news_ca.id as id, object_localized_news_ca.type as `type` FROM object_localized_news_ca WHERE ( object_localized_news_ca.type IN ('object','variant','folder')) AND object_localized_news_ca.published = 1 ORDER BY `date` DESC LIMIT 5 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_news_ca.id as id, object_localized_news_ca.type as `type` FROM object_localized_news_ca WHERE ( object_localized_news_ca.type IN ('object', 'variant', 'folder') ) AND object_localized_news_ca.published = 1 ORDER BY `date` DESC LIMIT 5 SELECT object_localized_news_ca.id as id, object_localized_news_ca.type as `type` FROM object_localized_news_ca WHERE ( object_localized_news_ca.type IN ('object','variant','folder')) AND object_localized_news_ca.published = 1 ORDER BY `date` DESC LIMIT 5;
57	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "object_94"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_94');
58	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "object_94\x01tags\x01" "class_news\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_94tags', 'class_newstags');
59	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "object_93"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_93');
60	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "object_93\x01tags\x01" "class_news\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_93tags', 'class_newstags');
61	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "object_12"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_12');
62	0.23 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "object_12\x01tags\x01" "class_news\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_12tags', 'class_newstags');
63	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "object_92"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_92');
64	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "object_92\x01tags\x01" "class_news\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_92tags', 'class_newstags');
65	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1786648757 "object_13"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_13');
66	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1786648757 "object_13\x01tags\x01" "class_news\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1786648757 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_13tags', 'class_newstags');
67	0.41 ms	SELECT YEAR(FROM_UNIXTIME(date)) AS any, MONTH(FROM_UNIXTIME(date)) AS mes, COUNT() AS entrades FROM object_store_news WHERE date IS NOT NULL GROUP BY any, mes ORDER BY any DESC, mes DESC Parameters: [] View formatted query View runnable query Explain query SELECT YEAR( FROM_UNIXTIME(date) ) AS any, MONTH( FROM_UNIXTIME(date) ) AS mes, COUNT() AS entrades FROM object_store_news WHERE date IS NOT NULL GROUP BY any, mes ORDER BY any DESC, mes DESC SELECT YEAR(FROM_UNIXTIME(date)) AS any, MONTH(FROM_UNIXTIME(date)) AS mes, COUNT(*) AS entrades FROM object_store_news WHERE date IS NOT NULL GROUP BY any, mes ORDER BY any DESC, mes DESC;
68	2.89 ms	SELECT t.name, COUNT() AS entrades FROM tags_assignment a JOIN tags t ON t.id = a.tagid WHERE a.ctype = ? GROUP BY t.id, t.name HAVING entrades > 1 ORDER BY entrades DESC, t.name ASC LIMIT 25 Parameters: [`"object"`] View formatted query View runnable query Explain query SELECT t.name, COUNT() AS entrades FROM tags_assignment a JOIN tags t ON t.id = a.tagid WHERE a.ctype = ? GROUP BY t.id, t.name HAVING entrades > 1 ORDER BY entrades DESC, t.name ASC LIMIT 25 SELECT t.name, COUNT(*) AS entrades FROM tags_assignment a JOIN tags t ON t.id = a.tagid WHERE a.ctype = 'object' GROUP BY t.id, t.name HAVING entrades > 1 ORDER BY entrades DESC, t.name ASC LIMIT 25;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
antic	doctrine.dbal.antic_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://psicopnaturmolins.cat/blog/etiqueta/crisis%20de%20parella

Configuration Settings

Theme

Page Width