Return
Main page
Update
PDF
Online help
Desktop
Choice of period :
Day
Week
Month
Year
All
Customized
From
to
(m/d/yy)
Request
Hits by parent request
Mean time (ms)
Max time (ms)
Standard deviation
Mean cpu time (ms)
Mean allocated Kb
% of system error
Mean hits sql
Mean time sql (ms)
CanhotoNotaSericeImp.delete
34
40
5
2
280
0.00
2
22
SELECT
cil.id AS idCanhotoImportacaoLote, ci.id AS idCanhotoImportacao, cn.id AS idCanhotoNota
FROM
canhoto_importacao_lote cil INNER JOIN canhoto_importacao ci ON cil.id = ci.lote_id LEFT OUTER JOIN canhoto_nota cn ON cn.canhoto_importacao_id = ci.id
WHERE
cil.id = ? AND ci.id = ?
1.00
9
9
0
0.00
delete
from
canhoto_importacao
where
id = ? ;
delete
from
canhoto_importacao_lote
where
id = ? and (
select
count(*)
from
canhoto_importacao ci
where
ci.lote_id = ?) = 0;
1.00
13
14
0
0.00
Find usages