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 = 733;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  leadgen_prospect
SET
  STATUS = ?,
  enrichment_json = ?,
  fit_score = ?,
  fit_angle = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE leadgen_prospect SET STATUS = 'matched', enrichment_json = '{\"site_found\":true,\"url\":\"https://marquistech.com\",\"pages_fetched\":1,\"issues\":[\"https://marquistech.com/impressum: http 404\",\"https://marquistech.com/imprint: http 404\"],\"company_name_detected\":\"MARQUISTECH PTE. LTD.\",\"what_they_do\":\"Provides software testing and telecom/device testing services, including 5G and IoT validation, lab testing, certification, EMI/EMC testing, cybersecurity, and related consulting/software services.\",\"sector\":\"Software testing and telecom/device certification services\",\"country\":\"Singapore\",\"company_size_signal\":\"20+ years of experience; serves 27+ OEM partners\",\"energy_signals\":[\"Energy Efficiency\",\"Electricals Lab\",\"UPS / Inverter\",\"Cells / Batteries\"],\"tech_signals\":[\"Custom Software\",\"HRMS\",\"LSMS\",\"Travel Portal\",\"Automation Test Tool\"],\"summary\":\"Marquistech is a testing and certification services company focused on telecom, 5G, IoT, and device validation across multiple platforms and labs.\",\"confidence\":0.96,\"evidence\":[\"\\\"Leader in Software Testing on different Platforms\\\"\",\"\\\"provides telecom testing, 5G and IoT validation, GCF and PTCRB testing, EMI/EMC testing, cybersecurity, and device certification services worldwide\\\"\",\"\\\"We focus on streamlining market strategies for terminal devices for over 27 OEMs/ODMs\\\"\"],\"llm_used\":true,\"evidence_dropped\":0,\"evidence_verified\":true,\"fit\":{\"score\":70,\"angle\":\"energy_bridge_sg\",\"angle_label\":\"Energy⇄Business bridge + SG compliance\",\"hook\":\"your solar/energy operations and your accounting live in different systems — HoneyBee turns site telemetry into invoices and O&M tickets, with SG GST/IRAS compliance built in\",\"reasons\":[\"energy signals on their site (Energy Efficiency, Electricals Lab, UPS / Inverter) +40\",\"sector \\\"Software testing and telecom/device certification services\\\" +2\",\"jurisdiction SG +15\",\"site read (confidence 0.96) +8\",\"company size signal present +5\",\"no contact email — matchable, but a contact is needed before it can send\",\"angle: Energy⇄Business bridge + SG compliance\"],\"needs_email\":true,\"scored_at\":\"2026-08-24 19:12:16\",\"method\":\"rules_v1\"}}', fit_score = 70, fit_angle = 'energy_bridge_sg', updated_at = '2026-08-24 19:12:16' WHERE id = '733';

"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;