"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 = ?"
(parameters:
[1 => 69]
, types:
[1 => 1]
)
doctrine
[
"sql" => "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 = ?"
"params" => [1 => 69]
"types" => [1 => 1]
]
User Deprecated: Since symfony/framework-bundle 5.4: Method "Symfony\Bundle\FrameworkBundle\Controller\AbstractController::getDoctrine()" is deprecated, inject an instance of ManagerRegistry in your controller instead.
"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"
(parameters:
[1 => 12 => "PROD"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "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"
"params" => [1 => 12 => "PROD"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"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 = 4022961 ORDER BY m0_.id DESC LIMIT 100"
[
"sql" => "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 = 4022961 ORDER BY m0_.id DESC LIMIT 100"
"params" => [1 => "2025-07-02 00:00:00"
2 => "2025-07-02 23:59:59"
]
"types" => [1 => 22 => 2]
]