GET https://api-dev-bdw.softmena.dev/api/chat/conversations

Query Metrics

5 Database Queries
5 Different statements
4.32 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.44 ms
SET time_zone = '-03:00'
Parameters:
[]
2 1.06 ms
SELECT u0_.id AS id_0, u0_.uid AS uid_1, u0_.slug AS slug_2, u0_.email AS email_3, u0_.password AS password_4, u0_.fcm_token AS fcm_token_5, u0_.roles AS roles_6, u0_.username AS username_7, u0_.first_name AS first_name_8, u0_.last_name AS last_name_9, u0_.dni AS dni_10, u0_.phone_number AS phone_number_11, u0_.newsletter_active AS newsletter_active_12, u0_.created_at AS created_at_13, u0_.updated_at AS updated_at_14, u0_.is_active AS is_active_15, u0_.status AS status_16, u0_.type_account AS type_account_17, u0_.response_firebase AS response_firebase_18, u0_.faqs AS faqs_19, u0_.verification_token AS verification_token_20, u0_.onboarding_token AS onboarding_token_21, u0_.onboarding_token_expires_at AS onboarding_token_expires_at_22, u0_.email_verification_code AS email_verification_code_23, u0_.is_email_verified AS is_email_verified_24, u0_.email_verification_code_expires_at AS email_verification_code_expires_at_25, u0_.last_verification_code_sent_at AS last_verification_code_sent_at_26, u0_.reset_password_token AS reset_password_token_27, u0_.reset_token_expires_at AS reset_token_expires_at_28, u0_.permissions AS permissions_29, u0_.completed_consultations AS completed_consultations_30, u0_.msp_number AS msp_number_31, u0_.msp_verification_status AS msp_verification_status_32 FROM `user` u0_ WHERE (u0_.username = ? OR u0_.email = ?) AND u0_.status <> ?
Parameters:
[
  "softmenaia@gmail.com"
  "softmenaia@gmail.com"
  "deleted"
]
3 1.05 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.date_birth AS date_birth_3, t0.gender AS gender_4, t0.country AS country_5, t0.city AS city_6, t0.zipcode AS zipcode_7, t0.address AS address_8, t0.language AS language_9, t0.about AS about_10, t0.phone AS phone_11, t0.time_availability AS time_availability_12, t0.policies AS policies_13, t0.health_data_consent AS health_data_consent_14, t0.professional_declaration AS professional_declaration_15, t0.medical_condition AS medical_condition_16, t0.consult_time AS consult_time_17, t0.short_description AS short_description_18, t0.banner_image AS banner_image_19, t0.image_original AS image_original_20, t0.image_params AS image_params_21, t0.banner_image_original AS banner_image_original_22, t0.banner_image_params AS banner_image_params_23, t0.professional_info AS professional_info_24, t0.consult_type AS consult_type_25, t0.consult_price AS consult_price_26, t0.account_number AS account_number_27, t0.holder_name AS holder_name_28, t0.bank_name AS bank_name_29, t0.profile_media_type AS profile_media_type_30, t0.profile_video_url AS profile_video_url_31, t0.rejection_reason AS rejection_reason_32, t0.booking_mode AS booking_mode_33, t0.messaging_enabled AS messaging_enabled_34, t0.request_schedule AS request_schedule_35, t0.pricing_mode AS pricing_mode_36, t0.initial_price AS initial_price_37, t0.initial_duration AS initial_duration_38, t0.followup_price AS followup_price_39, t0.followup_duration AS followup_duration_40, t0.currency AS currency_41, t0.user_id AS user_id_42, t0.base_profession_id AS base_profession_id_43, t0.dimension_id AS dimension_id_44, t0.main_specialty_id AS main_specialty_id_45, t0.actividad_principal_study_id AS actividad_principal_study_id_46 FROM user_details t0 WHERE t0.user_id = ?
Parameters:
[
  134
]
4 0.52 ms
SELECT t0.id AS id_1, t0.uid AS uid_2, t0.status AS status_3, t0.available_balance AS available_balance_4, t0.frozen_balance AS frozen_balance_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.professional_id AS professional_id_8 FROM professional_wallets t0 WHERE t0.professional_id = ?
Parameters:
[
  134
]
5 1.25 ms
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.patient_id AS patient_id_3, c0_.professional_id AS professional_id_4 FROM conversation c0_ LEFT JOIN `user` u1_ ON c0_.patient_id = u1_.id LEFT JOIN `user` u2_ ON c0_.professional_id = u2_.id WHERE c0_.patient_id = ? OR c0_.professional_id = ? ORDER BY c0_.updated_at DESC
Parameters:
[
  134
  134
]

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\User 1
App\Entity\UserDetails 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\UserDetails No errors.
App\Entity\Profession No errors.
App\Entity\Dimension No errors.
App\Entity\Specialty No errors.
App\Entity\Studies No errors.
App\Entity\ProfessionalWallet No errors.
App\Entity\Booking No errors.
App\Entity\Availability No errors.
App\Entity\Withdrawal No errors.
App\Entity\Refund No errors.
App\Entity\Conversation No errors.