Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.transaction_id AS transaction_id_1,
  m0_.transaction_type AS transaction_type_2,
  m0_.transaction_time AS transaction_time_3,
  m0_.transaction_amount AS transaction_amount_4,
  m0_.ref_number AS ref_number_5,
  m0_.short_code AS short_code_6,
  m0_.balance AS balance_7,
  m0_.msisdn AS msisdn_8,
  m0_.first_name AS first_name_9,
  m0_.middle_name AS middle_name_10,
  m0_.last_name AS last_name_11,
  m0_.created_at AS created_at_12,
  m0_.is_used AS is_used_13
FROM
  mpesa m0_
WHERE
  m0_.created_at >= ?
  AND m0_.created_at <= ?
  AND m0_.is_used = 0
  AND m0_.short_code = 4022959
ORDER BY
  m0_.id DESC
LIMIT
  100

SELECT m0_.id AS id_0, m0_.transaction_id AS transaction_id_1, m0_.transaction_type AS transaction_type_2, m0_.transaction_time AS transaction_time_3, m0_.transaction_amount AS transaction_amount_4, m0_.ref_number AS ref_number_5, m0_.short_code AS short_code_6, m0_.balance AS balance_7, m0_.msisdn AS msisdn_8, m0_.first_name AS first_name_9, m0_.middle_name AS middle_name_10, m0_.last_name AS last_name_11, m0_.created_at AS created_at_12, m0_.is_used AS is_used_13 FROM mpesa m0_ WHERE m0_.created_at >= '2025-01-19 00:00:00' AND m0_.created_at <= '2025-01-19 23:59:59' AND m0_.is_used = 0 AND m0_.short_code = 4022959 ORDER BY m0_.id DESC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.paybill AS paybill_2,
  t0.consumer_key AS consumer_key_3,
  t0.consumer_secret AS consumer_secret_4,
  t0.pass_key AS pass_key_5,
  t0.token AS token_6,
  t0.token_updated_at AS token_updated_at_7,
  t0.auth_type AS auth_type_8,
  t0.short_code_type AS short_code_type_9,
  t0.station AS station_10
FROM
  mpesa_auth t0
WHERE
  t0.station = ?
  AND t0.auth_type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.paybill AS paybill_2, t0.consumer_key AS consumer_key_3, t0.consumer_secret AS consumer_secret_4, t0.pass_key AS pass_key_5, t0.token AS token_6, t0.token_updated_at AS token_updated_at_7, t0.auth_type AS auth_type_8, t0.short_code_type AS short_code_type_9, t0.station AS station_10 FROM mpesa_auth t0 WHERE t0.station = 14 AND t0.auth_type = 'PROD' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.created_at AS created_at_4,
  t0.roles AS roles_5,
  t0.email AS email_6,
  t0.person_id AS person_id_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.person_id AS person_id_7 FROM user t0 WHERE t0.id = 98;