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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 168.41 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 12500
Parameters:
[]
2 0.86 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:
[
  17812
  18068
  18324
  18580
  18836
  19092
  19348
  19604
  19860
  20116
  20372
  20628
  20884
  21140
  21396
  149
  405
  661
  917
  1173
  1429
  1685
  1941
  2197
  2453
  2709
  2965
  3221
  3477
  3733
  3989
  4245
  4501
  4757
  5013
  5269
  5525
  5781
  6037
  6293
  6549
  6805
  7061
  7317
  7573
  7829
  8085
  8341
  8597
  8853
]
3 2.97 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.