MySQL Query lock

Select Ifnull (wt.trx_mysql_thread_id,1) blocking_thread_id,

t.trx_mysql_thread_id thread_id,

CONCAT (P.user, ' @ ', p.host) user,

L.lock_table lock_table,

L.lock_index Locked_index,

L.lock_type Lock_type,

L.lock_mode Lock_mode,

CONCAT (

Floor (HOUR-Timediff (now (), t.trx_wait_started)/+), ' Day ',

MOD (HOUR (now (), t.trx_wait_started), 24), ': ',

MINUTE (Timediff (now (), t.trx_wait_started)), ': ',

Second (Timediff (now (), t.trx_wait_started)) as Wait_time,

T.trx_started trx_started,

T.trx_isolation_level Trx_isolation_level,

T.trx_rows_locked trx_rows_locked,

T.trx_rows_modified trx_rows_modified,

P.info Sql_text

From INFORMATION_SCHEMA. Innodb_trx T

Left JOIN information_schema.innodb_lock_waits w on t.trx_id = w.requesting_trx_id

Left JOIN information_schema.innodb_trx wt on wt.trx_id = w.blocking_trx_id

INNER JOIN information_schema.innodb_locks l on l.lock_trx_id = t.trx_id

INNER JOIN information_schema.processlist p on t.trx_mysql_thread_id = P.id

ORDER by 1

MySQL Query lock