Symfony Profiler

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 = ?

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 = 62;

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 = ?

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 = 1;

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 = ?

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 = 3;

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 = ?

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 = 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

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;

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

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 = '20260204-001' AND t0.customer_id = 3 LIMIT 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.id = ?

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 = 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.id = ?

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 = 6;

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 = ?

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 = 5;

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 = ?

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 = 3;

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 = ?

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 = 1;

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 = ?

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 = 1;

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 = ?

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 = 1;