https://solibikes.com/

Query Metrics

21 Database Queries
5 Different statements
6.03 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.button AS button_5, t0.link AS link_6, t0.type AS type_7 FROM banner t0 WHERE t0.type = ?
Parameters:
[
  "site"
]
2 0.51 ms
SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.description AS description_2, b0_.statut AS statut_3, b0_.principal_image AS principal_image_4, b0_.multiple_image AS multiple_image_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.agency_id AS agency_id_8, b0_.category_id AS category_id_9, b0_.kind_id AS kind_id_10, b0_.size_id AS size_id_11, b0_.brand_id AS brand_id_12 FROM bike b0_ GROUP BY b0_.brand_id
Parameters:
[]
3 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  4
]
4 0.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  6
]
5 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  7
]
6 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  8
]
7 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  9
]
8 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  10
]
9 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  11
]
10 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  12
]
11 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  13
]
12 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  14
]
13 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  15
]
14 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  16
]
15 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  17
]
16 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  18
]
17 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  19
]
18 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  20
]
19 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  21
]
20 0.53 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.difficulty AS difficulty_5, t0.distance AS distance_6, t0.duration AS duration_7, t0.price_with_bike AS price_with_bike_8, t0.price_without_bike AS price_without_bike_9, t0.banner AS banner_10, t0.image AS image_11, t0.images AS images_12, t0.map AS map_13, t0.alias AS alias_14, t0.statut AS statut_15 FROM circuit t0 WHERE t0.statut = ?
Parameters:
[
  1
]
21 0.47 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\Banner No errors.
App\Entity\Bike
  • The mappings App\Entity\Bike#kind and App\Entity\Kind#bikes are inconsistent with each other.
App\Entity\User No errors.
App\Entity\Agency No errors.
App\Entity\Category No errors.
App\Entity\Kind
  • The association App\Entity\Kind#bikes refers to the owning side field App\Entity\Bike#Type which does not exist.
App\Entity\Size No errors.
App\Entity\Brand No errors.
App\Entity\History No errors.
App\Entity\OrderParticipantBike No errors.
App\Entity\Order
  • The mappings App\Entity\Order#agency and App\Entity\Agency#orders are inconsistent with each other.
App\Entity\Accessory No errors.
App\Entity\Event No errors.
App\Entity\Participant No errors.
App\Entity\Circuit No errors.
App\Entity\CircuitSite No errors.
App\Entity\OrderCircuit No errors.
App\Entity\Period No errors.
App\Entity\Discount No errors.
App\Entity\Dealer No errors.
App\Entity\CategoryAccessory No errors.
App\Entity\Customer No errors.
App\Entity\Site No errors.
App\Entity\SiteCategory No errors.