GET https://garage.farahtech.ma/supplier/1

Query Metrics

8 Database Queries
8 Different statements
8.93 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 1.85 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.contact_person AS contact_person_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.tax_number AS tax_number_7, t0.payment_terms AS payment_terms_8, t0.website AS website_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 2.50 ms
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM delivery_note d0_ WHERE d0_.supplier_id = ?
Parameters:
[
  1
]
3 0.85 ms
SELECT DISTINCT d0_.id AS id_0, d0_.delivery_date AS delivery_date_1 FROM delivery_note d0_ WHERE d0_.supplier_id = ? ORDER BY d0_.delivery_date DESC LIMIT 5
Parameters:
[
  1
]
4 0.99 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM supplier_credit s0_ WHERE s0_.supplier_id = ?
Parameters:
[
  1
]
5 0.62 ms
SELECT DISTINCT s0_.id AS id_0, s0_.date AS date_1 FROM supplier_credit s0_ WHERE s0_.supplier_id = ? ORDER BY s0_.date DESC LIMIT 10
Parameters:
[
  1
]
6 0.42 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.type AS type_3, t0.status AS status_4, t0.date AS date_5, t0.reference AS reference_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.supplier_id AS supplier_id_10, t0.delivery_note_id AS delivery_note_id_11, t0.supplier_payment_id AS supplier_payment_id_12 FROM supplier_credit t0 WHERE t0.supplier_id = ?
Parameters:
[
  1
]
7 0.68 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.delivery_date AS delivery_date_3, t0.status AS status_4, t0.notes AS notes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.supplier_id AS supplier_id_8, t0.purchase_order_id AS purchase_order_id_9 FROM delivery_note t0 WHERE t0.supplier_id = ?
Parameters:
[
  1
]
8 1.03 ms
SELECT t0.id AS id_1, t0.garage AS garage_2, t0.currency AS currency_3, t0.date_format AS date_format_4, t0.time_format AS time_format_5, t0.notifications AS notifications_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.logo AS logo_9 FROM app_settings t0 LIMIT 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Supplier 1
App\Entity\AppSettings 1

Entities Mapping