GET https://tdb.encours.me/ru/order/6/step1

Query Metrics

4 Database Queries
4 Different statements
11.03 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_enterprise_online AS name_enterprise_online_3, t0.reference_facture AS reference_facture_4, t0.url_herakles AS url_herakles_5, t0.url_corporate AS url_corporate_6, t0.enterprise_type AS enterprise_type_7, t0.file_path_conditions AS file_path_conditions_8, t0.coef AS coef_9, t0.is_shared_transport_limited AS is_shared_transport_limited_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.invoice_comment AS invoice_comment_13, t0.vat AS vat_14, t0.phone AS phone_15, t0.fax AS fax_16, t0.rcs AS rcs_17, t0.is_wo_vat AS is_wo_vat_18, t0.email AS email_19, t0.cancellation_email AS cancellation_email_20, t0.delai_paiement_facture AS delai_paiement_facture_21, t0.image_name AS image_name_22, t0.image_size AS image_size_23, t0.night_overprice AS night_overprice_24, t0.night_shift_start AS night_shift_start_25, t0.night_shift_stop AS night_shift_stop_26, t0.luggage_price AS luggage_price_27, t0.invoice_to_be_paid_within_days AS invoice_to_be_paid_within_days_28, t0.vat_number AS vat_number_29, t0.invoice_type AS invoice_type_30, t0.language_invoice AS language_invoice_31, t0.whatsapp AS whatsapp_32, t0.email_envoi AS email_envoi_33, t0.iban AS iban_34, t0.bic_swift AS bic_swift_35, t0.contract_name AS contract_name_36, t0.couffin_rate AS couffin_rate_37, t0.couffin_tva AS couffin_tva_38, t0.baby_seat_rate AS baby_seat_rate_39, t0.baby_seat_tva AS baby_seat_tva_40, t0.booster_seat_rate AS booster_seat_rate_41, t0.booster_seat_tva AS booster_seat_tva_42, t0.creation_date AS creation_date_43, t0.update_date AS update_date_44, t0.is_deleted AS is_deleted_45, t0.delete_date AS delete_date_46, t0.bank_id AS bank_id_47, t0.location_id AS location_id_48, t0.created_by_id AS created_by_id_49, t0.updated_by_id AS updated_by_id_50, t0.deleted_by_id AS deleted_by_id_51 FROM enterprise t0 WHERE t0.id = ? AND ((t0.is_deleted = false or t0.is_deleted is null))
Parameters:
[
  "6"
]
2 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_enterprise_online AS name_enterprise_online_3, t0.reference_facture AS reference_facture_4, t0.url_herakles AS url_herakles_5, t0.url_corporate AS url_corporate_6, t0.enterprise_type AS enterprise_type_7, t0.file_path_conditions AS file_path_conditions_8, t0.coef AS coef_9, t0.is_shared_transport_limited AS is_shared_transport_limited_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.invoice_comment AS invoice_comment_13, t0.vat AS vat_14, t0.phone AS phone_15, t0.fax AS fax_16, t0.rcs AS rcs_17, t0.is_wo_vat AS is_wo_vat_18, t0.email AS email_19, t0.cancellation_email AS cancellation_email_20, t0.delai_paiement_facture AS delai_paiement_facture_21, t0.image_name AS image_name_22, t0.image_size AS image_size_23, t0.night_overprice AS night_overprice_24, t0.night_shift_start AS night_shift_start_25, t0.night_shift_stop AS night_shift_stop_26, t0.luggage_price AS luggage_price_27, t0.invoice_to_be_paid_within_days AS invoice_to_be_paid_within_days_28, t0.vat_number AS vat_number_29, t0.invoice_type AS invoice_type_30, t0.language_invoice AS language_invoice_31, t0.whatsapp AS whatsapp_32, t0.email_envoi AS email_envoi_33, t0.iban AS iban_34, t0.bic_swift AS bic_swift_35, t0.contract_name AS contract_name_36, t0.couffin_rate AS couffin_rate_37, t0.couffin_tva AS couffin_tva_38, t0.baby_seat_rate AS baby_seat_rate_39, t0.baby_seat_tva AS baby_seat_tva_40, t0.booster_seat_rate AS booster_seat_rate_41, t0.booster_seat_tva AS booster_seat_tva_42, t0.creation_date AS creation_date_43, t0.update_date AS update_date_44, t0.is_deleted AS is_deleted_45, t0.delete_date AS delete_date_46, t0.bank_id AS bank_id_47, t0.location_id AS location_id_48, t0.created_by_id AS created_by_id_49, t0.updated_by_id AS updated_by_id_50, t0.deleted_by_id AS deleted_by_id_51 FROM enterprise t0 WHERE t0.id = ? AND ((t0.is_deleted = false or t0.is_deleted is null)) LIMIT 1
Parameters:
[
  "6"
]
3 0.38 ms
SELECT t0.id AS id_1, t0.vehicule_option AS vehicule_option_2, t0.exemple AS exemple_3, t0.min_travellers AS min_travellers_4, t0.max_travellers AS max_travellers_5, t0.max_luggage AS max_luggage_6, t0.max_ski AS max_ski_7, t0.exonerated_vat AS exonerated_vat_8, t0.image_name AS image_name_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.name AS name_12, t0.frontend_url AS frontend_url_13, t0.creation_date AS creation_date_14, t0.update_date AS update_date_15, t0.is_deleted AS is_deleted_16, t0.delete_date AS delete_date_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.deleted_by_id AS deleted_by_id_20 FROM vehicule_societe t0 WHERE ((t0.is_deleted = false or t0.is_deleted is null))
Parameters:
[]
4 9.70 ms
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.zip_code AS zip_code_2, d0_.timezone AS timezone_3, d0_.is_main AS is_main_4, d0_.is_global AS is_global_5, d0_.is_airport AS is_airport_6, d0_.is_train_station AS is_train_station_7, d0_.type AS type_8, d0_.creation_date AS creation_date_9, d0_.update_date AS update_date_10, d0_.is_deleted AS is_deleted_11, d0_.delete_date AS delete_date_12, d0_.country_id AS country_id_13, d0_.parent_destination_id AS parent_destination_id_14, d0_.location_id AS location_id_15, d0_.created_by_id AS created_by_id_16, d0_.updated_by_id AS updated_by_id_17, d0_.deleted_by_id AS deleted_by_id_18 FROM destination d0_ WHERE (d0_.is_deleted = 0 AND d0_.parent_destination_id IS NOT NULL) AND (d0_.is_deleted = false or d0_.is_deleted is null) ORDER BY d0_.name ASC
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\Enterprise No errors.
App\Entity\Bank No errors.
App\Entity\Location No errors.
App\Entity\User No errors.
App\Entity\Booking No errors.
App\Entity\Customer No errors.
App\Entity\Agencies
  • The field App\Entity\Agencies#majoration is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Majoration#agencies does not contain the required 'inversedBy="majoration"' attribute.
  • The field App\Entity\Agencies#forfait is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Forfait#agency does not contain the required 'inversedBy="forfait"' attribute.
App\Entity\Outsource No errors.
App\Entity\GrilleTarifaire No errors.
App\Entity\Invoice No errors.
App\Entity\VehiculeSociete No errors.
App\Entity\GroupEnterprise No errors.
App\Entity\Vehicule No errors.
App\Entity\Driver
  • The association App\Entity\Driver#bookingItemOutsourceRequests refers to the owning side field App\Entity\BookingItemOutsourceRequest#driver which does not exist.
App\Entity\DetaxInternational No errors.
App\Entity\Supplement No errors.
App\Entity\PublicHoliday No errors.
App\Entity\PriceModulator No errors.
App\Entity\BookingItem
  • The mappings App\Entity\BookingItem#destinationFrom and App\Entity\Destination#bookingItemsFrom are inconsistent with each other.
App\Entity\Destination
  • The association App\Entity\Destination#bookingItemsFrom refers to the owning side field App\Entity\BookingItem#DestinationFrom which does not exist.
App\Entity\Country No errors.
App\Entity\VehiculeTranslation No errors.
App\Entity\DistanceDestination No errors.
App\Entity\BookingItemPropertyValue
  • The association App\Entity\BookingItemPropertyValue#bookingItemArrivee refers to the inverse side field App\Entity\BookingItem#bookingItemPropertyValuesArrivee which does not exist.
App\Entity\GroupDestination No errors.