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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 62.80 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 35550
Parameters:
[]
2 1.02 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:
[
  31728
  31739
  31767
  31738
  31718
  31777
  31760
  31766
  31727
  31737
  31776
  31717
  31726
  31775
  31759
  31736
  31725
  31765
  31716
  31724
  31774
  31764
  31715
  31773
  31723
  31714
  28990
  28991
  28992
  28993
  30672
  30673
  30674
  30675
  30676
  30677
  30678
  30679
  30680
  30681
  30682
  30683
  30684
  30685
  30686
  31713
  31751
  28994
  28995
  28996
]
3 6.25 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.