Query Metrics
4
Database Queries
4
Different statements
11.03 ms
Query time
5
Invalid entities
Queries
#▲ | 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 |
|
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 |
|
App\Entity\DetaxInternational | No errors. |
App\Entity\Supplement | No errors. |
App\Entity\PublicHoliday | No errors. |
App\Entity\PriceModulator | No errors. |
App\Entity\BookingItem |
|
App\Entity\Destination |
|
App\Entity\Country | No errors. |
App\Entity\VehiculeTranslation | No errors. |
App\Entity\DistanceDestination | No errors. |
App\Entity\BookingItemPropertyValue |
|
App\Entity\GroupDestination | No errors. |