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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 37.00 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 28100
Parameters:
[]
2 0.77 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:
[
  27372
  27373
  27374
  27375
  27376
  27377
  27378
  27379
  27380
  27381
  27382
  27383
  27384
  27385
  27386
  27387
  27388
  27389
  27390
  27391
  35283
  33931
  33926
  33930
  33925
  33929
  33924
  33928
  33927
  27392
  27393
  27394
  27395
  35793
  35595
  33345
  33344
  33343
  33342
  33337
  33341
  33333
  33340
  33329
  33339
  33327
  33332
  33336
  33338
  33331
]
3 3.76 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.