#!/usr/bin/env bash
set -euo pipefail

ROOT="${1:-.}"

echo "[1/2] En cok query gecen dosyalar"
rg -n --glob '*.php' -- '->query\(' "$ROOT" \
  | awk -F: '{print $1}' \
  | sort | uniq -c | sort -nr | head -n 50

echo
echo "[2/2] String birlestirme ile query suphelileri"
rg -n --glob '*.php' -- "query\\(\\\".*\\$|query\\('.*\\$" "$ROOT" | head -n 300 || true