Symfony Profiler

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

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 = 1 AND t0.ispublic = 1 AND t0.slug = 'traversee-vers-l-ile-de-groix' 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.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.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 = ?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 = 1 ORDER BY t0.time ASC;

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

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 = 2 ORDER BY t0.time ASC;

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

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 = 3 ORDER BY t0.time ASC;

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

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 = 4 ORDER BY t0.time ASC;

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