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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 26.02 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 17000
Parameters:
[]
2 0.99 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:
[
  8650
  8906
  9162
  9418
  9674
  9930
  10186
  10442
  10698
  10954
  11210
  11466
  11722
  11978
  12234
  12490
  12746
  13002
  13258
  13514
  13770
  14026
  14282
  14538
  14794
  15050
  15306
  15562
  15818
  16074
  16330
  16586
  16842
  17098
  17354
  17610
  17866
  18122
  18378
  18634
  18890
  19146
  19402
  19658
  19914
  20170
  20426
  20682
  20938
  21194
]
3 6.89 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.