GET https://content.gamingdesktop.com.au/admin/supplier-ref?page=121&sort%5BdsCode%5D=ASC

Query Metrics

3 Database Queries
3 Different statements
35.36 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

# Time Info
1 31.75 ms
SELECT DISTINCT s0_.id AS id_0, s0_.ds_code AS ds_code_1 FROM supplier_ref s0_ ORDER BY s0_.ds_code ASC LIMIT 50 OFFSET 6000
Parameters:
[]
2 0.95 ms
SELECT s0_.id AS id_0, s0_.sku AS sku_1, s0_.ls_code AS ls_code_2, s0_.alloy_code AS alloy_code_3, s0_.mmt_code AS mmt_code_4, s0_.ds_code AS ds_code_5, s0_.dd_code AS dd_code_6, s0_.synnex_code AS synnex_code_7 FROM supplier_ref s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.ds_code ASC
Parameters:
[
  9543
  9799
  10055
  10311
  10567
  10823
  11079
  11335
  11591
  11847
  12103
  12359
  12615
  12871
  13127
  13383
  13639
  13895
  14151
  14407
  14663
  14919
  15175
  15431
  15687
  15943
  16199
  16455
  16711
  16967
  17223
  17479
  17735
  17991
  18247
  18503
  18759
  19015
  19271
  19527
  19783
  20039
  20295
  20551
  20807
  21063
  21319
  72
  328
  584
]
3 2.65 ms
SELECT count(*) AS sclr_0 FROM supplier_ref s0_
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\SupplierRef 50

Entities Mapping

Class Mapping errors
App\Entity\SupplierRef No errors.