Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12
FROM
  user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12 FROM user t0 WHERE t0.id = 5 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.numero = ?
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.numero = 'baja3' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.numeroticket AS numeroticket_2,
  t0.pedidos AS pedidos_3,
  t0.mesaid_id AS mesaid_id_4
FROM
  tickets t0

SELECT t0.id AS id_1, t0.numeroticket AS numeroticket_2, t0.pedidos AS pedidos_3, t0.mesaid_id AS mesaid_id_4 FROM tickets t0;

SELECT
  t0.id AS id_1,
  t0.comentarios AS comentarios_2,
  t0.marchando AS marchando_3,
  t0.extras AS extras_4,
  t0.invitacion AS invitacion_5,
  t0.descuento AS descuento_6,
  t0.descuento_eur AS descuento_eur_7,
  t0.estado AS estado_8,
  t0.num_plato AS num_plato_9,
  t0.num_ref AS num_ref_10,
  t0.entregado AS entregado_11,
  t0.mesa_id AS mesa_id_12,
  t0.comida_id AS comida_id_13,
  t0.producttienda_id AS producttienda_id_14
FROM
  pedidos t0
WHERE
  t0.mesa_id = ?

SELECT t0.id AS id_1, t0.comentarios AS comentarios_2, t0.marchando AS marchando_3, t0.extras AS extras_4, t0.invitacion AS invitacion_5, t0.descuento AS descuento_6, t0.descuento_eur AS descuento_eur_7, t0.estado AS estado_8, t0.num_plato AS num_plato_9, t0.num_ref AS num_ref_10, t0.entregado AS entregado_11, t0.mesa_id AS mesa_id_12, t0.comida_id AS comida_id_13, t0.producttienda_id AS producttienda_id_14 FROM pedidos t0 WHERE t0.mesa_id = 'baja3';

SELECT
  t0.id AS id_1,
  t0.comentarios AS comentarios_2,
  t0.marchando AS marchando_3,
  t0.extras AS extras_4,
  t0.invitacion AS invitacion_5,
  t0.descuento AS descuento_6,
  t0.descuento_eur AS descuento_eur_7,
  t0.estado AS estado_8,
  t0.num_plato AS num_plato_9,
  t0.num_ref AS num_ref_10,
  t0.entregado AS entregado_11,
  t0.mesa_id AS mesa_id_12,
  t0.comida_id AS comida_id_13,
  t0.producttienda_id AS producttienda_id_14
FROM
  pedidos t0
WHERE
  t0.mesa_id = ?

SELECT t0.id AS id_1, t0.comentarios AS comentarios_2, t0.marchando AS marchando_3, t0.extras AS extras_4, t0.invitacion AS invitacion_5, t0.descuento AS descuento_6, t0.descuento_eur AS descuento_eur_7, t0.estado AS estado_8, t0.num_plato AS num_plato_9, t0.num_ref AS num_ref_10, t0.entregado AS entregado_11, t0.mesa_id AS mesa_id_12, t0.comida_id AS comida_id_13, t0.producttienda_id AS producttienda_id_14 FROM pedidos t0 WHERE t0.mesa_id = 68;

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.id = ?

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.id = 117;

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.id = ?

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.id = 129;

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.id = ?

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.id = 126;

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.id = ?

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.id = 1010;

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.id = ?

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.id = 966;

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.id = ?

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.id = 7;

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.id = ?

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.id = 11;

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.id = ?

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.id = 4;

SELECT
  t0.id AS id_1,
  t0.comentarios AS comentarios_2,
  t0.marchando AS marchando_3,
  t0.extras AS extras_4,
  t0.invitacion AS invitacion_5,
  t0.descuento AS descuento_6,
  t0.descuento_eur AS descuento_eur_7,
  t0.estado AS estado_8,
  t0.num_plato AS num_plato_9,
  t0.num_ref AS num_ref_10,
  t0.entregado AS entregado_11,
  t0.mesa_id AS mesa_id_12,
  t0.comida_id AS comida_id_13,
  t0.producttienda_id AS producttienda_id_14
FROM
  pedidos t0
WHERE
  t0.mesa_id = ?
  AND t0.marchando = ?

SELECT t0.id AS id_1, t0.comentarios AS comentarios_2, t0.marchando AS marchando_3, t0.extras AS extras_4, t0.invitacion AS invitacion_5, t0.descuento AS descuento_6, t0.descuento_eur AS descuento_eur_7, t0.estado AS estado_8, t0.num_plato AS num_plato_9, t0.num_ref AS num_ref_10, t0.entregado AS entregado_11, t0.mesa_id AS mesa_id_12, t0.comida_id AS comida_id_13, t0.producttienda_id AS producttienda_id_14 FROM pedidos t0 WHERE t0.mesa_id = 'baja3' AND t0.marchando = 0;

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;