Symfony Profiler

Query Metrics

67 Database Queries

12 Different statements

27.39 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
SELECT item_id, CASE 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 users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 translations_studio 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 translations_studio.key FROM translations_studio WHERE (`key` = ?)  GROUP BY translations_studio.key LIMIT 1
CREATE TABLE IF NOT EXISTS `translations_studio` (
                          `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                          `type` varchar(10) DEFAULT NULL,
                          `language` varchar(10) NOT NULL DEFAULT '',
                          `text` text DEFAULT NULL,
                          `creationDate` int(11) unsigned DEFAULT NULL,
                          `modificationDate` int(11) unsigned DEFAULT NULL,
                          `userOwner` int(11) unsigned DEFAULT NULL,
                          `userModification` int(11) unsigned DEFAULT NULL,
                          PRIMARY KEY (`key`,`language`),
                          KEY `language` (`language`)
                        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 (?)
SHOW COLUMNS FROM translations_studio
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
DELETE 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 translations_studio.key FROM translations_studio WHERE (`key` = ?)  GROUP BY translations_studio.key LIMIT 1
CREATE TABLE IF NOT EXISTS `translations_studio` (
                          `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                          `type` varchar(10) DEFAULT NULL,
                          `language` varchar(10) NOT NULL DEFAULT '',
                          `text` text DEFAULT NULL,
                          `creationDate` int(11) unsigned DEFAULT NULL,
                          `modificationDate` int(11) unsigned DEFAULT NULL,
                          `userOwner` int(11) unsigned DEFAULT NULL,
                          `userModification` int(11) unsigned DEFAULT NULL,
                          PRIMARY KEY (`key`,`language`),
                          KEY `language` (`language`)
                        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
DELETE 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 translations_studio.key FROM translations_studio WHERE (`key` = ?)  GROUP BY translations_studio.key LIMIT 1
CREATE TABLE IF NOT EXISTS `translations_studio` (
                          `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                          `type` varchar(10) DEFAULT NULL,
                          `language` varchar(10) NOT NULL DEFAULT '',
                          `text` text DEFAULT NULL,
                          `creationDate` int(11) unsigned DEFAULT NULL,
                          `modificationDate` int(11) unsigned DEFAULT NULL,
                          `userOwner` int(11) unsigned DEFAULT NULL,
                          `userModification` int(11) unsigned DEFAULT NULL,
                          PRIMARY KEY (`key`,`language`),
                          KEY `language` (`language`)
                        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
DELETE 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 translations_studio.key FROM translations_studio WHERE (`key` = ?)  GROUP BY translations_studio.key LIMIT 1
CREATE TABLE IF NOT EXISTS `translations_studio` (
                          `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                          `type` varchar(10) DEFAULT NULL,
                          `language` varchar(10) NOT NULL DEFAULT '',
                          `text` text DEFAULT NULL,
                          `creationDate` int(11) unsigned DEFAULT NULL,
                          `modificationDate` int(11) unsigned DEFAULT NULL,
                          `userOwner` int(11) unsigned DEFAULT NULL,
                          `userModification` int(11) unsigned DEFAULT NULL,
                          PRIMARY KEY (`key`,`language`),
                          KEY `language` (`language`)
                        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
DELETE 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 translations_studio.key FROM translations_studio WHERE (`key` = ?)  GROUP BY translations_studio.key LIMIT 1
CREATE TABLE IF NOT EXISTS `translations_studio` (
                          `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                          `type` varchar(10) DEFAULT NULL,
                          `language` varchar(10) NOT NULL DEFAULT '',
                          `text` text DEFAULT NULL,
                          `creationDate` int(11) unsigned DEFAULT NULL,
                          `modificationDate` int(11) unsigned DEFAULT NULL,
                          `userOwner` int(11) unsigned DEFAULT NULL,
                          `userModification` int(11) unsigned DEFAULT NULL,
                          PRIMARY KEY (`key`,`language`),
                          KEY `language` (`language`)
                        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
DELETE 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 translations_studio.key FROM translations_studio WHERE (`key` = ?)  GROUP BY translations_studio.key LIMIT 1
CREATE TABLE IF NOT EXISTS `translations_studio` (
                          `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                          `type` varchar(10) DEFAULT NULL,
                          `language` varchar(10) NOT NULL DEFAULT '',
                          `text` text DEFAULT NULL,
                          `creationDate` int(11) unsigned DEFAULT NULL,
                          `modificationDate` int(11) unsigned DEFAULT NULL,
                          `userOwner` int(11) unsigned DEFAULT NULL,
                          `userModification` int(11) unsigned DEFAULT NULL,
                          PRIMARY KEY (`key`,`language`),
                          KEY `language` (`language`)
                        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
DELETE FROM cache_items WHERE item_id IN (?, ?)

#▲	Time	Info
1	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: [`1793106005 "app:ce82b1a2ae0029fce1373a9bbcce99a8b55d6b7f"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('app:ce82b1a2ae0029fce1373a9bbcce99a8b55d6b7f');
2	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: [`1793106005 "app:ce82b1a2ae0029fce1373a9bbcce99a8b55d6b7f"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('app:ce82b1a2ae0029fce1373a9bbcce99a8b55d6b7f');
3	0.87 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`2 => 92 3 => 1793106005 0 => "app:ce82b1a2ae0029fce1373a9bbcce99a8b55d6b7f" 1 => b"O:1:"©":1:{s:6:"*ý¢\x08À\x1E";O:50:"Symfony\Component\RateLimiter\Policy\SlidingWindow":1:{s:41:"\x00\x00\x00\t\x00\x00\x00\x00\x00\x00\x00<studio_api_general-172.18.0.1";d:1793106038.345161;}}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (92, 1793106005, 'app:ce82b1a2ae0029fce1373a9bbcce99a8b55d6b7f', 0x4F3A313A22A9223A313A7B733A363A222AFDA208C01E223B4F3A35303A2253796D666F6E795C436F6D706F6E656E745C526174654C696D697465725C506F6C6963795C536C6964696E6757696E646F77223A313A7B733A34313A2200000009000000000000003C73747564696F5F6170695F67656E6572616C2D3137322E31382E302E31223B643A313739333130363033382E3334353136313B7D7D) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
4	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: [`1793106005 "maintenance_mode"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');
5	0.55 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 1`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 1;
6	0.22 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 1;
7	0.23 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 1;
8	0.22 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 1;
9	0.61 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: [`1793106005 "system_supported_js_locales_en"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_js_locales_en');
10	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: [`1793106005 "system\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags');
11	0.35 ms	SELECT * FROM translations_studio LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_studio LIMIT 1; SELECT * FROM translations_studio LIMIT 1;;
12	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: [`1793106005 "translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
13	0.17 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: [`1793106005 "\x00tags\x00translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
14	0.49 ms	SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 Parameters: [`"Cedra SKU"`] View formatted query View runnable query Explain query SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 SELECT translations_studio.key FROM translations_studio WHERE (`key` = 'Cedra SKU') GROUP BY translations_studio.key LIMIT 1;
15	0.62 ms	CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; Parameters: [] View formatted query View runnable query Explain query CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`, `language`), KEY `language` (`language`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci; CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;;
16	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793106005 "system_resource_columns_translations_studio"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_translations_studio');
17	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: [`1793106005 "\x00tags\x00system_resource_columns_translations_studio"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_translations_studio');
18	1.17 ms	SHOW COLUMNS FROM translations_studio Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM translations_studio SHOW COLUMNS FROM translations_studio;
19	0.81 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Cedra SKU" "simple" "en" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Cedra SKU', 'simple', 'en', '', 1793106005, 1793106005, 1, 1);
20	0.44 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Cedra SKU" "simple" "de" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Cedra SKU', 'simple', 'de', '', 1793106005, 1793106005, 1, 1);
21	0.41 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Cedra SKU" "simple" "fr" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Cedra SKU', 'simple', 'fr', '', 1793106005, 1793106005, 1, 1);
22	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: [`1793106005 "system_cache_write_lock"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_cache_write_lock');
23	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793106005 "\x00tags\x00system_cache_write_lock"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_cache_write_lock');
24	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: [`1793106005 "system_cache_write_lock"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_cache_write_lock');
25	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: [`1793106005 "\x00tags\x00system_cache_write_lock"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_cache_write_lock');
26	0.41 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`2 => 30 3 => 1793106005 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"ìü¢\x08À\x1E";i:1793106005;}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (30, 1793106005, 'system_cache_write_lock', 0x4F3A313A22A9223A313A7B733A363A22ECFCA208C01E223B693A313739333130363030353B7D) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
27	0.24 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"translator\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('translatortags', 'translatetags');
28	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: [`1793106005 "translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
29	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793106005 "\x00tags\x00translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
30	0.18 ms	SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 Parameters: [`"Short Description"`] View formatted query View runnable query Explain query SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 SELECT translations_studio.key FROM translations_studio WHERE (`key` = 'Short Description') GROUP BY translations_studio.key LIMIT 1;
31	0.21 ms	CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; Parameters: [] View formatted query View runnable query Explain query CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`, `language`), KEY `language` (`language`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci; CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;;
32	1.62 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Short Description" "simple" "en" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Short Description', 'simple', 'en', '', 1793106005, 1793106005, 1, 1);
33	0.54 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Short Description" "simple" "de" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Short Description', 'simple', 'de', '', 1793106005, 1793106005, 1, 1);
34	0.47 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Short Description" "simple" "fr" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Short Description', 'simple', 'fr', '', 1793106005, 1793106005, 1, 1);
35	0.20 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"translator\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('translatortags', 'translatetags');
36	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: [`1793106005 "translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
37	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: [`1793106005 "\x00tags\x00translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
38	0.21 ms	SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 Parameters: [`"Brand"`] View formatted query View runnable query Explain query SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 SELECT translations_studio.key FROM translations_studio WHERE (`key` = 'Brand') GROUP BY translations_studio.key LIMIT 1;
39	0.17 ms	CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; Parameters: [] View formatted query View runnable query Explain query CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`, `language`), KEY `language` (`language`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci; CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;;
40	0.54 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Brand" "simple" "en" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Brand', 'simple', 'en', '', 1793106005, 1793106005, 1, 1);
41	0.54 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Brand" "simple" "de" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Brand', 'simple', 'de', '', 1793106005, 1793106005, 1, 1);
42	0.44 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Brand" "simple" "fr" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Brand', 'simple', 'fr', '', 1793106005, 1793106005, 1, 1);
43	0.19 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"translator\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('translatortags', 'translatetags');
44	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: [`1793106005 "translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
45	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793106005 "\x00tags\x00translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
46	0.21 ms	SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 Parameters: [`"OEM Part Number"`] View formatted query View runnable query Explain query SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 SELECT translations_studio.key FROM translations_studio WHERE (`key` = 'OEM Part Number') GROUP BY translations_studio.key LIMIT 1;
47	0.16 ms	CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; Parameters: [] View formatted query View runnable query Explain query CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`, `language`), KEY `language` (`language`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci; CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;;
48	0.48 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"OEM Part Number" "simple" "en" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('OEM Part Number', 'simple', 'en', '', 1793106005, 1793106005, 1, 1);
49	0.52 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"OEM Part Number" "simple" "de" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('OEM Part Number', 'simple', 'de', '', 1793106005, 1793106005, 1, 1);
50	0.56 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"OEM Part Number" "simple" "fr" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('OEM Part Number', 'simple', 'fr', '', 1793106005, 1793106005, 1, 1);
51	0.18 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"translator\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('translatortags', 'translatetags');
52	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: [`1793106005 "translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
53	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: [`1793106005 "\x00tags\x00translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
54	0.30 ms	SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 Parameters: [`"Selling Price"`] View formatted query View runnable query Explain query SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 SELECT translations_studio.key FROM translations_studio WHERE (`key` = 'Selling Price') GROUP BY translations_studio.key LIMIT 1;
55	0.16 ms	CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; Parameters: [] View formatted query View runnable query Explain query CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`, `language`), KEY `language` (`language`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci; CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;;
56	0.48 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Selling Price" "simple" "en" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Selling Price', 'simple', 'en', '', 1793106005, 1793106005, 1, 1);
57	0.54 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Selling Price" "simple" "de" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Selling Price', 'simple', 'de', '', 1793106005, 1793106005, 1, 1);
58	0.49 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"Selling Price" "simple" "fr" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('Selling Price', 'simple', 'fr', '', 1793106005, 1793106005, 1, 1);
59	0.16 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"translator\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('translatortags', 'translatetags');
60	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: [`1793106005 "translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
61	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793106005 "\x00tags\x00translations_studio_data_17661b7266fda1ef7196d51e5e395cf9"`] 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 > 1793106005 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translations_studio_data_17661b7266fda1ef7196d51e5e395cf9');
62	0.18 ms	SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 Parameters: [`"WooCommerce Product Id"`] View formatted query View runnable query Explain query SELECT translations_studio.key FROM translations_studio WHERE (`key` = ?) GROUP BY translations_studio.key LIMIT 1 SELECT translations_studio.key FROM translations_studio WHERE (`key` = 'WooCommerce Product Id') GROUP BY translations_studio.key LIMIT 1;
63	0.18 ms	CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; Parameters: [] View formatted query View runnable query Explain query CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`, `language`), KEY `language` (`language`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci; CREATE TABLE IF NOT EXISTS `translations_studio` ( `key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `type` varchar(10) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT '', `text` text DEFAULT NULL, `creationDate` int(11) unsigned DEFAULT NULL, `modificationDate` int(11) unsigned DEFAULT NULL, `userOwner` int(11) unsigned DEFAULT NULL, `userModification` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`key`,`language`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;;
64	0.46 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"WooCommerce Product Id" "simple" "en" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('WooCommerce Product Id', 'simple', 'en', '', 1793106005, 1793106005, 1, 1);
65	1.22 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"WooCommerce Product Id" "simple" "de" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('WooCommerce Product Id', 'simple', 'de', '', 1793106005, 1793106005, 1, 1);
66	3.75 ms	INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"WooCommerce Product Id" "simple" "fr" "" 1793106005 1793106005 1 1`] View formatted query View runnable query Explain query INSERT INTO translations_studio ( `key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO translations_studio (`key`, `type`, `language`, `text`, `modificationDate`, `creationDate`, `userOwner`, `userModification`) VALUES ('WooCommerce Product Id', 'simple', 'fr', '', 1793106005, 1793106005, 1, 1);
67	0.17 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"translator\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('translatortags', 'translatetags');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

POST http://pim.cedraparts.com/pimcore-studio/api/translations/create

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping