LOCAL:



MariaDB [test_march2024]> show profiles;
+----------+--------------+-----------------------------------------------------------------------------------+
| Query_ID | Duration | Query |
+----------+--------------+-----------------------------------------------------------------------------------+
| 1 | 146.28067054 | select count(1) from lots l inner join lot_extension le on l.lot_num = le.lot_num |
+----------+--------------+-----------------------------------------------------------------------------------+
1 row in set (0.000 sec)

MariaDB [test_march2024]> show profile for QUERY 1;
+--------------------------------+------------+
| Status | Duration |
+--------------------------------+------------+
| Starting | 0.000029 |
| Waiting for query cache lock | 0.000003 |
| starting | 0.000002 |
| Checking query cache for query | 0.000057 |
| checking permissions | 0.000006 |
| Opening tables | 0.000040 |
| After opening tables | 0.000007 |
| System lock | 0.000006 |
| table lock | 0.000007 |
| Opening tables | 0.000019 |
| After opening tables | 0.000002 |
| System lock | 0.000004 |
| table lock | 0.000204 |
| Unlocking tables | 0.000004 |
| closing tables | 0.000009 |
| Waiting for query cache lock | 0.000002 |
| closing tables | 0.000068 |
| init | 0.000031 |
| Optimizing | 0.000016 |
| Statistics | 0.000047 |
| Preparing | 0.000024 |
| Executing | 0.000003 |
| Sending data | 146.279786 |
| End of update loop | 0.000029 |
| Query end | 0.000004 |
| Commit | 0.000007 |
| closing tables | 0.000005 |
| Unlocking tables | 0.000002 |
| closing tables | 0.000023 |
| Starting cleanup | 0.000004 |
| Freeing items | 0.000012 |
| Updating status | 0.000007 |
| Waiting for query cache lock | 0.000003 |
| Updating status | 0.000029 |
| Waiting for query cache lock | 0.000005 |
| Updating status | 0.000002 |
| Storing result in query cache | 0.000010 |
| Logging slow query | 0.000008 |
| Opening tables | 0.000022 |
| System lock | 0.000003 |
| table lock | 0.000005 |
| Opening tables | 0.000002 |
| After opening tables | 0.000075 |
| closing tables | 0.000004 |
| Unlocking tables | 0.000003 |
| closing tables | 0.000007 |
| Reset for next command | 0.000026 |
+--------------------------------+------------+