PHPackages                             professionalchacha/php-query-optimizer - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. professionalchacha/php-query-optimizer

ActiveLibrary[Utility & Helpers](/categories/utility)

professionalchacha/php-query-optimizer
======================================

PHP query performance analyzer

1.0.0(4mo ago)018MITPHP

Since Mar 16Pushed 2mo agoCompare

[ Source](https://github.com/sahil512sk/query-optimizer)[ Packagist](https://packagist.org/packages/professionalchacha/php-query-optimizer)[ RSS](/packages/professionalchacha-php-query-optimizer/feed)WikiDiscussions main Synced 4w ago

READMEChangelogDependencies (1)Versions (2)Used By (0)

PHP Query Optimizer
===================

[](#php-query-optimizer)

A PHP library for analyzing SQL queries and identifying potential performance issues.

Features
--------

[](#features)

- Analyzes SQL queries for common performance anti-patterns
- Provides suggestions for query optimization
- Extensible rule system
- Command-line interface for quick analysis

Installation
------------

[](#installation)

```
composer require professionalchacha/php-query-optimizer
```

Or clone the repository:

```
git clone https://github.com/professionalchacha/php-query-optimizer.git
cd php-query-optimizer
composer install
```

Usage
-----

[](#usage)

### After Installation (via Composer)

[](#after-installation-via-composer)

**Windows Users:**

```
# Method 1: Direct PHP execution (Recommended)
php vendor\bin\query-analyze.php path\to\your\file.php
php vendor\bin\query-analyze.php "SELECT * FROM users ORDER BY created_at"

# Method 2: Use package directly
php vendor\professionalchacha\php-query-optimizer\analyze-file.php path\to\file.php
php vendor\professionalchacha\php-query-optimizer\query-analyzer.php "SELECT * FROM users"

# Method 3: Use provided batch file
vendor-bin-query-analyze.bat path\to\your\file.php
vendor-bin-query-analyze.bat "SELECT * FROM users"
```

**Linux/Mac Users:**

```
# Method 1: Using vendor/bin (Recommended)
php vendor/bin/query-analyze.php path/to/your/file.php
php vendor/bin/query-analyze.php "SELECT * FROM users ORDER BY created_at"

# Method 2: Use package directly
php vendor/professionalchacha/php-query-optimizer/analyze-file.php path/to/file.php
php vendor/professionalchacha/php-query-optimizer/query-analyzer.php "SELECT * FROM users"
```

**Method 2: Using Composer Script**

```
# Add this to your composer.json scripts section:
# "query-analyze": "vendor/bin/query-analyze.php"

# Then run:
composer query-analyze path/to/your/file.php
composer query-analyze "SELECT * FROM users"
```

**Method 3: Create Local Alias**

```
# Create a local batch file (Windows)
echo @echo off > query-analyze.bat
echo php vendor\bin\query-analyze.php %%* >> query-analyze.bat

# Or create a local shell script (Linux/Mac)
echo '#!/bin/bash' > query-analyze
echo 'php vendor/bin/query-analyze.php "$@"' >> query-analyze
chmod +x query-analyze

# Then use:
./query-analyze path/to/your/file.php
```

**Method 4: Global Setup (Advanced)**

```
# Run setup script (requires admin rights)
php setup-global.bat  # Windows
bash setup-global.sh   # Linux/Mac
```

**Alternative Commands**

```
# Windows
php vendor\bin\analyze-file.php path\to\your\file.php
php vendor\bin\query-analyzer.php "SELECT * FROM users"

# Linux/Mac
php vendor/bin/analyze-file.php path/to/your/file.php
php vendor/bin/query-analyzer.php "SELECT * FROM users ORDER BY created_at"
```

### Command Line (from source)

[](#command-line-from-source)

```
php query-analyze.php "SELECT * FROM users ORDER BY created_at"
php analyze-file.php path/to/your/file.php
```

### Programmatic

[](#programmatic)

```