Query Metrics
3
Database Queries
3
Different statements
17.78 ms
Query time
0
Invalid entities
50
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 9.93 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM stock s0_ ORDER BY s0_.id DESC LIMIT 50 OFFSET 35000
Parameters:
[] |
| 2 | 1.57 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_.id DESC
Parameters:
[ 1159 1158 1157 1156 1155 1154 1153 1152 1151 1150 1149 1148 1147 1146 1145 1144 1143 1142 1141 1140 1139 1138 1137 1136 1135 1134 1133 1132 1131 1130 1129 1128 1127 1126 1125 1124 1123 1122 1121 1120 1119 1118 1117 1116 1115 1114 1113 1112 1111 1110 ] |
| 3 | 6.29 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 | 50 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Stock | No errors. |