GET https://new.alles-fuer-selbermacher.de/lagerort?page=57

Response
200 OK
IP
216.73.217.8
Profiled on
Token
85e5a7

Query Metrics

6 Database Queries
6 Different statements
11.36 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
7.89 ms
(69.44%) 		1 
SELECT DISTINCT l0_.id AS id_0, l1_.id AS id_1, l2_.name AS name_2, l3_.name AS name_3, l0_.regalboden AS regalboden_4, l0_.segment AS segment_5 FROM lv_lagerort l0_ LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id ORDER BY l1_.id ASC, l2_.name ASC, l3_.name ASC, l0_.regalboden ASC, l0_.segment ASC LIMIT 50 OFFSET 2800
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.57 ms
(13.83%) 		1 
SELECT l0_.id AS id_0, l0_.regal_id AS regal_id_1, l0_.segment AS segment_2, l0_.regalboden AS regalboden_3, l0_.zusatz AS zusatz_4, l0_.lager_id AS lager_id_5, l0_.lagerbereich_id AS lagerbereich_id_6, l0_.Bemerkungen AS Bemerkungen_7, l0_.delete_if_empty AS delete_if_empty_8, l0_.regal_id AS regal_id_9, l0_.lager_id AS lager_id_10, l0_.lagerbereich_id AS lagerbereich_id_11 FROM lv_lagerort l0_ LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id WHERE l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY l1_.id ASC, l2_.name ASC, l3_.name ASC, l0_.regalboden ASC, l0_.segment ASC
Parameters: 
[
  1483
  1486
  1497
  1473
  1482
  1487
  1496
  1474
  1481
  1488
  1495
  1475
  1480
  1489
  1494
  1476
  1479
  1490
  1493
  1477
  1478
  1491
  1492
  1419
  1426
  1427
  1434
  1435
  1442
  1420
  1425
  1428
  1433
  1436
  1441
  1421
  1424
  1429
  1432
  1437
  1440
  1422
  1423
  1430
  1431
  1438
  1439
  1443
  1450
  1451
]
View formatted query    View runnable query    Explain query
0.56 ms
(4.89%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.attribut_id AS attribut_id_3 FROM lv_lagerbereich t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.50 ms
(4.45%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.to_billbee AS to_billbee_3, t0.is_store AS is_store_4, t0.multi AS multi_5 FROM lv_lager t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
0.44 ms
(3.87%) 		1 
SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lv_lagerort l0_ LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.40 ms
(3.52%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2 FROM lv_regal t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.

Entities Mapping

Class Mapping errors
App\Entity\LvLagerort No errors.
App\Entity\LvLager No errors.
App\Entity\LvLagerbereich No errors.
App\Entity\LvRegal No errors.
App\Entity\OcProduct No errors.