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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 50.82 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 20700
Parameters:
[]
2 0.76 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:
[
  3050
  5583
  6011
  6800
  8046
  6152
  3588
  3589
  922
  1732
  1596
  3217
  1570
  2256
  1571
  1917
  2943
  2512
  1266
  4594
  3990
  17648
  12595
  13701
  17148
  19219
  2497
  4366
  1964
  2095
  13132
  17081
  1845
  13131
  5889
  5444
  1935
  15541
  15959
  15590
  4381
  5659
  8069
  5382
  7172
  2364
  8085
  15830
  3702
  16635
]
3 6.96 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.