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

Query Metrics

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

Grouped Statements

Show all queries

refuge connection

Time Count Info
1.31 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_.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 07:15: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.