When you have innoDB tables with many rows, InnoDB does not store the number of rows in a table but MyISAM does.
So for each InnoDB table PHPMyAdmin invokes SELECT count(*) FROM query which is very slow if number of rows is very high. To resolve this you should edit config.inc.php file and set $cfg['MaxExactCount']. This will invoke count(*) sql for tables that has less MaxExactCount rows.
Open \config.inc.php file and add these two lines of code in it:
$cfg['MaxExactCount'] = 0;
$cfg['MaxExactCountViews'] = 0;Resource: https://stackoverflow.com/questions/14027351/phpmyadmin-opens-mysql-table-lists-very-slowly/53140805