http://zenixsystem.com.mx/graficas?year=2022

Query Metrics

312 Database Queries
11 Different statements
418.80 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.