Symfony Profiler

Query Metrics

26 Database Queries

5 Different statements

2.02 ms Query time

1 Invalid entities

261 Managed entities

Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.is_main = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.description AS description_5, u0_.username AS username_6, u0_.roles AS roles_7, u0_.password AS password_8, u0_.created_at AS created_at_9, u0_.updated_at AS updated_at_10, u0_.reset_token AS reset_token_11, u0_.registration_token AS registration_token_12, u0_.first_home_token AS first_home_token_13, u0_.locale AS locale_14, u0_.is_founder AS is_founder_15, u0_.pre_reg_at AS pre_reg_at_16, u0_.first_reminder_pre_reg_at AS first_reminder_pre_reg_at_17, u0_.second_reminder_pre_reg_at AS second_reminder_pre_reg_at_18, u0_.registration_completed_at AS registration_completed_at_19, u0_.first_home_at AS first_home_at_20, u0_.first_reminder_home_at AS first_reminder_home_at_21, u0_.second_reminder_home_at AS second_reminder_home_at_22, u0_.first_home_completed_at AS first_home_completed_at_23, u0_.pre_reg_status AS pre_reg_status_24, u0_.first_home_status AS first_home_status_25, u0_.referral_code AS referral_code_26, u1_.id AS id_27, u1_.file_name AS file_name_28, u1_.dimensions AS dimensions_29, u1_.updated_at AS updated_at_30, t2_.id AS id_31, t2_.entity_class AS entity_class_32, t2_.entity_id AS entity_id_33, t2_.field_name AS field_name_34, h3_.id AS id_35, h3_.created_at AS created_at_36, h3_.updated_at AS updated_at_37, h3_.area AS area_38, h3_.bedrooms AS bedrooms_39, h3_.bathrooms AS bathrooms_40, h3_.double_beds AS double_beds_41, h3_.single_beds AS single_beds_42, h3_.child_beds AS child_beds_43, h3_.baby_beds AS baby_beds_44, h3_.is_draft AS is_draft_45, h3_.form_step AS form_step_46, h3_.draft_token AS draft_token_47, h3_.is_enabled AS is_enabled_48, h3_.points_by_night AS points_by_night_49, h3_.min_recommended_nights AS min_recommended_nights_50, h3_.last_inactivity_reminder_at AS last_inactivity_reminder_at_51, h3_.address_street AS address_street_52, h3_.address_city AS address_city_53, h3_.address_zip AS address_zip_54, h3_.address_region AS address_region_55, h3_.address_country AS address_country_56, h3_.address_full_address AS address_full_address_57, h3_.address_latitude AS address_latitude_58, h3_.address_longitude AS address_longitude_59, h3_.address_public_latitude AS address_public_latitude_60, h3_.address_public_longitude AS address_public_longitude_61, h3_.address_place_id AS address_place_id_62, t4_.id AS id_63, t4_.entity_class AS entity_class_64, t4_.entity_id AS entity_id_65, t4_.field_name AS field_name_66, h5_.id AS id_67, h5_.file_name AS file_name_68, h5_.dimensions AS dimensions_69, h5_.updated_at AS updated_at_70, h5_.position AS position_71, t6_.id AS id_72, t6_.entity_class AS entity_class_73, t6_.entity_id AS entity_id_74, t6_.field_name AS field_name_75, p7_.id AS id_76, p7_.from_date AS from_date_77, p7_.to_date AS to_date_78, p7_.adults AS adults_79, p7_.children AS children_80, p7_.babies AS babies_81, p7_.notify_by_email AS notify_by_email_82, p7_.address_street AS address_street_83, p7_.address_city AS address_city_84, p7_.address_zip AS address_zip_85, p7_.address_region AS address_region_86, p7_.address_country AS address_country_87, p7_.address_full_address AS address_full_address_88, p7_.address_latitude AS address_latitude_89, p7_.address_longitude AS address_longitude_90, p7_.address_public_latitude AS address_public_latitude_91, p7_.address_public_longitude AS address_public_longitude_92, p7_.address_place_id AS address_place_id_93, t8_.id AS id_94, t8_.first_name AS first_name_95, t8_.age_group AS age_group_96, t8_.relationship AS relationship_97, l9_.id AS id_98, l9_.name AS name_99, l9_.code AS code_100, l9_.is_main AS is_main_101, u0_.avatar_id AS avatar_id_102, u0_.round_id AS round_id_103, u0_.sponsor_id AS sponsor_id_104, u1_.alt_id AS alt_id_105, h3_.user_id AS user_id_106, h3_.title_id AS title_id_107, h3_.description_id AS description_id_108, h3_.neighborhood_description_id AS neighborhood_description_id_109, h3_.rules_id AS rules_id_110, h5_.alt_id AS alt_id_111, h5_.home_id AS home_id_112, p7_.user_id AS user_id_113, t8_.user_id AS user_id_114, l9_.image_id AS image_id_115 FROM user u0_ LEFT JOIN user_image u1_ ON u0_.avatar_id = u1_.id LEFT JOIN text_content t2_ ON u1_.alt_id = t2_.id LEFT JOIN home h3_ ON u0_.id = h3_.user_id LEFT JOIN text_content t4_ ON h3_.title_id = t4_.id LEFT JOIN home_image h5_ ON h3_.id = h5_.home_id LEFT JOIN text_content t6_ ON h5_.alt_id = t6_.id LEFT JOIN preferred_destination p7_ ON u0_.id = p7_.user_id LEFT JOIN traveler t8_ ON u0_.id = t8_.user_id LEFT JOIN user_language u10_ ON u0_.id = u10_.user_id LEFT JOIN language l9_ ON l9_.id = u10_.language_id WHERE u0_.id = ? ORDER BY h5_.position ASC
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.description AS description_6, t0.username AS username_7, t0.roles AS roles_8, t0.password AS password_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.reset_token AS reset_token_12, t0.registration_token AS registration_token_13, t0.first_home_token AS first_home_token_14, t0.locale AS locale_15, t0.is_founder AS is_founder_16, t0.pre_reg_at AS pre_reg_at_17, t0.first_reminder_pre_reg_at AS first_reminder_pre_reg_at_18, t0.second_reminder_pre_reg_at AS second_reminder_pre_reg_at_19, t0.registration_completed_at AS registration_completed_at_20, t0.first_home_at AS first_home_at_21, t0.first_reminder_home_at AS first_reminder_home_at_22, t0.second_reminder_home_at AS second_reminder_home_at_23, t0.first_home_completed_at AS first_home_completed_at_24, t0.pre_reg_status AS pre_reg_status_25, t0.first_home_status AS first_home_status_26, t0.referral_code AS referral_code_27, t0.avatar_id AS avatar_id_28, t0.round_id AS round_id_29, t0.sponsor_id AS sponsor_id_30 FROM user t0 WHERE t0.sponsor_id = ?
SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE t0.text_content_id = ?

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
App\Entity\Uploadable\HomeImage	138
App\Entity\Home	114
App\Entity\TextContent	4
App\Entity\Language	1
App\Entity\Uploadable\LanguageImage	1
App\Entity\User	1
App\Entity\Round	1
App\Entity\Translation	1

Entities Mapping

Class	Mapping errors
App\Entity\Language	No errors.
App\Entity\Uploadable\LanguageImage	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\User	The association App\Entity\User#spokenLanguages refers to the inverse side field App\Entity\Language#users which does not exist.
App\Entity\Uploadable\UserImage	No errors.
App\Entity\Address	No errors.
App\Entity\Home	No errors.
App\Entity\Uploadable\HomeImage	No errors.
App\Entity\PreferredDestination	No errors.
App\Entity\Traveler	No errors.
App\Entity\TextContent	No errors.
App\Entity\Round	No errors.
App\Entity\PointMovement	No errors.
App\Entity\UserFavoriteHome	No errors.
App\Entity\Stay	No errors.
App\Entity\UserConversation	No errors.
App\Entity\Label	No errors.
App\Entity\Feature	No errors.
App\Entity\Period	No errors.
App\Entity\Translation	No errors.

Symfony Profiler

GET https://bo.preprod.twoo-way.com/api/users/56

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping