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

Response
200 OK
Browse referrer URL
IP
190.6.49.11
Profiled on
Token
5603fd

Query Metrics

9 Database Queries
7 Different statements
8.64 ms Query time
0 Invalid entities
39 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.37 ms
(27.46%) 		2 
SELECT t0.id AS id_1, t0.uid AS uid_2, t0.slug AS slug_3, t0.email AS email_4, t0.password AS password_5, t0.fcm_token AS fcm_token_6, t0.roles AS roles_7, t0.username AS username_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.dni AS dni_11, t0.phone_number AS phone_number_12, t0.newsletter_active AS newsletter_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.is_active AS is_active_16, t0.status AS status_17, t0.type_account AS type_account_18, t0.response_firebase AS response_firebase_19, t0.faqs AS faqs_20, t0.verification_token AS verification_token_21, t0.onboarding_token AS onboarding_token_22, t0.onboarding_token_expires_at AS onboarding_token_expires_at_23, t0.email_verification_code AS email_verification_code_24, t0.is_email_verified AS is_email_verified_25, t0.email_verification_code_expires_at AS email_verification_code_expires_at_26, t0.last_verification_code_sent_at AS last_verification_code_sent_at_27, t0.reset_password_token AS reset_password_token_28, t0.reset_token_expires_at AS reset_token_expires_at_29, t0.permissions AS permissions_30, t0.completed_consultations AS completed_consultations_31, t0.msp_number AS msp_number_32, t0.msp_verification_status AS msp_verification_status_33, t34.id AS id_35, t34.image AS image_36, t34.date_birth AS date_birth_37, t34.gender AS gender_38, t34.country AS country_39, t34.city AS city_40, t34.zipcode AS zipcode_41, t34.address AS address_42, t34.language AS language_43, t34.about AS about_44, t34.phone AS phone_45, t34.time_availability AS time_availability_46, t34.policies AS policies_47, t34.health_data_consent AS health_data_consent_48, t34.professional_declaration AS professional_declaration_49, t34.medical_condition AS medical_condition_50, t34.consult_time AS consult_time_51, t34.short_description AS short_description_52, t34.banner_image AS banner_image_53, t34.image_original AS image_original_54, t34.image_params AS image_params_55, t34.banner_image_original AS banner_image_original_56, t34.banner_image_params AS banner_image_params_57, t34.professional_info AS professional_info_58, t34.consult_type AS consult_type_59, t34.consult_price AS consult_price_60, t34.account_number AS account_number_61, t34.holder_name AS holder_name_62, t34.bank_name AS bank_name_63, t34.profile_media_type AS profile_media_type_64, t34.profile_video_url AS profile_video_url_65, t34.rejection_reason AS rejection_reason_66, t34.booking_mode AS booking_mode_67, t34.messaging_enabled AS messaging_enabled_68, t34.request_schedule AS request_schedule_69, t34.pricing_mode AS pricing_mode_70, t34.initial_price AS initial_price_71, t34.initial_duration AS initial_duration_72, t34.followup_price AS followup_price_73, t34.followup_duration AS followup_duration_74, t34.currency AS currency_75, t34.user_id AS user_id_76, t34.base_profession_id AS base_profession_id_77, t34.dimension_id AS dimension_id_78, t34.main_specialty_id AS main_specialty_id_79, t34.actividad_principal_study_id AS actividad_principal_study_id_80, t81.id AS id_82, t81.uid AS uid_83, t81.status AS status_84, t81.available_balance AS available_balance_85, t81.frozen_balance AS frozen_balance_86, t81.created_at AS created_at_87, t81.updated_at AS updated_at_88, t81.professional_id AS professional_id_89 FROM `user` t0 LEFT JOIN user_details t34 ON t34.user_id = t0.id LEFT JOIN professional_wallets t81 ON t81.professional_id = t0.id WHERE t0.id = ?
Parameters: 
[
  116
]
View formatted query    View runnable query    Explain query    View query backtrace
1.63 ms
(18.86%) 		2 
SELECT t0.id AS id_1, t0.message_text AS message_text_2, t0.is_read AS is_read_3, t0.created_at AS created_at_4, t0.message_type AS message_type_5, t0.metadata AS metadata_6, t0.conversation_id AS conversation_id_7, t0.sender_id AS sender_id_8 FROM chat_message t0 WHERE t0.conversation_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(14.39%) 		1 
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: 
[
  115
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(12.78%) 		1 
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: 
[
  "osmelmenavera@gmail.com"
  "osmelmenavera@gmail.com"
  "deleted"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.09 ms
(12.67%) 		1 
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: 
[
  115
  115
]
View formatted query    View runnable query    Explain query    View query backtrace
0.79 ms
(9.16%) 		1 
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: 
[
  115
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(4.69%) 		1 
SET time_zone = '-03:00'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\ChatMessage 25
App\Entity\User 3
App\Entity\UserDetails 3
App\Entity\ProfessionalWallet 3
App\Entity\Conversation 2
App\Entity\Profession 1
App\Entity\Specialty 1
App\Entity\Studies 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\WalletLedger 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.
App\Entity\ChatMessage No errors.