POST https://resa.escal-hatoup.klerthis.net/mon-compte/printbooking

Query Metrics

23 Database Queries
13 Different statements
3.85 ms Query time
3 Invalid entities
31 Managed entities

Queries

Group similar statements

# Time Info
1 0.44 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone AS phone_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 0.30 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.amount AS amount_3, t0.status AS status_4, t0.notes AS notes_5, t0.expires_at AS expires_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.delivered_at AS delivered_at_9, t0.cart_id AS cart_id_10, t0.customer_id AS customer_id_11, t0.retailer_id AS retailer_id_12, t13.id AS id_14, t13.amount AS amount_15, t13.paymenttype AS paymenttype_16, t13.paymenttoken AS paymenttoken_17, t13.paymentdetails AS paymentdetails_18, t13.transactionid AS transactionid_19, t13.status AS status_20, t13.expires_at AS expires_at_21, t13.created_at AS created_at_22, t13.updated_at AS updated_at_23, t13.paid_at AS paid_at_24, t13.booking_id AS booking_id_25, t13.customer_id AS customer_id_26, t13.retailer_id AS retailer_id_27 FROM booking t0 LEFT JOIN `order` t13 ON t13.booking_id = t0.id WHERE t0.number = ? AND t0.customer_id = ? LIMIT 1
Parameters:
[
  "20260204-001"
  3
]
3 0.23 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.seat AS seat_4, t0.freeseat AS freeseat_5, t0.price AS price_6, t0.originalprice AS originalprice_7, t0.discount AS discount_8, t0.gender AS gender_9, t0.nationality AS nationality_10, t0.birthdate AS birthdate_11, t0.onboard AS onboard_12, t0.checked AS checked_13, t0.status AS status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.booking_id AS booking_id_17, t0.cart_id AS cart_id_18, t0.pricecategory_id AS pricecategory_id_19, t0.pricetype_id AS pricetype_id_20, t0.tourday_id AS tourday_id_21, t0.departurestep_id AS departurestep_id_22, t0.arrivalstep_id AS arrivalstep_id_23, t0.parent_id AS parent_id_24, t25.id AS id_26, t25.firstname AS firstname_27, t25.lastname AS lastname_28, t25.seat AS seat_29, t25.freeseat AS freeseat_30, t25.price AS price_31, t25.originalprice AS originalprice_32, t25.discount AS discount_33, t25.gender AS gender_34, t25.nationality AS nationality_35, t25.birthdate AS birthdate_36, t25.onboard AS onboard_37, t25.checked AS checked_38, t25.status AS status_39, t25.created_at AS created_at_40, t25.updated_at AS updated_at_41, t25.booking_id AS booking_id_42, t25.cart_id AS cart_id_43, t25.pricecategory_id AS pricecategory_id_44, t25.pricetype_id AS pricetype_id_45, t25.tourday_id AS tourday_id_46, t25.departurestep_id AS departurestep_id_47, t25.arrivalstep_id AS arrivalstep_id_48, t25.parent_id AS parent_id_49, t25.customer_id AS customer_id_50, t0.customer_id AS customer_id_51 FROM passenger t0 LEFT JOIN passenger t25 ON t25.parent_id = t0.id WHERE t0.booking_id = ?
Parameters:
[
  5
]
4 0.20 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.seat AS seat_4, t0.freeseat AS freeseat_5, t0.price AS price_6, t0.originalprice AS originalprice_7, t0.discount AS discount_8, t0.gender AS gender_9, t0.nationality AS nationality_10, t0.birthdate AS birthdate_11, t0.onboard AS onboard_12, t0.checked AS checked_13, t0.status AS status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.booking_id AS booking_id_17, t0.cart_id AS cart_id_18, t0.pricecategory_id AS pricecategory_id_19, t0.pricetype_id AS pricetype_id_20, t0.tourday_id AS tourday_id_21, t0.departurestep_id AS departurestep_id_22, t0.arrivalstep_id AS arrivalstep_id_23, t0.parent_id AS parent_id_24, t25.id AS id_26, t25.firstname AS firstname_27, t25.lastname AS lastname_28, t25.seat AS seat_29, t25.freeseat AS freeseat_30, t25.price AS price_31, t25.originalprice AS originalprice_32, t25.discount AS discount_33, t25.gender AS gender_34, t25.nationality AS nationality_35, t25.birthdate AS birthdate_36, t25.onboard AS onboard_37, t25.checked AS checked_38, t25.status AS status_39, t25.created_at AS created_at_40, t25.updated_at AS updated_at_41, t25.booking_id AS booking_id_42, t25.cart_id AS cart_id_43, t25.pricecategory_id AS pricecategory_id_44, t25.pricetype_id AS pricetype_id_45, t25.tourday_id AS tourday_id_46, t25.departurestep_id AS departurestep_id_47, t25.arrivalstep_id AS arrivalstep_id_48, t25.parent_id AS parent_id_49, t25.customer_id AS customer_id_50, t0.customer_id AS customer_id_51 FROM passenger t0 LEFT JOIN passenger t25 ON t25.parent_id = t0.id WHERE t0.parent_id = ?
Parameters:
[
  62
]
5 0.16 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.seat AS seat_4, t0.freeseat AS freeseat_5, t0.price AS price_6, t0.originalprice AS originalprice_7, t0.discount AS discount_8, t0.gender AS gender_9, t0.nationality AS nationality_10, t0.birthdate AS birthdate_11, t0.onboard AS onboard_12, t0.checked AS checked_13, t0.status AS status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.booking_id AS booking_id_17, t0.cart_id AS cart_id_18, t0.pricecategory_id AS pricecategory_id_19, t0.pricetype_id AS pricetype_id_20, t0.tourday_id AS tourday_id_21, t0.departurestep_id AS departurestep_id_22, t0.arrivalstep_id AS arrivalstep_id_23, t0.parent_id AS parent_id_24, t25.id AS id_26, t25.firstname AS firstname_27, t25.lastname AS lastname_28, t25.seat AS seat_29, t25.freeseat AS freeseat_30, t25.price AS price_31, t25.originalprice AS originalprice_32, t25.discount AS discount_33, t25.gender AS gender_34, t25.nationality AS nationality_35, t25.birthdate AS birthdate_36, t25.onboard AS onboard_37, t25.checked AS checked_38, t25.status AS status_39, t25.created_at AS created_at_40, t25.updated_at AS updated_at_41, t25.booking_id AS booking_id_42, t25.cart_id AS cart_id_43, t25.pricecategory_id AS pricecategory_id_44, t25.pricetype_id AS pricetype_id_45, t25.tourday_id AS tourday_id_46, t25.departurestep_id AS departurestep_id_47, t25.arrivalstep_id AS arrivalstep_id_48, t25.parent_id AS parent_id_49, t25.customer_id AS customer_id_50, t0.customer_id AS customer_id_51 FROM passenger t0 LEFT JOIN passenger t25 ON t25.parent_id = t0.id WHERE t0.parent_id = ?
Parameters:
[
  64
]
6 0.12 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.seat AS seat_4, t0.freeseat AS freeseat_5, t0.price AS price_6, t0.originalprice AS originalprice_7, t0.discount AS discount_8, t0.gender AS gender_9, t0.nationality AS nationality_10, t0.birthdate AS birthdate_11, t0.onboard AS onboard_12, t0.checked AS checked_13, t0.status AS status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.booking_id AS booking_id_17, t0.cart_id AS cart_id_18, t0.pricecategory_id AS pricecategory_id_19, t0.pricetype_id AS pricetype_id_20, t0.tourday_id AS tourday_id_21, t0.departurestep_id AS departurestep_id_22, t0.arrivalstep_id AS arrivalstep_id_23, t0.parent_id AS parent_id_24, t25.id AS id_26, t25.firstname AS firstname_27, t25.lastname AS lastname_28, t25.seat AS seat_29, t25.freeseat AS freeseat_30, t25.price AS price_31, t25.originalprice AS originalprice_32, t25.discount AS discount_33, t25.gender AS gender_34, t25.nationality AS nationality_35, t25.birthdate AS birthdate_36, t25.onboard AS onboard_37, t25.checked AS checked_38, t25.status AS status_39, t25.created_at AS created_at_40, t25.updated_at AS updated_at_41, t25.booking_id AS booking_id_42, t25.cart_id AS cart_id_43, t25.pricecategory_id AS pricecategory_id_44, t25.pricetype_id AS pricetype_id_45, t25.tourday_id AS tourday_id_46, t25.departurestep_id AS departurestep_id_47, t25.arrivalstep_id AS arrivalstep_id_48, t25.parent_id AS parent_id_49, t25.customer_id AS customer_id_50, t0.customer_id AS customer_id_51 FROM passenger t0 LEFT JOIN passenger t25 ON t25.parent_id = t0.id WHERE t0.parent_id = ?
Parameters:
[
  66
]
7 0.16 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.id = ?
Parameters:
[
  6
]
8 0.19 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.id = ?
Parameters:
[
  1
]
9 0.17 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.id = ?
Parameters:
[
  1
]
10 0.14 ms
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.id = ?
Parameters:
[
  1
]
11 0.12 ms
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
]
12 0.09 ms
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.id = ?
Parameters:
[
  3
]
13 0.09 ms
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:
[
  2
]
14 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.requirement AS requirement_5, t0.agemin AS agemin_6, t0.agemax AS agemax_7, t0.seat AS seat_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.position AS position_11, t0.status AS status_12 FROM pricecategory t0 WHERE t0.id = ?
Parameters:
[
  1
]
15 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.position AS position_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.application AS application_8, t0.jsonconditions AS jsonconditions_9 FROM pricetype t0 WHERE t0.id = ?
Parameters:
[
  1
]
16 0.09 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.id = ?
Parameters:
[
  27
]
17 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.id = ?
Parameters:
[
  7
]
18 0.12 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.id = ?
Parameters:
[
  2
]
19 0.13 ms
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.id = ?
Parameters:
[
  19
]
20 0.10 ms
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.id = ?
Parameters:
[
  21
]
21 0.12 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.requirement AS requirement_5, t0.agemin AS agemin_6, t0.agemax AS agemax_7, t0.seat AS seat_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.position AS position_11, t0.status AS status_12 FROM pricecategory t0 WHERE t0.id = ?
Parameters:
[
  4
]
22 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:
[]
23 0.23 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6 FROM userparam t0 WHERE t0.user_id = ?
Parameters:
[
  3
]

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\Passenger 6
App\Entity\Userparam 5
App\Entity\Step 4
App\Entity\Pricecategory 2
App\Entity\Tourday 2
App\Entity\Tour 2
App\Entity\Service 2
App\Entity\Pier 2
App\Entity\User 1
App\Entity\Booking 1
App\Entity\Order 1
App\Entity\Pricetype 1
App\Entity\Boat 1
App\Entity\Company 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Userparam No errors.
App\Entity\Booking
  • The mappings App\Entity\Booking#retailer and App\Entity\User#bookings are inconsistent with each other.
App\Entity\Order
  • The mappings App\Entity\Order#retailer and App\Entity\User#orders are inconsistent with each other.
App\Entity\Cart
  • The mappings App\Entity\Cart#bookings and App\Entity\Booking#cart are inconsistent with each other.
App\Entity\Passenger No errors.
App\Entity\Pricecategory No errors.
App\Entity\Pricetype No errors.
App\Entity\Tourday No errors.
App\Entity\Step No errors.
App\Entity\Tour No errors.
App\Entity\Boat No errors.
App\Entity\Service No errors.
App\Entity\Option No errors.
App\Entity\Product No errors.
App\Entity\Pier No errors.
App\Entity\Company No errors.