Query Metrics
312
Database Queries
11
Different statements
418.80 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
247.57 ms (59.11%) |
36 |
SELECT COUNT(s0_.id) AS sclr_0 FROM sheet_data s0_ WHERE MONTH(s0_.estimated_final_arrival_date) = ? AND YEAR(s0_.estimated_final_arrival_date) = ?
Parameters:
[ 1 "2022" ] |
66.13 ms (15.79%) |
120 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.percent AS percent_3, t0.type AS type_4 FROM chart_history t0 WHERE t0.date = ? AND t0.type = ? LIMIT 1
Parameters:
[ "2025-01-01" "fidelizacion" ] |
24.27 ms (5.79%) |
12 |
SELECT COUNT(e0_.id) AS sclr_0 FROM empate e0_ WHERE (e0_.open_date BETWEEN ? AND ?) AND e0_.status = 1
Parameters:
[ "2022-01-01 00:00:00" "2022-02-08 00:00:00" ] |
22.62 ms (5.40%) |
12 |
SELECT COUNT(e0_.id) AS sclr_0 FROM empate e0_ WHERE (e0_.open_date BETWEEN ? AND ?) AND e0_.status_reinicio = 1
Parameters:
[ "2022-01-01 00:00:00" "2022-02-08 00:00:00" ] |
18.40 ms (4.39%) |
60 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.percent AS percent_3, t0.type AS type_4 FROM chart_goal t0 WHERE t0.date = ? AND t0.type = ? LIMIT 1
Parameters:
[ "2022-01-01" "empate" ] |
17.73 ms (4.23%) |
12 |
SELECT COUNT(s0_.id) AS sclr_0 FROM solicitud s0_ WHERE s0_.status = 'Cerrada' AND MONTH(s0_.open_date) = ? AND YEAR(s0_.open_date) = ?
Parameters:
[ 1 "2022" ] |
10.10 ms (2.41%) |
12 |
"COMMIT"
Parameters:
[] |
4.56 ms (1.09%) |
12 |
INSERT INTO chart_history (date, percent, type) VALUES (?, ?, ?)
Parameters:
[ 1 => "2025-01-01" 2 => 0.0 3 => "fidelizacion" ] |
3.86 ms (0.92%) |
12 |
SELECT COUNT(f0_.id) AS sclr_0 FROM fidelizacion f0_ WHERE f0_.month = ? AND f0_.fidelizado = 1
Parameters:
[
1
]
|
2.67 ms (0.64%) |
12 |
SELECT COUNT(f0_.id) AS sclr_0 FROM fidelizacion f0_ WHERE f0_.month = ? AND f0_.fidelizado = 0
Parameters:
[
1
]
|
0.91 ms (0.22%) |
12 |
"START TRANSACTION"
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\Fidelizacion | No errors. |
App\Entity\ChartHistory | No errors. |
App\Entity\Solicitud | No errors. |
App\Entity\SheetData | No errors. |
App\Entity\Empate | No errors. |
App\Entity\ChartGoal | No errors. |