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
  l0_.id AS id_0,
  l0_.company_name AS company_name_1,
  l0_.domain AS domain_2,
  l0_.website_url AS website_url_3,
  l0_.contact_name AS contact_name_4,
  l0_.contact_email AS contact_email_5,
  l0_.country AS country_6,
  l0_.jurisdiction AS jurisdiction_7,
  l0_.source_type AS source_type_8,
  l0_.source_ref AS source_ref_9,
  l0_.dedupe_key AS dedupe_key_10,
  l0_.status AS status_11,
  l0_.existing_lead_id AS existing_lead_id_12,
  l0_.lawful_basis AS lawful_basis_13,
  l0_.lawful_basis_note AS lawful_basis_note_14,
  l0_.enrichment_json AS enrichment_json_15,
  l0_.sector AS sector_16,
  l0_.size_signal AS size_signal_17,
  l0_.energy_signal AS energy_signal_18,
  l0_.enriched_at AS enriched_at_19,
  l0_.fit_score AS fit_score_20,
  l0_.fit_angle AS fit_angle_21,
  l0_.motion AS motion_22,
  l0_.created_login_id AS created_login_id_23,
  l0_.created_at AS created_at_24,
  l0_.updated_at AS updated_at_25,
  l0_.delete_flag AS delete_flag_26
FROM
  leadgen_prospect l0_
WHERE
  l0_.source_type = ?
  AND l0_.delete_flag = 0
ORDER BY
  l0_.id DESC
LIMIT
  1000

SELECT l0_.id AS id_0, l0_.company_name AS company_name_1, l0_.domain AS domain_2, l0_.website_url AS website_url_3, l0_.contact_name AS contact_name_4, l0_.contact_email AS contact_email_5, l0_.country AS country_6, l0_.jurisdiction AS jurisdiction_7, l0_.source_type AS source_type_8, l0_.source_ref AS source_ref_9, l0_.dedupe_key AS dedupe_key_10, l0_.status AS status_11, l0_.existing_lead_id AS existing_lead_id_12, l0_.lawful_basis AS lawful_basis_13, l0_.lawful_basis_note AS lawful_basis_note_14, l0_.enrichment_json AS enrichment_json_15, l0_.sector AS sector_16, l0_.size_signal AS size_signal_17, l0_.energy_signal AS energy_signal_18, l0_.enriched_at AS enriched_at_19, l0_.fit_score AS fit_score_20, l0_.fit_angle AS fit_angle_21, l0_.motion AS motion_22, l0_.created_login_id AS created_login_id_23, l0_.created_at AS created_at_24, l0_.updated_at AS updated_at_25, l0_.delete_flag AS delete_flag_26 FROM leadgen_prospect l0_ WHERE l0_.source_type = 'geo' AND l0_.delete_flag = 0 ORDER BY l0_.id DESC LIMIT 1000;