Query Metrics
15
Database Queries
7
Different statements
6.22 ms
Query time
1
Invalid entities
Grouped Statements
| 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 |
|
| 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. |