Untitled
Posted by NotLim on Fri 21st Nov 2014 19:09
raw | new post

+---------+------------------+-----------+------------------------+---------+-------+----------------+------------------------------------------------------------------------------------------------------+
| Id      | User             | Host      | db                     | Command | Time  | State          | Info                                                                                                 |
+---------+------------------+-----------+------------------------+---------+-------+----------------+------------------------------------------------------------------------------------------------------+
| 7102776 | leechprotect     | localhost | leechprotect           | Sleep   | 17911 |                |                                                                                                      |
| 7174225 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 189   | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174274 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 177   | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174315 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 163   | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174325 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 161   | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174446 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 126   | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174463 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 121   | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174517 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 101   | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174582 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 80    | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174657 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 65    | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174693 | egdochil_claudio | localhost | egdochil_intranet      | Query   | 55    | Sending data   | SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' )  |
| 7174853 | miraelmu_ek8usua | localhost | miraelmu_ek8basedat    | Sleep   | 16    |                |                                                                                                      |
| 7174911 | mundoasi_root    | localhost | mundoasi_mundoasiatico | Query   | 0     | Opening tables | SELECT attribute_value FROM jos_vm_product_attribute WHERE `product_id` = '0' AND attribute_name='do |
| 7174913 | modsec           | localhost | modsec                 | Query   | 1     | update         | INSERT INTO modsec (`ip`, `date`, `time`, `handler`, `get`, `host`, `mod_security_message`, `mod_sec |
| 7174914 | root             | localhost |                        | Query   | 0     |                | show processlist                                                                                     |
+---------+------------------+-----------+------------------------+---------+-------+----------------+------------------------------------------------------------------------------------------------------+

# User@Host: egdochil_claudio[egdochil_claudio] @ localhost []
# Query_time: 38.291757  Lock_time: 0.004160 Rows_sent: 15  Rows_examined: 10004105
SET timestamp=1416596568;
SELECT inventario.num_serie, inventario.num_guia, DATE_FORMAT( inventario.fec_ingreso, '%d/%m/%Y' ) AS fecha_ingreso, Bodegas.des_bodega, subbodegas.des_subbodega, Articulos.des_articulo, Estadoinventario.des_estado, ultimos_traslados.fechatraslado, ultimos_traslados.responsable, usuario
FROM (
(
(
(
(
inventario
LEFT JOIN Articulos ON inventario.articulo = Articulos.id_articulo
)
LEFT JOIN subbodegas ON subbodegas.id_subbodega = inventario.bodega
)
LEFT JOIN Estadoinventario ON Estadoinventario.id_estado = inventario.estado_articulo
)
LEFT JOIN ultimos_traslados ON inventario.num_serie = ultimos_traslados.num_serie
)
LEFT JOIN ultimos_historicos ON inventario.num_serie = ultimos_historicos.num_serie
)
INNER JOIN Bodegas ON subbodegas.id_bodega = Bodegas.id_bodega

WHERE ((inventario.bodega = 84) and (inventario.estado_articulo = 1));