hi guys, i'm running a busy server with a very big query blocking many others queries. the point is...
there's a query with update or delete?
could we add a column about query type? examples:
SET query (set variable= xxx)
SELECT query (select * from table...)
UPDATE query
REPLACE query
DELETE query
etc etc...
and a column (when possible) about what tables will be used? this help with waiting table lock...
this help a lot seeing what could be blocked (or not)
today to do this i should parse the query, since queries have a big comment to get information about user, ip, session, pid and file being used, a new column could be easier to see that
here a output of my today processlist when some queries was being blocked
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | STAGE | MAX_STAGE | PROGRESS | MEMORY_USED | EXAMINED_ROWS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53224 | rspadim | 187.65.224.39:32957 | information_schema | Query | 0 | executing | SELECT `ID`, `USER`, `HOST`, `DB`, `COMMAND`, `TIME`, `STATE`, `INFO`, `TIME_MS`, `STAGE`, `MAX_STAGE`, `PROGRESS`, `MEMORY_USED`, `EXAMINED_ROWS` FROM `information_schema`.`PROCESSLIST` LIMIT 1000 | 0.402 | 0 | 0 | 0.000 | 75640 | 0 |
| 35707 | rspadim | 187.65.224.39:33181 | 19_org | Query | 225 | Waiting for table level lock | explain /* pid:18029 spd_user: adm.jn SELF='/rdm-business/app/industria.pcp.spadim' ms=7 ip=10.10.0.26 session=mojydk.kz8frkrnm8ki220duxhk4kkwcwk8gw4osg */SELECT a.unidade_id,a.lote_spa,a.lote_tipo,a.vendedor_tipo,a.vendedor_id,a.cliente_tipo,a.cliente_id,a.sit_producao,SUM(b.cur_op_quant) AS cur_op_quant,SUM(b.cur_op_quant*b.vliq) AS cur_op_volume_liq,SUM(b.cur_op_quant*b.pliq) AS cur_op_peso_liquido,b.cur_op,b.cur_op_seq,a.sit_pcp,b.item_id,b.item_id_red,b.cur_oe FROM spamov_itens AS b, spamov AS a WHERE b.unidade_id=a.unidade_id AND b.lote_tipo=a.lote_tipo AND b.lote_spa=a.lote_spa AND a.unidade_id IN ("1001") AND a.abate='N' AND a.lote_tipo IN ('v') AND b.cur_op_quant>0 AND a.producao="Y" AND sit_pcp="mov" AND a.lote_spa>=0 AND a.lote_spa<=99999999999 AND a.cur_oe>=0 AND a.cur_oe<=99999999999 AND b.cur_op=0 AND a.data_digitacao>='2000-01-01 02:00:00' AND a.data_digitacao<='2013-06-18 02:59:59' GROUP BY b.unidade_id,b.item_id,b.item_id_red ORDER BY b.item_id ASC,b.item_id_red ASC | 225428.005 | 0 | 0 | 0.000 | 69744 | 0 |
| 22406 | rdm | localhost | 19_org | Query | 372 | Waiting for table level lock | /* pid:24552 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 372612.190 | 0 | 0 | 0.000 | 45264 | 0 |
| 136 | rdm | localhost | 19_org | Query | 527 | Waiting for table level lock | /* pid:25004 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 527491.402 | 0 | 0 | 0.000 | 45264 | 0 |
| 135 | rdm | localhost | 19_org | Query | 528 | Waiting for table level lock | /* pid:17299 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 528461.488 | 0 | 0 | 0.000 | 45264 | 0 |
| 134 | rdm | localhost | 19_org | Query | 528 | Waiting for table level lock | /* pid:6361 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 528646.023 | 0 | 0 | 0.000 | 45264 | 0 |
| 133 | rdm | localhost | 19_org | Query | 529 | Waiting for table level lock | /* pid:18255 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 529645.124 | 0 | 0 | 0.000 | 45264 | 0 |
| 132 | rdm | localhost | 19_org | Query | 530 | Waiting for table level lock | /* pid:6833 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 530265.900 | 0 | 0 | 0.000 | 45264 | 0 |
| 131 | rdm | localhost | 19_org | Query | 531 | Waiting for table level lock | /* pid:7104 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 531630.494 | 0 | 0 | 0.000 | 45264 | 0 |
| 130 | rdm | localhost | 19_org | Query | 532 | Waiting for table level lock | /* pid:26371 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 532872.096 | 0 | 0 | 0.000 | 45264 | 0 |
| 129 | rdm | localhost | 19_org | Query | 525 | Waiting for table level lock | /* pid:6360 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 525492.411 | 0 | 0 | 0.000 | 45264 | 0 |
| 128 | rdm | localhost | 19_org | Query | 512 | Waiting for table level lock | /* pid:7089 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 512173.875 | 0 | 0 | 0.000 | 45264 | 0 |
| 127 | rdm | localhost | 19_org | Query | 541 | Waiting for table level lock | /* pid:26360 spd_user: v.90067 SELF='/rdm-business/app/spa.supervisor.spadim' ms=6 ip=10.10.0.38 session=mojyd7.ufyxq3c3n6ny4b9487e04o0skg4kw4gg4o */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:36:06" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 541262.453 | 0 | 0 | 0.000 | 45264 | 0 |
| 126 | rdm | localhost | 19_org | Query | 541 | Waiting for table level lock | /* pid:6307 spd_user: couto_it_48 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=187.67.55.11 session=mojyf0.7pi5nb51dedoe4hc1v5csw0g4k44os4cos */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:36:05" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 541629.216 | 0 | 0 | 0.000 | 45264 | 0 |
| 125 | rdm | localhost | 19_org | Query | 538 | Waiting for table level lock | /* pid:26370 spd_user: ricardo.sup SELF='/rdm-business/app/spa.supervisor.spadim' ms=6 ip=10.10.0.63 session=mojyc0.m3bw9kyvw9lb94juwjhoo0o0k00sscwoc0 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:36:09" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 538323.969 | 0 | 0 | 0.000 | 45264 | 0 |
| 124 | rdm | localhost | 19_org | Query | 538 | Waiting for table level lock | /* pid:7106 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 538341.577 | 0 | 0 | 0.000 | 45264 | 0 |
| 123 | rdm | localhost | 19_org | Query | 554 | Waiting for table level lock | /* pid:25003 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 554607.729 | 0 | 0 | 0.000 | 45264 | 0 |
| 122 | rdm | localhost | 19_org | Query | 554 | Waiting for table level lock | /* pid:26359 spd_user: ger.lima SELF='/rdm-business/app/spa.gerente.spadim' ms=6 ip=10.10.0.8 session=mojyf7.tus5fs5umakn8p0l1n34g84owo0k08k8ck */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:52" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 554962.994 | 0 | 0 | 0.000 | 45264 | 0 |
| 121 | rdm | localhost | 19_org | Query | 525 | Waiting for table level lock | /* pid:11406 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 525434.632 | 0 | 0 | 0.000 | 45264 | 0 |
| 120 | rdm | localhost | 19_org | Query | 558 | Waiting for table level lock | /* pid:26132 spd_user: sumye_150 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=4 ip=189.106.12.14 session=mojyc6.9b1fgryx84hw85v4to3y8g0cwwcckkkwgc */SELECT data_prevista_embarque,data_prevista_chegada,data_prevista_processo,sit_spa FROM spamov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=855174 | 558068.497 | 0 | 0 | 0.000 | 45264 | 0 |
| 119 | rdm | localhost | 19_org | Query | 561 | Waiting for table level lock | /* pid:7080 spd_user: tlmk.90634 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=10.10.0.12 session=mojydd.vztreb8f46mkbytxrlmw4ws488swowoko4 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:46" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 561163.967 | 0 | 0 | 0.000 | 45264 | 0 |
| 117 | rdm | localhost | 19_org | Query | 563 | Waiting for table level lock | /* pid:6595 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 563199.658 | 0 | 0 | 0.000 | 45264 | 0 |
| 116 | rdm | localhost | 19_org | Query | 563 | Waiting for table level lock | /* pid:10505 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 563204.831 | 0 | 0 | 0.000 | 45264 | 0 |
| 115 | rdm | localhost | 19_org | Query | 563 | Waiting for table level lock | /* pid:16444 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 563647.830 | 0 | 0 | 0.000 | 45264 | 0 |
| 114 | rdm | localhost | 19_org | Query | 564 | Waiting for table level lock | /* pid:17322 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 564217.635 | 0 | 0 | 0.000 | 45264 | 0 |
| 113 | rdm | localhost | 19_org | Query | 564 | Waiting for table level lock | /* pid:6589 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 564362.801 | 0 | 0 | 0.000 | 45264 | 0 |
| 112 | rdm | localhost | 19_org | Query | 564 | Waiting for table level lock | /* pid:26131 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 564683.159 | 0 | 0 | 0.000 | 45264 | 0 |
| 111 | rdm | localhost | 19_org | Query | 564 | Waiting for table level lock | /* pid:17577 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 564859.322 | 0 | 0 | 0.000 | 45264 | 0 |
| 110 | rdm | localhost | 19_org | Query | 565 | Waiting for table level lock | /* pid:17578 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 565052.110 | 0 | 0 | 0.000 | 45264 | 0 |
| 109 | rdm | localhost | 19_org | Query | 549 | Waiting for table level lock | /* pid:17285 spd_user: v.90102 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=-1 ip=200.97.118.126 session=mojyci.emyc19ldicepl5f7fdkgs8w0wcgwkskccc */SELECT distribuidor_tipo,distribuidor_id,vendedor_tipo,vendedor_id,cliente_tipo,cliente_id,d_pag FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456196 | 549257.803 | 0 | 0 | 0.000 | 45264 | 0 |
| 108 | rdm | localhost | 19_org | Query | 565 | Waiting for table level lock | /* pid:17576 spd_user: tlmk.90634 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=0 ip=10.10.0.12 session=mojydd.vztreb8f46mkbytxrlmw4ws488swowoko4 */SELECT data_prevista_embarque,data_prevista_chegada,data_prevista_processo,sit_spa FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456195 | 565745.667 | 0 | 0 | 0.000 | 45264 | 0 |
| 107 | rdm | localhost | 19_org | Query | 565 | Waiting for table level lock | /* pid:7098 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 565915.260 | 0 | 0 | 0.000 | 45264 | 0 |
| 106 | rdm | localhost | 19_org | Query | 566 | Waiting for table level lock | /* pid:18256 spd_user: ricardo.sup SELF='/rdm-business/app/spa.supervisor.spadim' ms=6 ip=10.10.0.63 session=mojyc0.m3bw9kyvw9lb94juwjhoo0o0k00sscwoc0 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:41" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 566342.786 | 0 | 0 | 0.000 | 45264 | 0 |
| 105 | rdm | localhost | 19_org | Query | 527 | Waiting for table level lock | /* pid:17575 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 527510.078 | 0 | 0 | 0.000 | 45264 | 0 |
| 103 | rdm | localhost | 19_org | Query | 572 | Waiting for table level lock | /* pid:17320 spd_user: tlmk.90652 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=10.10.0.11 session=mojydt.6o1abtr8718qmc4bct5dwcosgsckkkwco4 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:35" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 572365.223 | 0 | 0 | 0.000 | 45264 | 0 |
| 102 | rdm | localhost | 19_org | Query | 573 | Waiting for table level lock | /* pid:7088 spd_user: tlmk.90634 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=0 ip=10.10.0.12 session=mojydd.vztreb8f46mkbytxrlmw4ws488swowoko4 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:33" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 573774.785 | 0 | 0 | 0.000 | 45264 | 0 |
| 101 | rdm | localhost | 19_org | Query | 575 | Waiting for table level lock | /* pid:7074 spd_user: tlmk.90634 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=0 ip=10.10.0.12 session=mojydd.vztreb8f46mkbytxrlmw4ws488swowoko4 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:31" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 575718.327 | 0 | 0 | 0.000 | 45264 | 0 |
| 100 | rdm | localhost | 19_org | Query | 564 | Waiting for table level lock | /* pid:24551 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 564531.734 | 0 | 0 | 0.000 | 45264 | 0 |
| 104 | rdm | localhost | 19_org | Query | 560 | Waiting for table level lock | /* pid:26361 spd_user: ger.lima SELF='/rdm-business/app/industria.estoque.spadim' ms=0 ip=10.10.0.8 session=mojyf7.tus5fs5umakn8p0l1n34g84owo0k08k8ck */SELECT SUM( b.quantidade * IF(a.sit_spa='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS ped_compra_quant,SUM( b.quantidade * b.pecas * IF(a.sit_spa='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS ped_compra_pecas,SUM( b.quantidade * b.pliq * IF(a.sit_spa='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS ped_compra_pliq,SUM( b.quantidade * b.pbruto * IF(a.sit_spa='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS ped_compra_pbruto,SUM( b.quantidade * b.vliq * IF(a.sit_spa='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS ped_compra_vliq,SUM( b.quantidade * b.vbruto * IF(a.sit_spa='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS ped_compra_vbruto,SUM( IF(b.quant_lib>0,(b.quant_lib-b.quant_rejeitado-b.quant_embarcado),(b.quantidade-b.quant_rejeitado-b.quant_embarcado)) * IF(a.sit_spa!='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS compras_quant,SUM( b.pecas * IF(b.quant_lib>0,(b.quant_lib-b.quant_rejeitado-b.quant_embarcado),(b.quantidade-b.quant_rejeitado-b.quant_embarcado)) * IF(a.sit_spa!='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS compras_pecas,SUM( b.pliq * IF(b.quant_lib>0,(b.quant_lib-b.quant_rejeitado-b.quant_embarcado),(b.quantidade-b.quant_rejeitado-b.quant_embarcado)) * IF(a.sit_spa!='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS compras_pliq,SUM( b.pbruto * IF(b.quant_lib>0,(b.quant_lib-b.quant_rejeitado-b.quant_embarcado),(b.quantidade-b.quant_rejeitado-b.quant_embarcado)) * IF(a.sit_spa!='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS compras_pbruto,SUM( b.vliq * IF(b.quant_lib>0,(b.quant_lib-b.quant_rejeitado-b.quant_embarcado),(b.quantidade-b.quant_rejeitado-b.quant_embarcado)) * IF(a.sit_spa!='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS compras_vliq,SUM( b.vbruto * IF(b.quant_lib>0,(b.quant_lib-b.quant_rejeitado-b.quant_embarcado),(b.quantidade-b.quant_rejeitado-b.quant_embarcado)) * IF(a.sit_spa!='mov',0,1) * IF(a.saida_entrada='e',1,-1) ) AS compras_vbruto FROM spamov AS a,spamov_itens AS b WHERE (a.distribuidor_tipo,a.distribuidor_id)!=('f',2) AND a.unidade_id=1001 AND a.lote_tipo='c' AND b.unidade_id=a.unidade_id AND b.lote_tipo=a.lote_tipo AND b.lote_spa=a.lote_spa AND b.item_id=67 AND b.item_id_red=724 AND a.compra_cancelada='N' | 560340.831 | 0 | 0 | 0.000 | 143152 | 0 |
| 99 | rdm | localhost | 19_org | Query | 578 | Waiting for table level lock | /* pid:6256 spd_user: ger.lima SELF='/rdm-business/app/spa.gerente.spadim' ms=-1 ip=10.10.0.18 session=mojydb.xcxcu0ll75xs4kje54u4gocck4c4c8wk8c */SELECT distribuidor_tipo,distribuidor_id,vendedor_tipo,vendedor_id,cliente_tipo,cliente_id,d_pag FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456197 | 578273.374 | 0 | 0 | 0.000 | 45264 | 0 |
| 98 | rdm | localhost | 19_org | Query | 579 | Waiting for table level lock | /* pid:26372 spd_user: tlmk.90634 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=-1 ip=10.10.0.12 session=mojydd.vztreb8f46mkbytxrlmw4ws488swowoko4 */SELECT distribuidor_tipo,distribuidor_id,vendedor_tipo,vendedor_id,cliente_tipo,cliente_id,d_pag FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456195 | 579380.206 | 0 | 0 | 0.000 | 45264 | 0 |
| 97 | rdm | localhost | 19_org | Query | 580 | Waiting for table level lock | /* pid:17094 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 580302.060 | 0 | 0 | 0.000 | 45264 | 0 |
| 96 | rdm | localhost | 19_org | Query | 580 | Waiting for table level lock | /* pid:14823 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 580307.834 | 0 | 0 | 0.000 | 45264 | 0 |
| 95 | rdm | localhost | 19_org | Query | 580 | Waiting for table level lock | /* pid:26358 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 580396.220 | 0 | 0 | 0.000 | 45264 | 0 |
| 94 | rdm | localhost | 19_org | Query | 580 | Waiting for table level lock | /* pid:16442 spd_user: couto_it_48 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=187.67.55.11 session=mojyf0.7pi5nb51dedoe4hc1v5csw0g4k44os4cos */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:27" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 580257.731 | 0 | 0 | 0.000 | 45264 | 0 |
| 93 | rdm | localhost | 19_org | Query | 582 | Waiting for table level lock | /* pid:25905 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 582378.637 | 0 | 0 | 0.000 | 45264 | 0 |
| 92 | rdm | localhost | 19_org | Query | 582 | Waiting for table level lock | /* pid:6590 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 582555.465 | 0 | 0 | 0.000 | 45264 | 0 |
| 91 | rdm | localhost | 19_org | Query | 578 | Waiting for table level lock | /* pid:6255 spd_user: ppdp01.1 SELF='/rdm-business/app/industria.pdp.spadim' ms=-1 ip=172.16.1.52 session=mojycp.e4qtxa6lja7luma2hqnsw8gwc448skok08 */UPDATE spamov_itens AS a SET quant_produzido=20894,pecas_prod=20894,pliq_prod=459908.45,vliq_prod=0,pbruto_prod=468335.15,vbruto_prod=0 WHERE unidade_id=1001 AND lote_tipo='i' AND lote_spa=75 AND item_id=67 AND item_id_red=89 | 578809.478 | 0 | 0 | 0.000 | 53424 | 0 |
| 90 | rdm | localhost | 19_org | Query | 582 | Waiting for table level lock | /* pid:17095 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 582765.870 | 0 | 0 | 0.000 | 45264 | 0 |
| 88 | rdm | localhost | 19_org | Query | 535 | Waiting for table level lock | /* pid:6848 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 535863.507 | 0 | 0 | 0.000 | 45264 | 0 |
| 86 | rdm | localhost | 19_org | Query | 585 | Waiting for table level lock | /* pid:11408 spd_user: sup.shpak SELF='/rdm-business/app/spa.supervisor.spadim' ms=6 ip=189.106.119.106 session=mojyeq.72d53rqx08uu460bh8pgc0g80s4840s4gk */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:21" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 585508.214 | 0 | 0 | 0.000 | 45264 | 0 |
| 85 | rdm | localhost | 19_org | Query | 586 | Waiting for table level lock | /* pid:12095 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 586390.666 | 0 | 0 | 0.000 | 45264 | 0 |
| 84 | rdm | localhost | 19_org | Query | 586 | Waiting for table level lock | /* pid:14821 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 586646.722 | 0 | 0 | 0.000 | 45264 | 0 |
| 83 | rdm | localhost | 19_org | Query | 586 | Waiting for table level lock | /* pid:6826 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 586880.248 | 0 | 0 | 0.000 | 45264 | 0 |
| 81 | rdm | localhost | 19_org | Query | 588 | Waiting for table level lock | /* pid:6258 spd_user: v.90577 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=187.13.97.228 session=mojyej.x2x0c7y6n9jn9235fo5c084sg4kgcwok4s */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:19" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 588028.896 | 0 | 0 | 0.000 | 45264 | 0 |
| 80 | rdm | localhost | 19_org | Query | 588 | Waiting for table level lock | /* pid:12093 spd_user: cesar_it_162 SELF='/rdm-business/app/spa.supervisor.spadim' ms= |
588981.403 | 0 | 0 | 0.000 | 45264 | 0 |
| 79 | rdm | localhost | 19_org | Query | 589 | Waiting for table level lock | /* pid:24778 spd_user: ricardo.sup SELF='/rdm-business/app/spa.supervisor.spadim' ms=6 ip=10.10.0.63 session=mojyc0.m3bw9kyvw9lb94juwjhoo0o0k00sscwoc0 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:18" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 589459.273 | 0 | 0 | 0.000 | 45264 | 0 |
| 78 | rdm | localhost | 19_org | Query | 590 | Waiting for table level lock | /* pid:7087 spd_user: tlmk.90635 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=10.10.0.14 session=mojye7.7auzyay75aemolwxt6jkgkkkc48cogsgs8 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:17" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 590276.002 | 0 | 0 | 0.000 | 45264 | 0 |
| 77 | rdm | localhost | 19_org | Query | 592 | Waiting for table level lock | /* pid:7114 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 592153.944 | 0 | 0 | 0.000 | 45264 | 0 |
| 76 | rdm | localhost | 19_org | Query | 592 | Waiting for table level lock | /* pid:7109 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 592484.058 | 0 | 0 | 0.000 | 45264 | 0 |
| 75 | rdm | localhost | 19_org | Query | 592 | Waiting for table level lock | /* pid:24553 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 592643.714 | 0 | 0 | 0.000 | 45264 | 0 |
| 74 | rdm | localhost | 19_org | Query | 593 | Waiting for table level lock | /* pid:24550 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 593068.672 | 0 | 0 | 0.000 | 45264 | 0 |
| 73 | rdm | localhost | 19_org | Query | 593 | Waiting for table level lock | /* pid:10504 spd_user: tlmk.90634 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=-7 ip=10.10.0.12 session=mojydd.vztreb8f46mkbytxrlmw4ws488swowoko4 */SELECT data_prevista_embarque,data_prevista_chegada,data_prevista_processo,sit_spa FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456195 | 593511.279 | 0 | 0 | 0.000 | 45264 | 0 |
| 72 | rdm | localhost | 19_org | Query | 593 | Waiting for table level lock | /* pid:6591 spd_user: tlmk.90634 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=-7 ip=10.10.0.12 session=mojydd.vztreb8f46mkbytxrlmw4ws488swowoko4 */SELECT data_prevista_embarque,data_prevista_chegada,data_prevista_processo,sit_spa FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456195 | 593707.388 | 0 | 0 | 0.000 | 45264 | 0 |
| 71 | rdm | localhost | 19_org | Query | 594 | Waiting for table level lock | /* pid:10573 spd_user: tlmk.90634 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=-7 ip=10.10.0.12 session=mojydd.vztreb8f46mkbytxrlmw4ws488swowoko4 */SELECT data_prevista_embarque,data_prevista_chegada,data_prevista_processo,sit_spa FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456195 | 594454.280 | 0 | 0 | 0.000 | 45264 | 0 |
| 69 | rdm | localhost | 19_org | Query | 600 | Waiting for table level lock | /* pid:14824 spd_user: ricardo.sup SELF='/rdm-business/app/spa.supervisor.spadim' ms=6 ip=10.10.0.63 session=mojyc0.m3bw9kyvw9lb94juwjhoo0o0k00sscwoc0 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:06" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 600517.209 | 0 | 0 | 0.000 | 45264 | 0 |
| 68 | rdm | localhost | 19_org | Query | 601 | Waiting for table level lock | /* pid:6827 spd_user: tlmk.90587 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=10.10.0.13 session=mojydn.lytuzbfeh5h0767z1vx4woo4gkwcsgc8cg */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:35:05" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 601593.594 | 0 | 0 | 0.000 | 45264 | 0 |
| 66 | rdm | localhost | 19_org | Query | 612 | Waiting for table level lock | /* pid:17300 spd_user: sumye_150 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=4 ip=189.106.12.14 session=mojyc6.9b1fgryx84hw85v4to3y8g0cwwcckkkwgc */SELECT data_prevista_embarque,data_prevista_chegada,data_prevista_processo,sit_spa FROM spamov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=855174 | 612552.448 | 0 | 0 | 0.000 | 45264 | 0 |
| 65 | rdm | localhost | 19_org | Query | 613 | Waiting for table level lock | /* pid:7095 spd_user: cesar_it_162 SELF='/rdm-business/app/spa.supervisor.spadim' ms=0 ip=10.10.0.123 session=mojydb.v69u7fsd19o7ll9e811k4w0ko4wkggww44 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:34:54" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 613032.881 | 0 | 0 | 0.000 | 45264 | 0 |
| 64 | rdm | localhost | 19_org | Query | 614 | Waiting for table level lock | /* pid:7112 spd_user: v.90102 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=-1 ip=200.97.118.126 session=mojyci.emyc19ldicepl5f7fdkgs8w0wcgwkskccc */SELECT distribuidor_tipo,distribuidor_id,vendedor_tipo,vendedor_id,cliente_tipo,cliente_id,d_pag FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456196 | 614033.570 | 0 | 0 | 0.000 | 45264 | 0 |
| 63 | rdm | localhost | 19_org | Query | 591 | Waiting for table level lock | /* pid:17586 spd_user: ppdp01.1 SELF='/rdm-business/app/industria.pdp.spadim' ms=-1 ip=172.16.1.52 session=mojycp.e4qtxa6lja7luma2hqnsw8gwc448skok08 */UPDATE spamov_itens AS a SET quant_produzido=20893,pecas_prod=20893,pliq_prod=459892.65,vliq_prod=0,pbruto_prod=468318.95,vbruto_prod=0 WHERE unidade_id=1001 AND lote_tipo='i' AND lote_spa=75 AND item_id=67 AND item_id_red=89 | 591891.055 | 0 | 0 | 0.000 | 53424 | 0 |
| 62 | rdm | localhost | 19_org | Query | 615 | Waiting for table level lock | /* pid:6844 spd_user: v.90023 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=177.192.198.122 session=mojydx.phnx1m2z9cm3c1c4zue8gwocso8kcg0oko */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:34:52" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 615257.836 | 0 | 0 | 0.000 | 45264 | 0 |
| 60 | rdm | localhost | 19_org | Query | 594 | Waiting for table level lock | /* pid:11403 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-2 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT rest_data_producao,rest_data_vencimento,rest_embarque_processado,rest_contrato FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 594461.783 | 0 | 0 | 0.000 | 45264 | 0 |
| 59 | rdm | localhost | 19_org | Query | 616 | Waiting for table level lock | /* pid:17284 spd_user: tlmk.90652 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=10.10.0.11 session=mojydt.6o1abtr8718qmc4bct5dwcosgsckkkwco4 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:34:51" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 616195.277 | 0 | 0 | 0.000 | 45264 | 0 |
| 57 | rdm | localhost | 19_org | Query | 617 | Waiting for table level lock | /* pid:17323 spd_user: vv.90504 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=6 ip=177.179.99.50 session=mojydv.7602kq7qu58o1djtavowswgcw80o0gg4g- */SELECT COUNT AS quant_ped,SUM(quant_itens) AS quant_itens,SUM(cur_oe_quant) AS quant_oe,SUM(valor_total) AS valor_total,SUM(valor_tab) AS valor_tab,SUM(valor_total*dias_medios)/SUM(valor_total) AS dias_medios FROM (SELECT a.lote_spa,a.quant_itens,a.cur_oe_quant,a.valor_total,a.valor_total/(1-(a.desconto_itens/100)) AS valor_tab,a.dias_medios,(SELECT plano_conta_numero FROM rotas WHERE plano_conta_id=a.rota_id AND plano_conta_id_red=a.rota_id_red) AS rota_numero FROM spamov AS a WHERE a.lote_tipo='v' AND a.lote_spa>=0 AND a.lote_spa<=99999999999 AND a.lote_estorno=0 AND a.data_prevista_embarque>='2013-06-01 03:00:00' AND a.data_prevista_embarque<='2013-06-18 02:59:59' AND ((a.distribuidor_tipo,a.distribuidor_id) = ('f',90504) OR (a.gerente_tipo,a.gerente_id) = ('f',90504) OR (a.supervisor_tipo,a.supervisor_id) = ('f',90504) OR (a.vendedor_tipo,a.vendedor_id) = ('f',90504) OR (a.digitador_tipo,a.digitador_id) = ('f',90504) OR (a.cliente_tipo,a.cliente_id) = ('f',90504)) AND sit_spa!='mov' GROUP BY a.unidade_id,a.lote_tipo,a.lote_spa) AS tmp_tbl |
617795.898 | 0 | 0 | 0.000 | 94216 | 0 |
| 56 | rdm | localhost | 19_org | Query | 617 | Waiting for table level lock | /* pid:17583 spd_user: v.90651 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=0 ip=189.24.25.108 session=mojycs.1m2h9ik1n1oi7xgyxae1w8owcoo08s44g0 */SELECT MAX(a) FROM (SELECT MAX(lote_spa) AS a FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' UNION SELECT MAX(orcamento_numero) AS a FROM spamov WHERE unidade_id=1001 AND lote_tipo='v') AS b | 617246.108 | 0 | 0 | 0.000 | 61584 | 0 |
| 54 | rdm | localhost | 19_org | Query | 613 | Waiting for table level lock | /* pid:16096 spd_user: iran_it_34 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=0 ip=187.105.76.118 session=mojycy.wttbnebrnemc8u418r6okg0k0w00ogwk08 */UPDATE spamov_digitacao SET data_prevista_embarque="2013-06-17 16:34:54" WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=0 | 613373.215 | 0 | 0 | 0.000 | 45264 | 0 |
| 51 | rdm | localhost | 19_org | Query | 615 | Waiting for table level lock | /* pid:6850 spd_user: ger.lima SELF='/rdm-business/app/spa.gerente.spadim' ms=-1 ip=10.10.0.18 session=mojydb.xcxcu0ll75xs4kje54u4gocck4c4c8wk8c */SELECT distribuidor_tipo,distribuidor_id,vendedor_tipo,vendedor_id,cliente_tipo,cliente_id,d_pag FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456197 | 615402.782 | 0 | 0 | 0.000 | 45264 | 0 |
| 50 | rdm | localhost | 19_org | Query | 613 | Waiting for table level lock | /* pid:7107 spd_user: ricardo.sup SELF='/rdm-business/app/spa.supervisor.spadim' ms=6 ip=10.10.0.63 session=mojyc0.m3bw9kyvw9lb94juwjhoo0o0k00sscwoc0 */SELECT data_prevista_embarque,data_prevista_chegada,data_prevista_processo,sit_spa FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456192 | 613791.678 | 0 | 0 | 0.000 | 45264 | 0 |
| 46 | rdm | localhost | 19_org | Query | 609 | Waiting for table level lock | /* pid:11409 spd_user: v.90102 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=0 ip=200.97.118.126 session=mojyci.emyc19ldicepl5f7fdkgs8w0wcgwkskccc */SELECT data_prevista_embarque,data_prevista_chegada,data_prevista_processo,sit_spa FROM spamov_digitacao WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456196 | 609239.144 | 0 | 0 | 0.000 | 45264 | 0 |
| 45 | rdm | localhost | 19_org | Query | 610 | Waiting for table level lock | /* pid:12089 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=-1 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT valor_un_pg,valor_tabela_grandeza_un,valor_tabela_grandeza_qnt FROM spamov_itens WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 AND item_id=67 AND item_id_red=724 | 610088.094 | 0 | 0 | 0.000 | 45264 | 0 |
| 29 | rdm | localhost | 19_org | Query | 611 | Waiting for table level lock | /* pid:6593 spd_user: v.90577 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=0 ip=187.13.97.228 session=mojyce.mhxsgi66bft9qotcblkw4g084000w00o8- */SELECT b.valor_un_pg FROM spamov_itens AS b,spamov AS c WHERE b.lote_spa!=1456189 AND (b.unidade_id,b.lote_tipo,b.lote_spa)=(c.unidade_id,c.lote_tipo,c.lote_spa) AND b.item_id=67 AND b.item_id_red=447 AND c.unidade_id=1001 AND c.lote_tipo='v' AND c.cliente_tipo='j' AND c.cliente_id=25208 ORDER BY c.lote_spa DESC LIMIT 1 | 611446.794 | 0 | 0 | 0.000 | 53424 | 0 |
| 28 | rdm | localhost | 19_org | Query | 606 | Waiting for table level lock | /* pid:6257 spd_user: ger.lima SELF='/rdm-business/app/spa.gerente.spadim' ms=0 ip=10.10.0.9 session=mojyd5.wksprbkj3bo5d92mtf5s00080s4ccss8wg */SELECT b.valor_un_pg FROM spamov_itens AS b,spamov AS c WHERE b.lote_spa!=854797 AND (b.unidade_id,b.lote_tipo,b.lote_spa)=(c.unidade_id,c.lote_tipo,c.lote_spa) AND b.item_id=67 AND b.item_id_red=854 AND c.unidade_id=1001 AND c.lote_tipo='v' AND c.cliente_tipo='f' AND c.cliente_id=43943 ORDER BY c.lote_spa DESC LIMIT 1 | 606858.040 | 0 | 0 | 0.000 | 53424 | 0 |
| 24 | rdm | localhost | 19_org | Query | 562 | Waiting for table level lock | /* pid:10502 spd_user: ppdp01.1 SELF='/rdm-business/app/industria.pdp.spadim' ms=-1 ip=172.16.1.52 session=mojycp.e4qtxa6lja7luma2hqnsw8gwc448skok08 */UPDATE spamov_itens AS a SET quant_produzido=20895,pecas_prod=20895,pliq_prod=459932.75,vliq_prod=0,pbruto_prod=468359.85,vbruto_prod=0 WHERE unidade_id=1001 AND lote_tipo='i' AND lote_spa=75 AND item_id=67 AND item_id_red=89 | 562494.182 | 0 | 0 | 0.000 | 53424 | 0 |
| 49 | rdm | localhost | 19_org | Query | 617 | Waiting for table level lock | /* pid:15051 spd_user: v.90067 SELF='/rdm-business/app/spa.supervisor.spadim' ms=0 ip=10.10.0.38 session=mojyd7.ufyxq3c3n6ny4b9487e04o0skg4kw4gg4o */UPDATE spamov_digitacao SET margem_itens=158.50340136054,dias_medios=7,comissao_valor=0.00,comissao_basecalculo=182.40,valor_total_sem_desc=182.4,valor_total_sem_desc_nf=182.4,valor_total=182.4,valor_total_nf=182.4,impostos_retidos=0,quant_itens=1,pecas=1,vbruto=0,vliq=0,pbruto=24,pliq=24,desconto_itens=-1.4686248331108,desconto_sobre_pedido=0.00,desconto_sobre_pedido_por='0',moeda="R$",moeda_fator=1,icms_basecalculo=0.00,icms_valor=0.00,icms_subst_basecalculo=0.00,icms_subst_valor=0.00,ipi_basecalculo=182.40,ipi_valor=0.00,iss_basecalculo=182.40,iss_valor=0.00 WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456194 | 617114.366 | 0 | 0 | 0.000 | 61584 | 0 |
| 48 | rdm | localhost | 19_org | Query | 619 | Copying to tmp table | /* pid:18029 spd_user: adm.jn SELF='/rdm-business/app/industria.pcp.spadim' ms=7 ip=10.10.0.26 session=mojydk.kz8frkrnm8ki220duxhk4kkwcwk8gw4osg */SELECT a.unidade_id,a.lote_spa,a.lote_tipo,a.vendedor_tipo,a.vendedor_id,a.cliente_tipo,a.cliente_id,a.sit_producao,SUM(b.cur_op_quant) AS cur_op_quant,SUM(b.cur_op_quant*b.vliq) AS cur_op_volume_liq,SUM(b.cur_op_quant*b.pliq) AS cur_op_peso_liquido,b.cur_op,b.cur_op_seq,a.sit_pcp,b.item_id,b.item_id_red,b.cur_oe FROM spamov_itens AS b, spamov AS a WHERE b.unidade_id=a.unidade_id AND b.lote_tipo=a.lote_tipo AND b.lote_spa=a.lote_spa AND a.unidade_id IN ("1001") AND a.abate='N' AND a.lote_tipo IN ('v') AND b.cur_op_quant>0 AND a.producao="Y" AND sit_pcp="mov" AND a.lote_spa>=0 AND a.lote_spa<=99999999999 AND a.cur_oe>=0 AND a.cur_oe<=99999999999 AND b.cur_op=0 AND a.data_digitacao>='2000-01-01 02:00:00' AND a.data_digitacao<='2013-06-18 02:59:59' GROUP BY b.unidade_id,b.item_id,b.item_id_red ORDER BY b.item_id ASC,b.item_id_red ASC | 619676.104 | 0 | 0 | 0.000 | 1162208 | 0 |
| 47 | rdm | localhost | 19_org | Query | 617 | Waiting for table level lock | /* pid:17097 spd_user: tlmk.90634 SELF='/rdm-business/app/spa.vendedorexterno.spadim' ms=0 ip=10.10.0.12 session=mojydd.vztreb8f46mkbytxrlmw4ws488swowoko4 */UPDATE spamov_digitacao SET margem_itens=61.751292186075,dias_medios=7,comissao_valor=0.00,comissao_basecalculo=319.20,valor_total_sem_desc=319.2,valor_total_sem_desc_nf=319.2,valor_total=319.2,valor_total_nf=319.2,impostos_retidos=0,quant_itens=2,pecas=2,vbruto=72.384,vliq=0,pbruto=43.96,pliq=42,desconto_itens=-1.4686248331108,desconto_sobre_pedido=0.00,desconto_sobre_pedido_por='0',moeda="R$",moeda_fator=1,icms_basecalculo=0.00,icms_valor=0.00,icms_subst_basecalculo=0.00,icms_subst_valor=0.00,ipi_basecalculo=319.20,ipi_valor=0.00,iss_basecalculo=319.20,iss_valor=0.00 WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456195 | 617150.006 | 0 | 0 | 0.000 | 61584 | 0 |
| 41 | rdm | localhost | 19_org | Query | 617 | Waiting for table level lock | /* pid:15052 spd_user: cesar_it_162 SELF='/rdm-business/app/spa.supervisor.spadim' ms=0 ip=186.241.142.146 session=mojyd5.x9plf2s4atgb534arcwkkkkkgkskogks-- */UPDATE spamov AS a SET cur_oe_quant=(SELECT SUM(cur_oe_quant) FROM spamov_itens WHERE unidade_id=a.unidade_id AND lote_tipo='v' AND lote_spa=a.lote_spa),cur_oe_pecas=(SELECT SUM(cur_oe_quant*pecas) FROM spamov_itens WHERE unidade_id=a.unidade_id AND lote_tipo='v' AND lote_spa=a.lote_spa),cur_oe_vbruto=(SELECT SUM(cur_oe_quant*vbruto) FROM spamov_itens WHERE unidade_id=a.unidade_id AND lote_tipo='v' AND lote_spa=a.lote_spa),cur_oe_vliq=(SELECT SUM(cur_oe_quant*vliq) FROM spamov_itens WHERE unidade_id=a.unidade_id AND lote_tipo='v' AND lote_spa=a.lote_spa),cur_oe_pbruto=(SELECT SUM(cur_oe_quant*pbruto) FROM spamov_itens WHERE unidade_id=a.unidade_id AND lote_tipo='v' AND lote_spa=a.lote_spa),cur_oe_pliq=(SELECT SUM(cur_oe_quant*pliq) FROM spamov_itens WHERE unidade_id=a.unidade_id AND lote_tipo='v' AND lote_spa=a.lote_spa),cur_op_quant=(SELECT SUM(cur_op_quant) FROM spamov_itens WHERE unidade_id=a.unidade_id AND lote_tipo='v' AND lote_spa=a.lote_spa) WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa=1456193 | 617865.831 | 0 | 0 | 0.000 | 110528 | 0 |
| 20 | rdm | localhost | 19_org | Query | 610 | Waiting for table level lock | /* pid:7075 spd_user: valinho15 SELF='/rdm-business/app/spa.supervisor.spadim' ms=0 ip=189.48.71.90 session=mojycn.sdik1xdj7ble044m8z6og8skcsc08sccwg */SELECT b.valor_un_pg FROM spamov_itens AS b,spamov AS c WHERE b.lote_spa!=1456188 AND (b.unidade_id,b.lote_tipo,b.lote_spa)=(c.unidade_id,c.lote_tipo,c.lote_spa) AND b.item_id=67 AND b.item_id_red=486 AND c.unidade_id=1001 AND c.lote_tipo='v' AND c.cliente_tipo='j' AND c.cliente_id=43888 ORDER BY c.lote_spa DESC LIMIT 1 | 610073.046 | 0 | 0 | 0.000 | 53424 | 0 |
| 16 | rdm | localhost | 19_org | Query | 611 | Waiting for table level lock | /* pid:11641 spd_user: ppdp01.1 SELF='/rdm-business/app/industria.pdp.spadim' ms=-1 ip=172.16.1.52 session=mojycp.e4qtxa6lja7luma2hqnsw8gwc448skok08 */UPDATE spamov_itens AS a SET quant_produzido=17966,pecas_prod=22492,pliq_prod=384447.66,vliq_prod=0,pbruto_prod=391856.71,vbruto_prod=0 WHERE unidade_id=1001 AND lote_tipo='i' AND lote_spa=75 AND item_id=67 AND item_id_red=403 | 611401.036 | 0 | 0 | 0.000 | 53424 | 0 |
| 3 | rdm | localhost | 19_org | Query | 519 | Waiting for table level lock | /* pid:6592 spd_user: ppde4.1 SELF='/rdm-business/app/industria.pde.spadim' ms=8 ip=172.16.1.57 session=mojycq.urcufh8qq4fx5hre85h2cc08s48k8k0sss */SELECT cur_oe,cur_oe_seq FROM spamov WHERE unidade_id=1001 AND lote_tipo='c' AND lote_spa=27521 | 519066.150 | 0 | 0 | 0.000 | 45264 | 0 |