"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.is_active AS is_active_7, t0.person_id AS person_id_8 FROM user t0 WHERE t0.id = ?"
(parameters:
[1 => 157]
, 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.is_active AS is_active_7, t0.person_id AS person_id_8 FROM user t0 WHERE t0.id = ?"
"params" => [1 => 157]
"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 t.id,\n t.amount,\n d.account_date,\n ts.station_name as to_station,\n fs.station_name as from_station,\n w.id as waybill,\n t.expenses,\n t.is_cancelled,\n t.tax_amount,\n t.balance,\n t.pin_number,\n w.percel_count, \n t.is_cancelled\n FROM transaction t \n JOIN daily_account d on d.id = t.daily_account_id\n JOIN way_bill w ON w.id = t.way_bill_id\n JOIN station ts ON ts.id = w.to_station_id\n JOIN station fs ON fs.id = w.from_station_id\n WHERE t.id > 0 ORDER BY t.id DESC LIMIT 0, 20
"""
(parameters:
[]
, types:
[]
)
doctrine
[
"sql" => """
SELECT t.id,\n t.amount,\n d.account_date,\n ts.station_name as to_station,\n fs.station_name as from_station,\n w.id as waybill,\n t.expenses,\n t.is_cancelled,\n t.tax_amount,\n t.balance,\n t.pin_number,\n w.percel_count, \n t.is_cancelled\n FROM transaction t \n JOIN daily_account d on d.id = t.daily_account_id\n JOIN way_bill w ON w.id = t.way_bill_id\n JOIN station ts ON ts.id = w.to_station_id\n JOIN station fs ON fs.id = w.from_station_id\n WHERE t.id > 0 ORDER BY t.id DESC LIMIT 0, 20
"""
"params" => []
"types" => []
]
debug
Executing statement:
"""
SELECT COUNT(t.id) AS count_t \n FROM transaction t \n JOIN daily_account d on d.id = t.daily_account_id\n JOIN way_bill w ON w.id = t.way_bill_id\n JOIN station ts ON ts.id = w.to_station_id\n JOIN station fs ON fs.id = w.from_station_id\n WHERE t.id > 0
"""
(parameters:
[]
, types:
[]
)
doctrine
[
"sql" => """
SELECT COUNT(t.id) AS count_t \n FROM transaction t \n JOIN daily_account d on d.id = t.daily_account_id\n JOIN way_bill w ON w.id = t.way_bill_id\n JOIN station ts ON ts.id = w.to_station_id\n JOIN station fs ON fs.id = w.from_station_id\n WHERE t.id > 0
"""
"params" => []
"types" => []
]