Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

160 Database Queries

31 Different statements

62.33 ms Query time

0 Invalid entities

Queries

Group similar statements


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 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 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 settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
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_url_slugs WHERE slug = '/ar/about-us' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT object_localized_46_ar.o_id as o_id, object_localized_46_ar.o_type as o_type FROM object_localized_46_ar WHERE ( object_localized_46_ar.o_type IN ('object','folder')) AND object_localized_46_ar.o_published = 1 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 name FROM classes WHERE id = ?
SELECT object_localized_30_ar.o_id as o_id, object_localized_30_ar.o_type as o_type FROM object_localized_30_ar WHERE ( object_localized_30_ar.o_type IN ('object','folder')) AND object_localized_30_ar.o_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 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 object_localized_47_ar.o_id as o_id, object_localized_47_ar.o_type as o_type FROM object_localized_47_ar WHERE ( object_localized_47_ar.o_type IN ('object','folder')) AND object_localized_47_ar.o_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 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 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_47_ar.o_id as o_id, object_localized_47_ar.o_type as o_type FROM object_localized_47_ar WHERE (featured  = 1 AND  object_localized_47_ar.o_type IN ('object','folder')) AND object_localized_47_ar.o_published = 1 LIMIT 1
SELECT object_27.o_id as o_id, object_27.o_type as o_type FROM object_27 WHERE (o_id  = 347 AND  object_27.o_type IN ('object','folder')) AND object_27.o_published = 1 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 name FROM classes WHERE id = ?
SELECT object_localized_events_ar.o_id as o_id, object_localized_events_ar.o_type as o_type FROM object_localized_events_ar WHERE (featured IN (?) AND  object_localized_events_ar.o_type IN ('object','folder')) AND object_localized_events_ar.o_published = 1 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 name FROM classes WHERE id = ?
SELECT object_54.o_id as o_id, object_54.o_type as o_type FROM object_54 WHERE (op_name = ? and u_id = ? and obj_id = ? AND  object_54.o_type IN ('object','folder')) AND object_54.o_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 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 o_id FROM objects WHERE o_path = :path AND `o_key` = :key
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 name FROM classes WHERE id = ?
SELECT object_localized_67_ar.o_id as o_id, object_localized_67_ar.o_type as o_type FROM object_localized_67_ar WHERE (o_id NOT IN (?) AND  object_localized_67_ar.o_type IN ('object','folder')) AND object_localized_67_ar.o_published = 1 ORDER BY `oo_id` DESC   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 object_EF_OSO.o_id as o_id, object_EF_OSO.o_type as o_type FROM object_EF_OSO WHERE (cartId = ? AND IFNULL(successorOrder__id , "") = "" AND  object_EF_OSO.o_type IN ('object','folder')) AND object_EF_OSO.o_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 object_localized_41_ar.o_id as o_id, object_localized_41_ar.o_type as o_type FROM object_localized_41_ar WHERE ( object_localized_41_ar.o_type IN ('object','folder')) AND object_localized_41_ar.o_published = 1 ORDER BY `order` ASC   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 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 object_localized_4_ar.o_id as o_id, object_localized_4_ar.o_type as o_type FROM object_localized_4_ar WHERE ( object_localized_4_ar.o_type IN ('object','folder')) AND object_localized_4_ar.o_published = 1 ORDER BY `order` ASC   LIMIT 10
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 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 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 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_11_ar.o_id as o_id, object_localized_11_ar.o_type as o_type FROM object_localized_11_ar WHERE ( object_localized_11_ar.o_type IN ('object','folder')) AND object_localized_11_ar.o_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 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 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 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 COUNT(*) FROM object_localized_43_ar WHERE (o_parentId = 269 AND  object_localized_43_ar.o_type IN ('object','folder')) AND object_localized_43_ar.o_published = 1
SELECT object_localized_43_ar.o_id as o_id, object_localized_43_ar.o_type as o_type FROM object_localized_43_ar WHERE (o_parentId = 269 AND  object_localized_43_ar.o_type IN ('object','folder')) AND object_localized_43_ar.o_published = 1 ORDER BY `name` ASC   LIMIT 20
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 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 * FROM documents_editables WHERE documentId = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
DELETE FROM tmp_store WHERE id = ?
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'gcs_web' AND TABLE_NAME = 'tmp_store' ORDER BY ORDINAL_POSITION ASC
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'tmp_store' */ WHERE k.table_name = 'tmp_store' AND k.table_schema = 'gcs_web' /*!50116 AND c.constraint_schema = 'gcs_web' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'tmp_store' AND TABLE_SCHEMA = 'gcs_web' ORDER BY SEQ_IN_INDEX ASC
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'tmp_store'
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
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 = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
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 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_4_ar.o_id as o_id, object_localized_4_ar.o_type as o_type FROM object_localized_4_ar WHERE ( object_localized_4_ar.o_type IN ('object','folder')) AND object_localized_4_ar.o_published = 1 ORDER BY `order` ASC   LIMIT 10
SELECT object_localized_11_ar.o_id as o_id, object_localized_11_ar.o_type as o_type FROM object_localized_11_ar WHERE ( object_localized_11_ar.o_type IN ('object','folder')) AND object_localized_11_ar.o_published = 1

#▲	Time	Info
1	1.06 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: [`1765491249 [ "\x00tags\x00site_domain_bc924d98e461656b565b4763d3409616" "site_domain_bc924d98e461656b565b4763d3409616" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_bc924d98e461656b565b4763d3409616', 'site_domain_bc924d98e461656b565b4763d3409616');
2	0.37 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: [`1765491249 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_bc924d98e461656b565b4763d3409616\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_bc924d98e461656b565b4763d3409616\0tags\0');
3	0.62 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 IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/ar/about-us" "sourcePathQuery" => "/ar/about-us" "sourceEntireUri" => "https://gcs.centric.ae/ar/about-us" "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 IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/ar/about-us' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/ar/about-us' AND `type` = 'path_query') OR (source = 'https://gcs.centric.ae/ar/about-us' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
4	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: [`1765491249 [ "\x00tags\x00system_route_redirect" "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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	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: [`1765491249 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'redirect\0tags\0', 'route\0tags\0', 'system_route_redirect\0tags\0');
6	0.33 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';
7	0.37 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "about-us" "path" => "/ar/"`] 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 '/ar/' AND `key` = BINARY 'about-us';
8	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: [`1765491249 [ "\x00tags\x00document_26" "document_26" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_26', 'document_26');
9	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: [`1765491249 [ "document_26\x00tags\x00" "asset_871\x00tags\x00" "asset_1024\x00tags\x00" "asset_1021\x00tags\x00" "asset_1022\x00tags\x00" "asset_1157\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_26\0tags\0', 'asset_871\0tags\0', 'asset_1024\0tags\0', 'asset_1021\0tags\0', 'asset_1022\0tags\0', 'asset_1157\0tags\0');
10	0.47 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: [`1765491249 [ "\x00tags\x00document_properties_26" "document_properties_26" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_26', 'document_properties_26');
11	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: [`1765491249 [ "document_properties\x00tags\x00" "document_26\x00tags\x00" "document_properties_26\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_26\0tags\0', 'document_properties_26\0tags\0');
12	0.35 ms	SELECT * FROM object_url_slugs WHERE slug = '/ar/about-us' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/ar/about-us' AND ( siteId = 0 OR siteId = 0 ) ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/ar/about-us' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;
13	0.38 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	6.46 ms	SELECT object_localized_46_ar.o_id as o_id, object_localized_46_ar.o_type as o_type FROM object_localized_46_ar WHERE ( object_localized_46_ar.o_type IN ('object','folder')) AND object_localized_46_ar.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_46_ar.o_id as o_id, object_localized_46_ar.o_type as o_type FROM object_localized_46_ar WHERE ( object_localized_46_ar.o_type IN ('object', 'folder') ) AND object_localized_46_ar.o_published = 1 LIMIT 1 SELECT object_localized_46_ar.o_id as o_id, object_localized_46_ar.o_type as o_type FROM object_localized_46_ar WHERE ( object_localized_46_ar.o_type IN ('object','folder')) AND object_localized_46_ar.o_published = 1 LIMIT 1;
15	0.67 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: [`1765491249 [ "\x00tags\x00object_330" "object_330" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_330', 'object_330');
16	0.43 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: [`1765491249 [ "object_330\x00tags\x00" "class_46\x00tags\x00" "asset_870\x00tags\x00" "asset_871\x00tags\x00" "asset_407\x00tags\x00" "asset_814\x00tags\x00" "asset_410\x00tags\x00" "asset_815\x00tags\x00" "asset_813\x00tags\x00" "asset_412\x00tags\x00" "asset_812\x00tags\x00" "asset_855\x00tags\x00" "asset_856\x00tags\x00" "asset_857\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_330\0tags\0', 'class_46\0tags\0', 'asset_870\0tags\0', 'asset_871\0tags\0', 'asset_407\0tags\0', 'asset_814\0tags\0', 'asset_410\0tags\0', 'asset_815\0tags\0', 'asset_813\0tags\0', 'asset_412\0tags\0', 'asset_812\0tags\0', 'asset_855\0tags\0', 'asset_856\0tags\0', 'asset_857\0tags\0');
17	0.35 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"46"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '46';
18	0.62 ms	SELECT object_localized_30_ar.o_id as o_id, object_localized_30_ar.o_type as o_type FROM object_localized_30_ar WHERE ( object_localized_30_ar.o_type IN ('object','folder')) AND object_localized_30_ar.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_30_ar.o_id as o_id, object_localized_30_ar.o_type as o_type FROM object_localized_30_ar WHERE ( object_localized_30_ar.o_type IN ('object', 'folder') ) AND object_localized_30_ar.o_published = 1 SELECT object_localized_30_ar.o_id as o_id, object_localized_30_ar.o_type as o_type FROM object_localized_30_ar WHERE ( object_localized_30_ar.o_type IN ('object','folder')) AND object_localized_30_ar.o_published = 1;
19	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: [`1765491249 [ "\x00tags\x00object_47265" "object_47265" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_47265', 'object_47265');
20	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: [`1765491249 [ "object_47265\x00tags\x00" "class_30\x00tags\x00" "asset_515\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_47265\0tags\0', 'class_30\0tags\0', 'asset_515\0tags\0');
21	0.15 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';
22	0.49 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: [`1765491249 [ "\x00tags\x00object_47266" "object_47266" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_47266', 'object_47266');
23	0.33 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: [`1765491249 [ "object_47266\x00tags\x00" "class_30\x00tags\x00" "asset_1167\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_47266\0tags\0', 'class_30\0tags\0', 'asset_1167\0tags\0');
24	0.29 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: [`1765491249 [ "\x00tags\x00object_47268" "object_47268" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_47268', 'object_47268');
25	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: [`1765491249 [ "object_47268\x00tags\x00" "class_30\x00tags\x00" "asset_572\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_47268\0tags\0', 'class_30\0tags\0', 'asset_572\0tags\0');
26	1.54 ms	SELECT object_localized_47_ar.o_id as o_id, object_localized_47_ar.o_type as o_type FROM object_localized_47_ar WHERE ( object_localized_47_ar.o_type IN ('object','folder')) AND object_localized_47_ar.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_47_ar.o_id as o_id, object_localized_47_ar.o_type as o_type FROM object_localized_47_ar WHERE ( object_localized_47_ar.o_type IN ('object', 'folder') ) AND object_localized_47_ar.o_published = 1 SELECT object_localized_47_ar.o_id as o_id, object_localized_47_ar.o_type as o_type FROM object_localized_47_ar WHERE ( object_localized_47_ar.o_type IN ('object','folder')) AND object_localized_47_ar.o_published = 1;
27	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: [`1765491249 [ "\x00tags\x00object_334" "object_334" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_334', 'object_334');
28	0.34 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: [`1765491249 [ "object_334\x00tags\x00" "class_47\x00tags\x00" "asset_142\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_334\0tags\0', 'class_47\0tags\0', 'asset_142\0tags\0');
29	0.22 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"47"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '47';
30	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: [`1765491249 [ "\x00tags\x00object_335" "object_335" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_335', 'object_335');
31	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: [`1765491249 [ "object_335\x00tags\x00" "class_47\x00tags\x00" "asset_143\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_335\0tags\0', 'class_47\0tags\0', 'asset_143\0tags\0');
32	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: [`1765491249 [ "\x00tags\x00object_336" "object_336" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_336', 'object_336');
33	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: [`1765491249 [ "object_336\x00tags\x00" "class_47\x00tags\x00" "asset_145\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_336\0tags\0', 'class_47\0tags\0', 'asset_145\0tags\0');
34	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: [`1765491249 [ "\x00tags\x00object_337" "object_337" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_337', 'object_337');
35	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: [`1765491249 [ "object_337\x00tags\x00" "class_47\x00tags\x00" "asset_144\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_337\0tags\0', 'class_47\0tags\0', 'asset_144\0tags\0');
36	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: [`1765491249 [ "\x00tags\x00object_338" "object_338" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_338', 'object_338');
37	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: [`1765491249 [ "object_338\x00tags\x00" "class_47\x00tags\x00" "asset_146\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_338\0tags\0', 'class_47\0tags\0', 'asset_146\0tags\0');
38	0.55 ms	SELECT object_localized_47_ar.o_id as o_id, object_localized_47_ar.o_type as o_type FROM object_localized_47_ar WHERE (featured = 1 AND object_localized_47_ar.o_type IN ('object','folder')) AND object_localized_47_ar.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_47_ar.o_id as o_id, object_localized_47_ar.o_type as o_type FROM object_localized_47_ar WHERE ( featured = 1 AND object_localized_47_ar.o_type IN ('object', 'folder') ) AND object_localized_47_ar.o_published = 1 LIMIT 1 SELECT object_localized_47_ar.o_id as o_id, object_localized_47_ar.o_type as o_type FROM object_localized_47_ar WHERE (featured = 1 AND object_localized_47_ar.o_type IN ('object','folder')) AND object_localized_47_ar.o_published = 1 LIMIT 1;
39	0.45 ms	SELECT object_27.o_id as o_id, object_27.o_type as o_type FROM object_27 WHERE (o_id = 347 AND object_27.o_type IN ('object','folder')) AND object_27.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_27.o_id as o_id, object_27.o_type as o_type FROM object_27 WHERE ( o_id = 347 AND object_27.o_type IN ('object', 'folder') ) AND object_27.o_published = 1 LIMIT 1 SELECT object_27.o_id as o_id, object_27.o_type as o_type FROM object_27 WHERE (o_id = 347 AND object_27.o_type IN ('object','folder')) AND object_27.o_published = 1 LIMIT 1;
40	0.29 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: [`1765491249 [ "\x00tags\x00object_347" "object_347" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_347', 'object_347');
41	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: [`1765491249 [ "object_347\x00tags\x00" "class_27\x00tags\x00" "asset_413\x00tags\x00" "asset_837\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_347\0tags\0', 'class_27\0tags\0', 'asset_413\0tags\0', 'asset_837\0tags\0');
42	0.14 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';
43	1.62 ms	SELECT object_localized_events_ar.o_id as o_id, object_localized_events_ar.o_type as o_type FROM object_localized_events_ar WHERE (featured IN (?) AND object_localized_events_ar.o_type IN ('object','folder')) AND object_localized_events_ar.o_published = 1 LIMIT 1 Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT object_localized_events_ar.o_id as o_id, object_localized_events_ar.o_type as o_type FROM object_localized_events_ar WHERE ( featured IN (?) AND object_localized_events_ar.o_type IN ('object', 'folder') ) AND object_localized_events_ar.o_published = 1 LIMIT 1 SELECT object_localized_events_ar.o_id as o_id, object_localized_events_ar.o_type as o_type FROM object_localized_events_ar WHERE (featured IN ('1') AND object_localized_events_ar.o_type IN ('object','folder')) AND object_localized_events_ar.o_published = 1 LIMIT 1;
44	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: [`1765491249 [ "\x00tags\x00object_122054" "object_122054" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_122054', 'object_122054');
45	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: [`1765491249 [ "object_122054\x00tags\x00" "class_events\x00tags\x00" "asset_1607\x00tags\x00" "asset_1605\x00tags\x00" "asset_1604\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_122054\0tags\0', 'class_events\0tags\0', 'asset_1607\0tags\0', 'asset_1605\0tags\0', 'asset_1604\0tags\0');
46	0.17 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"events"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'events';
47	0.94 ms	SELECT object_54.o_id as o_id, object_54.o_type as o_type FROM object_54 WHERE (op_name = ? and u_id = ? and obj_id = ? AND object_54.o_type IN ('object','folder')) AND object_54.o_published = 1 Parameters: [`"Like" null 122054`] View formatted query View runnable query Explain query SELECT object_54.o_id as o_id, object_54.o_type as o_type FROM object_54 WHERE ( op_name = ? and u_id = ? and obj_id = ? AND object_54.o_type IN ('object', 'folder') ) AND object_54.o_published = 1 SELECT object_54.o_id as o_id, object_54.o_type as o_type FROM object_54 WHERE (op_name = 'Like' and u_id = NULL and obj_id = 122054 AND object_54.o_type IN ('object','folder')) AND object_54.o_published = 1;
48	0.48 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: [`1765491249 [ "\x00tags\x00website_config" "website_config" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0website_config', 'website_config');
49	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: [`1765491249 [ "website_config\x00tags\x00" "system\x00tags\x00" "config\x00tags\x00" "output\x00tags\x00" "object_49467\x00tags\x00" "object_122141\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_config\0tags\0', 'system\0tags\0', 'config\0tags\0', 'output\0tags\0', 'object_49467\0tags\0', 'object_122141\0tags\0');
50	0.45 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "Newsletter" "path" => "/NewsLetterHead/"`] 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 = '/NewsLetterHead/' AND `o_key` = 'Newsletter';
51	0.37 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: [`1765491249 [ "\x00tags\x00object_122972" "object_122972" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_122972', 'object_122972');
52	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: [`1765491249 [ "object_122972\x00tags\x00" "class_67\x00tags\x00" "asset_1838\x00tags\x00" "asset_1897\x00tags\x00" "asset_1899\x00tags\x00" "asset_1839\x00tags\x00" "asset_1898\x00tags\x00" "asset_1900\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_122972\0tags\0', 'class_67\0tags\0', 'asset_1838\0tags\0', 'asset_1897\0tags\0', 'asset_1899\0tags\0', 'asset_1839\0tags\0', 'asset_1898\0tags\0', 'asset_1900\0tags\0');
53	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"67"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '67';
54	0.78 ms	SELECT object_localized_67_ar.o_id as o_id, object_localized_67_ar.o_type as o_type FROM object_localized_67_ar WHERE (o_id NOT IN (?) AND object_localized_67_ar.o_type IN ('object','folder')) AND object_localized_67_ar.o_published = 1 ORDER BY `oo_id` DESC LIMIT 1 Parameters: [`122972`] View formatted query View runnable query Explain query SELECT object_localized_67_ar.o_id as o_id, object_localized_67_ar.o_type as o_type FROM object_localized_67_ar WHERE ( o_id NOT IN (?) AND object_localized_67_ar.o_type IN ('object', 'folder') ) AND object_localized_67_ar.o_published = 1 ORDER BY `oo_id` DESC LIMIT 1 SELECT object_localized_67_ar.o_id as o_id, object_localized_67_ar.o_type as o_type FROM object_localized_67_ar WHERE (o_id NOT IN (122972) AND object_localized_67_ar.o_type IN ('object','folder')) AND object_localized_67_ar.o_published = 1 ORDER BY `oo_id` DESC LIMIT 1;
55	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: [`1765491249 [ "\x00tags\x00object_123243" "object_123243" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_123243', 'object_123243');
56	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: [`1765491249 [ "object_123243\x00tags\x00" "class_67\x00tags\x00" "asset_2216\x00tags\x00" "asset_1897\x00tags\x00" "asset_1899\x00tags\x00" "asset_2214\x00tags\x00" "asset_1898\x00tags\x00" "asset_1900\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_123243\0tags\0', 'class_67\0tags\0', 'asset_2216\0tags\0', 'asset_1897\0tags\0', 'asset_1899\0tags\0', 'asset_2214\0tags\0', 'asset_1898\0tags\0', 'asset_1900\0tags\0');
57	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: [`1765491249 [ "\x00tags\x00asset_2212" "asset_2212" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_2212', 'asset_2212');
58	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: [`1765491249 [ "asset_2212\x00tags\x00" ]`] 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 > 1765491249 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_2212\0tags\0');
59	0.86 ms	SELECT object_EF_OSO.o_id as o_id, object_EF_OSO.o_type as o_type FROM object_EF_OSO WHERE (cartId = ? AND IFNULL(successorOrder__id , "") = "" AND object_EF_OSO.o_type IN ('object','folder')) AND object_EF_OSO.o_published = 1 Parameters: [`"Pimcore\Bundle\EcommerceFrameworkBundle\CartManager\SessionCart_sesscart_693b422924950"`] View formatted query View runnable query Explain query SELECT object_EF_OSO.o_id as o_id, object_EF_OSO.o_type as o_type FROM object_EF_OSO WHERE ( cartId = ? AND IFNULL(successorOrder__id, "") = "" AND object_EF_OSO.o_type IN ('object', 'folder') ) AND object_EF_OSO.o_published = 1 SELECT object_EF_OSO.o_id as o_id, object_EF_OSO.o_type as o_type FROM object_EF_OSO WHERE (cartId = 'Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\SessionCart_sesscart_693b422924950' AND IFNULL(successorOrder__id , "") = "" AND object_EF_OSO.o_type IN ('object','folder')) AND object_EF_OSO.o_published = 1;
60	0.31 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;;
61	0.50 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: [`1765491250 [ "\x00tags\x00translation_data_0ae734d8b811c294d89efb3311a9fc4d" "translation_data_0ae734d8b811c294d89efb3311a9fc4d" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_0ae734d8b811c294d89efb3311a9fc4d', 'translation_data_0ae734d8b811c294d89efb3311a9fc4d');
62	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: [`1765491250 [ "translator\x00tags\x00" "translator_website\x00tags\x00" "translate\x00tags\x00" "translation_data_0ae734d8b811c294d89efb3311a9fc4d\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translator\0tags\0', 'translator_website\0tags\0', 'translate\0tags\0', 'translation_data_0ae734d8b811c294d89efb3311a9fc4d\0tags\0');
63	0.85 ms	SELECT object_localized_41_ar.o_id as o_id, object_localized_41_ar.o_type as o_type FROM object_localized_41_ar WHERE ( object_localized_41_ar.o_type IN ('object','folder')) AND object_localized_41_ar.o_published = 1 ORDER BY `order` ASC LIMIT 5 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_41_ar.o_id as o_id, object_localized_41_ar.o_type as o_type FROM object_localized_41_ar WHERE ( object_localized_41_ar.o_type IN ('object', 'folder') ) AND object_localized_41_ar.o_published = 1 ORDER BY `order` ASC LIMIT 5 SELECT object_localized_41_ar.o_id as o_id, object_localized_41_ar.o_type as o_type FROM object_localized_41_ar WHERE ( object_localized_41_ar.o_type IN ('object','folder')) AND object_localized_41_ar.o_published = 1 ORDER BY `order` ASC LIMIT 5;
64	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: [`1765491250 [ "\x00tags\x00object_260" "object_260" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_260', 'object_260');
65	0.33 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: [`1765491250 [ "object_260\x00tags\x00" "class_41\x00tags\x00" "asset_2120\x00tags\x00" "asset_2121\x00tags\x00" "asset_2122\x00tags\x00" "asset_1357\x00tags\x00" "asset_1822\x00tags\x00" "asset_1114\x00tags\x00" "asset_616\x00tags\x00" "asset_1364\x00tags\x00" "asset_1367\x00tags\x00" "asset_424\x00tags\x00" "asset_639\x00tags\x00" "asset_425\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_260\0tags\0', 'class_41\0tags\0', 'asset_2120\0tags\0', 'asset_2121\0tags\0', 'asset_2122\0tags\0', 'asset_1357\0tags\0', 'asset_1822\0tags\0', 'asset_1114\0tags\0', 'asset_616\0tags\0', 'asset_1364\0tags\0', 'asset_1367\0tags\0', 'asset_424\0tags\0', 'asset_639\0tags\0', 'asset_425\0tags\0');
66	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"41"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '41';
67	0.47 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: [`1765491250 [ "\x00tags\x00object_413" "object_413" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_413', 'object_413');
68	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: [`1765491250 [ "object_413\x00tags\x00" "class_41\x00tags\x00" "asset_2123\x00tags\x00" "asset_2129\x00tags\x00" "asset_2125\x00tags\x00" "asset_1358\x00tags\x00" "asset_1824\x00tags\x00" "asset_1117\x00tags\x00" "asset_618\x00tags\x00" "asset_1362\x00tags\x00" "asset_1368\x00tags\x00" "asset_1150\x00tags\x00" "asset_1151\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_413\0tags\0', 'class_41\0tags\0', 'asset_2123\0tags\0', 'asset_2129\0tags\0', 'asset_2125\0tags\0', 'asset_1358\0tags\0', 'asset_1824\0tags\0', 'asset_1117\0tags\0', 'asset_618\0tags\0', 'asset_1362\0tags\0', 'asset_1368\0tags\0', 'asset_1150\0tags\0', 'asset_1151\0tags\0');
69	0.28 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: [`1765491250 [ "\x00tags\x00object_263" "object_263" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_263', 'object_263');
70	0.29 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: [`1765491250 [ "object_263\x00tags\x00" "class_41\x00tags\x00" "asset_2126\x00tags\x00" "asset_2127\x00tags\x00" "asset_2128\x00tags\x00" "asset_1356\x00tags\x00" "asset_1823\x00tags\x00" "asset_1116\x00tags\x00" "asset_617\x00tags\x00" "asset_1365\x00tags\x00" "asset_1366\x00tags\x00" "asset_1152\x00tags\x00" "asset_1153\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_263\0tags\0', 'class_41\0tags\0', 'asset_2126\0tags\0', 'asset_2127\0tags\0', 'asset_2128\0tags\0', 'asset_1356\0tags\0', 'asset_1823\0tags\0', 'asset_1116\0tags\0', 'asset_617\0tags\0', 'asset_1365\0tags\0', 'asset_1366\0tags\0', 'asset_1152\0tags\0', 'asset_1153\0tags\0');
71	0.88 ms	SELECT object_localized_4_ar.o_id as o_id, object_localized_4_ar.o_type as o_type FROM object_localized_4_ar WHERE ( object_localized_4_ar.o_type IN ('object','folder')) AND object_localized_4_ar.o_published = 1 ORDER BY `order` ASC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_4_ar.o_id as o_id, object_localized_4_ar.o_type as o_type FROM object_localized_4_ar WHERE ( object_localized_4_ar.o_type IN ('object', 'folder') ) AND object_localized_4_ar.o_published = 1 ORDER BY `order` ASC LIMIT 10 SELECT object_localized_4_ar.o_id as o_id, object_localized_4_ar.o_type as o_type FROM object_localized_4_ar WHERE ( object_localized_4_ar.o_type IN ('object','folder')) AND object_localized_4_ar.o_published = 1 ORDER BY `order` ASC LIMIT 10;
72	0.33 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: [`1765491250 [ "\x00tags\x00object_122158" "object_122158" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_122158', 'object_122158');
73	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: [`1765491250 [ "object_122158\x00tags\x00" "class_4\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_122158\0tags\0', 'class_4\0tags\0');
74	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '4';
75	0.45 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: [`1765491250 [ "\x00tags\x00object_123284" "object_123284" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_123284', 'object_123284');
76	0.34 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: [`1765491250 [ "object_123284\x00tags\x00" "class_4\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_123284\0tags\0', 'class_4\0tags\0');
77	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: [`1765491250 [ "\x00tags\x00object_423" "object_423" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_423', 'object_423');
78	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: [`1765491250 [ "object_423\x00tags\x00" "class_4\x00tags\x00" "asset_1846\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_423\0tags\0', 'class_4\0tags\0', 'asset_1846\0tags\0');
79	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: [`1765491250 [ "\x00tags\x00object_415" "object_415" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_415', 'object_415');
80	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: [`1765491250 [ "object_415\x00tags\x00" "class_4\x00tags\x00" "asset_1850\x00tags\x00" "asset_710\x00tags\x00" "asset_709\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_415\0tags\0', 'class_4\0tags\0', 'asset_1850\0tags\0', 'asset_710\0tags\0', 'asset_709\0tags\0');
81	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: [`1765491250 [ "\x00tags\x00object_539" "object_539" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_539', 'object_539');
82	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: [`1765491250 [ "object_539\x00tags\x00" "class_4\x00tags\x00" "asset_1845\x00tags\x00" "asset_662\x00tags\x00" "asset_674\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_539\0tags\0', 'class_4\0tags\0', 'asset_1845\0tags\0', 'asset_662\0tags\0', 'asset_674\0tags\0');
83	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: [`1765491250 [ "\x00tags\x00object_637" "object_637" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_637', 'object_637');
84	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: [`1765491250 [ "object_637\x00tags\x00" "class_4\x00tags\x00" "asset_1848\x00tags\x00" "asset_687\x00tags\x00" "asset_688\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_637\0tags\0', 'class_4\0tags\0', 'asset_1848\0tags\0', 'asset_687\0tags\0', 'asset_688\0tags\0');
85	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: [`1765491250 [ "\x00tags\x00object_566" "object_566" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_566', 'object_566');
86	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: [`1765491250 [ "object_566\x00tags\x00" "class_4\x00tags\x00" "asset_1849\x00tags\x00" "asset_681\x00tags\x00" "asset_683\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_566\0tags\0', 'class_4\0tags\0', 'asset_1849\0tags\0', 'asset_681\0tags\0', 'asset_683\0tags\0');
87	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: [`1765491250 [ "\x00tags\x00object_530" "object_530" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_530', 'object_530');
88	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: [`1765491250 [ "object_530\x00tags\x00" "class_4\x00tags\x00" "asset_1844\x00tags\x00" "asset_656\x00tags\x00" "asset_665\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_530\0tags\0', 'class_4\0tags\0', 'asset_1844\0tags\0', 'asset_656\0tags\0', 'asset_665\0tags\0');
89	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: [`1765491250 [ "\x00tags\x00object_532" "object_532" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_532', 'object_532');
90	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: [`1765491250 [ "object_532\x00tags\x00" "class_4\x00tags\x00" "asset_1843\x00tags\x00" "asset_664\x00tags\x00" "asset_667\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_532\0tags\0', 'class_4\0tags\0', 'asset_1843\0tags\0', 'asset_664\0tags\0', 'asset_667\0tags\0');
91	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: [`1765491250 [ "\x00tags\x00object_533" "object_533" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_533', 'object_533');
92	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: [`1765491250 [ "object_533\x00tags\x00" "class_4\x00tags\x00" "asset_1847\x00tags\x00" "asset_658\x00tags\x00" "asset_668\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_533\0tags\0', 'class_4\0tags\0', 'asset_1847\0tags\0', 'asset_658\0tags\0', 'asset_668\0tags\0');
93	0.89 ms	SELECT object_localized_11_ar.o_id as o_id, object_localized_11_ar.o_type as o_type FROM object_localized_11_ar WHERE ( object_localized_11_ar.o_type IN ('object','folder')) AND object_localized_11_ar.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_11_ar.o_id as o_id, object_localized_11_ar.o_type as o_type FROM object_localized_11_ar WHERE ( object_localized_11_ar.o_type IN ('object', 'folder') ) AND object_localized_11_ar.o_published = 1 SELECT object_localized_11_ar.o_id as o_id, object_localized_11_ar.o_type as o_type FROM object_localized_11_ar WHERE ( object_localized_11_ar.o_type IN ('object','folder')) AND object_localized_11_ar.o_published = 1;
94	0.34 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: [`1765491250 [ "\x00tags\x00object_49542" "object_49542" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49542', 'object_49542');
95	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: [`1765491250 [ "object_49542\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49542\0tags\0', 'class_11\0tags\0');
96	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"11"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '11';
97	0.32 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: [`1765491250 [ "\x00tags\x00object_49543" "object_49543" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49543', 'object_49543');
98	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: [`1765491250 [ "object_49543\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49543\0tags\0', 'class_11\0tags\0');
99	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: [`1765491250 [ "\x00tags\x00object_49544" "object_49544" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49544', 'object_49544');
100	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: [`1765491250 [ "object_49544\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49544\0tags\0', 'class_11\0tags\0');
101	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: [`1765491250 [ "\x00tags\x00object_49545" "object_49545" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49545', 'object_49545');
102	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: [`1765491250 [ "object_49545\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49545\0tags\0', 'class_11\0tags\0');
103	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: [`1765491250 [ "\x00tags\x00object_49546" "object_49546" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49546', 'object_49546');
104	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: [`1765491250 [ "object_49546\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49546\0tags\0', 'class_11\0tags\0');
105	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: [`1765491250 [ "\x00tags\x00object_49547" "object_49547" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49547', 'object_49547');
106	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: [`1765491250 [ "object_49547\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49547\0tags\0', 'class_11\0tags\0');
107	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: [`1765491250 [ "\x00tags\x00object_49548" "object_49548" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49548', 'object_49548');
108	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: [`1765491250 [ "object_49548\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49548\0tags\0', 'class_11\0tags\0');
109	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: [`1765491250 [ "\x00tags\x00object_49549" "object_49549" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49549', 'object_49549');
110	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: [`1765491250 [ "object_49549\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49549\0tags\0', 'class_11\0tags\0');
111	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: [`1765491250 [ "\x00tags\x00object_49550" "object_49550" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49550', 'object_49550');
112	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: [`1765491250 [ "object_49550\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49550\0tags\0', 'class_11\0tags\0');
113	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: [`1765491250 [ "\x00tags\x00object_49551" "object_49551" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49551', 'object_49551');
114	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: [`1765491250 [ "object_49551\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49551\0tags\0', 'class_11\0tags\0');
115	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: [`1765491250 [ "\x00tags\x00object_49552" "object_49552" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_49552', 'object_49552');
116	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: [`1765491250 [ "object_49552\x00tags\x00" "class_11\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49552\0tags\0', 'class_11\0tags\0');
117	0.87 ms	SELECT COUNT() FROM object_localized_43_ar WHERE (o_parentId = 269 AND object_localized_43_ar.o_type IN ('object','folder')) AND object_localized_43_ar.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM object_localized_43_ar WHERE ( o_parentId = 269 AND object_localized_43_ar.o_type IN ('object', 'folder') ) AND object_localized_43_ar.o_published = 1 SELECT COUNT(*) FROM object_localized_43_ar WHERE (o_parentId = 269 AND object_localized_43_ar.o_type IN ('object','folder')) AND object_localized_43_ar.o_published = 1;
118	0.77 ms	SELECT object_localized_43_ar.o_id as o_id, object_localized_43_ar.o_type as o_type FROM object_localized_43_ar WHERE (o_parentId = 269 AND object_localized_43_ar.o_type IN ('object','folder')) AND object_localized_43_ar.o_published = 1 ORDER BY `name` ASC LIMIT 20 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_43_ar.o_id as o_id, object_localized_43_ar.o_type as o_type FROM object_localized_43_ar WHERE ( o_parentId = 269 AND object_localized_43_ar.o_type IN ('object', 'folder') ) AND object_localized_43_ar.o_published = 1 ORDER BY `name` ASC LIMIT 20 SELECT object_localized_43_ar.o_id as o_id, object_localized_43_ar.o_type as o_type FROM object_localized_43_ar WHERE (o_parentId = 269 AND object_localized_43_ar.o_type IN ('object','folder')) AND object_localized_43_ar.o_published = 1 ORDER BY `name` ASC LIMIT 20;
119	0.32 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: [`1765491250 [ "\x00tags\x00object_275" "object_275" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_275', 'object_275');
120	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: [`1765491250 [ "object_275\x00tags\x00" "class_43\x00tags\x00" "asset_832\x00tags\x00" "asset_833\x00tags\x00" "asset_808\x00tags\x00" "asset_809\x00tags\x00" "asset_802\x00tags\x00" "asset_803\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_275\0tags\0', 'class_43\0tags\0', 'asset_832\0tags\0', 'asset_833\0tags\0', 'asset_808\0tags\0', 'asset_809\0tags\0', 'asset_802\0tags\0', 'asset_803\0tags\0');
121	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"43"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '43';
122	0.48 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: [`1765491250 [ "\x00tags\x00object_279" "object_279" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_279', 'object_279');
123	0.34 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: [`1765491250 [ "object_279\x00tags\x00" "class_43\x00tags\x00" "asset_882\x00tags\x00" "asset_881\x00tags\x00" "asset_806\x00tags\x00" "asset_807\x00tags\x00" "asset_879\x00tags\x00" "asset_880\x00tags\x00" "asset_50\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_279\0tags\0', 'class_43\0tags\0', 'asset_882\0tags\0', 'asset_881\0tags\0', 'asset_806\0tags\0', 'asset_807\0tags\0', 'asset_879\0tags\0', 'asset_880\0tags\0', 'asset_50\0tags\0');
124	0.46 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`26`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 26;
125	0.45 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: [`1765491250 [ "\x00tags\x00asset_1015" "asset_1015" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1015', 'asset_1015');
126	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: [`1765491250 [ "asset_1015\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1015\0tags\0');
127	0.45 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: [`1765491250 [ "\x00tags\x00asset_1019" "asset_1019" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1019', 'asset_1019');
128	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: [`1765491250 [ "asset_1019\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1019\0tags\0');
129	0.53 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: [`1765491250 [ "\x00tags\x00asset_1016" "asset_1016" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1016', 'asset_1016');
130	0.29 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: [`1765491250 [ "asset_1016\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1016\0tags\0');
131	0.29 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: [`1765491250 [ "\x00tags\x00asset_1018" "asset_1018" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1018', 'asset_1018');
132	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: [`1765491250 [ "asset_1018\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1018\0tags\0');
133	0.37 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_0e46a96657a23fea0a218103a60ceba5" "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 = 'auto_0e46a96657a23fea0a218103a60ceba5' AND scope = 'pimcore_image_thumbnails';
134	0.35 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_1018__76336d0f4008a072eae06c040455b861"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_1018__76336d0f4008a072eae06c040455b861';
135	0.35 ms	DELETE FROM tmp_store WHERE id = ? Parameters: [`"thumb_1018__76336d0f4008a072eae06c040455b861"`] View formatted query View runnable query Explain query DELETE FROM tmp_store WHERE id = ? DELETE FROM tmp_store WHERE id = 'thumb_1018__76336d0f4008a072eae06c040455b861';
136	0.90 ms	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'gcs_web' AND TABLE_NAME = 'tmp_store' ORDER BY ORDINAL_POSITION ASC Parameters: [] View formatted query View runnable query Explain query SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'gcs_web' AND TABLE_NAME = 'tmp_store' ORDER BY ORDINAL_POSITION ASC SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'gcs_web' AND TABLE_NAME = 'tmp_store' ORDER BY ORDINAL_POSITION ASC;
137	0.51 ms	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'tmp_store' / WHERE k.table_name = 'tmp_store' AND k.table_schema = 'gcs_web' /!50116 AND c.constraint_schema = 'gcs_web' / AND k.`REFERENCED_COLUMN_NAME` is not NULL Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'tmp_store' / WHERE k.table_name = 'tmp_store' AND k.table_schema = 'gcs_web' /!50116 AND c.constraint_schema = 'gcs_web' / AND k.`REFERENCED_COLUMN_NAME` is not NULL SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'tmp_store' / WHERE k.table_name = 'tmp_store' AND k.table_schema = 'gcs_web' /!50116 AND c.constraint_schema = 'gcs_web' / AND k.`REFERENCED_COLUMN_NAME` is not NULL;
138	0.27 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'tmp_store' AND TABLE_SCHEMA = 'gcs_web' ORDER BY SEQ_IN_INDEX ASC Parameters: [] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'tmp_store' AND TABLE_SCHEMA = 'gcs_web' ORDER BY SEQ_IN_INDEX ASC SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'tmp_store' AND TABLE_SCHEMA = 'gcs_web' ORDER BY SEQ_IN_INDEX ASC;
139	0.44 ms	SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'tmp_store' Parameters: [] View formatted query View runnable query Explain query SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'tmp_store' SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'tmp_store';
140	0.44 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_1018__76336d0f4008a072eae06c040455b861" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:12:"scaleByWidth";s:9:"arguments";a:2:{s:5:"width";i:800;s:11:"forceResize";b:0;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_0e46a96657a23fea0a218103a60ceba5";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"JPEG";s:10:"\x00\x00quality";i:85;s:17:"\x00\x00highResolution";N;s:16:"\x00\x00preserveColor";b:0;s:19:"\x00\x00preserveMetaData";b:0;s:15:"\x00\x00rasterizeSVG";b:0;s:15:"\x00\x00downloadable";b:0;s:19:"\x00\x00modificationDate";N;s:15:"\x00\x00creationDate";N;s:17:"\x00\x00filenameSuffix";N;s:20:"\x00\x00preserveAnimation";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1765491250 ":col4" => 1766096050 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( :col0, :col1, :col2, :col3, :col4, :col5 ) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
141	0.40 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: [`1765491250 [ "\x00tags\x00asset_871" "asset_871" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_871', 'asset_871');
142	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: [`1765491250 [ "asset_871\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_871\0tags\0');
143	0.19 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
144	0.24 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
145	0.50 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: [`1765491250 [ "\x00tags\x00object_330" "object_330" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_330', 'object_330');
146	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: [`1765491250 [ "object_330\x00tags\x00" "class_46\x00tags\x00" "asset_870\x00tags\x00" "asset_871\x00tags\x00" "asset_407\x00tags\x00" "asset_814\x00tags\x00" "asset_410\x00tags\x00" "asset_815\x00tags\x00" "asset_813\x00tags\x00" "asset_412\x00tags\x00" "asset_812\x00tags\x00" "asset_855\x00tags\x00" "asset_856\x00tags\x00" "asset_857\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_330\0tags\0', 'class_46\0tags\0', 'asset_870\0tags\0', 'asset_871\0tags\0', 'asset_407\0tags\0', 'asset_814\0tags\0', 'asset_410\0tags\0', 'asset_815\0tags\0', 'asset_813\0tags\0', 'asset_412\0tags\0', 'asset_812\0tags\0', 'asset_855\0tags\0', 'asset_856\0tags\0', 'asset_857\0tags\0');
147	0.48 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: [`1765491250 [ "\x00tags\x00asset_1024" "asset_1024" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1024', 'asset_1024');
148	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: [`1765491250 [ "asset_1024\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1024\0tags\0');
149	0.51 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: [`1765491250 [ "\x00tags\x00imagick_format_avif" "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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_avif', 'imagick_format_avif');
150	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: [`1765491250 [ "imagick_format_avif\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_avif\0tags\0');
151	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: [`1765491250 [ "\x00tags\x00imagick_format_webp" "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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_webp', 'imagick_format_webp');
152	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: [`1765491250 [ "imagick_format_webp\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp\0tags\0');
153	0.49 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: [`1765491250 [ "\x00tags\x00asset_1157" "asset_1157" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1157', 'asset_1157');
154	0.28 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: [`1765491250 [ "asset_1157\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1157\0tags\0');
155	0.41 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: [`1765491250 [ "\x00tags\x00asset_1022" "asset_1022" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1022', 'asset_1022');
156	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: [`1765491250 [ "asset_1022\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1022\0tags\0');
157	0.45 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: [`1765491250 [ "\x00tags\x00asset_1021" "asset_1021" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1021', 'asset_1021');
158	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: [`1765491250 [ "asset_1021\x00tags\x00" ]`] 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 > 1765491250 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1021\0tags\0');
159	0.99 ms	SELECT object_localized_4_ar.o_id as o_id, object_localized_4_ar.o_type as o_type FROM object_localized_4_ar WHERE ( object_localized_4_ar.o_type IN ('object','folder')) AND object_localized_4_ar.o_published = 1 ORDER BY `order` ASC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_4_ar.o_id as o_id, object_localized_4_ar.o_type as o_type FROM object_localized_4_ar WHERE ( object_localized_4_ar.o_type IN ('object', 'folder') ) AND object_localized_4_ar.o_published = 1 ORDER BY `order` ASC LIMIT 10 SELECT object_localized_4_ar.o_id as o_id, object_localized_4_ar.o_type as o_type FROM object_localized_4_ar WHERE ( object_localized_4_ar.o_type IN ('object','folder')) AND object_localized_4_ar.o_published = 1 ORDER BY `order` ASC LIMIT 10;
160	0.79 ms	SELECT object_localized_11_ar.o_id as o_id, object_localized_11_ar.o_type as o_type FROM object_localized_11_ar WHERE ( object_localized_11_ar.o_type IN ('object','folder')) AND object_localized_11_ar.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_11_ar.o_id as o_id, object_localized_11_ar.o_type as o_type FROM object_localized_11_ar WHERE ( object_localized_11_ar.o_type IN ('object', 'folder') ) AND object_localized_11_ar.o_published = 1 SELECT object_localized_11_ar.o_id as o_id, object_localized_11_ar.o_type as o_type FROM object_localized_11_ar WHERE ( object_localized_11_ar.o_type IN ('object','folder')) AND object_localized_11_ar.o_published = 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

https://gcs.centric.ae/ar/about-us

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache