GET https://iview-sy.com/api/iv_messages

Query Metrics

2 Database Queries
2 Different statements
0.79 ms Query time
0 Invalid entities
8 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
0.52 ms
(65.32%)
1
SELECT m0_.id AS id_0, m0_.mtype AS mtype_1, m0_.mnat AS mnat_2, m0_.mtext AS mtext_3, m0_.mgender AS mgender_4, m0_.mage AS mage_5, m0_.create_date AS create_date_6, m0_.update_date AS update_date_7, m0_.receiver_id AS receiver_id_8, m0_.mcity_id AS mcity_id_9, m0_.created_by_id AS created_by_id_10, m0_.updated_by_id AS updated_by_id_11 FROM messages m0_ WHERE (m0_.mtype IN (1, 2, 4) AND m0_.receiver_id = ?) OR m0_.mtype = 3 ORDER BY m0_.id DESC
Parameters:
[
  385
]
0.27 ms
(34.68%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.full_name AS full_name_4, t0.first_name AS first_name_5, t0.father_name AS father_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.birth_year AS birth_year_9, t0.ucode AS ucode_10, t0.altucode AS altucode_11, t0.alt_cway AS alt_cway_12, t0.join_date AS join_date_13, t0.image AS image_14, t0.roles AS roles_15, t0.password AS password_16, t0.mobile AS mobile_17, t0.status AS status_18, t0.cway AS cway_19, t0.vcode AS vcode_20, t0.share AS share_21, t0.type AS type_22, t0.gender AS gender_23, t0.token AS token_24, t0.city_id AS city_id_25, t0.center_id AS center_id_26, t0.created_by_id AS created_by_id_27 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  385
]

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\Messages 4
App\Entity\User 2
App\Entity\City 2

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\City No errors.
App\Entity\ServiceCenter No errors.
App\Entity\Messages No errors.