Query Metrics
52
Database Queries
5
Different statements
55.31 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
45.73 ms (82.69%) |
15 |
SELECT e0_.id AS id_0, e0_.descripcion AS descripcion_1, e0_.kunde AS kunde_2, e0_.servicios AS servicios_3, e0_.total AS total_4, e0_.start AS start_5, e0_.payment AS payment_6, e0_.cash AS cash_7, e0_.card AS card_8, e0_.gift_card AS gift_card_9, e1_.nombre AS nombre_10 FROM eventos e0_ INNER JOIN estilistas e1_ ON (e1_.id = e0_.estilistas_id) WHERE e0_.start BETWEEN ? AND ? AND e0_.estilistas_id = ?
Parameters:
[ "2024-03-01 00:00:00" "2024-03-14 23:59:59" 1 ] |
5.42 ms (9.81%) |
15 |
SELECT s0_.id AS id_0, s0_.numero_fac AS numero_fac_1, s0_.productos_id AS productos_id_2, s0_.total AS total_3, s0_.payment_method AS payment_method_4, s0_.date AS date_5 FROM sold_products s0_ WHERE s0_.date BETWEEN ? AND ? AND s0_.estilistas_id = ? ORDER BY s0_.date DESC
Parameters:
[ "2024-03-01 00:00:00" "2024-03-14 23:59:59" 1 ] |
3.33 ms (6.03%) |
20 |
SELECT t0.id AS id_1, t0.codigo_producto AS codigo_producto_2, t0.marca AS marca_3, t0.nombre AS nombre_4, t0.cantidad AS cantidad_5, t0.precio_costo AS precio_costo_6, t0.precio_vp AS precio_vp_7, t0.company_id AS company_id_8 FROM productos t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"134"
]
|
0.44 ms (0.80%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apellidos AS apellidos_6, t0.identificacion AS identificacion_7, t0.telefono AS telefono_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.work_days AS work_days_11, t0.time_table AS time_table_12, t0.porcent AS porcent_13, t0.salary AS salary_14, t0.salary_hour AS salary_hour_15, t0.foto_perfil AS foto_perfil_16, t0.enabled AS enabled_17, t0.admin_pass AS admin_pass_18, t0.code AS code_19, t0.checked AS checked_20, t0.showed AS showed_21, t0.product_percent AS product_percent_22, t0.notify AS notify_23, t0.company_id AS company_id_24 FROM estilistas t0 WHERE t0.company_id = ?
Parameters:
[
1
]
|
0.38 ms (0.68%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.nif AS nif_6, t0.abono AS abono_7, t0.status AS status_8, t0.address AS address_9, t0.phone AS phone_10, t0.web_side AS web_side_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.deleted_at AS deleted_at_14, t0.max AS max_15 FROM company t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Company |
|
App\Entity\Estilistas | No errors. |
App\Entity\Preferencias | No errors. |
App\Entity\Productos | No errors. |
App\Entity\Clientes | No errors. |
App\Entity\Servicios | No errors. |
App\Entity\WaitingList | No errors. |
App\Entity\GiftCard | No errors. |
App\Entity\CheckTime | No errors. |
App\Entity\Eventos | No errors. |
App\Entity\SoldProducts | No errors. |