Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  zonas t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM zonas t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.precio AS precio_4,
  t0.unitario AS unitario_5,
  t0.iscomida AS iscomida_6,
  t0.isbebida AS isbebida_7,
  t0.extra AS extra_8,
  t0.posiblesextras AS posiblesextras_9,
  t0.num_plato AS num_plato_10,
  t0.numplato AS numplato_11,
  t0.rutaimg AS rutaimg_12,
  t0.is_deleted AS is_deleted_13,
  t0.type_food_id AS type_food_id_14
FROM
  comida t0
WHERE
  t0.iscomida = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.precio AS precio_4, t0.unitario AS unitario_5, t0.iscomida AS iscomida_6, t0.isbebida AS isbebida_7, t0.extra AS extra_8, t0.posiblesextras AS posiblesextras_9, t0.num_plato AS num_plato_10, t0.numplato AS numplato_11, t0.rutaimg AS rutaimg_12, t0.is_deleted AS is_deleted_13, t0.type_food_id AS type_food_id_14 FROM comida t0 WHERE t0.iscomida = 1;

SELECT
  m1.numero
FROM
  mesas m1
WHERE
  m1.union_mesas IS NULL
  AND NOT EXISTS (
    SELECT
      1
    FROM
      mesas m2
    WHERE
      FIND_IN_SET(m1.numero, m2.union_mesas) > 0
  )

SELECT m1.numero FROM mesas m1 WHERE m1.union_mesas IS NULL AND NOT EXISTS ( SELECT 1 FROM mesas m2 WHERE FIND_IN_SET(m1.numero, m2.union_mesas) > 0 );

SELECT
  t0.id AS id_1,
  t0.dia AS dia_2,
  t0.iniciocaja AS iniciocaja_3,
  t0.finalcaja AS finalcaja_4,
  t0.totalcaja AS totalcaja_5,
  t0.descuadre AS descuadre_6,
  t0.observaciones AS observaciones_7
FROM
  cajaregistro t0
WHERE
  t0.dia = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.dia AS dia_2, t0.iniciocaja AS iniciocaja_3, t0.finalcaja AS finalcaja_4, t0.totalcaja AS totalcaja_5, t0.descuadre AS descuadre_6, t0.observaciones AS observaciones_7 FROM cajaregistro t0 WHERE t0.dia = '2026-03-20 00:00:00' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.pagado AS pagado_3,
  t0.por_pagar AS por_pagar_4,
  t0.union_mesas AS union_mesas_5,
  t0.localizacion AS localizacion_6,
  t0.comensales AS comensales_7,
  t0.factura AS factura_8,
  t0.coord_x AS coord_x_9,
  t0.coord_y AS coord_y_10,
  t0.icon AS icon_11,
  t0.zonas_id AS zonas_id_12
FROM
  mesas t0

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.pagado AS pagado_3, t0.por_pagar AS por_pagar_4, t0.union_mesas AS union_mesas_5, t0.localizacion AS localizacion_6, t0.comensales AS comensales_7, t0.factura AS factura_8, t0.coord_x AS coord_x_9, t0.coord_y AS coord_y_10, t0.icon AS icon_11, t0.zonas_id AS zonas_id_12 FROM mesas t0;

SELECT
  m0_.numero AS numero_0,
  m0_.union_mesas AS union_mesas_1
FROM
  mesas m0_
WHERE
  m0_.union_mesas IS NOT NULL

SELECT m0_.numero AS numero_0, m0_.union_mesas AS union_mesas_1 FROM mesas m0_ WHERE m0_.union_mesas IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.pagado AS pagado_3,
  t0.por_pagar AS por_pagar_4,
  t0.union_mesas AS union_mesas_5,
  t0.localizacion AS localizacion_6,
  t0.comensales AS comensales_7,
  t0.factura AS factura_8,
  t0.coord_x AS coord_x_9,
  t0.coord_y AS coord_y_10,
  t0.icon AS icon_11,
  t0.zonas_id AS zonas_id_12
FROM
  mesas t0
WHERE
  t0.zonas_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.pagado AS pagado_3, t0.por_pagar AS por_pagar_4, t0.union_mesas AS union_mesas_5, t0.localizacion AS localizacion_6, t0.comensales AS comensales_7, t0.factura AS factura_8, t0.coord_x AS coord_x_9, t0.coord_y AS coord_y_10, t0.icon AS icon_11, t0.zonas_id AS zonas_id_12 FROM mesas t0 WHERE t0.zonas_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.active AS active_4,
  t0.ruta_img AS ruta_img_5
FROM
  tipo_comida t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.active AS active_4, t0.ruta_img AS ruta_img_5 FROM tipo_comida t0 WHERE t0.active = 1;

SELECT
  numero,
  comensales,
  factura,
  coord_x,
  coord_y,
  icon
FROM
  `mesas`
WHERE
  localizacion = 'C'

SELECT numero, comensales, factura, coord_x, coord_y, icon   FROM `mesas` WHERE localizacion = 'C';

SELECT
  m.numero,
  m.union_mesas
FROM
  mesas m
WHERE
  m.union_mesas IS NOT NULL
  AND m.zonas_id = ?

SELECT m.numero, m.union_mesas FROM mesas m WHERE m.union_mesas IS NOT NULL AND m.zonas_id = 1;

SELECT
  numero,
  comensales
FROM
  mesas
WHERE
  comensales != 0

SELECT numero, comensales FROM mesas WHERE comensales != 0;

SELECT
  COUNT(numero) AS TotalMesas
FROM
  `mesas`
WHERE
  localizacion = 'C'

SELECT COUNT(numero) AS TotalMesas FROM `mesas` WHERE localizacion = 'C';

SELECT
  SUM(por_pagar) AS total_porpagar,
  zonas_id
FROM
  mesas
WHERE
  zonas_id = 2

SELECT SUM(por_pagar) AS total_porpagar, zonas_id FROM mesas WHERE zonas_id = 2;

SELECT
  numero,
  comensales,
  factura
FROM
  `mesas`
WHERE
  localizacion = 'T'

SELECT numero, comensales, factura  FROM `mesas` WHERE localizacion = 'T';

SELECT
  SUM(por_pagar) AS total_porpagar,
  zonas_id
FROM
  mesas
WHERE
  zonas_id = 1

SELECT SUM(por_pagar) AS total_porpagar, zonas_id FROM mesas WHERE zonas_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  zonas t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM zonas t0;