Mine
public text v1 · immutablemysql> 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