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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 142.91 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 10600
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_.ds_code ASC
Parameters:
[
  4478
  4734
  4990
  5246
  5502
  5758
  6014
  6270
  6526
  6782
  7038
  7294
  7550
  7806
  8062
  8318
  8574
  8830
  9086
  9342
  9598
  9854
  10110
  10366
  10622
  10878
  11134
  11390
  11646
  11902
  12158
  12414
  12670
  12926
  13182
  13438
  13694
  13950
  14206
  14462
  14718
  14974
  15230
  15486
  15742
  15998
  16254
  16510
  16766
  17022
]
3 2.42 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.