GET https://staging.clubalpin01.fr/cron-task/refuge/cleanup-expired-reservations

Query Metrics

1 Database Queries
1 Different statements
1.20 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

refuge connection

Time Count Info
1.20 ms
(100.00%)
1
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_.quote_only AS quote_only_15, r0_.startDate AS startDate_16, r0_.endDate AS endDate_17, r0_.nights AS nights_18, r0_.createdAt AS createdAt_19, r0_.cancelledAt AS cancelledAt_20, r0_.createdByAdminId AS createdByAdminId_21, r0_.moneticoAuthDeposit AS moneticoAuthDeposit_22, r0_.moneticoAuthBalance AS moneticoAuthBalance_23, r0_.address AS address_24, r0_.organizationName AS organizationName_25, r0_.chequeReference AS chequeReference_26, r0_.peopleDetails AS peopleDetails_27, r0_.ffcamCards AS ffcamCards_28, r0_.ffcamProofsPending AS ffcamProofsPending_29, r0_.ffcamMissingCount AS ffcamMissingCount_30, r0_.reminder10SentAt AS reminder10SentAt_31, r0_.reminder5SentAt AS reminder5SentAt_32 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-04-17 17:30:09"
  "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.