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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.data AS data_3,
  t0.company_id AS company_id_4,
  t0.create_login_id AS create_login_id_5,
  t0.edit_login_id AS edit_login_id_6,
  t0.lock_flag AS lock_flag_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.doc_booked_flag AS doc_booked_flag_10,
  t0.time_stamp_of_form AS time_stamp_of_form_11
FROM
  acc_setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = 'leadgen_operator_user_ids' LIMIT 1;

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.id = ?

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.id = 643;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  leadgen_prospect
SET
  domain = ?,
  website_url = ?,
  STATUS = ?,
  enrichment_json = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE leadgen_prospect SET domain = 'recordowl.com', website_url = 'https://recordowl.com/company/levana-group-pte-ltd', STATUS = 'new', enrichment_json = '{\"source\":\"acra_open_data\",\"country\":\"Singapore\",\"acra\":{\"uen\":\"201716114R\",\"entity_type\":\"Local Company\",\"status\":\"Registered\",\"ssic_code\":\"\",\"ssic_desc\":\"\",\"reg_street_name\":\"LAVENDER STREET\",\"reg_postal_code\":\"338729\",\"issue_date\":\"2017-06-08\",\"attribution\":\"Contains information from ACRA dataset d_3f960c10fed6145404ca7b821f263b87 accessed on 2026-08-24 from data.gov.sg, made available under the terms of the Singapore Open Data Licence version 1.0.\"},\"resolution\":{\"resolved\":true,\"method\":\"manual\",\"confidence\":1,\"resolved_at\":\"2026-08-24 16:42:03\"}}', updated_at = '2026-08-24 16:42:03' WHERE id = '643';

"COMMIT"

"COMMIT";

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;