| 1 |
1.40 ms |
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.ls_description AS ls_description_3, t0.alloy_description AS alloy_description_4, t0.alloy_short_description AS alloy_short_description_5, t0.alloy_features_benefits AS alloy_features_benefits_6, t0.mmt_description AS mmt_description_7, t0.ds_description AS ds_description_8, t0.ds_features_html AS ds_features_html_9, t0.icecat_description AS icecat_description_10, t0.icecat_short_description AS icecat_short_description_11, t0.icecat_features AS icecat_features_12, t0.icecat_specifications AS icecat_specifications_13, t0.icecat_middle_description AS icecat_middle_description_14, t0.icecat_long_summary AS icecat_long_summary_15, t0.icecat_bullet_points AS icecat_bullet_points_16 FROM description t0 WHERE t0.id = ?
Parameters: [
"batch-delete"
]
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.ls_description AS ls_description_3, t0.alloy_description AS alloy_description_4, t0.alloy_short_description AS alloy_short_description_5, t0.alloy_features_benefits AS alloy_features_benefits_6, t0.mmt_description AS mmt_description_7, t0.ds_description AS ds_description_8, t0.ds_features_html AS ds_features_html_9, t0.icecat_description AS icecat_description_10, t0.icecat_short_description AS icecat_short_description_11, t0.icecat_features AS icecat_features_12, t0.icecat_specifications AS icecat_specifications_13, t0.icecat_middle_description AS icecat_middle_description_14, t0.icecat_long_summary AS icecat_long_summary_15, t0.icecat_bullet_points AS icecat_bullet_points_16 FROM description t0 WHERE t0.id = 'batch-delete';
|
| 2 |
0.56 ms |
SELECT DATABASE()
|
| 3 |
1.46 ms |
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: [
"content"
]
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'content'
AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;
|
| 4 |
0.17 ms |
SELECT DATABASE()
|
| 5 |
0.69 ms |
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: [
"content"
]
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'content'
AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;
|
| 6 |
0.22 ms |
SELECT @@character_set_database, @@collation_database
SELECT @@character_set_database, @@collation_database;
|
| 7 |
0.23 ms |
SELECT DATABASE()
|
| 8 |
9.25 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;
|
| 9 |
0.50 ms |
SELECT DATABASE()
|
| 10 |
0.69 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;
|
| 11 |
0.32 ms |
SELECT DATABASE()
|
| 12 |
1.22 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;
|
| 13 |
0.23 ms |
SELECT DATABASE()
|
| 14 |
1.09 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';
|
| 15 |
0.46 ms |
SELECT * FROM doctrine_migration_versions
SELECT * FROM doctrine_migration_versions;
|
| 16 |
0.21 ms |
SELECT DATABASE()
|