Log executed Laravel SQL queries and their line number and more

Related tags

Laravel laravel laravel-framework laravel-package query-log laravel-developer laravel-query-log
Overview

Laravel Query Log

Log executed Laravel SQL queries and their line number and more!

Documentation

Get documentation on laravelarticle.com

Sample Preview

text format

url         : http://example.test
method      : GET
total_query : 3
total_time  : 5.69
--------------------

sl          : 1
query       : select * from `students` where `id` = ? and `name` = ?
bindings    : 6|Tomas
final_query : select * from `students` where `id` = 6 and `name` = 'Tomas'
time        : 4.38
file        : C:\www\example\app\Http\Controllers\SiteController.php:10
line        : 10

sl          : 2
query       : select * from `students` where `id` = ? and `phone` = ?
bindings    : 6|649-768-7305
final_query : select * from `students` where `id` = 6 and `phone` = '649-768-7305'
time        : 0.75
file        : C:\www\example\app\Http\Controllers\SiteController.php:11
line        : 11

sl          : 3
query       : select * from `students` where `id` = ?
bindings    : 6
final_query : select * from `students` where `id` = 6
time        : 0.56
file        : C:\www\example\app\Http\Controllers\SiteController.php:12
line        : 12

Other Packages

You might also like...
The missing laravel helper that allows you to inspect your eloquent queries with it's bind parameters

Laravel Query Inspector The missing laravel helper that allows you to ispect your eloquent queries with it's bind parameters Motivations Let's say you

Mouad ZIANI 59 Sep 25, 2022
Simple Laravel 5 package to dump all running queries on the page.
Simple Laravel 5 package to dump all running queries on the page.

Abandoned: Use this package instead Laravel QueryDumper Introduction Simple Laravel 5 package to dump all running queries on the page. If it's SELECT

Sarfraz Ahmed 24 May 14, 2020
Trait for Laravel testing to count/assert about database queries

counts_database_queries Trait for Laravel testing to count/assert about database queries Installing composer require ohffs/counts-database-queries-tra

null 1 Feb 23, 2022
Need some filters? This package is based on the Repository Design Pattern to let you create specific queries easily.
Need some filters? This package is based on the Repository Design Pattern to let you create specific queries easily.

DevMakerLab/Laravel-Filters Need some filters? This package is based on the Repository Design Pattern to let you create specific queries easily. Insta

DevMakerLab 19 Feb 20, 2022
An extended laravel eloquent WHERE method to work with sql LIKE operator.

Laravel Eloquent WhereLike An extended laravel eloquent WHERE method to work with sql LIKE operator. Inspiration The idea of this package comes from o

Touhidur Rahman 33 Aug 6, 2022
A Laravel Artisan SQL Interactive Interface
A Laravel Artisan SQL Interactive Interface

sqli A Laravel 4 & 5 Artisan SQL Interactive Interface, plus a handful of Artisan commands to execute SQL queries. sqli It's like tinker for SQL, just

Antonio Carlos Ribeiro 61 Apr 18, 2022
Sqlcommenter is a plugin/middleware/wrapper to augment SQL statements from laravel

sqlcommenter is a plugin/middleware/wrapper to augment SQL statements from laravel with comments that can be used later to correlate user code with SQL statements.

Google 7 Jul 14, 2022
Laravel Logable is a simple way to log http request in your Laravel application.
Laravel Logable is a simple way to log http request in your Laravel application.

Laravel Logable is a simple way to log http request in your Laravel application. Requirements php = 7.4 Laravel version = 6.0 Installation composer

Sagar 6 Aug 25, 2022
Projeto de um sistema de pedidos de uma Pizzaria. Feito durante o curso
Projeto de um sistema de pedidos de uma Pizzaria. Feito durante o curso "SQL - Básico ao Avançado" Dísponível na Udemy pelo instrutor Matheus Baptisti

PJ-Pizzaria Este projeto é um sistema de pedidos de uma Pizzaria. O objeto de estudo aqui é a conexão de PHP + BD, PHP e a WEB, Regras de negócio comp

João Pedro Sassi Granado 2 Nov 29, 2021
Comments
  • Undefined index: queries

    Undefined index: queries

    ErrorException

    Undefined index: queries

    at vendor/haruncpi/laravel-query-log/src/Supports/TextLogFileWriter.php:19 15▕ } 16▕ 17▕ $this->writeLine("--------------------\n"); 18▕ ➜ 19▕ foreach ($data['queries'] as $q) { 20▕ foreach ($q as $key => $val) { 21▕ if (is_array($val)) { 22▕ $this->writeLine($this->addSpace($key, 12) . ": " . implode("|", $val)); 23▕ } else {

      +9 vendor frames

    10 artisan:51 Illuminate\Foundation\Console\Kernel::terminate()

    opened by hmshohrab 4
Owner
Md.Harun-Ur-Rashid
Hi, this is Harun from Chittagong, Bangladesh. I am professionally full stack web developer.
Md.Harun-Ur-Rashid
GitHub https://laravelarticle.com/laravel-query-log
Laravel User Activity Log - a package for Laravel 8.x that provides easy to use features to log the activities of the users of your Laravel app

Laravel User Activity Log - a package for Laravel 8.x that provides easy to use features to log the activities of the users of your Laravel app

null 9 Dec 14, 2022
Laravel Authentication Log is a package Log user authentication details and send new device notifications.

Laravel Authentication Log is a package which tracks your user's authentication information such as login/logout time, IP, Browser, Location, etc. as well as sends out notifications via mail, slack, or sms for new devices and failed logins.

Anthony Rappa 540 Jan 5, 2023
a Laravel package help you to execute more effective databases queries.

Laravel Query Helper Laravel Query Helper was developed for laravel 7.2+ to help you optimizing sql queries, this package will contain all advanced sq

karam mustafa 9 Jul 26, 2022
Laravel package to convert English numbers to Bangla number or Bangla text, Bangla month name and Bangla Money Format

Number to Bangla Number, Word or Month Name in Laravel | Get Wordpress Plugin Laravel package to convert English numbers to Bangla number or Bangla te

Md. Rakibul Islam 50 Dec 26, 2022
Laravel package to convert English numbers to Bangla number or Bangla text, Bangla month name and Bangla Money Format

Number to Bangla Number, Word or Month Name in Laravel | Get Wordpress Plugin Laravel package to convert English numbers to Bangla number or Bangla te

Md. Rakibul Islam 50 Dec 26, 2022
Phone number functionality for Laravel

Laravel Phone Adds phone number functionality to Laravel and Lumen based on the PHP port of Google's libphonenumber API by giggsey. Table of Contents

null 2.1k Dec 31, 2022
Laravel Dutch Phone Number Validator

Laravel Dutch Phone Number Validator Validate if the given phone number is a valid Dutch phone number Table of Contents Installation Usage Translation

Tim Wassenburg 0 May 30, 2022
Adds phone number functionality to Laravel based on the PHP port of Google's libphonenumber API by giggsey.

Laravel Phone Adds phone number functionality to Laravel based on the PHP port of Google's libphonenumber API by giggsey. Table of Contents Demo Insta

null 2.1k Jan 2, 2023
Adds phone number functionality to TYPO3 based on the PHP port of Google's libphonenumber API by giggsey

TYPO3 Phone Adds phone number functionality to TYPO3 based on the PHP port of Google's libphonenumber API by giggsey. Installation composer require si

Simon Schaufelberger 3 Oct 25, 2022
Fullstack komponents to write Forms, Queries and Menus in Laravel

kompo.io • Documentation • Demos • Twitter kompo/kompo kompo/kompo is a library of Fullstack Komponents to help you write forms, queries and menus in

Bass El Hachem 107 Dec 5, 2022