GET https://comandas.algarabiarestaurante.com/api/table/1/d10a34148092eb53e68b714330851d5a40383089d9527b8d/state

Query Metrics

5 Database Queries
5 Different statements
3.58 ms Query time
0 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
0.98 ms
(27.30%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.submitted_at AS submitted_at_4, t0.confirmed_at AS confirmed_at_5, t0.entered_in_dual_link AS entered_in_dual_link_6, t0.entered_in_dual_link_at AS entered_in_dual_link_at_7, t0.table_session_id AS table_session_id_8 FROM customer_order t0 WHERE t0.table_session_id = ? AND t0.status = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
  "DRAFT"
]
0.96 ms
(26.93%)
1
SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.created_at AS created_at_2, t0_.confirmed_at AS confirmed_at_3, t0_.closed_at AS closed_at_4, t0_.dining_table_id AS dining_table_id_5 FROM table_session t0_ WHERE t0_.dining_table_id = ? AND t0_.status IN (?, ?) ORDER BY t0_.id DESC LIMIT 1
Parameters:
[
  1
  "PENDING"
  "OPEN"
]
0.59 ms
(16.61%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.qr_token AS qr_token_3, t0.enabled AS enabled_4, t0.sort_order AS sort_order_5, t0.merged_into_id AS merged_into_id_6 FROM dining_table t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.57 ms
(15.88%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.submitted_at AS submitted_at_4, t0.confirmed_at AS confirmed_at_5, t0.entered_in_dual_link AS entered_in_dual_link_6, t0.entered_in_dual_link_at AS entered_in_dual_link_at_7, t0.table_session_id AS table_session_id_8 FROM customer_order t0 WHERE t0.table_session_id = ? ORDER BY t0.id DESC
Parameters:
[
  1
]
0.47 ms
(13.27%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.qr_token AS qr_token_3, t0.enabled AS enabled_4, t0.sort_order AS sort_order_5, t0.merged_into_id AS merged_into_id_6 FROM dining_table t0 WHERE t0.merged_into_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Order 3
App\Entity\DiningTable 2
App\Entity\TableSession 1

Entities Mapping

Class Mapping errors
App\Entity\DiningTable No errors.
App\Entity\TableSession No errors.
App\Entity\Order No errors.
App\Entity\OrderItem No errors.