3.05 ms (24.22%)
1
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 = 'eventiko_cza'
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 :
[
"eventiko_cza "
"eventiko_cza "
"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 = 'eventiko_cza'
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 = 'eventiko_cza' AND t . TABLE_SCHEMA = 'eventiko_cza' AND t . TABLE_NAME = 'doctrine_migration_versions'
AND t . TABLE_TYPE = 'BASE TABLE'
ORDER BY c . TABLE_NAME ,
c . ORDINAL_POSITION ;
Copy
2.32 ms (18.43%)
1
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 :
[
"eventiko_cza "
"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 = 'eventiko_cza' AND t . TABLE_NAME = 'doctrine_migration_versions' AND t . TABLE_TYPE = 'BASE TABLE' ;
Copy
1.92 ms (15.26%)
1
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 :
[
"eventiko_cza "
"eventiko_cza "
"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 = 'eventiko_cza' AND c . CONSTRAINT_SCHEMA = 'eventiko_cza' 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 ;
Copy
0.69 ms (5.46%)
1
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 :
[
"eventiko_cza "
"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 = 'eventiko_cza' AND TABLE_NAME = 'doctrine_migration_versions'
ORDER BY TABLE_NAME ,
SEQ_IN_INDEX ;
Copy
0.30 ms (2.35%)
1
INSERT INTO core_error_log (message , context , level , level_name , extra , created_at ) VALUES (? , ? , ? , ? , ? , ? )
Parameters :
[
"Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET https://eventiko.cz/robots.txt"" at RouterListener.php line 156 "
null
400
"ERROR "
"a:0:{} "
"2025-11-08 13:54:55 "
]
INSERT INTO core_error_log (message , context , level , level_name , extra , created_at ) VALUES ('Uncaught PHP Exception Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException: \"No route found for \"GET https://eventiko.cz/robots.txt\"\" at RouterListener.php line 156' , NULL , 400 , 'ERROR' , 'a:0:{}' , '2025-11-08 13:54:55' );
Copy