https://helensbakery.boldrdev.nl/boldr-api/cloudprnt/BOLDR123123123

Query Metrics

9 Database Queries
3 Different statements
2.80 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.52 ms
SELECT t1.id AS id_2, t0.secret AS secret_3, t0.template AS template_4, t1.dtype FROM shop_cloudprnt_receipt_printer_configuration t0 INNER JOIN shop_receipt_printer_configuration t1 ON t0.id = t1.id WHERE t0.secret = ?
Parameters:
[
  "BOLDR123123123"
]
2 0.32 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.separate_items_by_category AS separate_items_by_category_3, t0.restrict_items_by_category AS restrict_items_by_category_4, t0.name AS name_5, t0.locale AS locale_6, t0.driver AS driver_7, t0.configuration_id AS configuration_id_8 FROM shop_receipt_printer t0 WHERE t0.configuration_id = ?
Parameters:
[
  1
]
3 0.27 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.separate_items_by_category AS separate_items_by_category_3, t0.restrict_items_by_category AS restrict_items_by_category_4, t0.name AS name_5, t0.locale AS locale_6, t0.driver AS driver_7, t0.configuration_id AS configuration_id_8 FROM shop_receipt_printer t0 WHERE t0.configuration_id = ?
Parameters:
[
  2
]
4 0.25 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.separate_items_by_category AS separate_items_by_category_3, t0.restrict_items_by_category AS restrict_items_by_category_4, t0.name AS name_5, t0.locale AS locale_6, t0.driver AS driver_7, t0.configuration_id AS configuration_id_8 FROM shop_receipt_printer t0 WHERE t0.configuration_id = ?
Parameters:
[
  3
]
5 0.24 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.separate_items_by_category AS separate_items_by_category_3, t0.restrict_items_by_category AS restrict_items_by_category_4, t0.name AS name_5, t0.locale AS locale_6, t0.driver AS driver_7, t0.configuration_id AS configuration_id_8 FROM shop_receipt_printer t0 WHERE t0.configuration_id = ?
Parameters:
[
  4
]
6 0.23 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.separate_items_by_category AS separate_items_by_category_3, t0.restrict_items_by_category AS restrict_items_by_category_4, t0.name AS name_5, t0.locale AS locale_6, t0.driver AS driver_7, t0.configuration_id AS configuration_id_8 FROM shop_receipt_printer t0 WHERE t0.configuration_id = ?
Parameters:
[
  5
]
7 0.24 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.separate_items_by_category AS separate_items_by_category_3, t0.restrict_items_by_category AS restrict_items_by_category_4, t0.name AS name_5, t0.locale AS locale_6, t0.driver AS driver_7, t0.configuration_id AS configuration_id_8 FROM shop_receipt_printer t0 WHERE t0.configuration_id = ?
Parameters:
[
  7
]
8 0.29 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.separate_items_by_category AS separate_items_by_category_3, t0.restrict_items_by_category AS restrict_items_by_category_4, t0.name AS name_5, t0.locale AS locale_6, t0.driver AS driver_7, t0.configuration_id AS configuration_id_8 FROM shop_receipt_printer t0 WHERE t0.configuration_id = ?
Parameters:
[
  8
]
9 0.45 ms
SELECT s0_.id AS id_0, s0_.state AS state_1, s0_.time_created AS time_created_2, s0_.printer_id AS printer_id_3 FROM shop_receipt_printer_receipt s0_ WHERE s0_.printer_id IN (?) AND s0_.state IN (?)
Parameters:
[
  [
    1
    2
    3
    4
    5
    7
    8
  ]
  [
    "unknown"
    "queued"
  ]
]

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
Boldr\Shop\ReceiptPrinterBundle\Entity\PrinterConfiguration No errors.
Boldr\Shop\CloudPrntReceiptPrinterBundle\Entity\CloudPrntPrinterConfiguration No errors.
Boldr\Shop\ReceiptPrinterBundle\Entity\Printer No errors.
Boldr\Shop\ReceiptPrinterBundle\Entity\PrinterCategory No errors.
Boldr\Shop\ShopBundle\Entity\Category No errors.
Boldr\Shop\ReceiptPrinterBundle\Entity\Receipt No errors.