Query Metrics
1
Database Queries
1
Different statements
1.74 ms
Query time
0
Invalid entities
0
Managed entities
Queries
refuge connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.74 ms |
SELECT r0_.id AS id_0, r0_.reservationNumber AS reservationNumber_1, r0_.email AS email_2, r0_.first_name AS first_name_3, r0_.last_name AS last_name_4, r0_.fullName AS fullName_5, r0_.phone AS phone_6, r0_.totalPrice AS totalPrice_7, r0_.peopleCount AS peopleCount_8, r0_.status AS status_9, r0_.paymentStatus AS paymentStatus_10, r0_.depositPaid AS depositPaid_11, r0_.depositAmount AS depositAmount_12, r0_.depositPaidAmount AS depositPaidAmount_13, r0_.isPrivate AS isPrivate_14, r0_.startDate AS startDate_15, r0_.endDate AS endDate_16, r0_.nights AS nights_17, r0_.createdAt AS createdAt_18, r0_.cancelledAt AS cancelledAt_19, r0_.createdByAdminId AS createdByAdminId_20, r0_.moneticoAuthDeposit AS moneticoAuthDeposit_21, r0_.moneticoAuthBalance AS moneticoAuthBalance_22, r0_.address AS address_23, r0_.organizationName AS organizationName_24, r0_.chequeReference AS chequeReference_25, r0_.peopleDetails AS peopleDetails_26, r0_.ffcamCards AS ffcamCards_27, r0_.ffcamProofsPending AS ffcamProofsPending_28, r0_.ffcamMissingCount AS ffcamMissingCount_29, r0_.reminder10SentAt AS reminder10SentAt_30, r0_.reminder5SentAt AS reminder5SentAt_31 FROM reservation r0_ WHERE r0_.createdAt < ? AND r0_.status = ? AND r0_.paymentStatus = ? AND r0_.depositPaid = ? AND r0_.status NOT IN (?, ?, ?) ORDER BY r0_.createdAt ASC
Parameters:
[ "2026-02-16 11:15:08" "pending" "pending" 0 "canceled" "refused" "completed" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| refuge | doctrine.dbal.refuge_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| refuge | doctrine.orm.refuge_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
refuge entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Supervisor | No errors. |
refuge entity manager
| Class | Mapping errors |
|---|---|
| App\Refuge\Entity\Reservation | No errors. |