SELECT r.`trx_id` waiting_trx_id,

        r.`trx_mysql_thread_id` waiting_thread,

        r.`trx_query` waiting_query,

        b.`trx_id` bolcking_trx_id,

        b.`trx_mysql_thread_id` blocking_thread,

        b.`trx_query` block_query

 FROM information_schema.`INNODB_LOCK_WAITS` w

 INNER JOIN information_schema.`INNODB_TRX` b

 ON b.`trx_id`= w.`blocking_trx_id`

 INNER JOIN information_schema.`INNODB_TRX` r

 ON r.`trx_id`= w.`requesting_trx_id`;