GET https://www.otoline.fr/rent/home

Query Metrics

25 Database Queries
4 Different statements
2.48 ms Query time
1 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.total AS total_4, t0.with_drive_features AS with_drive_features_5, t0.with_lesson_features AS with_lesson_features_6, t0.price_id AS price_id_7, t0.plans_prices AS plans_prices_8, t0.content AS content_9, t0.is_personalized AS is_personalized_10, t0.type_id AS type_id_11 FROM forfait t0 WHERE t0.type_id = ? ORDER BY t0.total ASC
Parameters:
[
  2
]
2 0.13 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "NAME"
]
3 0.15 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "FAVICON"
]
4 0.08 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "FAVICON"
]
5 0.08 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "FAVICON"
]
6 0.08 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "COLOR"
]
7 0.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "COLOR_2"
]
8 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "COLOR_3"
]
9 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "COLOR_4"
]
10 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "COLOR_5"
]
11 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "COLOR"
]
12 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "COLOR_3"
]
13 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "COLOR_5"
]
14 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "LOGO_S"
]
15 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "NAME"
]
16 0.08 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.options AS options_4, t0.code AS code_5 FROM type_forfait t0 WHERE t0.id = ?
Parameters:
[
  2
]
17 0.18 ms
SELECT p0_.id AS id_0, p0_.min AS min_1, p0_.max AS max_2, p0_.amount AS amount_3, p0_.type AS type_4 FROM price_threshold p0_ WHERE (p0_.type = ? AND p0_.min IS NULL AND p0_.max IS NOT NULL AND ? <= p0_.max) OR (p0_.type = ? AND p0_.min IS NOT NULL AND p0_.max IS NULL AND ? >= p0_.min) OR (p0_.type = ? AND p0_.min IS NOT NULL AND p0_.max IS NOT NULL AND ? BETWEEN p0_.min AND p0_.max)
Parameters:
[
  "rentManual"
  10.0
  "rentManual"
  10.0
  "rentManual"
  10.0
]
18 0.13 ms
SELECT p0_.id AS id_0, p0_.min AS min_1, p0_.max AS max_2, p0_.amount AS amount_3, p0_.type AS type_4 FROM price_threshold p0_ WHERE (p0_.type = ? AND p0_.min IS NULL AND p0_.max IS NOT NULL AND ? <= p0_.max) OR (p0_.type = ? AND p0_.min IS NOT NULL AND p0_.max IS NULL AND ? >= p0_.min) OR (p0_.type = ? AND p0_.min IS NOT NULL AND p0_.max IS NOT NULL AND ? BETWEEN p0_.min AND p0_.max)
Parameters:
[
  "rentManual"
  21.0
  "rentManual"
  21.0
  "rentManual"
  21.0
]
19 0.11 ms
SELECT p0_.id AS id_0, p0_.min AS min_1, p0_.max AS max_2, p0_.amount AS amount_3, p0_.type AS type_4 FROM price_threshold p0_ WHERE (p0_.type = ? AND p0_.min IS NULL AND p0_.max IS NOT NULL AND ? <= p0_.max) OR (p0_.type = ? AND p0_.min IS NOT NULL AND p0_.max IS NULL AND ? >= p0_.min) OR (p0_.type = ? AND p0_.min IS NOT NULL AND p0_.max IS NOT NULL AND ? BETWEEN p0_.min AND p0_.max)
Parameters:
[
  "rentAuto"
  10.0
  "rentAuto"
  10.0
  "rentAuto"
  10.0
]
20 0.12 ms
SELECT p0_.id AS id_0, p0_.min AS min_1, p0_.max AS max_2, p0_.amount AS amount_3, p0_.type AS type_4 FROM price_threshold p0_ WHERE (p0_.type = ? AND p0_.min IS NULL AND p0_.max IS NOT NULL AND ? <= p0_.max) OR (p0_.type = ? AND p0_.min IS NOT NULL AND p0_.max IS NULL AND ? >= p0_.min) OR (p0_.type = ? AND p0_.min IS NOT NULL AND p0_.max IS NOT NULL AND ? BETWEEN p0_.min AND p0_.max)
Parameters:
[
  "rentAuto"
  21.0
  "rentAuto"
  21.0
  "rentAuto"
  21.0
]
21 0.08 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "LOGO_S"
]
22 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "ADR"
]
23 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "CP"
]
24 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "PHONE"
]
25 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.value AS value_4, t0.type AS type_5 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "EMAIL"
]

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\Parametre 12
App\Entity\PriceThreshold 3
App\Entity\Forfait 2
App\Entity\TypeForfait 1

Entities Mapping

Class Mapping errors
App\Entity\Forfait No errors.
App\Entity\TypeForfait No errors.
App\Entity\PaymentPlan No errors.
App\Entity\Account
  • The field 'App\Entity\Account#lessonsState' uses a non-existent type 'array'.
App\Entity\Parametre No errors.
App\Entity\PriceThreshold No errors.