GET http://whatsapp.jizen.com.ar/database?page=1&sort%5BultExtraer%5D=DESC

Query Metrics

5 Database Queries
4 Different statements
1.66 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.43 ms
SELECT DISTINCT d0_.id AS id_0, d0_.ult_extraer AS ult_extraer_1 FROM database d0_ ORDER BY d0_.ult_extraer DESC LIMIT 20
Parameters:
[]
2 0.39 ms
SELECT d0_.id AS id_0, d0_.nombre AS nombre_1, d0_.ssh AS ssh_2, d0_.name_db AS name_db_3, d0_.ult_extraer AS ult_extraer_4, d0_.user AS user_5, d0_.pass AS pass_6, d0_.url AS url_7, d0_.direccion AS direccion_8, d0_.telefono AS telefono_9, d0_.create_at AS create_at_10, d0_.update_at AS update_at_11, d0_.create_by_id AS create_by_id_12, d0_.update_by_id AS update_by_id_13 FROM database d0_ WHERE d0_.id IN (?, ?) ORDER BY d0_.ult_extraer DESC
Parameters:
[
  2
  1
]
3 0.22 ms
SELECT count(*) AS sclr_0 FROM database d0_
Parameters:
[]
4 0.39 ms
SELECT t0.id AS id_1, t0.turno_id AS turno_id_2, t0.medico AS medico_3, t0.fecha AS fecha_4, t0.hora AS hora_5, t0.paciente AS paciente_6, t0.link AS link_7, t0.modelo AS modelo_8, t0.telefono AS telefono_9, t0.envio AS envio_10, t0.codigo AS codigo_11, t0.cancelado AS cancelado_12, t0.estado AS estado_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.db_id AS db_id_16, t0.create_by_id AS create_by_id_17, t0.update_by_id AS update_by_id_18 FROM mensaje t0 WHERE (t0.envio IS NULL AND t0.db_id = ?)
Parameters:
[
  2
]
5 0.22 ms
SELECT t0.id AS id_1, t0.turno_id AS turno_id_2, t0.medico AS medico_3, t0.fecha AS fecha_4, t0.hora AS hora_5, t0.paciente AS paciente_6, t0.link AS link_7, t0.modelo AS modelo_8, t0.telefono AS telefono_9, t0.envio AS envio_10, t0.codigo AS codigo_11, t0.cancelado AS cancelado_12, t0.estado AS estado_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.db_id AS db_id_16, t0.create_by_id AS create_by_id_17, t0.update_by_id AS update_by_id_18 FROM mensaje t0 WHERE (t0.envio IS NULL AND t0.db_id = ?)
Parameters:
[
  1
]

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\Database No errors.
App\Entity\Usuario No errors.
App\Entity\Mensaje
  • The association App\Entity\Mensaje#respuestas refers to the owning side field App\Entity\Respuesta#mensaje which does not exist.
App\Entity\Respuesta No errors.