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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 27.77 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 9450
Parameters:
[]
2 0.66 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:
[
  10639
  10134
  8904
  12869
  9425
  8897
  8223
  7112
  10030
  12764
  10007
  9697
  9492
  10640
  8635
  9426
  8224
  9393
  10008
  10009
  10135
  10049
  19840
  7113
  7153
  12765
  10274
  12766
  9599
  12767
  7384
  10050
  7165
  19882
  7115
  7191
  9364
  12870
  18583
  8238
  19883
  9600
  12871
  7799
  10051
  8181
  10031
  7116
  18584
  7386
]
3 6.53 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.