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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 46.48 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 28700
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:
[
  32239
  32246
  32254
  32236
  32242
  32234
  32253
  32233
  32252
  32238
  32251
  32240
  30710
  29537
  29538
  30835
  30836
  30648
  30837
  30838
  30839
  30840
  30841
  30842
  30843
  30844
  30845
  30846
  30847
  29539
  29540
  29541
  29542
  29543
  29544
  29545
  29546
  29547
  29548
  29549
  29550
  29551
  30068
  34580
  30465
  31562
  29552
  30069
  29553
  29554
]
3 4.81 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.