Query Metrics
398
Database Queries
8
Different statements
58.35 ms
Query time
0
Invalid entities
761
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
52.77 ms (90.42%) |
362 |
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.system_name AS system_name_4, t0.`desc` AS desc_5, t0.price AS price_6, t0.is_option AS is_option_7, t0.internal_notes AS internal_notes_8, t0.ean AS ean_9, t0.pos_product AS pos_product_10, t0.channels_fine_tuning AS channels_fine_tuning_11, t0.images AS images_12, t0.cod_impuesto AS cod_impuesto_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM connector_products t0 WHERE t0.id = ?
Parameters:
[
"b54a3643-7075-4dbc-9711-9a20057a52cc"
]
|
|
3.98 ms (6.81%) |
29 |
SELECT t0.id AS id_1, t0.product_order AS product_order_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.section_id AS section_id_6 FROM connector_catalog_products t0 WHERE t0.section_id = ? ORDER BY t0.product_order ASC
Parameters:
[
"11f3a0bf-3476-4559-b57d-4d2ca9edfb1a"
]
|
|
0.34 ms (0.58%) |
2 |
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.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
2489692
]
|
|
0.31 ms (0.53%) |
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:
[
330710
]
|
|
0.30 ms (0.52%) |
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:
[
330710
]
|
|
0.27 ms (0.47%) |
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 FROM sucursal t0 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
"POBLADO"
]
|
|
0.19 ms (0.33%) |
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:
[
1
]
|
|
0.19 ms (0.32%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.`desc` AS desc_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.catalog_id AS catalog_id_7 FROM connector_sections t0 WHERE t0.catalog_id = ? ORDER BY t0.position ASC
Parameters:
[
"4e8d47ec-abcc-4335-a4c7-184d11859b55"
]
|
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\ConnectorCatalogProduct | 362 |
| App\Entity\ConnectorProduct | 362 |
| App\Entity\ConnectorSection | 29 |
| App\Entity\Lineas | 3 |
| App\Entity\User | 1 |
| App\Entity\Cabecera | 1 |
| App\Entity\ConnectorStore | 1 |
| App\Entity\Sucursal | 1 |
| App\Entity\ConnectorCatalog | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Cabecera | No errors. |
| App\Entity\Domicilios | No errors. |
| App\Entity\ConnectorStore | No errors. |
| App\Entity\Lineas | No errors. |
| App\Entity\CabeceraStatus | No errors. |
| App\Entity\CabeceraLinkdepago | No errors. |
| App\Entity\Sucursal | No errors. |
| App\Entity\ConnectorCatalog | No errors. |
| App\Entity\ConnectorSection | No errors. |
| App\Entity\ConnectorCatalogProduct | No errors. |
| App\Entity\ConnectorProduct | No errors. |
| App\Entity\ConnectorProductGroup | No errors. |