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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 17.98 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 1850
Parameters:
[]
2 1.10 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:
[
  2248
  1825
  1478
  2326
  1779
  2470
  1937
  2299
  2133
  2235
  2396
  2031
  3133
  1531
  1797
  2506
  1338
  1757
  1656
  1702
  1649
  1329
  1357
  1596
  1635
  1423
  1499
  1429
  1507
  1535
  1653
  1682
  1717
  1644
  1516
  1469
  1425
  1652
  1730
  1695
  1541
  1389
  1303
  1324
  1312
  1325
  1308
  1361
  1770
  1317
]
3 3.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.