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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 112.93 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 35500
Parameters:
[]
2 0.83 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:
[
  32741
  32740
  28966
  28967
  28968
  28969
  28970
  28971
  28972
  28973
  28974
  28975
  28976
  28977
  28978
  28979
  28980
  28981
  28982
  28983
  28984
  28985
  28986
  28987
  28988
  28989
  31753
  31747
  31790
  31752
  32332
  32330
  32331
  32329
  33764
  33763
  33762
  33761
  31455
  31454
  31456
  31453
  34489
  34492
  34491
  34487
  34486
  34488
  34490
  34485
]
3 7.12 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.