https://api-magento.webfactura.cl/api/v3/pos/getDocumentsFiltered/data.json/?nro_orden=000620730&resource=80MM

Query Metrics

4 Database Queries
4 Different statements
556.25 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.81 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.empresa_id AS empresa_id_4, t0.oauth_consumer_key AS oauth_consumer_key_5, t0.oauth_consumer_secret AS oauth_consumer_secret_6, t0.store_base_url AS store_base_url_7, t0.oauth_verifier AS oauth_verifier_8, t0.oauth_token AS oauth_token_9, t0.oauth_token_secret AS oauth_token_secret_10, t0.is_active AS is_active_11, t0.store_base_url_qa AS store_base_url_qa_12, t0.oauth_token_qa AS oauth_token_qa_13, t0.modo_demo AS modo_demo_14 FROM magento t0 WHERE t0.empresa_id = ? LIMIT 1
Parameters:
[
  809
]
2 0.78 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.empresa_rut AS empresa_rut_3, t0.empresa_razon_social AS empresa_razon_social_4, t0.webfactura_id AS webfactura_id_5, t0.webfactura_client_id AS webfactura_client_id_6, t0.webfactura_client_secret AS webfactura_client_secret_7, t0.empresa_giro AS empresa_giro_8, t0.empresa_direccion AS empresa_direccion_9, t0.empresa_comuna AS empresa_comuna_10, t0.empresa_ciudad AS empresa_ciudad_11, t0.empresa_telefono AS empresa_telefono_12, t0.empresa_correo AS empresa_correo_13, t0.precio_bruto AS precio_bruto_14, t0.precio_neto AS precio_neto_15, t0.empresa_actividad_economica AS empresa_actividad_economica_16, t0.is_active AS is_active_17, t0.modo_demo AS modo_demo_18, t0.webfactura_client_id_qa AS webfactura_client_id_qa_19, t0.webfactura_client_secret_qa AS webfactura_client_secret_qa_20 FROM empresa t0 WHERE t0.webfactura_id = ? LIMIT 1
Parameters:
[
  809
]
3 554.06 ms
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.empresa_id AS empresa_id_3, m0_.doc_fecha_emision AS doc_fecha_emision_4, m0_.increment_id AS increment_id_5, m0_.state AS state_6, m0_.status AS status_7, m0_.doc_folio AS doc_folio_8, m0_.protect_code AS protect_code_9, m0_.doc_tipo_id AS doc_tipo_id_10, m0_.pdf_url AS pdf_url_11 FROM magento_order m0_ WHERE m0_.empresa_id = ? AND (m0_.increment_id = ? OR m0_.protect_code = ?)
Parameters:
[
  809
  "000620730"
  "9746a113ba4ec83705bfb770eff8278e"
]
4 0.61 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.empresa_id AS empresa_id_4, t0.doc_fecha_emision AS doc_fecha_emision_5, t0.increment_id AS increment_id_6, t0.state AS state_7, t0.status AS status_8, t0.doc_folio AS doc_folio_9, t0.protect_code AS protect_code_10, t0.doc_tipo_id AS doc_tipo_id_11, t0.pdf_url AS pdf_url_12 FROM magento_order t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  90085
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Magento No errors.
App\Entity\Empresa No errors.
App\Entity\MagentoOrder No errors.