PHP Laravel查找2个查询构建器之间的差异

use Illuminate\Support\Facades\DB;

// 定义第一个查询构建器
$query1 = DB::table('users')
    ->where('age', '>', 25)
    ->select('name', 'email');

// 定义第二个查询构建器
$query2 = DB::table('users')
    ->where('age', '>', 30)
    ->select('name', 'email', 'phone');

// 获取第一个查询构建器的SQL语句和绑定参数
$sql1 = $query1->toSql();
$bindings1 = $query1->getBindings();

// 获取第二个查询构建器的SQL语句和绑定参数
$sql2 = $query2->toSql();
$bindings2 = $query2->getBindings();

// 输出SQL语句和绑定参数
echo "Query 1 SQL: " . $sql1 . "\n";
echo "Query 1 Bindings: " . implode(', ', $bindings1) . "\n";

echo "Query 2 SQL: " . $sql2 . "\n";
echo "Query 2 Bindings: " . implode(', ', $bindings2) . "\n";

// 比较SQL语句和绑定参数
if ($sql1 === $sql2 && $bindings1 === $bindings2) {
    echo "两个查询构建器完全相同。\n";
} else {
    echo "两个查询构建器存在差异。\n";
    if ($sql1 !== $sql2) {
        echo "SQL语句不同。\n";
    }
    if ($bindings1 !== $bindings2) {
        echo "绑定参数不同。\n";
    }
}