GET https://intra.quercus.palustris.dk/api/text_signs?itemsPerPage=10&order%5Bid%5D=ASC&page=1

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.61 ms
(41.20%)
1
SELECT t0.user_id AS user_id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.display_name AS display_name_6, t0.info AS info_7, t0.last_login AS last_login_8, t0.last_login_from AS last_login_from_9, t0.state AS state_10 FROM tbl_users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "mads@gartneriet.dk"
]
1.54 ms
(39.43%)
1
SELECT count(DISTINCT t0_.id) AS sclr_0 FROM text_sign t0_ INNER JOIN printers p1_ ON t0_.printer_id_id = p1_.id
Parameters:
[]
0.76 ms
(19.37%)
1
SELECT t0_.id AS id_0, t0_.do_print AS do_print_1, t0_.copies AS copies_2, t0_.textboxes AS textboxes_3, t0_.name AS name_4, t0_.dpi AS dpi_5, t0_.pixels_pr_mm AS pixels_pr_mm_6, t0_.imagedata AS imagedata_7, t0_.created AS created_8, t0_.updated AS updated_9, p1_.id AS id_10, p1_.name AS name_11, p1_.ip AS ip_12, p1_.dpi AS dpi_13, p1_.label_width_mm AS label_width_mm_14, p1_.label_height_mm AS label_height_mm_15, p1_.model AS model_16, p1_.config AS config_17, p1_.label_name AS label_name_18, p1_.label_description AS label_description_19, p1_.rotate AS rotate_20, p1_.twig_template AS twig_template_21, p1_.print_language AS print_language_22, t0_.printer_id_id AS printer_id_id_23 FROM text_sign t0_ INNER JOIN printers p1_ ON t0_.printer_id_id = p1_.id ORDER BY t0_.id ASC LIMIT 10
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\TextSign 6
App\Entity\Printers 2
App\Entity\Users 1

Entities Mapping