Joomla! Issue Tracker | Joomla! CMS #30826 - [4.0] [debuger bar] Show queries arguments

Closed
1 Oct 2020
Medium
Build: staging
# 30826

bato3
1 Oct 2020

Is your feature request related to a problem? Please describe.

In the Queries tab (Debugger bar): currently queries in the form of:

SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos37_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0

Please add argument values so that I know what asset and extension are.

Describe the solution you'd like

I propose a solution from the knex.js logger: after the query there is an array with values.

Additional context

It would be nice if we could reduce the number of occurrences of preparedArray n...

SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos37_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37)