GET https://staging.clubalpin01.fr/refuge-la-conay/tarifs

Query Metrics

10 Database Queries
4 Different statements
3.14 ms Query time
0 Invalid entities
34 Managed entities

Queries

Group similar statements

refuge connection

# Time Info
1 1.35 ms
SELECT MAX(t0_.effective_from) AS sclr_0 FROM tarif t0_ WHERE t0_.effective_from <= ?
Parameters:
[
  "2026-02-16 05:05:44"
]
2 0.31 ms
SELECT MIN(t0_.effective_from) AS sclr_0 FROM tarif t0_ WHERE t0_.effective_from > ?
Parameters:
[
  "2026-02-16 05:05:44"
]
3 0.29 ms
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[
  "2026-01-29 00:00:00"
  "PUBLIC"
]
4 0.19 ms
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[
  "2026-01-29 00:00:00"
  "FFCAM"
]
5 0.15 ms
SELECT MAX(t0_.effective_from) AS sclr_0 FROM tarif t0_ WHERE t0_.effective_from <= ?
Parameters:
[
  "2026-02-16 05:05:44"
]
6 0.18 ms
SELECT DISTINCT t0_.effective_from AS effective_from_0 FROM tarif t0_ WHERE t0_.effective_from < ? ORDER BY t0_.effective_from DESC
Parameters:
[
  "2026-01-29 00:00:00"
]
7 0.20 ms
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[
  "2025-11-29 00:00:00"
  "PUBLIC"
]
8 0.16 ms
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[
  "2025-11-29 00:00:00"
  "FFCAM"
]
9 0.16 ms
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[
  "2025-01-01 00:00:00"
  "PUBLIC"
]
10 0.16 ms
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[
  "2025-01-01 00:00:00"
  "FFCAM"
]

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
App\Refuge\Entity\Tarif 34

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Supervisor No errors.

refuge entity manager

Class Mapping errors
App\Refuge\Entity\Tarif No errors.