Query Metrics
7
Database Queries
7
Different statements
30.27 ms
Query time
1
Invalid entities
41
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.26 ms (30.58%) |
1 |
SELECT t0.id AS id_1, t0.nombrecliente AS nombrecliente_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.codpostalcliente AS codpostalcliente_5, t0.direccioncliente AS direccioncliente_6, t0.latitud AS latitud_7, t0.longitud AS longitud_8, t0.poblacioncliente AS poblacioncliente_9, t0.provinciacliente AS provinciacliente_10, t0.paiscliente AS paiscliente_11, t0.telefonocliente AS telefonocliente_12, t0.telefono2cliente AS telefono2cliente_13, t0.movilcliente AS movilcliente_14, t0.emailcliente AS emailcliente_15, t0.codmonedaminuta AS codmonedaminuta_16, t0.nifcliente AS nifcliente_17, t0.zona AS zona_18, t0.fechareserva AS fechareserva_19, t0.codcliente AS codcliente_20, t0.direccion2cliente AS direccion2cliente_21, t0.total AS total_22, t0.totalsiniva AS totalsiniva_23, t0.sucursal AS sucursal_24, t0.comentario AS comentario_25, t0.is_finalizada AS is_finalizada_26, t0.metododepago AS metododepago_27, t0.tipodeservicio AS tipodeservicio_28, t0.is_enviado AS is_enviado_29, t0.filename AS filename_30, t0.estado AS estado_31, t0.propinatotal AS propinatotal_32, t0.propinaporcentaje AS propinaporcentaje_33, t0.linkdepago AS linkdepago_34, t0.facturaelectronica AS facturaelectronica_35, t0.DIRECCION_2 AS DIRECCION_2_36, t0.NOMBRE_1 AS NOMBRE_1_37, t0.OTROS_NOMBRES AS OTROS_NOMBRES_38, t0.APELLIDO_1 AS APELLIDO_1_39, t0.APELLIDO_2 AS APELLIDO_2_40, t0.FE_MUNICIPIO AS FE_MUNICIPIO_41, t0.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_42, t0.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_43, t0.TIPOPERSONA AS TIPOPERSONA_44, t0.FE_REGIMEN AS FE_REGIMEN_45, t0.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_46, t0.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_47, t0.CENTRO_COSTOS AS CENTRO_COSTOS_48, t0.CENTRO_OPERACION AS CENTRO_OPERACION_49, t0.alias AS alias_50, t0.email_linkdepago AS email_linkdepago_51, t0.nombre_receptor AS nombre_receptor_52, t0.telefono_receptor AS telefono_receptor_53, t0.observaciones_receptor AS observaciones_receptor_54, t0.connector_order_id AS connector_order_id_55, t0.created_at AS created_at_56, t0.updated_at AS updated_at_57, t0.user_id AS user_id_58, t0.connector_store_id AS connector_store_id_59 FROM cabecera t0 WHERE t0.id = ?
Parameters:
[
"400065"
]
|
|
5.17 ms (17.07%) |
1 |
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.codarticulo AS codarticulo_3, t0.descripcion AS descripcion_4, t0.codfavorito AS codfavorito_5, t0.precio AS precio_6, t0.preciosiniva AS preciosiniva_7, t0.precioiva AS precioiva_8, t0.codimpuesto AS codimpuesto_9, t0.codmodificador AS codmodificador_10, t0.numlineasmodif AS numlineasmodif_11, t0.codfavoritos AS codfavoritos_12, t0.lft AS lft_13, t0.lvl AS lvl_14, t0.rgt AS rgt_15, t0.unidades AS unidades_16, t0.preciototal AS preciototal_17, t0.posicion AS posicion_18, t0.preciounidad AS preciounidad_19, t0.comentario AS comentario_20, t0.cabecera_id AS cabecera_id_21, t0.tree_root AS tree_root_22, t0.parent_id AS parent_id_23 FROM lineas t0 WHERE t0.cabecera_id = ? ORDER BY t0.tree_root ASC, t0.lft ASC
Parameters:
[
400065
]
|
|
4.88 ms (16.12%) |
1 |
SELECT t0.id AS id_1, t0.estado AS estado_2, t0.linkdepago AS linkdepago_3, t0.comentario AS comentario_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.cabecera_id AS cabecera_id_7 FROM cabecera_linkdepago t0 WHERE t0.cabecera_id = ?
Parameters:
[
400065
]
|
|
4.81 ms (15.89%) |
1 |
SELECT c0_.codigo AS codigo_0, c0_.porcentaje AS porcentaje_1, c0_.descripcion AS descripcion_2, c0_.activo AS activo_3, c0_.creado_en AS creado_en_4, c0_.actualizado_en AS actualizado_en_5 FROM codigos_impuesto c0_ WHERE c0_.porcentaje IS NULL ORDER BY c0_.codigo ASC
Parameters:
[] |
|
3.42 ms (11.30%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.poligono AS poligono_5, t0.color AS color_6, t0.mon_open_at AS mon_open_at_7, t0.mon_closed_at AS mon_closed_at_8, t0.tue_open_at AS tue_open_at_9, t0.tue_closed_at AS tue_closed_at_10, t0.wed_open_at AS wed_open_at_11, t0.wed_closed_at AS wed_closed_at_12, t0.thu_open_at AS thu_open_at_13, t0.thu_closed_at AS thu_closed_at_14, t0.fri_open_at AS fri_open_at_15, t0.fri_closed_at AS fri_closed_at_16, t0.sat_open_at AS sat_open_at_17, t0.sat_closed_at AS sat_closed_at_18, t0.sun_open_at AS sun_open_at_19, t0.sun_closed_at AS sun_closed_at_20, t0.is_enabled AS is_enabled_21, t0.is_enabled_programming AS is_enabled_programming_22, t0.is_enabled_reservation AS is_enabled_reservation_23, t0.is_active AS is_active_24, t0.delivery_capacity AS delivery_capacity_25, t0.number_delivery_men AS number_delivery_men_26, t0.codalmvent AS codalmvent_27, t0.server AS server_28, t0.server_db AS server_db_29, t0.server_user AS server_user_30, t0.server_pass AS server_pass_31, t0.costo_domicilio AS costo_domicilio_32, t0.connector_catalog_id AS connector_catalog_id_33, t0.connector_store_id AS connector_store_id_34 FROM sucursal t0
Parameters:
[] |
|
2.51 ms (8.28%) |
1 |
SELECT t0.id AS id_1, t0.estado AS estado_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5, t0.cabecera_id AS cabecera_id_6 FROM cabecera_status t0 WHERE t0.cabecera_id = ?
Parameters:
[
400065
]
|
|
0.23 ms (0.75%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.codvendedor AS codvendedor_6, t0.is_enabled AS is_enabled_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
8
]
|
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\Sucursal | 20 |
| App\Entity\ConnectorStore | 13 |
| App\Entity\Lineas | 3 |
| App\Entity\CabeceraStatus | 2 |
| App\Entity\User | 1 |
| App\Entity\ConnectorCatalog | 1 |
| App\Entity\Cabecera | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Cabecera | No errors. |
| App\Entity\Domicilios | No errors. |
| App\Entity\Sucursal | No errors. |
| App\Entity\ConnectorCatalog | No errors. |
| App\Entity\ConnectorStore | No errors. |
| App\Entity\Lineas | No errors. |
| App\Entity\CabeceraStatus | No errors. |
| App\Entity\CabeceraLinkdepago | No errors. |
| App\Entity\CodigoImpuesto |
|