Symfony Profiler

SELECT *FROM usersWHERE `type` = ? AND id = ?

SELECT * FROM users WHERE `type` = 'user' AND id = 3;

SELECT *FROM users_workspaces_assetWHERE userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 3;

SELECT *FROM users_workspaces_documentWHERE userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 3;

SELECT *FROM users_workspaces_objectWHERE userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 3;

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_11', 'object_11');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_11\0tags\0', 'class_3\0tags\0', 'asset_24\0tags\0');

SELECT nameFROM classesWHERE id = ?

SELECT name FROM classes WHERE id = '3';

SELECT idFROM versionsWHERE cid = :cid AND ctype = :ctype AND ( `date` > :mdate OR versionCount > :versionCount ) AND ( ( autoSave = 1 AND userId = :userId ) OR autoSave = 0 )ORDER BY `versionCount` DESCLIMIT 1

SELECT id FROM versions WHERE cid = 11 AND ctype = 'object' AND (`date` > 1690274074 OR versionCount > 22) AND ((autoSave = 1 AND userId = 3) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1;

SELECT *FROM versionsWHERE id = ?

SELECT * FROM versions WHERE id = '516485';

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_16468', 'object_16468');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_16468\0tags\0', 'class_19\0tags\0', 'asset_24\0tags\0');

SELECT nameFROM classesWHERE id = ?

SELECT name FROM classes WHERE id = '19';

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7', 'object_7');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7\0tags\0');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_5', 'object_5');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_5\0tags\0');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1', 'object_1');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');

SELECT name, type, data, cid, inheritable, cpathFROM propertiesWHERE ( ( cid IN (1, 16468, 7, 5) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'object'

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,16468,7,5) AND inheritable = 1) OR cid = 11 ) AND ctype='object';

SELECT name, type, data, cid, inheritable, cpathFROM propertiesWHERE ( ( cid IN (1, 16468, 7, 5) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'object'

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,16468,7,5) AND inheritable = 1) OR cid = 11 ) AND ctype='object';

SELECT nameFROM classesWHERE id = ?

SELECT name FROM classes WHERE id = '3';

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_351', 'document_351');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_351\0tags\0');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_24', 'asset_24');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_991', 'object_991');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_991\0tags\0', 'class_8\0tags\0');

SELECT nameFROM classesWHERE id = ?

SELECT name FROM classes WHERE id = '8';

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_11', 'object_11');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_16468', 'object_16468');

SELECT nameFROM classesWHERE id = ?

SELECT name FROM classes WHERE id = '19';

SELECT CONCAT(o_path, `o_key`) as o_pathFROM objectsWHERE o_id = ?

SELECT CONCAT(o_path,`o_key`) as o_path FROM objects WHERE o_id = 16468;

SELECT o_idFROM objectsWHERE o_path = :path AND `o_key` = :key

SELECT o_id FROM objects WHERE o_path = '/Studios/0_categories/superCat Podcast/' AND `o_key` = 'Podcast';

SELECT o_idFROM objectsWHERE o_path = :path AND `o_key` = :key

SELECT o_id FROM objects WHERE o_path = '/Studios/0_categories/superCat Podcast/' AND `o_key` = 'Podcast';

"START TRANSACTION"

"START TRANSACTION";

SELECT CONCAT(o_path, `o_key`) as o_pathFROM objectsWHERE o_id = ?

SELECT CONCAT(o_path,`o_key`) as o_path FROM objects WHERE o_id = 11;

SELECT o_versionCountFROM objectsWHERE o_id = ? FORUPDATE

SELECT o_versionCount FROM objects WHERE o_id = 11 FOR UPDATE;

SELECT MAX(versionCount)FROM versionsWHERE cid = ? AND ctype = 'object'

SELECT MAX(versionCount) FROM versions WHERE cid = 11 AND ctype = 'object';

DELETE FROM propertiesWHERE cid = ? AND ctype = ?

DELETE FROM properties WHERE cid = 11 AND ctype = 'object';

SELECT id, targetType, targetIdFROM dependenciesWHERE sourceType = ? AND sourceId = ?

SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'object' AND sourceId = 11;

INSERT INTO dependencies ( `sourceid`, `sourcetype`, `targetid`, `targettype`)VALUES (?, ?, ?, ?)

INSERT INTO dependencies (`sourceid`, `sourcetype`, `targetid`, `targettype`) VALUES (11, 'object', 351, 'document');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_objects', 'system_resource_columns_objects');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1726762253 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'resource\0tags\0', 'system_resource_columns_objects\0tags\0');

SELECT o_type, o_classId, o_classNameFROM objectsWHERE o_id = ?

SELECT o_type,o_classId,o_className FROM objects WHERE o_id = 11;

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS CollationFROM information_schema.COLUMNSWHERE TABLE_SCHEMA = 'ID328408_preprodptj' AND TABLE_NAME = 'objects'ORDER BY ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'ID328408_preprodptj' AND TABLE_NAME = 'objects' ORDER BY ORDINAL_POSITION ASC;

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'objects' */WHERE k.table_name = 'objects' AND k.table_schema = 'ID328408_preprodptj' /*!50116 AND c.constraint_schema = 'ID328408_preprodptj' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'objects' */ WHERE k.table_name = 'objects' AND k.table_schema = 'ID328408_preprodptj' /*!50116 AND c.constraint_schema = 'ID328408_preprodptj' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_TypeFROM information_schema.STATISTICSWHERE TABLE_NAME = 'objects' AND TABLE_SCHEMA = 'ID328408_preprodptj'ORDER BY SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'objects' AND TABLE_SCHEMA = 'ID328408_preprodptj' ORDER BY SEQ_IN_INDEX ASC;

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONSFROM information_schema.TABLESWHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'objects'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONSFROM information_schema.TABLESWHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'objects';

INSERT INTO `objects` ( `o_classId`, `o_className`, `o_published`, `o_id`, `o_parentId`, `o_type`, `o_key`, `o_path`, `o_index`, `o_creationDate`, `o_modificationDate`, `o_userOwner`, `o_userModification`, `o_childrenSortBy`, `o_childrenSortOrder`, `o_versionCount`)VALUES ( :col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13, :col14, :col15 ) ON DUPLICATE KEYUPDATE `o_classId` = :col0, `o_className` = :col1, `o_published` = :col2, `o_id` = :col3, `o_parentId` = :col4, `o_type` = :col5, `o_key` = :col6, `o_path` = :col7, `o_index` = :col8, `o_creationDate` = :col9, `o_modificationDate` = :col10, `o_userOwner` = :col11, `o_userModification` = :col12, `o_childrenSortBy` = :col13, `o_childrenSortOrder` = :col14, `o_versionCount` = :col15;

INSERT INTO `objects` (`o_classId`, `o_className`, `o_published`, `o_id`, `o_parentId`, `o_type`, `o_key`, `o_path`, `o_index`, `o_creationDate`, `o_modificationDate`, `o_userOwner`, `o_userModification`, `o_childrenSortBy`, `o_childrenSortOrder`, `o_versionCount`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13, :col14, :col15) ON DUPLICATE KEY UPDATE `o_classId` = :col0, `o_className` = :col1, `o_published` = :col2, `o_id` = :col3, `o_parentId` = :col4, `o_type` = :col5, `o_key` = :col6, `o_path` = :col7, `o_index` = :col8, `o_creationDate` = :col9, `o_modificationDate` = :col10, `o_userOwner` = :col11, `o_userModification` = :col12, `o_childrenSortBy` = :col13, `o_childrenSortOrder` = :col14, `o_versionCount` = :col15;;

DELETE FROM tree_locksWHERE id = ? AND type = ?

DELETE FROM tree_locks WHERE id = 11 AND type = 'object';

SELECT `src_id`FROM `object_relations_3`WHERE src_id = '11' AND ownertype = "object"LIMIT 1

SELECT `src_id` FROM `object_relations_3` WHERE src_id = '11' AND ownertype = "object" LIMIT 1;

DELETE FROM object_relations_3WHERE src_id = '11' AND ownertype = "object"

DELETE FROM object_relations_3 WHERE src_id = '11' AND ownertype = "object";

DELETE FROM object_relations_3WHERE ownertype = "localizedfield" AND ownername = "localizedfield" and src_id = 11

DELETE FROM object_relations_3 WHERE ownertype = "localizedfield" AND ownername = "localizedfield" and src_id = 11;

INSERT INTO object_relations_3 ( `dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`)VALUES (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_relations_3 (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (351, 'document', 'mailOnboarding', 11, 'localizedfield', 'localizedfield', 'en');

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS CollationFROM information_schema.COLUMNSWHERE TABLE_SCHEMA = 'ID328408_preprodptj' AND TABLE_NAME = 'object_localized_data_3'ORDER BY ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'ID328408_preprodptj' AND TABLE_NAME = 'object_localized_data_3' ORDER BY ORDINAL_POSITION ASC;

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'object_localized_data_3' */WHERE k.table_name = 'object_localized_data_3' AND k.table_schema = 'ID328408_preprodptj' /*!50116 AND c.constraint_schema = 'ID328408_preprodptj' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'object_localized_data_3' */ WHERE k.table_name = 'object_localized_data_3' AND k.table_schema = 'ID328408_preprodptj' /*!50116 AND c.constraint_schema = 'ID328408_preprodptj' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_TypeFROM information_schema.STATISTICSWHERE TABLE_NAME = 'object_localized_data_3' AND TABLE_SCHEMA = 'ID328408_preprodptj'ORDER BY SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'object_localized_data_3' AND TABLE_SCHEMA = 'ID328408_preprodptj' ORDER BY SEQ_IN_INDEX ASC;

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONSFROM information_schema.TABLESWHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'object_localized_data_3'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONSFROM information_schema.TABLESWHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'object_localized_data_3';

INSERT INTO `object_localized_data_3` (`ooo_id`, `language`, `title`)VALUES (:col0, :col1, :col2) ON DUPLICATE KEYUPDATE `ooo_id` = :col0, `language` = :col1, `title` = :col2;

INSERT INTO `object_localized_data_3` (`ooo_id`, `language`, `title`) VALUES (:col0, :col1, :col2) ON DUPLICATE KEY UPDATE `ooo_id` = :col0, `language` = :col1, `title` = :col2;;

SELECT *FROM object_localized_query_3_enWHERE ooo_id = 11 AND language = 'en'

SELECT * FROM object_localized_query_3_en WHERE ooo_id = 11 AND language = 'en';

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS CollationFROM information_schema.COLUMNSWHERE TABLE_SCHEMA = 'ID328408_preprodptj' AND TABLE_NAME = 'object_localized_query_3_en'ORDER BY ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'ID328408_preprodptj' AND TABLE_NAME = 'object_localized_query_3_en' ORDER BY ORDINAL_POSITION ASC;

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'object_localized_query_3_en' */WHERE k.table_name = 'object_localized_query_3_en' AND k.table_schema = 'ID328408_preprodptj' /*!50116 AND c.constraint_schema = 'ID328408_preprodptj' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'object_localized_query_3_en' */ WHERE k.table_name = 'object_localized_query_3_en' AND k.table_schema = 'ID328408_preprodptj' /*!50116 AND c.constraint_schema = 'ID328408_preprodptj' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_TypeFROM information_schema.STATISTICSWHERE TABLE_NAME = 'object_localized_query_3_en' AND TABLE_SCHEMA = 'ID328408_preprodptj'ORDER BY SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'object_localized_query_3_en' AND TABLE_SCHEMA = 'ID328408_preprodptj' ORDER BY SEQ_IN_INDEX ASC;

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONSFROM information_schema.TABLESWHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'object_localized_query_3_en'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONSFROM information_schema.TABLESWHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'object_localized_query_3_en';

INSERT INTO `object_localized_query_3_en` ( `ooo_id`, `language`, `title`, `mailOnboarding__id`, `mailOnboarding__type`)VALUES (:col0, :col1, :col2, :col3, :col4) ON DUPLICATE KEYUPDATE `ooo_id` = :col0, `language` = :col1, `title` = :col2, `mailOnboarding__id` = :col3, `mailOnboarding__type` = :col4;

INSERT INTO `object_localized_query_3_en` (`ooo_id`, `language`, `title`, `mailOnboarding__id`, `mailOnboarding__type`) VALUES (:col0, :col1, :col2, :col3, :col4) ON DUPLICATE KEY UPDATE `ooo_id` = :col0, `language` = :col1, `title` = :col2, `mailOnboarding__id` = :col3, `mailOnboarding__type` = :col4;;

"ROLLBACK"

"ROLLBACK";