Remote:

MariaDB [spider_2repmote_nodes]> show profiles;
+----------+---------------+-----------------------------------------------------------------------------------+
| Query_ID | Duration | Query |
+----------+---------------+-----------------------------------------------------------------------------------+
| 1 | 8014.99140933 | select count(1) from lots l inner join lot_extension le on l.lot_num = le.lot_num |
+----------+---------------+-----------------------------------------------------------------------------------+



MariaDB [spider_2repmote_nodes]> show profile for QUERY 1;
+--------------------------------+------------+
| Status | Duration |
+--------------------------------+------------+
| Starting | 0.000036 |
| Waiting for query cache lock | 0.000004 |
| starting | 0.000013 |
| Checking query cache for query | 0.000068 |
| checking permissions | 0.000007 |
| Opening tables | 0.000040 |
| After opening tables | 0.000007 |
| System lock | 0.000008 |
| table lock | 0.000008 |
| init | 0.000029 |
| Optimizing | 0.000024 |
| Statistics | 0.000052 |
| Preparing | 0.000079 |
| Executing | 0.000003 |
| Sending data | 999.999999 |
| Removing tmp table | 0.160503 |
| Sending data | 0.000044 |
| End of update loop | 0.000007 |
| Query end | 0.000003 |
| Commit | 0.001490 |
| closing tables | 0.000007 |
| Unlocking tables | 0.000009 |
| closing tables | 0.000030 |
| Starting cleanup | 0.000003 |
| Freeing items | 0.000007 |
| Updating status | 0.000021 |
| Logging slow query | 0.000007 |
| Opening tables | 0.000016 |
| System lock | 0.000003 |
| table lock | 0.000003 |
| Opening tables | 0.000002 |
| After opening tables | 0.000050 |
| closing tables | 0.000002 |
| Unlocking tables | 0.000002 |
| closing tables | 0.000006 |
| Reset for next command | 0.000019 |
+--------------------------------+------------+
36 rows in set (0.000 sec)