Symfony Profiler

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = DATABASE()
  AND table_name = 'platform_setting'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = 'platform_setting';

SELECT
  setting_value
FROM
  platform_setting
WHERE
  name = ?
  AND app_id IS NULL
LIMIT
  1

SELECT setting_value FROM platform_setting WHERE name = 'subscription_enforcement_enabled' AND app_id IS NULL LIMIT 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = DATABASE()
  AND table_name = 'platform_setting'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = 'platform_setting';

SELECT
  setting_value
FROM
  platform_setting
WHERE
  name = ?
  AND app_id IS NULL
LIMIT
  1

SELECT setting_value FROM platform_setting WHERE name = 'hard_suspension_enabled' AND app_id IS NULL LIMIT 1;

SELECT
  v0_.surface AS surface_0,
  COUNT(v0_.id) AS sclr_1,
  SUM(
    CASE WHEN v0_.converted_login_id IS NOT NULL THEN 1 ELSE 0 END
  ) AS sclr_2
FROM
  viral_touch v0_
WHERE
  v0_.landed_at >= ?
GROUP BY
  v0_.surface
ORDER BY
  sclr_1 DESC

SELECT v0_.surface AS surface_0, COUNT(v0_.id) AS sclr_1, SUM(CASE WHEN v0_.converted_login_id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_2 FROM viral_touch v0_ WHERE v0_.landed_at >= '2026-05-26 13:29:49' GROUP BY v0_.surface ORDER BY sclr_1 DESC;

SELECT
  l0_.status AS status_0,
  COUNT(l0_.id) AS sclr_1
FROM
  leadgen_prospect l0_
WHERE
  l0_.delete_flag = 0
GROUP BY
  l0_.status

SELECT l0_.status AS status_0, COUNT(l0_.id) AS sclr_1 FROM leadgen_prospect l0_ WHERE l0_.delete_flag = 0 GROUP BY l0_.status;

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.domain AS domain_3,
  t0.website_url AS website_url_4,
  t0.contact_name AS contact_name_5,
  t0.contact_email AS contact_email_6,
  t0.country AS country_7,
  t0.jurisdiction AS jurisdiction_8,
  t0.source_type AS source_type_9,
  t0.source_ref AS source_ref_10,
  t0.dedupe_key AS dedupe_key_11,
  t0.status AS status_12,
  t0.existing_lead_id AS existing_lead_id_13,
  t0.lawful_basis AS lawful_basis_14,
  t0.lawful_basis_note AS lawful_basis_note_15,
  t0.enrichment_json AS enrichment_json_16,
  t0.sector AS sector_17,
  t0.size_signal AS size_signal_18,
  t0.energy_signal AS energy_signal_19,
  t0.enriched_at AS enriched_at_20,
  t0.fit_score AS fit_score_21,
  t0.fit_angle AS fit_angle_22,
  t0.motion AS motion_23,
  t0.created_login_id AS created_login_id_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.delete_flag AS delete_flag_27
FROM
  leadgen_prospect t0
WHERE
  t0.delete_flag = ?
  AND t0.status = ?
ORDER BY
  t0.id DESC
LIMIT
  200

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.domain AS domain_3, t0.website_url AS website_url_4, t0.contact_name AS contact_name_5, t0.contact_email AS contact_email_6, t0.country AS country_7, t0.jurisdiction AS jurisdiction_8, t0.source_type AS source_type_9, t0.source_ref AS source_ref_10, t0.dedupe_key AS dedupe_key_11, t0.status AS status_12, t0.existing_lead_id AS existing_lead_id_13, t0.lawful_basis AS lawful_basis_14, t0.lawful_basis_note AS lawful_basis_note_15, t0.enrichment_json AS enrichment_json_16, t0.sector AS sector_17, t0.size_signal AS size_signal_18, t0.energy_signal AS energy_signal_19, t0.enriched_at AS enriched_at_20, t0.fit_score AS fit_score_21, t0.fit_angle AS fit_angle_22, t0.motion AS motion_23, t0.created_login_id AS created_login_id_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.delete_flag AS delete_flag_27 FROM leadgen_prospect t0 WHERE t0.delete_flag = 0 AND t0.status = 'new' ORDER BY t0.id DESC LIMIT 200;

SELECT
  t0.id AS id_1,
  t0.value_type AS value_type_2,
  t0.value AS value_3,
  t0.reason AS reason_4,
  t0.source_prospect_id AS source_prospect_id_5,
  t0.note AS note_6,
  t0.created_at AS created_at_7
FROM
  leadgen_suppression t0
ORDER BY
  t0.id DESC
LIMIT
  50

SELECT t0.id AS id_1, t0.value_type AS value_type_2, t0.value AS value_3, t0.reason AS reason_4, t0.source_prospect_id AS source_prospect_id_5, t0.note AS note_6, t0.created_at AS created_at_7 FROM leadgen_suppression t0 ORDER BY t0.id DESC LIMIT 50;

SELECT
  l0_.id AS id_0,
  l0_.prospect_id AS prospect_id_1,
  l0_.sender_address AS sender_address_2,
  l0_.recipient_email AS recipient_email_3,
  l0_.recipient_domain AS recipient_domain_4,
  l0_.subject AS subject_5,
  l0_.body_text AS body_text_6,
  l0_.body_html AS body_html_7,
  l0_.status AS status_8,
  l0_.message_id AS message_id_9,
  l0_.approved_login_id AS approved_login_id_10,
  l0_.scheduled_for AS scheduled_for_11,
  l0_.sent_at AS sent_at_12,
  l0_.bounce_type AS bounce_type_13,
  l0_.event_json AS event_json_14,
  l0_.motion AS motion_15,
  l0_.created_at AS created_at_16
FROM
  leadgen_send_log l0_
WHERE
  l0_.status IN (?, ?, ?, ?)
ORDER BY
  l0_.id DESC
LIMIT
  50

SELECT l0_.id AS id_0, l0_.prospect_id AS prospect_id_1, l0_.sender_address AS sender_address_2, l0_.recipient_email AS recipient_email_3, l0_.recipient_domain AS recipient_domain_4, l0_.subject AS subject_5, l0_.body_text AS body_text_6, l0_.body_html AS body_html_7, l0_.status AS status_8, l0_.message_id AS message_id_9, l0_.approved_login_id AS approved_login_id_10, l0_.scheduled_for AS scheduled_for_11, l0_.sent_at AS sent_at_12, l0_.bounce_type AS bounce_type_13, l0_.event_json AS event_json_14, l0_.motion AS motion_15, l0_.created_at AS created_at_16 FROM leadgen_send_log l0_ WHERE l0_.status IN ('draft', 'approved', 'sent', 'failed') ORDER BY l0_.id DESC LIMIT 50;

SELECT
  t0.module_id AS module_id_1,
  t0.module_name AS module_name_2,
  t0.module_route AS module_route_3,
  t0.parent_id AS parent_id_4,
  t0.level AS level_5,
  t0.status AS status_6,
  t0.enabled_for_all AS enabled_for_all_7,
  t0.company_id AS company_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.doc_booked_flag AS doc_booked_flag_11,
  t0.time_stamp_of_form AS time_stamp_of_form_12
FROM
  sys_module t0
WHERE
  t0.status = ?

SELECT t0.module_id AS module_id_1, t0.module_name AS module_name_2, t0.module_route AS module_route_3, t0.parent_id AS parent_id_4, t0.level AS level_5, t0.status AS status_6, t0.enabled_for_all AS enabled_for_all_7, t0.company_id AS company_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.doc_booked_flag AS doc_booked_flag_11, t0.time_stamp_of_form AS time_stamp_of_form_12 FROM sys_module t0 WHERE t0.status = 1;

SELECT
  data
FROM
  acc_setting
WHERE
  name = 'cors_extra_origins'
ORDER BY
  id DESC
LIMIT
  1

SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1;