Query Metrics
4
Database Queries
4
Different statements
556.25 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |