Query Metrics

17 Database Queries
13 Different statements
7.80 ms Query time
0 Invalid entities
30 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.51 ms
(19.42%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.img AS img_3, a0_.path AS path_4, a0_.alt AS alt_5, a0_.markup_title AS markup_title_6, a0_.button AS button_7, a0_.link AS link_8 FROM adventure a0_ ORDER BY a0_.id ASC
Parameters:
[]
0.97 ms
(12.39%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4 FROM categories t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "qui-sommes-nous"
]
0.87 ms
(11.11%)
3
SELECT t0.id AS id_1, t0.item AS item_2, t0.code AS code_3, t0.adventure_id AS adventure_id_4 FROM features t0 WHERE t0.adventure_id = ?
Parameters:
[
  1
]
0.69 ms
(8.90%)
1
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.img AS img_3, b0_.path AS path_4, b0_.alt AS alt_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.date AS date_8, b0_.slug AS slug_9, b0_.is_active AS is_active_10, b0_.markup_title AS markup_title_11, b0_.meta AS meta_12, b0_.type_id AS type_id_13, b0_.created_by_id AS created_by_id_14 FROM blog b0_ WHERE b0_.is_active = ? ORDER BY b0_.id DESC LIMIT 3
Parameters:
[
  1
]
0.65 ms
(8.35%)
2
SELECT t0.id AS id_1, t0.content AS content_2, t0.categories_id AS categories_id_3 FROM page_content t0 WHERE t0.categories_id = ? LIMIT 1
Parameters:
[
  8
]
0.52 ms
(6.66%)
1
SELECT COUNT(*) FROM renter t0
Parameters:
[]
0.50 ms
(6.37%)
1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.content AS content_2, f0_.slug AS slug_3, f0_.is_active AS is_active_4 FROM footer f0_ WHERE f0_.is_active = ? ORDER BY f0_.id ASC
Parameters:
[
  1
]
0.46 ms
(5.86%)
1
SELECT COUNT(*) FROM professionnal_owner t0
Parameters:
[]
0.37 ms
(4.71%)
1
SELECT h0_.id AS id_0, h0_.img AS img_1, h0_.path AS path_2, h0_.title AS title_3, h0_.year AS year_4, h0_.description AS description_5, h0_.position AS position_6 FROM history h0_ ORDER BY h0_.position ASC
Parameters:
[]
0.35 ms
(4.52%)
1
SELECT COUNT(*) FROM private_owner t0
Parameters:
[]
0.34 ms
(4.41%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM faq t0
Parameters:
[]
0.31 ms
(4.04%)
1
SELECT t0.id AS id_1, t0.img AS img_2, t0.path AS path_3 FROM partners t0
Parameters:
[]
0.25 ms
(3.26%)
1
SELECT COUNT(*) FROM partners t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Features 6
App\Entity\FAQ 4
App\Entity\Footer 4
App\Entity\Adventure 3
App\Entity\Blog 3
App\Entity\History 3
App\Entity\CategoriesTypes 2
App\Entity\Categories 2
App\Entity\PageContent 2
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Adventure No errors.
App\Entity\Features No errors.
App\Entity\Blog No errors.
App\Entity\CategoriesTypes No errors.
App\Entity\User No errors.
App\Entity\FAQ No errors.
App\Entity\History No errors.
App\Entity\Partners No errors.
App\Entity\Renter No errors.
App\Entity\ProfessionnalOwner No errors.
App\Entity\PrivateOwner No errors.
App\Entity\Categories No errors.
App\Entity\PageContent No errors.
App\Entity\Footer No errors.