Query Metrics
12
Database Queries
12
Different statements
147.62 ms
Query time
1
Invalid entities
21
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 15.01 ms |
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
]
|
| 2 | 3.88 ms |
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 | 7.91 ms |
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"
]
|
| 4 | 7.53 ms |
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 | 3.47 ms |
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
]
|
| 6 | 7.72 ms |
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 | 41.70 ms |
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"
]
|
| 8 | 5.53 ms |
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
]
|
| 9 | 2.50 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.estado AS estado_4 FROM tipo_servicio t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 10 | 1.30 ms |
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.nombres AS nombres_14, t0.apellidos AS apellidos_15, t0.telefono AS telefono_16, t0.url_foto AS url_foto_17, t0.id_recurso AS id_recurso_18, t0.id_region AS id_region_19, t0.id_rol AS id_rol_20, t1.type FROM user_tecnico t0 INNER JOIN users t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
5169
]
|
| 11 | 46.04 ms |
SELECT t0.id AS id_1, t0.identificacion AS identificacion_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.email AS email_5, t0.id_ciudad AS id_ciudad_6, t0.ciudad AS ciudad_7, t0.direccion AS direccion_8, t0.datos_referencia AS datos_referencia_9, t0.sector AS sector_10, t0.telefono AS telefono_11, t0.latitud AS latitud_12, t0.longitud AS longitud_13, t0.forma_pago AS forma_pago_14, t0.observacion AS observacion_15, t0.marca_vehiculo AS marca_vehiculo_16, t0.modelo_vehiculo AS modelo_vehiculo_17, t0.anio_vehiculo AS anio_vehiculo_18, t0.voltaje AS voltaje_19, t0.capacidad AS capacidad_20, t0.id_region AS id_region_21 FROM datos_entrega t0 WHERE t0.id = ?
Parameters:
[
8043
]
|
| 12 | 5.02 ms |
SELECT t0.id AS id_1, t0.identificacion AS identificacion_2, t0.razon_social AS razon_social_3, t0.email AS email_4, t0.direccion AS direccion_5, t0.ciudad AS ciudad_6, t0.telefono AS telefono_7 FROM datos_facturacion t0 WHERE t0.id = ?
Parameters:
[
7851
]
|
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 | 3 |
| 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 |
| App\Entity\RecursoTecnico | 1 |