Query Metrics
3
Database Queries
3
Different statements
3847.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3846.92 ms (99.98%) |
1 |
SELECT SUM(t0_.total_ca) AS sclr_0, count(t0_.id) AS sclr_1, t0_.id_point_of_sale AS id_point_of_sale_2, p1_.name AS name_3 FROM tickets t0_ LEFT JOIN points_of_sale p1_ ON (p1_.id_cashmag = t0_.id_point_of_sale) WHERE t0_.id_point_of_sale IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0_.date > ? AND t0_.date < ? GROUP BY t0_.id_point_of_sale
Parameters:
[ 180192 181290 180188 180170 180186 180190 180189 186109 187823 183405 180191 205345 207605 "2026-06-01 01:00:00" "2026-06-01 23:00:00" ] |
|
0.53 ms (0.01%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.22 ms (0.01%) |
1 |
SELECT t0.id AS id_1, t0.id_cashmag AS id_cashmag_2, t0.id_country AS id_country_3, t0.name AS name_4, t0.name_webshop AS name_webshop_5, t0.address AS address_6, t0.postal AS postal_7, t0.enable_credit AS enable_credit_8, t0.enable_order AS enable_order_9, t0.has_alcool AS has_alcool_10, t0.webshop_display_mode AS webshop_display_mode_11, t0.share_capital AS share_capital_12, t0.legal_form AS legal_form_13, t0.logo_base64 AS logo_base64_14, t0.tax_identification AS tax_identification_15, t0.activity_identification AS activity_identification_16, t0.company_identification AS company_identification_17, t0.phone_2 AS phone_2_18, t0.phone AS phone_19, t0.website AS website_20, t0.city AS city_21 FROM points_of_sale t0
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\PointsOfSale | No errors. |
| App\Entity\Tickets | No errors. |