Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

61 Database Queries

13 Different statements

237.74 ms Query time

0 Invalid entities

Queries

Group similar statements


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 settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT * FROM object_url_slugs WHERE slug = '/about-us' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT * FROM documents_editables WHERE documentId = ?
SELECT object_staff_member.o_id as o_id, object_staff_member.o_type as o_type FROM object_staff_member WHERE ( object_staff_member.o_type IN ('object','folder')) AND object_staff_member.o_published = 1
SELECT name FROM classes WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
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 * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
SELECT object_case_study.o_id as o_id, object_case_study.o_type as o_type FROM object_case_study WHERE ( object_case_study.o_type IN ('object','folder')) AND object_case_study.o_published = 1 ORDER BY `o_index`

#▲	Time	Info
1	2.17 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" => "/about-us" "sourcePathQuery" => "/about-us" "sourceEntireUri" => "https://dev.builtbytorq.com/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 = '/about-us' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/about-us' AND `type` = 'path_query') OR (source = 'https://dev.builtbytorq.com/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;
2	1.69 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';
3	2.43 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "about-us" "path" => "/"`] 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 '/' AND `key` = BINARY 'about-us';
4	2.89 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/about-us"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/about-us';
5	3.26 ms	SELECT * FROM object_url_slugs WHERE slug = '/about-us' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/about-us' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/about-us' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
6	1.94 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;
7	4.32 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6;
8	2.43 ms	SELECT object_staff_member.o_id as o_id, object_staff_member.o_type as o_type FROM object_staff_member WHERE ( object_staff_member.o_type IN ('object','folder')) AND object_staff_member.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_staff_member.o_id as o_id, object_staff_member.o_type as o_type FROM object_staff_member WHERE ( object_staff_member.o_type IN ('object', 'folder') ) AND object_staff_member.o_published = 1 SELECT object_staff_member.o_id as o_id, object_staff_member.o_type as o_type FROM object_staff_member WHERE ( object_staff_member.o_type IN ('object','folder')) AND object_staff_member.o_published = 1;
9	1.86 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"staff_member"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'staff_member';
10	2.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 67`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 67;
11	2.07 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 68`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 68;
12	1.90 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 65`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 65;
13	2.44 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 70`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 70;
14	1.87 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
15	1.74 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_70__0c7cd81336f817ae37e2ef2c95daeb78"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_70__0c7cd81336f817ae37e2ef2c95daeb78';
16	10.80 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_70__0c7cd81336f817ae37e2ef2c95daeb78" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:6:"SOURCE";s:10:"\x00\x00quality";i:90;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" => 1751334177 ":col4" => 1751938977 ":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;;
17	2.02 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
18	1.99 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_70__db584fd04095e873f32ee1d22133a8af"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_70__db584fd04095e873f32ee1d22133a8af';
19	10.70 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_70__db584fd04095e873f32ee1d22133a8af" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"avif";s:10:"\x00\x00quality";i:15;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" => 1751334177 ":col4" => 1751938977 ":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;;
20	1.78 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
21	1.92 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_70__9dd537bd5385125a47debd45994aaba8"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_70__9dd537bd5385125a47debd45994aaba8';
22	13.76 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_70__9dd537bd5385125a47debd45994aaba8" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"webp";s:10:"\x00\x00quality";i:90;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" => 1751334177 ":col4" => 1751938977 ":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;;
23	1.76 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
24	1.73 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_70__0c7cd81336f817ae37e2ef2c95daeb78"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_70__0c7cd81336f817ae37e2ef2c95daeb78';
25	1.90 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 69`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 69;
26	1.89 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
27	2.07 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_69__73dc2d759632d466cb9776cd210e80be"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_69__73dc2d759632d466cb9776cd210e80be';
28	9.38 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_69__73dc2d759632d466cb9776cd210e80be" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:6:"SOURCE";s:10:"\x00\x00quality";i:90;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" => 1751334177 ":col4" => 1751938977 ":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;;
29	1.63 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
30	1.61 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_69__acbee016a3a96486905ff2fa35833cc6"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_69__acbee016a3a96486905ff2fa35833cc6';
31	11.14 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_69__acbee016a3a96486905ff2fa35833cc6" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"avif";s:10:"\x00\x00quality";i:15;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" => 1751334177 ":col4" => 1751938977 ":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;;
32	1.90 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
33	1.74 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_69__fe67c0c6f095f045db34a27f335465d1"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_69__fe67c0c6f095f045db34a27f335465d1';
34	10.99 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_69__fe67c0c6f095f045db34a27f335465d1" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"webp";s:10:"\x00\x00quality";i:90;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" => 1751334177 ":col4" => 1751938977 ":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;;
35	1.90 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
36	2.18 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_69__73dc2d759632d466cb9776cd210e80be"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_69__73dc2d759632d466cb9776cd210e80be';
37	1.92 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 71`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 71;
38	2.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
39	1.73 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_71__b63255c94ec3cf4539dd7802338b1d9d"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_71__b63255c94ec3cf4539dd7802338b1d9d';
40	10.97 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_71__b63255c94ec3cf4539dd7802338b1d9d" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:6:"SOURCE";s:10:"\x00\x00quality";i:90;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" => 1751334177 ":col4" => 1751938977 ":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;;
41	1.90 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
42	1.59 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_71__760cd2ba80fc4df599417bf0af871f06"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_71__760cd2ba80fc4df599417bf0af871f06';
43	15.25 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_71__760cd2ba80fc4df599417bf0af871f06" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"avif";s:10:"\x00\x00quality";i:15;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" => 1751334177 ":col4" => 1751938977 ":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;;
44	2.01 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
45	1.98 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_71__1c8065f40b2800ba95ee1e3304ba2f27"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_71__1c8065f40b2800ba95ee1e3304ba2f27';
46	10.15 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_71__1c8065f40b2800ba95ee1e3304ba2f27" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"webp";s:10:"\x00\x00quality";i:90;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" => 1751334177 ":col4" => 1751938977 ":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;;
47	2.30 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
48	2.16 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_71__b63255c94ec3cf4539dd7802338b1d9d"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_71__b63255c94ec3cf4539dd7802338b1d9d';
49	2.59 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 72`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 72;
50	1.93 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
51	1.90 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_72__a49b2febf2b2346b0e5b7a5c92570069"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_72__a49b2febf2b2346b0e5b7a5c92570069';
52	12.63 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_72__a49b2febf2b2346b0e5b7a5c92570069" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:6:"SOURCE";s:10:"\x00\x00quality";i:90;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" => 1751334177 ":col4" => 1751938977 ":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;;
53	1.79 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
54	1.98 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_72__6bbc7825d619ba84031cffe73a277bf4"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_72__6bbc7825d619ba84031cffe73a277bf4';
55	10.25 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_72__6bbc7825d619ba84031cffe73a277bf4" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"avif";s:10:"\x00\x00quality";i:15;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" => 1751334177 ":col4" => 1751938977 ":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;;
56	2.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
57	1.94 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_72__fecaa5f80f03dcf0204c2532ae843ec9"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_72__fecaa5f80f03dcf0204c2532ae843ec9';
58	10.41 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_72__fecaa5f80f03dcf0204c2532ae843ec9" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";i:200;s:6:"height";i:200;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6a500f12d4102244f461106d48fcb087";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"webp";s:10:"\x00\x00quality";i:90;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" => 1751334177 ":col4" => 1751938977 ":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;;
59	1.90 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6a500f12d4102244f461106d48fcb087" "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_6a500f12d4102244f461106d48fcb087' AND scope = 'pimcore_image_thumbnails';
60	2.07 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_72__a49b2febf2b2346b0e5b7a5c92570069"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_72__a49b2febf2b2346b0e5b7a5c92570069';
61	2.31 ms	SELECT object_case_study.o_id as o_id, object_case_study.o_type as o_type FROM object_case_study WHERE ( object_case_study.o_type IN ('object','folder')) AND object_case_study.o_published = 1 ORDER BY `o_index` Parameters: [] View formatted query View runnable query Explain query SELECT object_case_study.o_id as o_id, object_case_study.o_type as o_type FROM object_case_study WHERE ( object_case_study.o_type IN ('object', 'folder') ) AND object_case_study.o_published = 1 ORDER BY `o_index` SELECT object_case_study.o_id as o_id, object_case_study.o_type as o_type FROM object_case_study WHERE ( object_case_study.o_type IN ('object','folder')) AND object_case_study.o_published = 1 ORDER BY `o_index` ;

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://dev.builtbytorq.com/about-us

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache