MariaDB [test]> set profiling = 0;
Query OK, 0 rows affected (0.01 sec)

MariaDB [test]> select 'without profiling';
+-------------------+
| without profiling |
+-------------------+
| without profiling |
+-------------------+
1 row in set (0.00 sec)

MariaDB [test]> set statement profiling=1 for select 'with one-statement profiling';
+------------------------------+
| with one-statement profiling |
+------------------------------+
| with one-statement profiling |
+------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> show profiles;
Empty set (0.00 sec)

MariaDB [test]> set profiling = 1;
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> select 'with profiling';
+----------------+
| with profiling |
+----------------+
| with profiling |
+----------------+
1 row in set (0.00 sec)

MariaDB [test]> set statement profiling=0 for select 'with one-statement profiling turned off';
+-----------------------------------------+
| with one-statement profiling turned off |
+-----------------------------------------+
| with one-statement profiling turned off |
+-----------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> set profiling = 0;
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> show profiles;
+----------+------------+--------------------------------------------------------------------------------+
| Query_ID | Duration   | Query                                                                          |
+----------+------------+--------------------------------------------------------------------------------+
|        1 | 0.00073110 | select 'with profiling'                                                        |
|        2 | 0.00060901 | set statement profiling=0 for select 'with one-statement profiling turned off' |
+----------+------------+--------------------------------------------------------------------------------+
2 rows in set (0.00 sec)