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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 136.05 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 10000
Parameters:
[]
2 0.89 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:
[
  1399
  1655
  1911
  2167
  2423
  2679
  2935
  3191
  3447
  3703
  3959
  4215
  4471
  4727
  4983
  5239
  5495
  5751
  6007
  6263
  6519
  6775
  7031
  7287
  7543
  7799
  8055
  8311
  8567
  8823
  9079
  9335
  9591
  9847
  10103
  10359
  10615
  10871
  11127
  11383
  11639
  11895
  12151
  12407
  12663
  12919
  13175
  13431
  13687
  13943
]
3 18.80 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.