Symfony Profiler

SELECT
  COUNT(*)
FROM
  citizens t0
WHERE
  t0.is_verified = ?

SELECT COUNT(*) FROM citizens t0 WHERE t0.is_verified = 1;

SELECT
  COUNT(*)
FROM
  pump_stations t0
WHERE
  t0.is_active = ?

SELECT COUNT(*) FROM pump_stations t0 WHERE t0.is_active = 1;

SELECT
  COUNT(*)
FROM
  fuel_transactions t0
WHERE
  t0.status = ?

SELECT COUNT(*) FROM fuel_transactions t0 WHERE t0.status = 'APPROVED';

SELECT
  COUNT(*)
FROM
  citizens t0
WHERE
  t0.is_verified = ?

SELECT COUNT(*) FROM citizens t0 WHERE t0.is_verified = 1;

SELECT
  COUNT(*)
FROM
  pump_stations t0
WHERE
  t0.is_active = ?

SELECT COUNT(*) FROM pump_stations t0 WHERE t0.is_active = 1;

SELECT
  COUNT(*)
FROM
  fuel_transactions t0
WHERE
  t0.status = ?

SELECT COUNT(*) FROM fuel_transactions t0 WHERE t0.status = 'APPROVED';

SELECT
  COALESCE(
    SUM(f0_.litres),
    0
  ) AS sclr_0
FROM
  fuel_transactions f0_
WHERE
  f0_.status = ?

SELECT COALESCE(SUM(f0_.litres), 0) AS sclr_0 FROM fuel_transactions f0_ WHERE f0_.status = 'APPROVED';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_LOGO' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_LOGO' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_LOGO' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'BROCHURE_PDF' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'BROCHURE_PDF' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_NAME' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'PHONE_NUMBER' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'PHONE_NUMBER' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'WHATSAPP_NUMBER' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'WEBSITE_URL' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'SUPPORT_EMAIL' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4 FROM settings t0 WHERE t0.name = 'APP_LOGO' LIMIT 1;