Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.27 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.68 ms	SELECT t0.name AS name_1, t0.people_name AS people_name_2, t0.iso AS iso_3, t0.code AS code_4, t0.need_iban AS need_iban_5, t0.need_ifsc_code AS need_ifsc_code_6, t0.need_routing_code AS need_routing_code_7, t0.need_aba_number AS need_aba_number_8, t0.mobile_number_prefix AS mobile_number_prefix_9, t0.iso3 AS iso3_10, t0.unique_name AS unique_name_11, t0.id AS id_12 FROM country t0 WHERE t0.iso = ? LIMIT 1 Parameters: [`"GB"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.people_name AS people_name_2, t0.iso AS iso_3, t0.code AS code_4, t0.need_iban AS need_iban_5, t0.need_ifsc_code AS need_ifsc_code_6, t0.need_routing_code AS need_routing_code_7, t0.need_aba_number AS need_aba_number_8, t0.mobile_number_prefix AS mobile_number_prefix_9, t0.iso3 AS iso3_10, t0.unique_name AS unique_name_11, t0.id AS id_12 FROM country t0 WHERE t0.iso = ? LIMIT 1 SELECT t0.name AS name_1, t0.people_name AS people_name_2, t0.iso AS iso_3, t0.code AS code_4, t0.need_iban AS need_iban_5, t0.need_ifsc_code AS need_ifsc_code_6, t0.need_routing_code AS need_routing_code_7, t0.need_aba_number AS need_aba_number_8, t0.mobile_number_prefix AS mobile_number_prefix_9, t0.iso3 AS iso3_10, t0.unique_name AS unique_name_11, t0.id AS id_12 FROM country t0 WHERE t0.iso = 'GB' LIMIT 1;
2	2.20 ms	SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ INNER JOIN product p1_ ON l0_.product_id = p1_.id INNER JOIN product_payment_connector p3_ ON p1_.id = p3_.product_id INNER JOIN payment_connector p2_ ON p2_.id = p3_.payment_connector_id WHERE p2_.country_id = ? AND l0_.enabled = true AND l0_.host = ? Parameters: [`225 "dev-app.fonigames.com"`] View formatted query View runnable query Explain query SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ INNER JOIN product p1_ ON l0_.product_id = p1_.id INNER JOIN product_payment_connector p3_ ON p1_.id = p3_.product_id INNER JOIN payment_connector p2_ ON p2_.id = p3_.payment_connector_id WHERE p2_.country_id = ? AND l0_.enabled = true AND l0_.host = ? SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ INNER JOIN product p1_ ON l0_.product_id = p1_.id INNER JOIN product_payment_connector p3_ ON p1_.id = p3_.product_id INNER JOIN payment_connector p2_ ON p2_.id = p3_.payment_connector_id WHERE p2_.country_id = 225 AND l0_.enabled = true AND l0_.host = 'dev-app.fonigames.com';
3	0.39 ms	SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ WHERE l0_.enabled = true AND l0_.host = ? Parameters: [`"dev-app.fonigames.com"`] View formatted query View runnable query Explain query SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ WHERE l0_.enabled = true AND l0_.host = ? SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ WHERE l0_.enabled = true AND l0_.host = 'dev-app.fonigames.com';

#▲

Time

Info

1.68 ms

SELECT t0.name AS name_1, t0.people_name AS people_name_2, t0.iso AS iso_3, t0.code AS code_4, t0.need_iban AS need_iban_5, t0.need_ifsc_code AS need_ifsc_code_6, t0.need_routing_code AS need_routing_code_7, t0.need_aba_number AS need_aba_number_8, t0.mobile_number_prefix AS mobile_number_prefix_9, t0.iso3 AS iso3_10, t0.unique_name AS unique_name_11, t0.id AS id_12 FROM country t0 WHERE t0.iso = ? LIMIT 1

Parameters:

[
  "GB"
]

View formatted query View runnable query Explain query

SELECT
  t0.name AS name_1,
  t0.people_name AS people_name_2,
  t0.iso AS iso_3,
  t0.code AS code_4,
  t0.need_iban AS need_iban_5,
  t0.need_ifsc_code AS need_ifsc_code_6,
  t0.need_routing_code AS need_routing_code_7,
  t0.need_aba_number AS need_aba_number_8,
  t0.mobile_number_prefix AS mobile_number_prefix_9,
  t0.iso3 AS iso3_10,
  t0.unique_name AS unique_name_11,
  t0.id AS id_12
FROM
  country t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.people_name AS people_name_2, t0.iso AS iso_3, t0.code AS code_4, t0.need_iban AS need_iban_5, t0.need_ifsc_code AS need_ifsc_code_6, t0.need_routing_code AS need_routing_code_7, t0.need_aba_number AS need_aba_number_8, t0.mobile_number_prefix AS mobile_number_prefix_9, t0.iso3 AS iso3_10, t0.unique_name AS unique_name_11, t0.id AS id_12 FROM country t0 WHERE t0.iso = 'GB' LIMIT 1;

2.20 ms

SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ INNER JOIN product p1_ ON l0_.product_id = p1_.id INNER JOIN product_payment_connector p3_ ON p1_.id = p3_.product_id INNER JOIN payment_connector p2_ ON p2_.id = p3_.payment_connector_id WHERE p2_.country_id = ? AND l0_.enabled = true AND l0_.host = ?

Parameters:

[
  225
  "dev-app.fonigames.com"
]

View formatted query View runnable query Explain query

SELECT
  l0_.name AS name_0,
  l0_.meta_title AS meta_title_1,
  l0_.html_content AS html_content_2,
  l0_.phone_number_label AS phone_number_label_3,
  l0_.pin_label AS pin_label_4,
  l0_.phone_number_button AS phone_number_button_5,
  l0_.sms_button AS sms_button_6,
  l0_.enabled AS enabled_7,
  l0_.unique_key AS unique_key_8,
  l0_.body_background AS body_background_9,
  l0_.head_html AS head_html_10,
  l0_.conversion_tag AS conversion_tag_11,
  l0_.has_shared_portal AS has_shared_portal_12,
  l0_.host AS host_13,
  l0_.pin_button AS pin_button_14,
  l0_.before_button_content AS before_button_content_15,
  l0_.after_button_content AS after_button_content_16,
  l0_.success_content AS success_content_17,
  l0_.css AS css_18,
  l0_.js AS js_19,
  l0_.use_default_browser_language AS use_default_browser_language_20,
  l0_.exit_url AS exit_url_21,
  l0_.unique_name AS unique_name_22,
  l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23,
  l0_.default_value AS default_value_24,
  l0_.google_sheet_id AS google_sheet_id_25,
  l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26,
  l0_.exit_url_type AS exit_url_type_27,
  l0_.has_cookies_consent AS has_cookies_consent_28,
  l0_.has_live_check_phone_number AS has_live_check_phone_number_29,
  l0_.google_conversion_action_id AS google_conversion_action_id_30,
  l0_.google_account_id AS google_account_id_31,
  l0_.id AS id_32,
  l0_.created_at AS created_at_33,
  l0_.updated_at AS updated_at_34,
  l0_.favicon_id AS favicon_id_35,
  l0_.default_language_id AS default_language_id_36,
  l0_.product_id AS product_id_37,
  l0_.header_enrichment_id AS header_enrichment_id_38,
  l0_.default_source_id AS default_source_id_39,
  l0_.exit_landing_page_id AS exit_landing_page_id_40
FROM
  landing_page l0_
  INNER JOIN product p1_ ON l0_.product_id = p1_.id
  INNER JOIN product_payment_connector p3_ ON p1_.id = p3_.product_id
  INNER JOIN payment_connector p2_ ON p2_.id = p3_.payment_connector_id
WHERE
  p2_.country_id = ?
  AND l0_.enabled = true
  AND l0_.host = ?

SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ INNER JOIN product p1_ ON l0_.product_id = p1_.id INNER JOIN product_payment_connector p3_ ON p1_.id = p3_.product_id INNER JOIN payment_connector p2_ ON p2_.id = p3_.payment_connector_id WHERE p2_.country_id = 225 AND l0_.enabled = true AND l0_.host = 'dev-app.fonigames.com';

0.39 ms

SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ WHERE l0_.enabled = true AND l0_.host = ?

Parameters:

[
  "dev-app.fonigames.com"
]

View formatted query View runnable query Explain query

SELECT
  l0_.name AS name_0,
  l0_.meta_title AS meta_title_1,
  l0_.html_content AS html_content_2,
  l0_.phone_number_label AS phone_number_label_3,
  l0_.pin_label AS pin_label_4,
  l0_.phone_number_button AS phone_number_button_5,
  l0_.sms_button AS sms_button_6,
  l0_.enabled AS enabled_7,
  l0_.unique_key AS unique_key_8,
  l0_.body_background AS body_background_9,
  l0_.head_html AS head_html_10,
  l0_.conversion_tag AS conversion_tag_11,
  l0_.has_shared_portal AS has_shared_portal_12,
  l0_.host AS host_13,
  l0_.pin_button AS pin_button_14,
  l0_.before_button_content AS before_button_content_15,
  l0_.after_button_content AS after_button_content_16,
  l0_.success_content AS success_content_17,
  l0_.css AS css_18,
  l0_.js AS js_19,
  l0_.use_default_browser_language AS use_default_browser_language_20,
  l0_.exit_url AS exit_url_21,
  l0_.unique_name AS unique_name_22,
  l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23,
  l0_.default_value AS default_value_24,
  l0_.google_sheet_id AS google_sheet_id_25,
  l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26,
  l0_.exit_url_type AS exit_url_type_27,
  l0_.has_cookies_consent AS has_cookies_consent_28,
  l0_.has_live_check_phone_number AS has_live_check_phone_number_29,
  l0_.google_conversion_action_id AS google_conversion_action_id_30,
  l0_.google_account_id AS google_account_id_31,
  l0_.id AS id_32,
  l0_.created_at AS created_at_33,
  l0_.updated_at AS updated_at_34,
  l0_.favicon_id AS favicon_id_35,
  l0_.default_language_id AS default_language_id_36,
  l0_.product_id AS product_id_37,
  l0_.header_enrichment_id AS header_enrichment_id_38,
  l0_.default_source_id AS default_source_id_39,
  l0_.exit_landing_page_id AS exit_landing_page_id_40
FROM
  landing_page l0_
WHERE
  l0_.enabled = true
  AND l0_.host = ?

SELECT l0_.name AS name_0, l0_.meta_title AS meta_title_1, l0_.html_content AS html_content_2, l0_.phone_number_label AS phone_number_label_3, l0_.pin_label AS pin_label_4, l0_.phone_number_button AS phone_number_button_5, l0_.sms_button AS sms_button_6, l0_.enabled AS enabled_7, l0_.unique_key AS unique_key_8, l0_.body_background AS body_background_9, l0_.head_html AS head_html_10, l0_.conversion_tag AS conversion_tag_11, l0_.has_shared_portal AS has_shared_portal_12, l0_.host AS host_13, l0_.pin_button AS pin_button_14, l0_.before_button_content AS before_button_content_15, l0_.after_button_content AS after_button_content_16, l0_.success_content AS success_content_17, l0_.css AS css_18, l0_.js AS js_19, l0_.use_default_browser_language AS use_default_browser_language_20, l0_.exit_url AS exit_url_21, l0_.unique_name AS unique_name_22, l0_.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_23, l0_.default_value AS default_value_24, l0_.google_sheet_id AS google_sheet_id_25, l0_.google_sheet_conversion_name AS google_sheet_conversion_name_26, l0_.exit_url_type AS exit_url_type_27, l0_.has_cookies_consent AS has_cookies_consent_28, l0_.has_live_check_phone_number AS has_live_check_phone_number_29, l0_.google_conversion_action_id AS google_conversion_action_id_30, l0_.google_account_id AS google_account_id_31, l0_.id AS id_32, l0_.created_at AS created_at_33, l0_.updated_at AS updated_at_34, l0_.favicon_id AS favicon_id_35, l0_.default_language_id AS default_language_id_36, l0_.product_id AS product_id_37, l0_.header_enrichment_id AS header_enrichment_id_38, l0_.default_source_id AS default_source_id_39, l0_.exit_landing_page_id AS exit_landing_page_id_40 FROM landing_page l0_ WHERE l0_.enabled = true AND l0_.host = 'dev-app.fonigames.com';

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\Country	No errors.
App\Entity\MccMnc	No errors.
App\Entity\Carrier	No errors.
App\Entity\PaymentConnector	No errors.
App\Entity\LandingPage	The field App\Entity\LandingPage#statsInputs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\StatsInput#landingPage does not contain the required 'inversedBy="statsInputs"' attribute. The field App\Entity\LandingPage#statsDatas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\StatsData#landingPage does not contain the required 'inversedBy="statsDatas"' attribute.
App\Entity\Product	No errors.
App\Entity\Image	No errors.
App\Entity\Language	No errors.
App\Entity\HeaderEnrichment	No errors.
App\Entity\Source	No errors.

Symfony Profiler

GET http://dev-app.fonigames.com/?rest_route=%2Fwp%2Fv2%2Fusers%2F

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping