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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 65.06 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 28950
Parameters:
[]
2 0.78 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:
[
  31607
  34382
  30567
  29743
  29744
  29745
  29640
  34082
  34081
  30510
  30511
  30512
  29971
  29746
  30052
  31929
  30941
  31834
  31547
  31835
  31696
  31560
  31686
  31947
  34116
  31928
  34073
  32005
  32004
  34072
  34394
  34354
  34894
  34684
  27531
  30620
  27532
  27533
  31152
  27534
  27535
  30621
  27536
  27537
  27538
  27539
  27540
  27541
  27542
  27543
]
3 5.45 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.