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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 70.21 ms
SELECT DISTINCT s0_.id AS id_0, s0_.ls_code AS ls_code_1 FROM supplier_ref s0_ ORDER BY s0_.ls_code ASC LIMIT 50 OFFSET 11550
Parameters:
[]
2 0.77 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_.ls_code ASC
Parameters:
[
  8256
  14341
  14318
  20280
  9256
  11268
  13083
  8680
  13084
  19863
  9166
  11408
  11889
  12450
  12451
  12188
  8173
  19856
  11303
  11890
  10375
  8282
  11409
  12189
  9257
  8681
  9071
  8257
  8283
  11410
  11891
  19864
  8174
  10768
  12419
  8284
  10458
  10714
  11892
  19865
  8682
  9167
  12344
  14342
  11269
  8015
  10000
  19866
  12420
  9168
]
3 2.31 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.