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

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.fetch_status AS fetch_status_3,
  t0.enrichment_json AS enrichment_json_4,
  t0.fetched_at AS fetched_at_5
FROM
  leadgen_enrichment_cache t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.fetch_status AS fetch_status_3, t0.enrichment_json AS enrichment_json_4, t0.fetched_at AS fetched_at_5 FROM leadgen_enrichment_cache t0 WHERE t0.domain = 'chunhoe.com.sg' LIMIT 1;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  leadgen_enrichment_cache l0_
WHERE
  l0_.fetched_at >= ?
  AND l0_.fetched_at <= ?

SELECT COUNT(l0_.id) AS sclr_0 FROM leadgen_enrichment_cache l0_ WHERE l0_.fetched_at >= '2026-08-24 00:00:00' AND l0_.fetched_at <= '2026-08-24 23:59:59';

SELECT
  name,
  data
FROM
  acc_setting
WHERE
  name IN (?, ?)

SELECT name, data FROM acc_setting WHERE name IN ('ai_cloud_tokens_month', 'ai_local_calls_month');

SELECT
  provider,
  COALESCE(
    SUM(calls),
    0
  ) calls,
  COALESCE(
    SUM(prompt_tokens),
    0
  ) pt,
  COALESCE(
    SUM(completion_tokens),
    0
  ) ct
FROM
  ai_usage_ledger
WHERE
  DAY >= ?
GROUP BY
  provider

SELECT provider, COALESCE(SUM(calls),0) calls, COALESCE(SUM(prompt_tokens),0) pt,
                        COALESCE(SUM(completion_tokens),0) ct
                 FROM ai_usage_ledger WHERE DAY >= '2026-08-01' GROUP BY provider;

INSERT INTO ai_usage_ledger (
  app_id, DAY, provider, calls, prompt_tokens,
  completion_tokens, created_at, updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?, NOW(), NOW()) ON DUPLICATE KEY
UPDATE
  calls = calls +
VALUES
  (calls),
  prompt_tokens = prompt_tokens +
VALUES
  (prompt_tokens),
  completion_tokens = completion_tokens +
VALUES
  (completion_tokens),
  updated_at = NOW()

INSERT INTO ai_usage_ledger (app_id, DAY, provider, calls, prompt_tokens, completion_tokens, created_at, updated_at)
                     VALUES (0, '2026-08-24', 'cloud', 1, 1340, 307, NOW(), NOW())
                     ON DUPLICATE KEY UPDATE
                       calls = calls + VALUES(calls),
                       prompt_tokens = prompt_tokens + VALUES(prompt_tokens),
                       completion_tokens = completion_tokens + VALUES(completion_tokens),
                       updated_at = NOW();

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.fetch_status AS fetch_status_3,
  t0.enrichment_json AS enrichment_json_4,
  t0.fetched_at AS fetched_at_5
FROM
  leadgen_enrichment_cache t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.fetch_status AS fetch_status_3, t0.enrichment_json AS enrichment_json_4, t0.fetched_at AS fetched_at_5 FROM leadgen_enrichment_cache t0 WHERE t0.domain = 'chunhoe.com.sg' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO leadgen_enrichment_cache (
  domain, fetch_status, enrichment_json,
  fetched_at
)
VALUES
  (?, ?, ?, ?)

INSERT INTO leadgen_enrichment_cache (domain, fetch_status, enrichment_json, fetched_at) VALUES ('chunhoe.com.sg', 'ok', '{\"site_found\":true,\"url\":\"https://chunhoe.com.sg\",\"pages_fetched\":1,\"issues\":[\"https://chunhoe.com.sg/impressum: http 404\",\"https://chunhoe.com.sg/imprint: http 404\"],\"company_name_detected\":\"CHUN HOE PTE. LTD.\",\"what_they_do\":\"Manufacturer, exporter, and supplier of building materials, hardware, steel wire products, fencing products, and green building materials; also mentions construction and civil engineering-related products.\",\"sector\":\"Building materials / manufacturing / hardware supply\",\"country\":\"Singapore\",\"company_size_signal\":\"Incorporated in 1993; grown over two decades; operates a Singapore factory and mentions subsidiaries/associate companies in Malaysia and Indonesia\",\"energy_signals\":[\"installed solar energy\",\"GREEN Building Material\",\"Green Steel Mesh\",\"saves more on energy and raw materials\"],\"tech_signals\":[\"Powered By NEWPAGES\"],\"summary\":\"Chun Hoe Pte Ltd is a Singapore-based building materials and hardware company that manufactures, exports, and trades steel wire, fencing, and green building material products, with a stated focus on sustainability and solar-powered production.\",\"confidence\":0.96,\"evidence\":[\"\\\"We manufacture, export, and trade building materials, hardware, and steel wire products.\\\"\",\"\\\"For the company\'s production site, we installed solar energy\\\"\",\"\\\"11 Tuas South Link 1, 01-17 & 18 Shine @ Tuas South, Singapore 636901.\\\"\"],\"llm_used\":true,\"evidence_dropped\":0,\"evidence_verified\":true,\"contact_email\":\"liew@brcfence.my\",\"contact_email_source\":\"site:/\",\"emails_found\":[\"admin@chunhoe.com.id\",\"liew@brcfence.my\",\"singaporemetalsteel@gmail.com\"]}', '2026-08-24 13:08:14');

UPDATE
  leadgen_prospect
SET
  contact_email = ?,
  STATUS = ?,
  enrichment_json = ?,
  sector = ?,
  size_signal = ?,
  energy_signal = ?,
  enriched_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE leadgen_prospect SET contact_email = 'liew@brcfence.my', STATUS = 'enriched', enrichment_json = '{\"site_found\":true,\"url\":\"https://chunhoe.com.sg\",\"pages_fetched\":1,\"issues\":[\"https://chunhoe.com.sg/impressum: http 404\",\"https://chunhoe.com.sg/imprint: http 404\"],\"company_name_detected\":\"CHUN HOE PTE. LTD.\",\"what_they_do\":\"Manufacturer, exporter, and supplier of building materials, hardware, steel wire products, fencing products, and green building materials; also mentions construction and civil engineering-related products.\",\"sector\":\"Building materials / manufacturing / hardware supply\",\"country\":\"Singapore\",\"company_size_signal\":\"Incorporated in 1993; grown over two decades; operates a Singapore factory and mentions subsidiaries/associate companies in Malaysia and Indonesia\",\"energy_signals\":[\"installed solar energy\",\"GREEN Building Material\",\"Green Steel Mesh\",\"saves more on energy and raw materials\"],\"tech_signals\":[\"Powered By NEWPAGES\"],\"summary\":\"Chun Hoe Pte Ltd is a Singapore-based building materials and hardware company that manufactures, exports, and trades steel wire, fencing, and green building material products, with a stated focus on sustainability and solar-powered production.\",\"confidence\":0.96,\"evidence\":[\"\\\"We manufacture, export, and trade building materials, hardware, and steel wire products.\\\"\",\"\\\"For the company\'s production site, we installed solar energy\\\"\",\"\\\"11 Tuas South Link 1, 01-17 & 18 Shine @ Tuas South, Singapore 636901.\\\"\"],\"llm_used\":true,\"evidence_dropped\":0,\"evidence_verified\":true,\"contact_email\":\"liew@brcfence.my\",\"contact_email_source\":\"site:/\",\"emails_found\":[\"admin@chunhoe.com.id\",\"liew@brcfence.my\",\"singaporemetalsteel@gmail.com\"]}', sector = 'Building materials / manufacturing / hardware supply', size_signal = 'Incorporated in 1993; grown over two decades; operates a Singapore factory and mentions subsidiaries', energy_signal = 1, enriched_at = '2026-08-24 13:08:14', updated_at = '2026-08-24 13:08:14' WHERE id = '540';

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