| 1 |
1.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.trigger_type AS trigger_type_4, t0.trigger_config AS trigger_config_5, t0.is_active AS is_active_6, t0.priority AS priority_7, t0.actions AS actions_8, t0.execution_count AS execution_count_9, t0.success_count AS success_count_10, t0.failure_count AS failure_count_11, t0.last_executed_at AS last_executed_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15 FROM workflow t0 WHERE t0.id = ?
Parameters: [
"batch-delete"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.trigger_type AS trigger_type_4, t0.trigger_config AS trigger_config_5, t0.is_active AS is_active_6, t0.priority AS priority_7, t0.actions AS actions_8, t0.execution_count AS execution_count_9, t0.success_count AS success_count_10, t0.failure_count AS failure_count_11, t0.last_executed_at AS last_executed_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15 FROM workflow t0 WHERE t0.id = 'batch-delete';
|
| 8 |
4.24 ms |
SELECT
c.TABLE_NAME,
c.COLUMN_NAME AS field,
IF(
c.DATA_TYPE = 'longtext'
AND EXISTS(
SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c
WHERE i_c.CONSTRAINT_SCHEMA = 'content'
AND i_c.TABLE_NAME = c.TABLE_NAME
AND i_c.CHECK_CLAUSE = CONCAT(
'json_valid(`',
c.COLUMN_NAME,
'`)'
)
),
'json',
c.DATA_TYPE
) AS type,
c.COLUMN_TYPE,
c.CHARACTER_MAXIMUM_LENGTH,
c.CHARACTER_OCTET_LENGTH,
c.NUMERIC_PRECISION,
c.NUMERIC_SCALE,
c.IS_NULLABLE AS `null`,
c.COLUMN_KEY AS `key`,
c.COLUMN_DEFAULT AS `default`,
c.EXTRA,
c.COLUMN_COMMENT AS comment,
c.CHARACTER_SET_NAME AS characterset,
c.COLLATION_NAME AS collation
FROM information_schema.COLUMNS c
INNER JOIN information_schema.TABLES t
ON t.TABLE_NAME = c.TABLE_NAME
WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ?
AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
c.ORDINAL_POSITION
Parameters: [
"content"
"content"
"doctrine_migration_versions"
]
SELECT
c.TABLE_NAME,
c.COLUMN_NAME AS field,
IF(
c.DATA_TYPE = 'longtext'
AND EXISTS(
SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c
WHERE i_c.CONSTRAINT_SCHEMA = 'content'
AND i_c.TABLE_NAME = c.TABLE_NAME
AND i_c.CHECK_CLAUSE = CONCAT(
'json_valid(`',
c.COLUMN_NAME,
'`)'
)
),
'json',
c.DATA_TYPE
) AS type,
c.COLUMN_TYPE,
c.CHARACTER_MAXIMUM_LENGTH,
c.CHARACTER_OCTET_LENGTH,
c.NUMERIC_PRECISION,
c.NUMERIC_SCALE,
c.IS_NULLABLE AS `null`,
c.COLUMN_KEY AS `key`,
c.COLUMN_DEFAULT AS `default`,
c.EXTRA,
c.COLUMN_COMMENT AS comment,
c.CHARACTER_SET_NAME AS characterset,
c.COLLATION_NAME AS collation
FROM information_schema.COLUMNS c
INNER JOIN information_schema.TABLES t
ON t.TABLE_NAME = c.TABLE_NAME
WHERE c.TABLE_SCHEMA = 'content' AND t.TABLE_SCHEMA = 'content' AND t.TABLE_NAME = 'doctrine_migration_versions'
AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
c.ORDINAL_POSITION;
|
| 10 |
0.33 ms |
SELECT
TABLE_NAME,
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_SCHEMA = ? AND TABLE_NAME = ?
ORDER BY TABLE_NAME,
SEQ_IN_INDEX
Parameters: [
"content"
"doctrine_migration_versions"
]
SELECT
TABLE_NAME,
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_SCHEMA = 'content' AND TABLE_NAME = 'doctrine_migration_versions'
ORDER BY TABLE_NAME,
SEQ_IN_INDEX;
|
| 12 |
0.81 ms |
SELECT
k.TABLE_NAME,
k.CONSTRAINT_NAME,
k.COLUMN_NAME,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME,
k.ORDINAL_POSITION,
c.UPDATE_RULE,
c.DELETE_RULE
FROM information_schema.key_column_usage k
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ?
AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
k.CONSTRAINT_NAME,
k.ORDINAL_POSITION
Parameters: [
"content"
"content"
"doctrine_migration_versions"
]
SELECT
k.TABLE_NAME,
k.CONSTRAINT_NAME,
k.COLUMN_NAME,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME,
k.ORDINAL_POSITION,
c.UPDATE_RULE,
c.DELETE_RULE
FROM information_schema.key_column_usage k
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = 'content' AND c.CONSTRAINT_SCHEMA = 'content' AND k.TABLE_NAME = 'doctrine_migration_versions'
AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
k.CONSTRAINT_NAME,
k.ORDINAL_POSITION;
|
| 14 |
1.00 ms |
SELECT t.TABLE_NAME,
t.ENGINE,
t.AUTO_INCREMENT,
t.TABLE_COMMENT,
t.CREATE_OPTIONS,
t.TABLE_COLLATION,
ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
ON ccsa.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters: [
"content"
"doctrine_migration_versions"
]
SELECT t.TABLE_NAME,
t.ENGINE,
t.AUTO_INCREMENT,
t.TABLE_COMMENT,
t.CREATE_OPTIONS,
t.TABLE_COLLATION,
ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
ON ccsa.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'content' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
|