Query Metrics
1
Database Queries
1
Different statements
0.61 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.61 ms (100.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surface AS surface_3, t0.nb_places AS nb_places_4, t0.max_nb_places_with_baby AS max_nb_places_with_baby_5, t0.nb_confortable_places AS nb_confortable_places_6, t0.nb_double_bed AS nb_double_bed_7, t0.nb_simple_bed AS nb_simple_bed_8, t0.nb_sofa_bed AS nb_sofa_bed_9, t0.nb_rooms AS nb_rooms_10, t0.sanitary AS sanitary_11, t0.independent_sanitary AS independent_sanitary_12, t0.shower AS shower_13, t0.bathrooms AS bathrooms_14, t0.energetic_performance_diag_ce AS energetic_performance_diag_ce_15, t0.energetic_performance_diag_ges AS energetic_performance_diag_ges_16, t0.surface_under1_m80_height AS surface_under1_m80_height_17, t0.points AS points_18, t0.classification_registration_number AS classification_registration_number_19, t0.classification_registration_date AS classification_registration_date_20, t0.external_gateway_id AS external_gateway_id_21, t0.created_at AS created_at_22, t0.deleted_at AS deleted_at_23, t0.is_on_operational_tour_website AS is_on_operational_tour_website_24, t0.internet_incoming_flow AS internet_incoming_flow_25, t0.internet_outcoming_flow AS internet_outcoming_flow_26, t0.internet_gsm_infos AS internet_gsm_infos_27, t0.translations_local_source AS translations_local_source_28, t0.optimisation_page_consulting_date AS optimisation_page_consulting_date_29, t0.is_hosting_primary_house AS is_hosting_primary_house_30, t0.is_hosting_secondary_house AS is_hosting_secondary_house_31, t0.is_city_hall_declared AS is_city_hall_declared_32, t0.sunday_hosting_preference AS sunday_hosting_preference_33, t0.is_city_hall_simple_declaration AS is_city_hall_simple_declaration_34, t0.is_owner AS is_owner_35, t0.city_hall_declaration_number AS city_hall_declaration_number_36, t0.city_hall_declaration_date AS city_hall_declaration_date_37, t0.city_hall_declaration_date_signature AS city_hall_declaration_date_signature_38, t0.latitude AS latitude_39, t0.longitude AS longitude_40, t0.address AS address_41, t0.zip AS zip_42, t0.city AS city_43, t0.optional_address_info AS optional_address_info_44, t0.is_address_valid AS is_address_valid_45, t0.nb_pieces AS nb_pieces_46, t0.reference AS reference_47, t0.alur_target_charge_value AS alur_target_charge_value_48, t0.alur_corpo_value AS alur_corpo_value_49, t0.is_on_personal_website_welcome_page AS is_on_personal_website_welcome_page_50, t0.insurance_link_fr AS insurance_link_fr_51, t0.insurance_link_en AS insurance_link_en_52, t0.is_on_website_to AS is_on_website_to_53, t0.charges AS charges_54, t0.only_for_sale AS only_for_sale_55, t0.sunday_for_rent AS sunday_for_rent_56, t0.saturday_for_rent AS saturday_for_rent_57, t0.has_short_stay AS has_short_stay_58, t0.end_date AS end_date_59, t0.website_url AS website_url_60, t0.video_code AS video_code_61, t0.hosting_type_id AS hosting_type_id_62, t0.distance_from_station_km_id AS distance_from_station_km_id_63, t0.distance_from_ski_lift_id AS distance_from_ski_lift_id_64, t0.tag_id AS tag_id_65, t0.hosting_class_id AS hosting_class_id_66, t0.spot_id AS spot_id_67, t0.sale_id AS sale_id_68, t0.rental_id AS rental_id_69, t0.floor_id AS floor_id_70, t0.lessor_id AS lessor_id_71, t0.country_id AS country_id_72, t0.geo_ville_id AS geo_ville_id_73, t0.distance_from_station_km2_id AS distance_from_station_km2_id_74, t0.distance_from_ski_lift2_id AS distance_from_ski_lift2_id_75, t0.main_station_id AS main_station_id_76, t0.secondary_station_id AS secondary_station_id_77 FROM hosting t0 WHERE t0.id = ?
Parameters:
[
4394
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Hosting | No errors. |
| App\Entity\HostingType | No errors. |
| App\Entity\HostingDistance | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\HostingClass | No errors. |
| App\Entity\Spot | No errors. |
| App\Entity\Sale | No errors. |
| App\Entity\Rental | No errors. |
| App\Entity\Floor | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Lessor | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\GeoVille | No errors. |
| App\Entity\Station | No errors. |