| 1 |
1.46 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 = ? AND t0.slug = ? LIMIT 1
Parameters: [
1
1
"croisiere-rade-de-lorient"
]
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 = 'croisiere-rade-de-lorient' LIMIT 1;
|
| 2 |
0.62 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
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;
|
| 3 |
0.58 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 = ?
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 = 3;
|
| 4 |
0.51 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 = ?
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 = 9;
|
| 5 |
3.02 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 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 = 3;
|
| 6 |
2.55 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.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 = 9 ORDER BY t0.time ASC;
|
| 7 |
0.58 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 = ?
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;
|