Ttykuu

i have a query that loads ~1600 lines.
I use in HeidiSQL to run querys (but they are coming from php/mysqli app).
On my test base it takes ~12 seconds to load and on client ~40 seconds (In php id doesnt even compleate).

My question is is my query bad? What coul be otimized?

P.S. I will not post creat querys for tables now as they have lot of columns. Also i did not know if i should leve all paramaeters in select so i did not removed them.

SELECT l.id AS lid, l.doc AS receive_doc, l.thisTransport AS receive_transport, l.productNr AS receive_productNr, 
l.activityDate AS receive_date, h.ladingNr AS receive_ladingNr, l.place_count AS receive_place_count,
h.cargo_status AS receive_cargo_status, h.client AS client, e.id AS eid, e.doc AS doc, e.deliverydate AS deliveryDate, 
e.activitydate AS activityDate, e.assistant_amount AS assistant_amount, e.amount AS amount, e.productnr AS productNr, 
e.productumo AS productUmo, e.status AS status, e.orgline, ni.name1, ni.name2, h.agreements AS agreements, nc.Name,
a.uom AS uom, au.uom AS auuom ,

(select z.status from item_ledger_entry as z where (z.orgLine=l.id OR z.cargoLine=l.id) AND e.doc=l.doc ORDER BY z.id DESC LIMIT 1) as istatus,
(select z.place_count from item_ledger_entry as z where (z.orgLine=l.id OR z.cargoLine=l.id) AND e.doc=l.doc ORDER BY z.id DESC LIMIT 1) as iplace_count,
(select z.activityDate from item_ledger_entry as z where (z.orgLine=l.id OR z.cargoLine=l.id) AND e.doc=l.doc ORDER BY z.id DESC LIMIT 1) as iactivityDate,
(select z.place_count from item_ledger_entry as z where (z.orgLine=l.id OR z.cargoLine=l.id) AND e.doc=l.doc ORDER BY z.id DESC LIMIT 1) as iassistant_amount


FROM cargo_receive AS l 
LEFT JOIN ledger_entry AS e 
ON e.cargoline = l.id OR e.orgline = l.id 

LEFT JOIN header_receive AS h ON l.doc = h.doc 

LEFT JOIN lines_agreements AS a 
ON h.agreements = a.contractnr 
AND e.productnr = a.item 
AND e.resource = a.service

LEFT JOIN uom AS au 
ON e.productnr = au.productnr 
AND au.status = 1 
AND au.convert_from = 1 

LEFT JOIN customers AS nc
ON h.client=nc.Code 

LEFT JOIN items AS ni
ON l.productNr=ni.code 


WHERE h.client='1234567' AND h.agreements='AG000001'

GROUP BY l.id
ORDER BY l.activityDate ASC, l.doc

Please help! Thanks in advance!