https://lamisa.simoft.com/listcomidamesas Return to referer URL

Query Metrics

15 Database Queries
7 Different statements
6.22 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.33 ms
(37.55%)
8
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 = ?
Parameters:
[
  117
]
1.13 ms
(18.24%)
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 = ? LIMIT 1
Parameters:
[
  5
]
0.95 ms
(15.27%)
2
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 = ?
Parameters:
[
  "baja3"
]
0.57 ms
(9.11%)
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
Parameters:
[
  "baja3"
]
0.55 ms
(8.91%)
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
Parameters:
[]
0.38 ms
(6.08%)
1
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 = ?
Parameters:
[
  "baja3"
  0
]
0.30 ms
(4.84%)
1
SELECT SUM(por_pagar) AS total_porpagar, zonas_id FROM mesas WHERE zonas_id = 1
Parameters:
[]

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
FOS\UserBundle\Model\User No errors.
App\Entity\User No errors.
App\Entity\Mesas No errors.
App\Entity\Zonas No errors.
App\Entity\Ventas No errors.
App\Entity\Pedidos
  • The association App\Entity\Pedidos#tickets refers to the owning side field App\Entity\Tickets#pedido which does not exist.
App\Entity\Tickets No errors.
App\Entity\Statscomida No errors.
App\Entity\Statscomensales No errors.
App\Entity\Comida No errors.
App\Entity\Productostienda No errors.
App\Entity\TipoComida No errors.
App\Entity\Stock No errors.