GET https://resa.escal-hatoup.klerthis.net/horaires/croisiere-rade-de-lorient

Query Metrics

7 Database Queries
7 Different statements
9.31 ms Query time
0 Invalid entities
12 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.02 ms
(32.38%)
1
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 INNER JOIN service_service ON t0.id = service_service.service_target WHERE service_service.service_source = ?
Parameters:
[
  3
]
2.55 ms
(27.40%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.tour_id = ? ORDER BY t0.time ASC
Parameters:
[
  9
]
1.46 ms
(15.62%)
1
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 = ? AND t0.slug = ? LIMIT 1
Parameters:
[
  1
  1
  "croisiere-rade-de-lorient"
]
0.62 ms
(6.66%)
1
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:
[]
0.58 ms
(6.24%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.description AS description_8, t0.photofile AS photofile_9, t0.mapfile AS mapfile_10, t0.status AS status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.position AS position_14 FROM pier t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.58 ms
(6.18%)
1
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
]
0.51 ms
(5.51%)
1
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
]

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 5
App\Entity\Step 2
App\Entity\Service 1
App\Entity\Company 1
App\Entity\Tour 1
App\Entity\Boat 1
App\Entity\Pier 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\Company 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\Pier No errors.