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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 46.10 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 20000
Parameters:
[]
2 1.09 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:
[
  25280
  25536
  25792
  26048
  26304
  26560
  26816
  36032
  705
  961
  1217
  1473
  1729
  1985
  2241
  2497
  2753
  3009
  3265
  3521
  3777
  4033
  4289
  4545
  4801
  5057
  5313
  5569
  5825
  6081
  6337
  6593
  6849
  7105
  7361
  7617
  7873
  8129
  8385
  8641
  8897
  9153
  9409
  9665
  9921
  10177
  10433
  10689
  10945
  11201
]
3 6.41 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.