GET https://manage.syberinfo.com.au/admin/stock?page=1&sort%5Bsku%5D=DESC

Query Metrics

3 Database Queries
3 Different statements
2.14 ms Query time
0 Invalid entities
41 Managed entities

Queries

Group similar statements

# Time Info
1 1.14 ms
SELECT DISTINCT s0_.id AS id_0, s0_.sku AS sku_1, s0_.id AS id_2 FROM stock s0_ ORDER BY s0_.sku DESC, s0_.id DESC LIMIT 50
Parameters:
[]
2 0.80 ms
SELECT s0_.id AS id_0, s0_.sku AS sku_1, s0_.ls_stock AS ls_stock_2, s0_.ls_cp AS ls_cp_3, s0_.alloy_stock AS alloy_stock_4, s0_.alloy_cp AS alloy_cp_5, s0_.mmt_stock AS mmt_stock_6, s0_.mmt_cp AS mmt_cp_7, s0_.ds_stock AS ds_stock_8, s0_.ds_cp AS ds_cp_9, s0_.dd_stock AS dd_stock_10, s0_.dd_cp AS dd_cp_11, s0_.dd_status AS dd_status_12, s0_.rrp AS rrp_13, s0_.synnex_cp AS synnex_cp_14, s0_.synnex_stock AS synnex_stock_15 FROM stock s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.sku DESC, s0_.id DESC
Parameters:
[
  39
  31
  32
  10
  29
  36
  18
  1
  38
  15
  41
  40
  14
  28
  35
  33
  16
  21
  7
  12
  8
  11
  9
  37
  3
  2
  17
  5
  24
  25
  13
  30
  23
  4
  34
  20
  6
  22
  19
  26
  27
]
3 0.20 ms
SELECT count(*) AS sclr_0 FROM stock 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\Stock 41

Entities Mapping

Class Mapping errors
App\Entity\Stock No errors.