Log actual query?

I turned on the weblogroute… but how do I see the actual query?


Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`content` AS `t0_c1`,

`t`.`book_id` AS `t0_c2`, `t`.`page_id` AS `t0_c3`, `book`.`id` AS `t1_c0`,

`book`.`slug` AS `t1_c1`, `book`.`title` AS `t1_c2`, `book`.`directory` AS

`t1_c3`, `book`.`description` AS `t1_c4`, `book`.`created` AS `t1_c5`,

`book`.`modified` AS `t1_c6` FROM `pages` `t`  LEFT OUTER JOIN `books`

`book` ON (`t`.`id`=`book`.`id`) WHERE (content LIKE :keyword) LIMIT 10

Does not have params replaced yet?

add property


in you "db" section of main.php

Thanks but it does not seem to have effect… or does it need to be in the Weblog? And why is this not enabled by default? is anybody actually using it with params?

Error in executing SQL: INSERT INTO comments (content, status,

book_id, created, user_id) VALUES (:yp0, :yp1, :yp2, NOW(), :yp3).

Bind with parameter :yp0='sdasdsda ', :yp1=2, :yp2=1, :yp3=1


            'connectionString' => 'mysql:host=localhost;dbname=ebooks',

            'emulatePrepare' => true,            

            'username' => 'root',

            'password' => '123qwe',

            'charset' => 'utf8',

            'enableParamLogging'=> true,

            'tablePrefix' => ''


Is exactly your params. So it works ;)