GET https://bo.preprod.twoo-way.com/admin/modeles-mail/6/previsualisation

Query Metrics

53 Database Queries
16 Different statements
2.93 ms Query time
2 Invalid entities
37 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
]
2 0.11 ms
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.id = ?
Parameters:
[
  2
]
3 0.09 ms
SELECT t0.id AS id_1, t0.keyname AS keyname_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.subject_id AS subject_id_6, t0.title_id AS title_id_7, t0.content_id AS content_id_8, t0.signature_id AS signature_id_9 FROM template_mail t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
4 0.10 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"
]
5 0.08 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"
]
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"
]
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"
]
8 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"
]
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"
]
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"
]
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"
]
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"
]
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"
]
14 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"
]
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"
]
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"
]
17 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"
]
18 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"
]
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"
]
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"
]
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"
]
22 0.24 ms
SELECT t0.id AS id_1, t0.slots AS slots_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.position AS position_5, t0.rewards_id AS rewards_id_6, t0.card_footer_id AS card_footer_id_7, t0.landing_template_id AS landing_template_id_8, t0.image_id AS image_id_9 FROM round t0 WHERE t0.position = ? LIMIT 1
Parameters:
[
  2
]
23 0.08 ms
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.enabled AS enabled_3, p0_.publication_start_date AS publication_start_date_4, p0_.publication_end_date AS publication_end_date_5, p0_.is_nav_back_button_enabled AS is_nav_back_button_enabled_6, p0_.title_id AS title_id_7, p0_.slug_id AS slug_id_8, p0_.template_id AS template_id_9, p0_.internal_template_id AS internal_template_id_10, p0_.article_template_id AS article_template_id_11, p0_.list_articles_template_id AS list_articles_template_id_12, p0_.switch_home_template_id AS switch_home_template_id_13, p0_.switch_home_location_template_id AS switch_home_location_template_id_14, p0_.seo_id AS seo_id_15, p0_.contact_template_id AS contact_template_id_16, p0_.sitemap_template_id AS sitemap_template_id_17, p0_.landing_template_id AS landing_template_id_18, p0_.nav_back_button_title_id AS nav_back_button_title_id_19, p0_.nav_back_button_page_id AS nav_back_button_page_id_20, p0_.parent_id AS parent_id_21 FROM page p0_ WHERE p0_.list_articles_template_id IS NOT NULL AND p0_.enabled = ?
Parameters:
[
  1
]
24 0.08 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.publication_start_date AS publication_start_date_5, t0.publication_end_date AS publication_end_date_6, t0.is_nav_back_button_enabled AS is_nav_back_button_enabled_7, t0.title_id AS title_id_8, t0.slug_id AS slug_id_9, t0.template_id AS template_id_10, t0.internal_template_id AS internal_template_id_11, t0.article_template_id AS article_template_id_12, t0.list_articles_template_id AS list_articles_template_id_13, t0.switch_home_template_id AS switch_home_template_id_14, t0.switch_home_location_template_id AS switch_home_location_template_id_15, t0.seo_id AS seo_id_16, t0.contact_template_id AS contact_template_id_17, t0.sitemap_template_id AS sitemap_template_id_18, t0.landing_template_id AS landing_template_id_19, t0.nav_back_button_title_id AS nav_back_button_title_id_20, t0.nav_back_button_page_id AS nav_back_button_page_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.enabled AS enabled_26, t22.publication_start_date AS publication_start_date_27, t22.publication_end_date AS publication_end_date_28, t22.is_nav_back_button_enabled AS is_nav_back_button_enabled_29, t22.title_id AS title_id_30, t22.slug_id AS slug_id_31, t22.template_id AS template_id_32, t22.internal_template_id AS internal_template_id_33, t22.article_template_id AS article_template_id_34, t22.list_articles_template_id AS list_articles_template_id_35, t22.switch_home_template_id AS switch_home_template_id_36, t22.switch_home_location_template_id AS switch_home_location_template_id_37, t22.seo_id AS seo_id_38, t22.contact_template_id AS contact_template_id_39, t22.sitemap_template_id AS sitemap_template_id_40, t22.landing_template_id AS landing_template_id_41, t22.nav_back_button_title_id AS nav_back_button_title_id_42, t22.nav_back_button_page_id AS nav_back_button_page_id_43, t22.parent_id AS parent_id_44, t0.parent_id AS parent_id_45 FROM page t0 LEFT JOIN page t22 ON t0.nav_back_button_page_id = t22.id WHERE t0.parent_id IN (?)
Parameters:
[
  1
]
25 0.05 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keyname AS keyname_3 FROM template t0 WHERE t0.id = ?
Parameters:
[
  3
]
26 0.05 ms
SELECT n0_.id AS id_0, n0_.redirection_type AS redirection_type_1, n0_.redirection_video AS redirection_video_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.position AS position_5, n0_.format AS format_6, n0_.background_class AS background_class_7, n0_.page_id AS page_id_8, n0_.title_id AS title_id_9, n0_.redirection_link_id AS redirection_link_id_10, n0_.redirection_page_id AS redirection_page_id_11, n0_.nav_id AS nav_id_12, n0_.sub_nav_id AS sub_nav_id_13 FROM nav_link n0_ WHERE n0_.redirection_page_id = ? AND n0_.sub_nav_id IS NOT NULL
Parameters:
[
  1
]
27 0.05 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  6
]
28 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.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  1
  6
]
29 0.06 ms
SELECT u0_.id AS id_0, u0_.phone AS phone_1, u0_.city AS city_2, u0_.zip AS zip_3, u0_.address AS address_4, u0_.email AS email_5, u0_.facebook AS facebook_6, u0_.twitter AS twitter_7, u0_.instagram AS instagram_8, u0_.youtube AS youtube_9, u0_.linkedin AS linkedin_10, u0_.fax AS fax_11, u0_.logo_id AS logo_id_12, u0_.footer_title_id AS footer_title_id_13, u0_.footer_subtitle_id AS footer_subtitle_id_14 FROM useful_info u0_ ORDER BY u0_.id DESC LIMIT 1
Parameters:
[]
30 0.08 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  1150
]
31 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.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  1
  1150
]
32 0.05 ms
SELECT u0_.id AS id_0, u0_.phone AS phone_1, u0_.city AS city_2, u0_.zip AS zip_3, u0_.address AS address_4, u0_.email AS email_5, u0_.facebook AS facebook_6, u0_.twitter AS twitter_7, u0_.instagram AS instagram_8, u0_.youtube AS youtube_9, u0_.linkedin AS linkedin_10, u0_.fax AS fax_11, u0_.logo_id AS logo_id_12, u0_.footer_title_id AS footer_title_id_13, u0_.footer_subtitle_id AS footer_subtitle_id_14 FROM useful_info u0_ ORDER BY u0_.id DESC LIMIT 1
Parameters:
[]
33 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.is_main = ? LIMIT 1
Parameters:
[
  1
]
34 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"
]
35 0.05 ms
SELECT count(c0_.id) AS sclr_0 FROM contact c0_ WHERE c0_.seen = ?
Parameters:
[
  0
]
36 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
Parameters:
[]
37 0.04 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  1151
]
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.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  1
  1151
]
39 0.05 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  50
]
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.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  1
  50
]
41 0.04 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  51
]
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.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  1
  51
]
43 0.04 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  1152
]
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.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  1
  1152
]
45 0.05 ms
SELECT t0.id AS id_1, t0.background_color AS background_color_2, t0.position AS position_3, t0.url_id AS url_id_4, t0.title_id AS title_id_5, t0.template_mail_id AS template_mail_id_6 FROM template_mail_button t0 WHERE t0.template_mail_id = ?
Parameters:
[
  6
]
46 0.04 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  1190
]
47 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.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  1
  1190
]
48 0.06 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  1189
]
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.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  1
  1189
]
50 0.07 ms
SELECT t0.id AS id_1, t0.alt AS alt_2, t0.file_name AS file_name_3, t0.dimensions AS dimensions_4, t0.updated_at AS updated_at_5 FROM useful_info_logo t0 WHERE t0.id = ?
Parameters:
[
  1
]
51 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"
]
52 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"
]
53 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"
]

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 13
App\Entity\Translation 8
App\Entity\Language 2
App\Entity\Uploadable\LanguageImage 2
App\Entity\User 1
App\Entity\TemplateMail 1
App\Entity\Round 1
App\Entity\LandingTemplate 1
App\Entity\Uploadable\RoundImage 1
App\Entity\Page 1
App\Entity\Template 1
App\Entity\ListArticlesTemplate 1
App\Entity\Seo 1
App\Entity\UsefulInfo 1
App\Entity\Uploadable\UsefulInfoLogo 1
App\Entity\TemplateMailButton 1

Entities Mapping

Class Mapping errors
App\Entity\Language No errors.
App\Entity\Uploadable\LanguageImage 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\Round No errors.
App\Entity\PointMovement No errors.
App\Entity\Address No errors.
App\Entity\Home No errors.
App\Entity\PreferredDestination No errors.
App\Entity\Traveler No errors.
App\Entity\UserFavoriteHome No errors.
App\Entity\TemplateMail No errors.
App\Entity\TextContent No errors.
App\Entity\Asset No errors.
App\Entity\TemplateMailButton No errors.
App\Entity\LandingTemplate No errors.
App\Entity\Uploadable\RoundImage No errors.
App\Entity\Page No errors.
App\Entity\Template No errors.
App\Entity\InternalTemplate No errors.
App\Entity\ArticleTemplate No errors.
App\Entity\ListArticlesTemplate No errors.
App\Entity\SwitchHomeTemplate No errors.
App\Entity\SwitchHomeLocationTemplate No errors.
App\Entity\Seo No errors.
App\Entity\ContactTemplate No errors.
App\Entity\SitemapTemplate
  • The association App\Entity\SitemapTemplate#template refers to the inverse side field App\Entity\Template#sitemapTemplates which does not exist.
App\Entity\NavLink No errors.
App\Entity\Nav No errors.
App\Entity\SubNav No errors.
App\Entity\Translation No errors.
App\Entity\UsefulInfo No errors.
App\Entity\Uploadable\UsefulInfoLogo No errors.
App\Entity\Contact No errors.