GET https://bo.preprod.twoo-way.com/api/homes?page=1

Response
200 OK
IP
45.80.32.49
Profiled on
Token
2bd90b

Query Metrics

70 Database Queries
6 Different statements
18.46 ms Query time
1 Invalid entities
631 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.06 ms 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.07 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.05 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.05 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.05 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.05 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.05 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.05 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.06 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.04 ms 
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
Parameters: 
[
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.07 ms 
SELECT count(DISTINCT h0_.id) AS sclr_0 FROM home h0_ LEFT JOIN user u1_ ON h0_.user_id = u1_.id LEFT JOIN preferred_destination p2_ ON u1_.id = p2_.user_id LEFT JOIN period p3_ ON h0_.id = p3_.home_id LEFT JOIN user_image u4_ ON u1_.avatar_id = u4_.id LEFT JOIN text_content t5_ ON u4_.alt_id = t5_.id LEFT JOIN home_feature h7_ ON h0_.id = h7_.home_id LEFT JOIN feature f6_ ON f6_.id = h7_.feature_id LEFT JOIN text_content t8_ ON h0_.title_id = t8_.id LEFT JOIN text_content t9_ ON h0_.description_id = t9_.id LEFT JOIN text_content t10_ ON h0_.neighborhood_description_id = t10_.id LEFT JOIN text_content t11_ ON h0_.rules_id = t11_.id LEFT JOIN home_image h12_ ON h0_.id = h12_.home_id LEFT JOIN text_content t13_ ON h12_.alt_id = t13_.id WHERE h0_.id IN (SELECT h14_.id FROM home h14_ LEFT JOIN user u15_ ON h14_.user_id = u15_.id LEFT JOIN preferred_destination p16_ ON u15_.id = p16_.user_id LEFT JOIN period p17_ ON h14_.id = p17_.home_id WHERE h14_.is_enabled = 1)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.06 ms 
SELECT DISTINCT h0_.id AS id_0, h0_.id AS id_1 FROM home h0_ LEFT JOIN user u1_ ON h0_.user_id = u1_.id LEFT JOIN preferred_destination p2_ ON u1_.id = p2_.user_id LEFT JOIN period p3_ ON h0_.id = p3_.home_id LEFT JOIN user_image u4_ ON u1_.avatar_id = u4_.id LEFT JOIN text_content t5_ ON u4_.alt_id = t5_.id LEFT JOIN home_feature h7_ ON h0_.id = h7_.home_id LEFT JOIN feature f6_ ON f6_.id = h7_.feature_id LEFT JOIN text_content t8_ ON h0_.title_id = t8_.id LEFT JOIN text_content t9_ ON h0_.description_id = t9_.id LEFT JOIN text_content t10_ ON h0_.neighborhood_description_id = t10_.id LEFT JOIN text_content t11_ ON h0_.rules_id = t11_.id LEFT JOIN home_image h12_ ON h0_.id = h12_.home_id LEFT JOIN text_content t13_ ON h12_.alt_id = t13_.id WHERE h0_.id IN (SELECT h14_.id FROM home h14_ LEFT JOIN user u15_ ON h14_.user_id = u15_.id LEFT JOIN preferred_destination p16_ ON u15_.id = p16_.user_id LEFT JOIN period p17_ ON h14_.id = p17_.home_id WHERE h14_.is_enabled = 1) ORDER BY h0_.id ASC LIMIT 30
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
26 15.16 ms 
SELECT h0_.id AS id_0, h0_.created_at AS created_at_1, h0_.updated_at AS updated_at_2, h0_.area AS area_3, h0_.bedrooms AS bedrooms_4, h0_.bathrooms AS bathrooms_5, h0_.double_beds AS double_beds_6, h0_.single_beds AS single_beds_7, h0_.child_beds AS child_beds_8, h0_.baby_beds AS baby_beds_9, h0_.is_draft AS is_draft_10, h0_.form_step AS form_step_11, h0_.draft_token AS draft_token_12, h0_.is_enabled AS is_enabled_13, h0_.points_by_night AS points_by_night_14, h0_.min_recommended_nights AS min_recommended_nights_15, h0_.last_inactivity_reminder_at AS last_inactivity_reminder_at_16, h0_.address_street AS address_street_17, h0_.address_city AS address_city_18, h0_.address_zip AS address_zip_19, h0_.address_region AS address_region_20, h0_.address_country AS address_country_21, h0_.address_full_address AS address_full_address_22, h0_.address_latitude AS address_latitude_23, h0_.address_longitude AS address_longitude_24, h0_.address_public_latitude AS address_public_latitude_25, h0_.address_public_longitude AS address_public_longitude_26, h0_.address_place_id AS address_place_id_27, u1_.id AS id_28, u1_.first_name AS first_name_29, u1_.last_name AS last_name_30, u1_.email AS email_31, u1_.phone AS phone_32, u1_.description AS description_33, u1_.username AS username_34, u1_.roles AS roles_35, u1_.password AS password_36, u1_.created_at AS created_at_37, u1_.updated_at AS updated_at_38, u1_.reset_token AS reset_token_39, u1_.registration_token AS registration_token_40, u1_.first_home_token AS first_home_token_41, u1_.locale AS locale_42, u1_.is_founder AS is_founder_43, u1_.pre_reg_at AS pre_reg_at_44, u1_.first_reminder_pre_reg_at AS first_reminder_pre_reg_at_45, u1_.second_reminder_pre_reg_at AS second_reminder_pre_reg_at_46, u1_.registration_completed_at AS registration_completed_at_47, u1_.first_home_at AS first_home_at_48, u1_.first_reminder_home_at AS first_reminder_home_at_49, u1_.second_reminder_home_at AS second_reminder_home_at_50, u1_.first_home_completed_at AS first_home_completed_at_51, u1_.pre_reg_status AS pre_reg_status_52, u1_.first_home_status AS first_home_status_53, u1_.referral_code AS referral_code_54, p2_.id AS id_55, p2_.start_at AS start_at_56, p2_.end_at AS end_at_57, p2_.type AS type_58, u3_.id AS id_59, u3_.file_name AS file_name_60, u3_.dimensions AS dimensions_61, u3_.updated_at AS updated_at_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, f5_.id AS id_67, f5_.points AS points_68, f5_.is_enabled AS is_enabled_69, f5_.position AS position_70, t6_.id AS id_71, t6_.entity_class AS entity_class_72, t6_.entity_id AS entity_id_73, t6_.field_name AS field_name_74, t7_.id AS id_75, t7_.entity_class AS entity_class_76, t7_.entity_id AS entity_id_77, t7_.field_name AS field_name_78, t8_.id AS id_79, t8_.entity_class AS entity_class_80, t8_.entity_id AS entity_id_81, t8_.field_name AS field_name_82, t9_.id AS id_83, t9_.entity_class AS entity_class_84, t9_.entity_id AS entity_id_85, t9_.field_name AS field_name_86, h10_.id AS id_87, h10_.file_name AS file_name_88, h10_.dimensions AS dimensions_89, h10_.updated_at AS updated_at_90, h10_.position AS position_91, t11_.id AS id_92, t11_.entity_class AS entity_class_93, t11_.entity_id AS entity_id_94, t11_.field_name AS field_name_95, h0_.user_id AS user_id_96, h0_.title_id AS title_id_97, h0_.description_id AS description_id_98, h0_.neighborhood_description_id AS neighborhood_description_id_99, h0_.rules_id AS rules_id_100, u1_.avatar_id AS avatar_id_101, u1_.round_id AS round_id_102, u1_.sponsor_id AS sponsor_id_103, p2_.home_id AS home_id_104, u3_.alt_id AS alt_id_105, f5_.type_id AS type_id_106, f5_.title_id AS title_id_107, f5_.subtitle_id AS subtitle_id_108, f5_.description_id AS description_id_109, f5_.icon_id AS icon_id_110, h10_.alt_id AS alt_id_111, h10_.home_id AS home_id_112 FROM home h0_ LEFT JOIN user u1_ ON h0_.user_id = u1_.id LEFT JOIN preferred_destination p12_ ON u1_.id = p12_.user_id LEFT JOIN period p2_ ON h0_.id = p2_.home_id LEFT JOIN user_image u3_ ON u1_.avatar_id = u3_.id LEFT JOIN text_content t4_ ON u3_.alt_id = t4_.id LEFT JOIN home_feature h13_ ON h0_.id = h13_.home_id LEFT JOIN feature f5_ ON f5_.id = h13_.feature_id LEFT JOIN text_content t6_ ON h0_.title_id = t6_.id LEFT JOIN text_content t7_ ON h0_.description_id = t7_.id LEFT JOIN text_content t8_ ON h0_.neighborhood_description_id = t8_.id LEFT JOIN text_content t9_ ON h0_.rules_id = t9_.id LEFT JOIN home_image h10_ ON h0_.id = h10_.home_id LEFT JOIN text_content t11_ ON h10_.alt_id = t11_.id WHERE h0_.id IN (SELECT h14_.id FROM home h14_ LEFT JOIN user u15_ ON h14_.user_id = u15_.id LEFT JOIN preferred_destination p16_ ON u15_.id = p16_.user_id LEFT JOIN period p17_ ON h14_.id = p17_.home_id WHERE h14_.is_enabled = 1) AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.id ASC, h10_.position ASC
Parameters: 
[
  11
  26
  34
  42
  60
  62
  69
  72
  80
  81
  83
  87
  92
  93
  94
  95
  96
  97
  98
  100
  101
  102
  103
  104
  105
  106
  107
  108
  109
  110
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.15 ms 
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 = ?
Parameters: 
[
  2047
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.09 ms 
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 = ?
Parameters: 
[
  2048
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.05 ms 
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 = ?
Parameters: 
[
  2049
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.05 ms 
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 = ?
Parameters: 
[
  2050
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.06 ms 
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 = ?
Parameters: 
[
  2051
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.05 ms 
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 = ?
Parameters: 
[
  2052
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.04 ms 
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 = ?
Parameters: 
[
  2053
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.04 ms 
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 = ?
Parameters: 
[
  2054
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.05 ms 
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 = ?
Parameters: 
[
  2059
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.05 ms 
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 = ?
Parameters: 
[
  2060
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.04 ms 
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 = ?
Parameters: 
[
  2061
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.04 ms 
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 = ?
Parameters: 
[
  2062
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.05 ms 
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 = ?
Parameters: 
[
  2202
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.04 ms 
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 = ?
Parameters: 
[
  2203
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.04 ms 
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 = ?
Parameters: 
[
  2204
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.04 ms 
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 = ?
Parameters: 
[
  2205
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.06 ms 
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 = ?
Parameters: 
[
  2266
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.04 ms 
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 = ?
Parameters: 
[
  2267
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.04 ms 
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 = ?
Parameters: 
[
  2268
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.04 ms 
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 = ?
Parameters: 
[
  2269
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.06 ms 
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 = ?
Parameters: 
[
  2282
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.04 ms 
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 = ?
Parameters: 
[
  2283
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.04 ms 
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 = ?
Parameters: 
[
  2284
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.04 ms 
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 = ?
Parameters: 
[
  2285
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.05 ms 
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 = ?
Parameters: 
[
  2308
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.04 ms 
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 = ?
Parameters: 
[
  2309
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.04 ms 
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 = ?
Parameters: 
[
  2310
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.04 ms 
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 = ?
Parameters: 
[
  2311
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.05 ms 
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 = ?
Parameters: 
[
  2316
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.04 ms 
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 = ?
Parameters: 
[
  2317
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.04 ms 
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 = ?
Parameters: 
[
  2318
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.04 ms 
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 = ?
Parameters: 
[
  2319
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.05 ms 
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 = ?
Parameters: 
[
  2325
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.04 ms 
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 = ?
Parameters: 
[
  2326
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.04 ms 
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 = ?
Parameters: 
[
  2327
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.05 ms 
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 = ?
Parameters: 
[
  2331
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.04 ms 
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 = ?
Parameters: 
[
  2332
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.04 ms 
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 = ?
Parameters: 
[
  2333
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.05 ms 
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 = ?
Parameters: 
[
  2566
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.04 ms 
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 = ?
Parameters: 
[
  2567
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.04 ms 
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 = ?
Parameters: 
[
  2568
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.05 ms 
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 = ?
Parameters: 
[
  2578
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.04 ms 
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 = ?
Parameters: 
[
  2579
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.04 ms 
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 = ?
Parameters: 
[
  2580
]
View formatted query    View runnable query    Explain query    View query backtrace

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\TextContent 257
App\Entity\Uploadable\HomeImage 72
App\Entity\Feature 71
App\Entity\Uploadable\FeatureIcon 70
App\Entity\Translation 44
App\Entity\Period 38
App\Entity\Home 30
App\Entity\FeatureType 22
App\Entity\User 21
App\Entity\Round 2
App\Entity\Uploadable\UserImage 2
App\Entity\Language 1
App\Entity\Uploadable\LanguageImage 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\Address No errors.
App\Entity\Home 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\Feature No errors.
App\Entity\Uploadable\HomeImage No errors.
App\Entity\Period No errors.
App\Entity\PreferredDestination No errors.
App\Entity\TextContent No errors.
App\Entity\Round No errors.
App\Entity\FeatureType No errors.
App\Entity\Uploadable\FeatureIcon No errors.
App\Entity\UserFavoriteHome No errors.
App\Entity\Stay No errors.
App\Entity\PointMovement No errors.
App\Entity\Traveler No errors.
App\Entity\UserConversation No errors.
App\Entity\Label No errors.
App\Entity\Translation No errors.