Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 1
• Migrations
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT t0.name AS name_1, t0.meta_title AS meta_title_2, t0.html_content AS html_content_3, t0.phone_number_label AS phone_number_label_4, t0.pin_label AS pin_label_5, t0.phone_number_button AS phone_number_button_6, t0.sms_button AS sms_button_7, t0.enabled AS enabled_8, t0.unique_key AS unique_key_9, t0.body_background AS body_background_10, t0.head_html AS head_html_11, t0.conversion_tag AS conversion_tag_12, t0.has_shared_portal AS has_shared_portal_13, t0.host AS host_14, t0.pin_button AS pin_button_15, t0.before_button_content AS before_button_content_16, t0.after_button_content AS after_button_content_17, t0.success_content AS success_content_18, t0.css AS css_19, t0.js AS js_20, t0.use_default_browser_language AS use_default_browser_language_21, t0.exit_url AS exit_url_22, t0.unique_name AS unique_name_23, t0.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_24, t0.id AS id_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.favicon_id AS favicon_id_28, t0.default_language_id AS default_language_id_29, t0.product_id AS product_id_30, t0.header_enrichment_id AS header_enrichment_id_31, t0.default_source_id AS default_source_id_32 FROM landing_page t0 WHERE t0.enabled = ? AND t0.host = ? LIMIT 1

[
  1
  "dev-sub.phonismart.com"
]

SELECT
  t0.name AS name_1,
  t0.meta_title AS meta_title_2,
  t0.html_content AS html_content_3,
  t0.phone_number_label AS phone_number_label_4,
  t0.pin_label AS pin_label_5,
  t0.phone_number_button AS phone_number_button_6,
  t0.sms_button AS sms_button_7,
  t0.enabled AS enabled_8,
  t0.unique_key AS unique_key_9,
  t0.body_background AS body_background_10,
  t0.head_html AS head_html_11,
  t0.conversion_tag AS conversion_tag_12,
  t0.has_shared_portal AS has_shared_portal_13,
  t0.host AS host_14,
  t0.pin_button AS pin_button_15,
  t0.before_button_content AS before_button_content_16,
  t0.after_button_content AS after_button_content_17,
  t0.success_content AS success_content_18,
  t0.css AS css_19,
  t0.js AS js_20,
  t0.use_default_browser_language AS use_default_browser_language_21,
  t0.exit_url AS exit_url_22,
  t0.unique_name AS unique_name_23,
  t0.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_24,
  t0.id AS id_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.favicon_id AS favicon_id_28,
  t0.default_language_id AS default_language_id_29,
  t0.product_id AS product_id_30,
  t0.header_enrichment_id AS header_enrichment_id_31,
  t0.default_source_id AS default_source_id_32
FROM
  landing_page t0
WHERE
  t0.enabled = ?
  AND t0.host = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.meta_title AS meta_title_2, t0.html_content AS html_content_3, t0.phone_number_label AS phone_number_label_4, t0.pin_label AS pin_label_5, t0.phone_number_button AS phone_number_button_6, t0.sms_button AS sms_button_7, t0.enabled AS enabled_8, t0.unique_key AS unique_key_9, t0.body_background AS body_background_10, t0.head_html AS head_html_11, t0.conversion_tag AS conversion_tag_12, t0.has_shared_portal AS has_shared_portal_13, t0.host AS host_14, t0.pin_button AS pin_button_15, t0.before_button_content AS before_button_content_16, t0.after_button_content AS after_button_content_17, t0.success_content AS success_content_18, t0.css AS css_19, t0.js AS js_20, t0.use_default_browser_language AS use_default_browser_language_21, t0.exit_url AS exit_url_22, t0.unique_name AS unique_name_23, t0.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_24, t0.id AS id_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.favicon_id AS favicon_id_28, t0.default_language_id AS default_language_id_29, t0.product_id AS product_id_30, t0.header_enrichment_id AS header_enrichment_id_31, t0.default_source_id AS default_source_id_32 FROM landing_page t0 WHERE t0.enabled = 1 AND t0.host = 'dev-sub.phonismart.com' LIMIT 1;

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'

[
  "sub_phonismart_dev"
]

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'sub_phonismart_dev'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE';

SELECT CURRENT_DATABASE()

[]

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'

[]

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

SHOW search_path

[]

SHOW search_path

SHOW search_path;