https://sydenstyle.com/public/balance_analitic Return to referer URL

Method
POST
HTTP Status
200
IP
2a02:9130:8c30:9070:a583:4a35:4e1:b32b
Profiled on
Token
dd5877

Query Metrics

52 Database Queries
5 Different statements
55.31 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.38 ms 
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
]
View formatted query    View runnable query    Explain query
2 0.44 ms 
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
]
View formatted query    View runnable query    Explain query
3 0.76 ms 
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
]
View formatted query    View runnable query    Explain query
4 0.25 ms 
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"
]
View formatted query    View runnable query    Explain query
5 0.21 ms 
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: 
[
  "124"
]
View formatted query    View runnable query    Explain query
6 0.18 ms 
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: 
[
  "151"
]
View formatted query    View runnable query    Explain query
7 0.13 ms 
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: 
[
  "151"
]
View formatted query    View runnable query    Explain query
8 0.12 ms 
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"
]
View formatted query    View runnable query    Explain query
9 0.14 ms 
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"
]
View formatted query    View runnable query    Explain query
10 0.13 ms 
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: 
[
  "172"
]
View formatted query    View runnable query    Explain query
11 0.12 ms 
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: 
[
  "151"
]
View formatted query    View runnable query    Explain query
12 0.11 ms 
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: 
[
  "172"
]
View formatted query    View runnable query    Explain query
13 0.11 ms 
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: 
[
  "151"
]
View formatted query    View runnable query    Explain query
14 10.43 ms 
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
]
View formatted query    View runnable query    Explain query
15 0.26 ms 
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"
  2
]
View formatted query    View runnable query    Explain query
16 1.19 ms 
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"
  2
]
View formatted query    View runnable query    Explain query
17 0.34 ms 
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"
  3
]
View formatted query    View runnable query    Explain query
18 2.98 ms 
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"
  3
]
View formatted query    View runnable query    Explain query
19 0.23 ms 
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"
  4
]
View formatted query    View runnable query    Explain query
20 3.11 ms 
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"
  4
]
View formatted query    View runnable query    Explain query
21 0.44 ms 
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"
  5
]
View formatted query    View runnable query    Explain query
22 4.23 ms 
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"
  5
]
View formatted query    View runnable query    Explain query
23 0.31 ms 
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"
  6
]
View formatted query    View runnable query    Explain query
24 0.55 ms 
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"
  6
]
View formatted query    View runnable query    Explain query
25 0.27 ms 
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"
  7
]
View formatted query    View runnable query    Explain query
26 0.32 ms 
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"
  7
]
View formatted query    View runnable query    Explain query
27 0.22 ms 
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"
  8
]
View formatted query    View runnable query    Explain query
28 3.81 ms 
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"
  8
]
View formatted query    View runnable query    Explain query
29 0.33 ms 
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"
  9
]
View formatted query    View runnable query    Explain query
30 1.75 ms 
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"
  9
]
View formatted query    View runnable query    Explain query
31 0.50 ms 
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"
  10
]
View formatted query    View runnable query    Explain query
32 0.20 ms 
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: 
[
  "143"
]
View formatted query    View runnable query    Explain query
33 0.17 ms 
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: 
[
  "146"
]
View formatted query    View runnable query    Explain query
34 0.16 ms 
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: 
[
  "172"
]
View formatted query    View runnable query    Explain query
35 8.07 ms 
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"
  10
]
View formatted query    View runnable query    Explain query
36 0.31 ms 
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"
  11
]
View formatted query    View runnable query    Explain query
37 0.36 ms 
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"
  11
]
View formatted query    View runnable query    Explain query
38 0.32 ms 
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"
  12
]
View formatted query    View runnable query    Explain query
39 0.19 ms 
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: 
[
  "154"
]
View formatted query    View runnable query    Explain query
40 0.17 ms 
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: 
[
  "140"
]
View formatted query    View runnable query    Explain query
41 0.16 ms 
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: 
[
  "29"
]
View formatted query    View runnable query    Explain query
42 0.15 ms 
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: 
[
  "172"
]
View formatted query    View runnable query    Explain query
43 2.66 ms 
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"
  12
]
View formatted query    View runnable query    Explain query
44 0.42 ms 
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"
  13
]
View formatted query    View runnable query    Explain query
45 0.23 ms 
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: 
[
  "151"
]
View formatted query    View runnable query    Explain query
46 0.21 ms 
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: 
[
  "174"
]
View formatted query    View runnable query    Explain query
47 0.20 ms 
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: 
[
  "127"
]
View formatted query    View runnable query    Explain query
48 2.33 ms 
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"
  13
]
View formatted query    View runnable query    Explain query
49 0.39 ms 
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"
  14
]
View formatted query    View runnable query    Explain query
50 3.01 ms 
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"
  14
]
View formatted query    View runnable query    Explain query
51 0.34 ms 
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"
  15
]
View formatted query    View runnable query    Explain query
52 0.93 ms 
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"
  15
]
View formatted query    View runnable query    Explain query

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
  • The field App\Entity\Company#estilistas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Estilistas#company does not contain the required 'inversedBy="estilistas"' attribute.
  • The mappings App\Entity\Company#clientes and App\Entity\Clientes#company are inconsistent with each other.
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.