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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 72.45 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 20400
Parameters:
[]
2 1.01 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:
[
  1779
  2035
  2291
  2547
  2803
  3059
  3315
  3571
  3827
  4083
  4339
  4595
  4851
  5107
  5363
  5619
  5875
  6131
  6387
  6643
  6899
  7155
  7411
  7667
  7923
  8179
  8435
  8691
  8947
  9203
  9459
  9715
  9971
  10227
  10483
  10739
  10995
  11251
  11507
  11763
  12019
  12275
  12531
  12787
  13043
  13299
  13555
  13811
  14067
  14323
]
3 18.55 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.