mysql> show full processlist;
+----------+-----------------+-------------------+-----------------+---------+------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id       | User            | Host              | db              | Command | Time | State        | Info                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
+----------+-----------------+-------------------+-----------------+---------+------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 16635793 | depozitauto     | 192.168.1.1:56007 | depozitauto     | Query   | 4385 | Sending data | SELECT v.vehicle_id, v.user_id, v.cylinder_capacity, v.model_year, v.model_month, v.type, v.price, v.vat, v.valuta_id,
                                                                                p.product_name, f.ro AS fuel_name, va.valuta_short_name, vpr.filename
                                                FROM `vehicle` v, product p, fuel f, valuta va, vehicle_pics_rel vpr
                                                WHERE  v.deleted IS NULL AND v.user_id=566
                                                  AND v.product_id = p.product_id
                                                  AND v.fuel_id = f.fuel_id AND v.valuta_id = va.valuta_id
                                                  AND v.vehicle_id = vpr.vehicle_id
                                                  AND vpr.ordinal = (SELECT MIN(ordinal) from vehicle_pics_rel WHERE vehicle_id = vpr.vehicle_id) |
| 16651274 | depozitauto     | 192.168.1.1:42637 | depozitauto     | Query   | 3591 | Sending data | SELECT v.vehicle_id, v.user_id, v.cylinder_capacity, v.model_year, v.model_month, v.type, v.price, v.vat, v.valuta_id,
                                                                                p.product_name, f.ro AS fuel_name, va.valuta_short_name, vpr.filename
                                                FROM `vehicle` v, product p, fuel f, valuta va, vehicle_pics_rel vpr
                                                WHERE  v.deleted IS NULL AND v.user_id=435
                                                  AND v.product_id = p.product_id
                                                  AND v.fuel_id = f.fuel_id AND v.valuta_id = va.valuta_id
                                                  AND v.vehicle_id = vpr.vehicle_id
                                                  AND vpr.ordinal = (SELECT MIN(ordinal) from vehicle_pics_rel WHERE vehicle_id = vpr.vehicle_id) |
| 16656473 | depozitauto     | 192.168.1.1:43632 | depozitauto     | Query   | 3325 | Sending data | SELECT v.vehicle_id, v.user_id, v.cylinder_capacity, v.model_year, v.model_month, v.type, v.price, v.vat, v.valuta_id,
                                                                                p.product_name, f.ro AS fuel_name, va.valuta_short_name, vpr.filename
                                                FROM `vehicle` v, product p, fuel f, valuta va, vehicle_pics_rel vpr
                                                WHERE  v.deleted IS NULL AND v.user_id=566
                                                  AND v.product_id = p.product_id
                                                  AND v.fuel_id = f.fuel_id AND v.valuta_id = va.valuta_id
                                                  AND v.vehicle_id = vpr.vehicle_id
                                                  AND vpr.ordinal = (SELECT MIN(ordinal) from vehicle_pics_rel WHERE vehicle_id = vpr.vehicle_id) |
| 16657470 | otthontrfump    | localhost         | otthontrfump    | Query   |    1 | Sending data | select * from swd_conf  where fk_account in (0,111545)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 16665551 | otthontrfump    | localhost         | otthontrfump    | Query   |    1 | Sending data | select * from swd_conf  where fk_account in (0,111545)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 16681183 | otthontrfump    | localhost         | otthontrfump    | Query   |    1 | Sending data | select * from swd_conf  where fk_account in (0,108271)                                |
| 16665551 | otthontrfump    | localhost         | otthontrfump    | Query   |    1 | Sending data | select * from swd_conf  where fk_account in (0,111545)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 16681183 | otthontrfump    | localhost         | otthontrfump    | Query   |    1 | Sending data | select * from swd_conf  where fk_account in (0,108271)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 16681461 | depozitauto     | 192.168.1.1:38956 | depozitauto     | Query   | 2016 | Locked       | OPTIMIZE TABLE `vehicle_pics_rel`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| 16692736 | otthontrfump    | localhost         | otthontrfump    | Query   |    1 | Sending data | select * from swd_conf  where fk_account in (0,108271)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 16695428 | depozitauto     | 192.168.1.1:55723 | depozitauto     | Query   | 1275 | Locked       | ALTER TABLE `vehicle_pics_rel` ADD INDEX(`vehicle_id`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 16704530 | mikrosatfump    | localhost         | mikrosatfump    | Sleep   |    1 |              | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 16708235 | depozitauto     | 192.168.1.1:50285 | depozitauto     | Query   |  461 | Locked       | SELECT COUNT(*) FROM `depozitauto`.`vehicle_pics_rel`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| 16719959 | vinylmasterfump | localhost         | vinylmasterfump | Sleep   |    4 |              | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 16720086 | root            | localhost         | NULL            | Query   |    0 | NULL         | show full processlist                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| 16720177 | retronom        | 192.168.1.1:33110 | retronom        | Sleep   |    3 |              | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 16720209 | zhongwen        | 192.168.1.1:33129 | zhongwen        | Sleep   |    1 |              | NULL