ЭТО?
+-------+------------------+-----------+-----------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info
| Progress |
+-------+------------------+-----------+-----------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------+----------+
| 17053 | 046593822_apteka | localhost | apteka_63 | Query | 0 | init | SHOW FULL PROCESSLIST
| 0.000 |
| 17210 | 046593822_apteka | localhost | apteka_63 | Sleep | 4 | | NULL
| 0.000 |
| 17211 | 046593822_apteka | localhost | apteka_63 | Sleep | 9 | | NULL
| 0.000 |
| 17218 | 046593822_apteka | localhost | apteka_63 | Query | 0 | Copying to tmp table | select m.image,p.manufacturer_id,p.product_id,m.name as name from oc_product_to_category p2c
left join oc_product p on p.product_id=p2c.product_id
left join oc_manufacturer m on m.manufacturer_id=p.manufacturer_id
where p2c.category_id in (71,488,489,490,491,492,493,494,495,496,497,498,741,743,742,504,505,509,510,512,513,744,745,518,519,520,524,525,526,527,528,747,746,533,768,769,767,766,765,760,763,764,758,
757,756,754,755,753,751,752,750,567,568,569,570,571,572,573,574,748,749,578,762,761,584,585,586,587,588,589,590,759) and p.status=1 group by p.manufacturer_id | 0.000 |
| 17219 | 046593822_apteka | localhost | apteka_63 | Sleep | 5 | | NULL
| 0.000 |
| 17220 | 046593822_apteka | localhost | apteka_63 | Query | 0 | Copying to tmp table | select m.image,p.manufacturer_id,p.product_id,m.name as name from oc_product_to_category p2c
left join oc_product p on p.product_id=p2c.product_id
left join oc_manufacturer m on m.manufacturer_id=p.manufacturer_id
where p2c.category_id in (71,488,489,490,491,492,493,494,495,496,497,498,741,743,742,504,505,509,510,512,513,744,745,518,519,520,524,525,526,527,528,747,746,533,768,769,767,766,765,760,763,764,758,
757,756,754,755,753,751,752,750,567,568,569,570,571,572,573,574,748,749,578,762,761,584,585,586,587,588,589,590,759) and p.status=1 group by p.manufacturer_id | 0.000 |
| 17221 | 046593822_apteka | localhost | apteka_63 | Sleep | 4 | | NULL
| 0.000 |
| 17226 | 046593822_apteka | localhost | apteka_63 | Sleep | 0 | | NULL
| 0.000 |
| 17227 | 046593822_apteka | localhost | apteka_63 | Sleep | 1 | | NULL
| 0.000 |
+-------+------------------+-----------+-----------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------+----------+
9 rows in set (0.00 sec)