GET http://resa.escal-hatoup.klerthis.net/

Query Metrics

19 Database Queries
4 Different statements
4.68 ms Query time
0 Invalid entities
175 Managed entities

Queries

Group similar statements

# Time Info
1 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.description AS description_5, t0.bannerfilename AS bannerfilename_6, t0.photofilename AS photofilename_7, t0.ispublic AS ispublic_8, t0.ispro AS ispro_9, t0.passengerinfos AS passengerinfos_10, t0.position AS position_11, t0.status AS status_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.jsonprices AS jsonprices_15 FROM service t0 WHERE t0.status = ? AND t0.ispublic = ? ORDER BY t0.position ASC
Parameters:
[
  1
  1
]
2 0.51 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.service_id = ?
Parameters:
[
  2
]
3 0.55 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.disabledseats AS disabledseats_3, t0.timeshift AS timeshift_4, t0.message AS message_5, t0.checked AS checked_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tour_id AS tour_id_10, t0.boat_id AS boat_id_11 FROM tourday t0 WHERE t0.tour_id = ?
Parameters:
[
  5
]
4 0.58 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.disabledseats AS disabledseats_3, t0.timeshift AS timeshift_4, t0.message AS message_5, t0.checked AS checked_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tour_id AS tour_id_10, t0.boat_id AS boat_id_11 FROM tourday t0 WHERE t0.tour_id = ?
Parameters:
[
  6
]
5 0.21 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.disabledseats AS disabledseats_3, t0.timeshift AS timeshift_4, t0.message AS message_5, t0.checked AS checked_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tour_id AS tour_id_10, t0.boat_id AS boat_id_11 FROM tourday t0 WHERE t0.tour_id = ?
Parameters:
[
  7
]
6 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.disabledseats AS disabledseats_3, t0.timeshift AS timeshift_4, t0.message AS message_5, t0.checked AS checked_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tour_id AS tour_id_10, t0.boat_id AS boat_id_11 FROM tourday t0 WHERE t0.tour_id = ?
Parameters:
[
  8
]
7 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.service_id = ?
Parameters:
[
  1
]
8 0.15 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.disabledseats AS disabledseats_3, t0.timeshift AS timeshift_4, t0.message AS message_5, t0.checked AS checked_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tour_id AS tour_id_10, t0.boat_id AS boat_id_11 FROM tourday t0 WHERE t0.tour_id = ?
Parameters:
[
  1
]
9 0.31 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.disabledseats AS disabledseats_3, t0.timeshift AS timeshift_4, t0.message AS message_5, t0.checked AS checked_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tour_id AS tour_id_10, t0.boat_id AS boat_id_11 FROM tourday t0 WHERE t0.tour_id = ?
Parameters:
[
  2
]
10 0.15 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.disabledseats AS disabledseats_3, t0.timeshift AS timeshift_4, t0.message AS message_5, t0.checked AS checked_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tour_id AS tour_id_10, t0.boat_id AS boat_id_11 FROM tourday t0 WHERE t0.tour_id = ?
Parameters:
[
  3
]
11 0.13 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.disabledseats AS disabledseats_3, t0.timeshift AS timeshift_4, t0.message AS message_5, t0.checked AS checked_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tour_id AS tour_id_10, t0.boat_id AS boat_id_11 FROM tourday t0 WHERE t0.tour_id = ?
Parameters:
[
  4
]
12 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.service_id = ?
Parameters:
[
  3
]
13 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.disabledseats AS disabledseats_3, t0.timeshift AS timeshift_4, t0.message AS message_5, t0.checked AS checked_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tour_id AS tour_id_10, t0.boat_id AS boat_id_11 FROM tourday t0 WHERE t0.tour_id = ?
Parameters:
[
  9
]
14 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.service_id = ?
Parameters:
[
  4
]
15 0.12 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.service_id = ?
Parameters:
[
  5
]
16 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.service_id = ?
Parameters:
[
  6
]
17 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.service_id = ?
Parameters:
[
  7
]
18 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.service_id = ?
Parameters:
[
  8
]
19 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.publicurl AS publicurl_3, t0.adminurl AS adminurl_4, t0.address AS address_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.logofilename AS logofilename_9, t0.faviconfilename AS faviconfilename_10, t0.email AS email_11, t0.updated_at AS updated_at_12, t0.siret AS siret_13, t0.naf AS naf_14, t0.vatnumber AS vatnumber_15, t0.companyname AS companyname_16, t0.rcs AS rcs_17, t0.theme AS theme_18, t0.paymentsolution AS paymentsolution_19 FROM company t0 LIMIT 1
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\Tourday 155
App\Entity\Tour 9
App\Entity\Service 8
App\Entity\Boat 2
App\Entity\Company 1

Entities Mapping

Class Mapping errors
App\Entity\Service No errors.
App\Entity\Pricecategory No errors.
App\Entity\Pricetype No errors.
App\Entity\Product No errors.
App\Entity\Tour No errors.
App\Entity\Boat No errors.
App\Entity\Step No errors.
App\Entity\Tourday No errors.
App\Entity\Option No errors.
App\Entity\Passenger No errors.
App\Entity\Company No errors.