额外“计数”查询

Question

我注意到 Cakephp 的日志中有很多额外的计数查询。它们看起来确实没有必要，而且会减慢速度。 有人知道它们的用途和/或如何将其删除吗？

 [194] => Array
            (
                [query] => SELECT COUNT(*) AS `count` FROM `gpx_points` AS `Point`   WHERE `Point`.`id` = 81857
                [affected] => 1
                [numRows] => 1
                [took] => 1
            )

        [195] => Array
            (
                [query] => SELECT COUNT(*) AS `count` FROM `gpx_points` AS `Point`   WHERE `Point`.`id` = 81857
                [affected] => 1
                [numRows] => 1
                [took] => 1
            )

        [196] => Array
            (
                [query] => UPDATE `gpx_points` SET `id` = 81857, `file_id` = 6, `zoom13` = '1'  WHERE `gpx_points`.`id` = 81857
                [affected] => 1
                [numRows] => 1
                [took] => 1
            )

        [197] => Array
            (
                [query] => SELECT COUNT(*) AS `count` FROM `gpx_points` AS `Point`   WHERE `Point`.`id` = 71020
                [affected] => 1
                [numRows] => 1
                [took] => 1
            )

        [198] => Array
            (
                [query] => SELECT COUNT(*) AS `count` FROM `gpx_points` AS `Point`   WHERE `Point`.`id` = 71020
                [affected] => 1
                [numRows] => 1
                [took] => 0
            )

        [199] => Array
            (
                [query] => UPDATE `gpx_points` SET `id` = 71020, `file_id` = 5, `zoom13` = '1'  WHERE `gpx_points`.`id` = 71020
                [affected] => 1
                [numRows] => 1
                [took] => 1
            )

Answer 1

您可以临时将调试挂钩放入 Cake 内部，以查看从何处调用查询。

1. 打开文件 cake\libs\model\datasources\dbo_source.php
2. 找到 logQuery() 函数

3. 在顶部添加：

   if(strpos($sql,'count')){ pr( 调试器::trace() ); }