GET https://boschecommerce.blubear.io/descarga-comprobante-pago/8713

Query Metrics

8 Database Queries
8 Different statements
92.75 ms Query time
1 Invalid entities
19 Managed entities

Grouped Statements

Show all queries

Time Count Info
41.70 ms
(44.96%)
1
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.username_canonical AS username_canonical_2, u0_.email AS email_3, u0_.email_canonical AS email_canonical_4, u0_.enabled AS enabled_5, u0_.salt AS salt_6, u0_.password AS password_7, u0_.last_login AS last_login_8, u0_.confirmation_token AS confirmation_token_9, u0_.password_requested_at AS password_requested_at_10, u0_.roles AS roles_11, u1_.Nombres AS nombres_12, u1_.Apellidos AS apellidos_13, u1_.Cargo AS cargo_14, u1_.Telefono AS telefono_15, u1_.Url_foto AS url_foto_16, u1_.Id_rol AS id_rol_17, u1_.Id_familia AS id_familia_18, u1_.Status AS status_19, u2_.Nombres AS nombres_20, u2_.Apellidos AS apellidos_21, u2_.Id_ciudad AS id_ciudad_22, u2_.Ciudad AS ciudad_23, u2_.Direccion AS direccion_24, u2_.Empresa AS empresa_25, u2_.Id_partner AS id_partner_26, u2_.Codigo_infor AS codigo_infor_27, u2_.Telefono AS telefono_28, u2_.Url_foto AS url_foto_29, u2_.Id_rol AS id_rol_30, u2_.Status AS status_31, u2_.bod_ov AS bod_ov_32, u2_.dpto_ov AS dpto_ov_33, u2_.serie_ov AS serie_ov_34, u2_.tipo_ov AS tipo_ov_35, u2_.ocultar_precio AS ocultar_precio_36, u3_.id_infor AS id_infor_37, u3_.id_adress AS id_adress_38, u3_.Nombres AS nombres_39, u3_.Apellidos AS apellidos_40, u3_.Direccion AS direccion_41, u3_.Direccion_referencia AS direccion_referencia_42, u3_.telefono AS telefono_43, u3_.id_ciudad_usuario AS id_ciudad_usuario_44, u3_.ciudad_usuario AS ciudad_usuario_45, u3_.sector AS sector_46, u3_.latitud AS latitud_47, u3_.longitud AS longitud_48, u3_.razon_social AS razon_social_49, u3_.identificacion AS identificacion_50, u3_.direccion_factura AS direccion_factura_51, u3_.ciudad_factura AS ciudad_factura_52, u3_.email_factura AS email_factura_53, u3_.telefono_factura AS telefono_factura_54, u3_.marca_vehiculo AS marca_vehiculo_55, u3_.modelo_vehiculo AS modelo_vehiculo_56, u3_.anio_vehiculo AS anio_vehiculo_57, u3_.fecha_creacion AS fecha_creacion_58, u4_.nombres AS nombres_59, u4_.apellidos AS apellidos_60, u4_.telefono AS telefono_61, u4_.url_foto AS url_foto_62, u0_.type AS type_63, u3_.id_ciudad AS id_ciudad_64, u3_.id_rol AS id_rol_65, u4_.id_recurso AS id_recurso_66, u4_.id_region AS id_region_67, u4_.id_rol AS id_rol_68 FROM users u0_ LEFT JOIN user_back u1_ ON u0_.id = u1_.id LEFT JOIN user_frontend u2_ ON u0_.id = u2_.id LEFT JOIN user_ecommerce u3_ ON u0_.id = u3_.id LEFT JOIN user_tecnico u4_ ON u0_.id = u4_.id WHERE u0_.email = ?
Parameters:
[
  "geneda2802@hotmail.com"
]
15.01 ms
(16.18%)
1
SELECT t0.id AS id_5, t0.username AS username_6, t0.username_canonical AS username_canonical_7, t0.email AS email_8, t0.email_canonical AS email_canonical_9, t0.enabled AS enabled_10, t0.salt AS salt_11, t0.password AS password_12, t0.last_login AS last_login_13, t0.confirmation_token AS confirmation_token_14, t0.password_requested_at AS password_requested_at_15, t0.roles AS roles_16, t0.type, t1.Nombres AS nombres_17, t1.Apellidos AS apellidos_18, t1.Cargo AS cargo_19, t1.Telefono AS telefono_20, t1.Url_foto AS url_foto_21, t1.Id_rol AS id_rol_22, t1.Id_familia AS id_familia_23, t1.Status AS status_24, t2.Nombres AS nombres_25, t2.Apellidos AS apellidos_26, t2.Id_ciudad AS id_ciudad_27, t2.Ciudad AS ciudad_28, t2.Direccion AS direccion_29, t2.Empresa AS empresa_30, t2.Id_partner AS id_partner_31, t2.Codigo_infor AS codigo_infor_32, t2.Telefono AS telefono_33, t2.Url_foto AS url_foto_34, t2.Id_rol AS id_rol_35, t2.Status AS status_36, t2.bod_ov AS bod_ov_37, t2.dpto_ov AS dpto_ov_38, t2.serie_ov AS serie_ov_39, t2.tipo_ov AS tipo_ov_40, t2.ocultar_precio AS ocultar_precio_41, t3.id_infor AS id_infor_42, t3.id_adress AS id_adress_43, t3.Nombres AS nombres_44, t3.Apellidos AS apellidos_45, t3.Direccion AS direccion_46, t3.Direccion_referencia AS direccion_referencia_47, t3.telefono AS telefono_48, t3.id_ciudad_usuario AS id_ciudad_usuario_49, t3.ciudad_usuario AS ciudad_usuario_50, t3.sector AS sector_51, t3.latitud AS latitud_52, t3.longitud AS longitud_53, t3.razon_social AS razon_social_54, t3.identificacion AS identificacion_55, t3.direccion_factura AS direccion_factura_56, t3.ciudad_factura AS ciudad_factura_57, t3.email_factura AS email_factura_58, t3.telefono_factura AS telefono_factura_59, t3.marca_vehiculo AS marca_vehiculo_60, t3.modelo_vehiculo AS modelo_vehiculo_61, t3.anio_vehiculo AS anio_vehiculo_62, t3.fecha_creacion AS fecha_creacion_63, t3.id_ciudad AS id_ciudad_64, t3.id_rol AS id_rol_65, t4.nombres AS nombres_66, t4.apellidos AS apellidos_67, t4.telefono AS telefono_68, t4.url_foto AS url_foto_69, t4.id_recurso AS id_recurso_70, t4.id_region AS id_region_71, t4.id_rol AS id_rol_72 FROM users t0 LEFT JOIN user_back t1 ON t0.id = t1.id LEFT JOIN user_frontend t2 ON t0.id = t2.id LEFT JOIN user_ecommerce t3 ON t0.id = t3.id LEFT JOIN user_tecnico t4 ON t0.id = t4.id WHERE t0.id = ?
Parameters:
[
  314
]
7.91 ms
(8.53%)
1
SELECT t0.id AS id_1, t0.id_horario AS id_horario_2, t0.id_orden AS id_orden_3, t0.id_tecnico AS id_tecnico_4 FROM disponibilidad t0 WHERE t0.id_orden = ? LIMIT 1
Parameters:
[
  "8713"
]
7.72 ms
(8.33%)
1
SELECT t0.id AS id_1, t0.id_infor AS id_infor_2, t0.partner_plantilla AS partner_plantilla_3, t0.nombre AS nombre_4, t0.estado AS estado_5, t0.descuento_punto_venta AS descuento_punto_venta_6, t0.valor_minimo_instalacion_domicilio AS valor_minimo_instalacion_domicilio_7, t0.correos_administrativos AS correos_administrativos_8, t0.ciudad_id AS ciudad_id_9 FROM region_entrega t0 WHERE t0.id = ?
Parameters:
[
  12
]
7.53 ms
(8.12%)
1
SELECT t0.id AS id_1, t0.cantidad AS cantidad_2, t0.iva AS iva_3, t0.descuento AS descuento_4, t0.cant_descuento_bateria AS cant_descuento_bateria_5, t0.descuento_agente AS descuento_agente_6, t0.aplica_descuento_bateria AS aplica_descuento_bateria_7, t0.valor_descuento_bateria AS valor_descuento_bateria_8, t0.precio AS precio_9, t0.estado AS estado_10, t0.fecha_actualizacion AS fecha_actualizacion_11, t0.comentario AS comentario_12, t0.id_orden AS id_orden_13, t0.id_producto AS id_producto_14 FROM detalle_orden t0 WHERE t0.id_orden = ? AND t0.estado = ?
Parameters:
[
  "8713"
  "A"
]
5.53 ms
(5.96%)
1
SELECT t0.id AS id_1, t0.Idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Idfamilia AS idfamilia_9, t0.Value_linea_de_producto AS value_linea_de_producto_10, t0.Value_grupo_estadistico AS value_grupo_estadistico_11, t0.Id_estructura_ecommerce AS id_estructura_ecommerce_12, t0.Descripcion_comercial AS descripcion_comercial_13, t0.Descripcion_corta AS descripcion_corta_14, t0.Descripcion_larga AS descripcion_larga_15, t0.Aplicaciones_relacionadas AS aplicaciones_relacionadas_16, t0.url_foto AS url_foto_17, t0.sesion AS sesion_18, t0.tiene_despiece AS tiene_despiece_19, t0.estado_btc AS estado_btc_20, t0.descuento_bateria AS descuento_bateria_21, t0.valor_descuento_bateria AS valor_descuento_bateria_22, t0.otros_productos AS otros_productos_23, t0.promocion_vigente AS promocion_vigente_24, t0.slogan AS slogan_25, t0.tipo_uso AS tipo_uso_26, t0.marca AS marca_27 FROM producto t0 WHERE t0.id = ?
Parameters:
[
  2047
]
3.88 ms
(4.18%)
1
SELECT t0.id AS id_1, t0.latitud_atencion AS latitud_atencion_2, t0.longitud_atencion AS longitud_atencion_3, t0.observacion AS observacion_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_programado AS fecha_programado_6, t0.inicio_programado AS inicio_programado_7, t0.fin_programado AS fin_programado_8, t0.fecha_atencion AS fecha_atencion_9, t0.inicio AS inicio_10, t0.fin AS fin_11, t0.ultima_modificacion AS ultima_modificacion_12, t0.fecha_cancelado AS fecha_cancelado_13, t0.usuario_creacion AS usuario_creacion_14, t0.usuario_modificacion AS usuario_modificacion_15, t0.descuento_punto_venta AS descuento_punto_venta_16, t0.id_pago_app AS id_pago_app_17, t0.id_baterias_desc AS id_baterias_desc_18, t0.tipo_pago_app AS tipo_pago_app_19, t0.pago_total AS pago_total_20, t0.request_pagos_app AS request_pagos_app_21, t0.total_pedido AS total_pedido_22, t0.id_cliente AS id_cliente_23, t0.id_ejecutivo AS id_ejecutivo_24, t0.id_datos_facturacion AS id_datos_facturacion_25, t0.id_datos_entrega AS id_datos_entrega_26, t0.id_tipo_servicio AS id_tipo_servicio_27, t0.id_punto_venta AS id_punto_venta_28, t0.id_pago AS id_pago_29, t0.id_canal_contacto AS id_canal_contacto_30, t0.id_estado_orden AS id_estado_orden_31 FROM orden t0 WHERE t0.id = ?
Parameters:
[
  "8713"
]
3.47 ms
(3.74%)
1
SELECT t1.id AS id_2, t1.username AS username_3, t1.username_canonical AS username_canonical_4, t1.email AS email_5, t1.email_canonical AS email_canonical_6, t1.enabled AS enabled_7, t1.salt AS salt_8, t1.password AS password_9, t1.last_login AS last_login_10, t1.confirmation_token AS confirmation_token_11, t1.password_requested_at AS password_requested_at_12, t1.roles AS roles_13, t0.id_infor AS id_infor_14, t0.id_adress AS id_adress_15, t0.Nombres AS nombres_16, t0.Apellidos AS apellidos_17, t0.Direccion AS direccion_18, t0.Direccion_referencia AS direccion_referencia_19, t0.telefono AS telefono_20, t0.id_ciudad_usuario AS id_ciudad_usuario_21, t0.ciudad_usuario AS ciudad_usuario_22, t0.sector AS sector_23, t0.latitud AS latitud_24, t0.longitud AS longitud_25, t0.razon_social AS razon_social_26, t0.identificacion AS identificacion_27, t0.direccion_factura AS direccion_factura_28, t0.ciudad_factura AS ciudad_factura_29, t0.email_factura AS email_factura_30, t0.telefono_factura AS telefono_factura_31, t0.marca_vehiculo AS marca_vehiculo_32, t0.modelo_vehiculo AS modelo_vehiculo_33, t0.anio_vehiculo AS anio_vehiculo_34, t0.fecha_creacion AS fecha_creacion_35, t0.id_ciudad AS id_ciudad_36, t0.id_rol AS id_rol_37, t1.type FROM user_ecommerce t0 INNER JOIN users t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  10428
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Users 4
App\Entity\Rol 2
App\Entity\Orden 1
App\Entity\DatosFacturacion 1
App\Entity\DatosEntrega 1
App\Entity\TipoServicio 1
App\Entity\CanalContacto 1
App\Entity\EstadoOrden 1
App\Entity\Disponibilidad 1
App\Entity\Horario 1
App\Entity\DetalleOrden 1
App\Entity\Producto 1
App\Entity\RegionEntrega 1
App\Entity\Ciudad 1
App\Entity\Marca 1

Entities Mapping

Class Mapping errors
App\Entity\Users No errors.
App\Entity\User_back No errors.
App\Entity\User_frontend No errors.
App\Entity\User_ecommerce No errors.
App\Entity\User_tecnico No errors.
App\Entity\RegionEntrega No errors.
App\Entity\Rol No errors.
App\Entity\RecursoTecnico No errors.
App\Entity\Orden No errors.
App\Entity\DatosFacturacion No errors.
App\Entity\DatosEntrega No errors.
App\Entity\TipoServicio No errors.
App\Entity\PuntoVenta No errors.
App\Entity\Pago No errors.
App\Entity\CanalContacto No errors.
App\Entity\EstadoOrden No errors.
App\Entity\DetalleOrden No errors.
App\Entity\EstadoServicio No errors.
App\Entity\Disponibilidad No errors.
App\Entity\Horario
  • The field App\Entity\Horario#disponibilidad is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Disponibilidad#idHorario does not contain the required 'inversedBy: "disponibilidad"' attribute.
App\Entity\Producto No errors.
App\Entity\Ciudad No errors.
App\Entity\Marca No errors.
App\Entity\Adjuntos No errors.
App\Entity\DetalleProductoTipoRelacion No errors.
App\Entity\CrossReferences No errors.
App\Entity\Caracteristica_valor No errors.
App\Entity\DetalleProductoAplicacion No errors.
App\Entity\shopping_cart No errors.