Skip to content

Instantly share code, notes, and snippets.

@TanjinAlam

TanjinAlam/gist:bfff499578357ed30ec55dfa454a0de3

Created May 9, 2025 16:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save TanjinAlam/bfff499578357ed30ec55dfa454a0de3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save TanjinAlam/bfff499578357ed30ec55dfa454a0de3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
# Time: 2025-05-01T05:55:40.192599Z
# User@Host: shukhee_prod_user[shukhee_prod_user] @ [10.0.54.117] Id: 846832
# Query_time: 183.172190 Lock_time: 0.000004 Rows_sent: 10 Rows_examined: 12014129
SET timestamp=1746078757;
SELECT DISTINCT `distinctAlias`.`PatientPackage_id` AS `ids_PatientPackage_id`, `distinctAlias`.`PatientPackage_createdAt` FROM (SELECT `PatientPackage`.`id` AS `PatientPackage_id`, `PatientPackage`.`uuid` AS `PatientPackage_uuid`, `PatientPackage`.`createdAt` AS `PatientPackage_createdAt`, `PatientPackage`.`updatedAt` AS `PatientPackage_updatedAt`, `PatientPackage`.`name` AS `PatientPackage_name`, `PatientPackage`.`packageType` AS `PatientPackage_packageType`, `PatientPackage`.`description` AS `PatientPackage_description`, `PatientPackage`.`terms` AS `PatientPackage_terms`, `PatientPackage`.`userNumber` AS `PatientPackage_userNumber`, `PatientPackage`.`timePeriod` AS `PatientPackage_timePeriod`, `PatientPackage`.`price` AS `PatientPackage_price`, `PatientPackage`.`status` AS `PatientPackage_status`, `PatientPackage`.`paymentStatus` AS `PatientPackage_paymentStatus`, `PatientPackage`.`serviceStatus` AS `PatientPackage_serviceStatus`, `PatientPackage`.`requestRemarks` AS `PatientPackage_requestRemarks`, `PatientPackage`.`purchasedAt` AS `PatientPackage_purchasedAt`, `PatientPackage`.`expiredAt` AS `PatientPackage_expiredAt`, `PatientPackage`.`canceledAt` AS `PatientPackage_canceledAt`, `PatientPackage`.`createdBy` AS `PatientPackage_createdBy`, `PatientPackage`.`creatorType` AS `PatientPackage_creatorType`, `PatientPackage`.`channel` AS `PatientPackage_channel`, `PatientPackage`.`patientId` AS `PatientPackage_patientId`, `PatientPackage`.`subscriptionPackageId` AS `PatientPackage_subscriptionPackageId`, `PatientPackage__PatientPackage_patient`.`id` AS `PatientPackage__PatientPackage_patient_id`, `PatientPackage__PatientPackage_patient`.`name` AS `PatientPackage__PatientPackage_patient_name`, `PatientPackage__PatientPackage_patient`.`organizationEmployeeId` AS `PatientPackage__PatientPackage_patient_organizationEmployeeId`, `PatientPackage__PatientPackage_patient`.`nid` AS `PatientPackage__PatientPackage_patient_nid`, `PatientPackage__PatientPackage_patient`.`mobile` AS `PatientPackage__PatientPackage_patient_mobile`, `PatientPackage__PatientPackage_patient`.`gender` AS `PatientPackage__PatientPackage_patient_gender`, `PatientPackage__PatientPackage_patient`.`profilePic` AS `PatientPackage__PatientPackage_patient_profilePic`, `PatientPackage__PatientPackage_patient`.`dob` AS `PatientPackage__PatientPackage_patient_dob`, `PatientPackage__PatientPackage_patient`.`height` AS `PatientPackage__PatientPackage_patient_height`, `PatientPackage__PatientPackage_patient`.`weight` AS `PatientPackage__PatientPackage_patient_weight`, `PatientPackage__PatientPackage_patient`.`diseases` AS `PatientPackage__PatientPackage_patient_diseases`, `PatientPackage__PatientPackage_patient`.`email` AS `PatientPackage__PatientPackage_patient_email`, `PatientPackage__PatientPackage_patient`.`patientUniqueId` AS `PatientPackage__PatientPackage_patient_patientUniqueId`, `PatientPackage__PatientPackage_patient`.`password` AS `PatientPackage__PatientPackage_patient_password`, `PatientPackage__PatientPackage_patient`.`isActive` AS `PatientPackage__PatientPackage_patient_isActive`, `PatientPackage__PatientPackage_patient`.`createdById` AS `PatientPackage__PatientPackage_patient_createdById`, `PatientPackage__PatientPackage_patient`.`createdByType` AS `PatientPackage__PatientPackage_patient_createdByType`, `PatientPackage__PatientPackage_patient`.`source` AS `PatientPackage__PatientPackage_patient_source`, `PatientPackage__PatientPackage_patient`.`createdAt` AS `PatientPackage__PatientPackage_patient_createdAt`, `PatientPackage__PatientPackage_patient`.`updatedAt` AS `PatientPackage__PatientPackage_patient_updatedAt`, `PatientPackage__PatientPackage_patient`.`deletedAt` AS `PatientPackage__PatientPackage_patient_deletedAt`, `PatientPackage__PatientPackage_patient`.`b2bClientId` AS `PatientPackage__PatientPackage_patient_b2bClientId`, `PatientPackage__PatientPackage_patient`.`organizationId` AS `PatientPackage__PatientPackage_patient_organizationId`, `PatientPackage__PatientPackage_patient`.`divisionId` AS `PatientPackage__PatientPackage_patient_divisionId`, `PatientPackage__PatientPackage_patient`.`districtId` AS `PatientPackage__PatientPackage_patient_districtId`, `PatientPackage__PatientPackage_patient`.`areaId` AS `PatientPackage__PatientPackage_patient_areaId`, `PatientPackage__PatientPackage_subscriptionPackage`.`id` AS `PatientPackage__PatientPackage_subscriptionPackage_id`, `PatientPackage__PatientPackage_packageServices`.`id` AS `PatientPackage__PatientPackage_packageServices_id`, `PatientPackage__PatientPackage_packageServices`.`uuid` AS `PatientPackage__PatientPackage_packageServices_uuid`, `PatientPackage__PatientPackage_packageServices`.`createdAt` AS `PatientPackage__PatientPackage_packageServices_createdAt`, `PatientPackage__PatientPackage_packageServices`.`updatedAt` AS `PatientPackage__PatientPackage_packageServices_updatedAt`, `PatientPackage__PatientPackage_packageServices`.`slug` AS `PatientPackage__PatientPackage_packageServices_slug`, `PatientPackage__PatientPackage_packageServices`.`serviceType` AS `PatientPackage__PatientPackage_packageServices_serviceType`, `PatientPackage__PatientPackage_packageServices`.`value` AS `PatientPackage__PatientPackage_packageServices_value`, `PatientPackage__PatientPackage_packageServices`.`capAmount` AS `PatientPackage__PatientPackage_packageServices_capAmount`, `PatientPackage__PatientPackage_packageServices`.`numberOfUsage` AS `PatientPackage__PatientPackage_packageServices_numberOfUsage`, `PatientPackage__PatientPackage_packageServices`.`description` AS `PatientPackage__PatientPackage_packageServices_description`, `PatientPackage__PatientPackage_packageServices`.`remainingLimit` AS `PatientPackage__PatientPackage_packageServices_remainingLimit`, `PatientPackage__PatientPackage_packageServices`.`patientId` AS `PatientPackage__PatientPackage_packageServices_patientId`, `PatientPackage__PatientPackage_packageServices`.`patientPackageId` AS `PatientPackage__PatientPackage_packageServices_patientPackageId`, `PatientPackage__PatientPackage_packageServices`.`serviceId` AS `PatientPackage__PatientPackage_packageServices_serviceId`, `00cb3e58292b062565c105e677afe3d980a5faef`.`id` AS `00cb3e58292b062565c105e677afe3d980a5faef_id`, `00cb3e58292b062565c105e677afe3d980a5faef`.`uuid` AS `00cb3e58292b062565c105e677afe3d980a5faef_uuid`, `00cb3e58292b062565c105e677afe3d980a5faef`.`createdAt` AS `00cb3e58292b062565c105e677afe3d980a5faef_createdAt`, `00cb3e58292b062565c105e677afe3d980a5faef`.`updatedAt` AS `00cb3e58292b062565c105e677afe3d980a5faef_updatedAt`, `00cb3e58292b062565c105e677afe3d980a5faef`.`name` AS `00cb3e58292b062565c105e677afe3d980a5faef_name`, `00cb3e58292b062565c105e677afe3d980a5faef`.`slug` AS `00cb3e58292b062565c105e677afe3d980a5faef_slug`, `00cb3e58292b062565c105e677afe3d980a5faef`.`status` AS `00cb3e58292b062565c105e677afe3d980a5faef_status`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`id` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_id`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`uuid` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_uuid`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`createdAt` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_createdAt`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`updatedAt` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_updatedAt`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`patientPackage` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_patientPackage`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`slug` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_slug`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`referenceId` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_referenceId`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`remarks` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_remarks`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`patientId` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_patientId`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`patientPackageServiceId` AS `f255983d7dae0a98a631d46012390de05aeb7b4e`, `PatientPackage__PatientPackage_patientPackageInsurance`.`id` AS `PatientPackage__PatientPackage_patientPackageInsurance_id`, `PatientPackage__PatientPackage_patientPackageInsurance`.`uuid` AS `PatientPackage__PatientPackage_patientPackageInsurance_uuid`, `PatientPackage__PatientPackage_patientPackageInsurance`.`createdAt` AS `465bb8e6cb4f76176f7874206b2b714754990872`, `PatientPackage__PatientPackage_patientPackageInsurance`.`updatedAt` AS `4a329a7834bb8300a8bd18c54d117406ff40d3b0`, `PatientPackage__PatientPackage_patientPackageInsurance`.`insuranceMemberId` AS `f3bdc9fb3f2c02f8dd0da4fa52b5989a889667ef`, `PatientPackage__PatientPackage_patientPackageInsurance`.`memberName` AS `2098728d3966d85428be138a3748007fea679972`, `PatientPackage__PatientPackage_patientPackageInsurance`.`mobile` AS `PatientPackage__PatientPackage_patientPackageInsurance_mobile`, `PatientPackage__PatientPackage_patientPackageInsurance`.`nid` AS `PatientPackage__PatientPackage_patientPackageInsurance_nid`, `PatientPackage__PatientPackage_patientPackageInsurance`.`nomineeName` AS `0f3d3d946092ddec01ed58400a5406e1ef9b7d53`, `PatientPackage__PatientPackage_patientPackageInsurance`.`nomineeNID` AS `97352cee097fa5d5367f8dbb16fee28c287753d4`, `PatientPackage__PatientPackage_patientPackageInsurance`.`nomineeMobile` AS `eb45d4d4a46235d3cb0e3eac6bda8f0ee3aae4f1`, `PatientPackage__PatientPackage_patientPackageInsurance`.`relationshipWithNominee` AS `f687e034df9d3babf25b267cd93a2b11f76a46c7`, `PatientPackage__PatientPackage_patientPackageInsurance`.`patientPackageId` AS `7ef66db60923f308cab26ed29448bcdbd69d5f05`, `PatientPackage__PatientPackage_patientPackageInsurance`.`patientId` AS `40c5c6c1cab4b34327ec0f492a330c8099d7d270`, `PatientPackage__PatientPackage_patientPackageInsurance`.`subscriptionPackageId` AS `0e21a40f8f11f4c5031ed583e96741d694d5c092`, `PatientPackage__PatientPackage_patientPackageInsurance`.`insuranceProviderId` AS `4b2f9116a904f328fa5ce8dcf326d2d80ec09314` FROM `patient_package` `PatientPackage` LEFT JOIN `patient` `PatientPackage__PatientPackage_patient` ON `PatientPackage__PatientPackage_patient`.`id`=`PatientPackage`.`patientId` AND (`PatientPackage__PatientPackage_patient`.`deletedAt` IS NULL) LEFT JOIN `subscription_package` `PatientPackage__PatientPackage_subscriptionPackage` ON `PatientPackage__PatientPackage_subscriptionPackage`.`id`=`PatientPackage`.`subscriptionPackageId` AND (`PatientPackage__PatientPackage_subscriptionPackage`.`deletedAt` IS NULL) LEFT JOIN `patient_package_service` `PatientPackage__PatientPackage_packageServices` ON `PatientPackage__PatientPackage_packageServices`.`patientPackageId`=`PatientPackage`.`id` AND (`PatientPackage__PatientPackage_packageServices`.`deletedAt` IS NULL) LEFT JOIN `service` `00cb3e58292b062565c105e677afe3d980a5faef` ON `00cb3e58292b062565c105e677afe3d980a5faef`.`id`=`PatientPackage__PatientPackage_packageServices`.`serviceId` AND (`00cb3e58292b062565c105e677afe3d980a5faef`.`deletedAt` IS NULL) LEFT JOIN `patient_package_service_history` `2fa963bb63e2faa246988848a2da0d0b63bdd037` ON `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`patientId`=`PatientPackage__PatientPackage_packageServices`.`id` AND (`2fa963bb63e2faa246988848a2da0d0b63bdd037`.`deletedAt` IS NULL) LEFT JOIN `patient_package_insurance` `PatientPackage__PatientPackage_patientPackageInsurance` ON `PatientPackage__PatientPackage_patientPackageInsurance`.`patientPackageId`=`PatientPackage`.`id` AND (`PatientPackage__PatientPackage_patientPackageInsurance`.`deletedAt` IS NULL) WHERE `PatientPackage`.`deletedAt` IS NULL) `distinctAlias` ORDER BY `distinctAlias`.`PatientPackage_createdAt` DESC, `PatientPackage_id` ASC LIMIT 10;
# Time: 2025-05-01T06:24:13.631871Z
# User@Host: shukhee_prod_user[shukhee_prod_user] @ [10.0.54.117] Id: 846835
# Query_time: 115.306981 Lock_time: 0.000004 Rows_sent: 10 Rows_examined: 12014144
SET timestamp=1746080538;
SELECT DISTINCT `distinctAlias`.`PatientPackage_id` AS `ids_PatientPackage_id`, `distinctAlias`.`PatientPackage_createdAt` FROM (SELECT `PatientPackage`.`id` AS `PatientPackage_id`, `PatientPackage`.`uuid` AS `PatientPackage_uuid`, `PatientPackage`.`createdAt` AS `PatientPackage_createdAt`, `PatientPackage`.`updatedAt` AS `PatientPackage_updatedAt`, `PatientPackage`.`name` AS `PatientPackage_name`, `PatientPackage`.`packageType` AS `PatientPackage_packageType`, `PatientPackage`.`description` AS `PatientPackage_description`, `PatientPackage`.`terms` AS `PatientPackage_terms`, `PatientPackage`.`userNumber` AS `PatientPackage_userNumber`, `PatientPackage`.`timePeriod` AS `PatientPackage_timePeriod`, `PatientPackage`.`price` AS `PatientPackage_price`, `PatientPackage`.`status` AS `PatientPackage_status`, `PatientPackage`.`paymentStatus` AS `PatientPackage_paymentStatus`, `PatientPackage`.`serviceStatus` AS `PatientPackage_serviceStatus`, `PatientPackage`.`requestRemarks` AS `PatientPackage_requestRemarks`, `PatientPackage`.`purchasedAt` AS `PatientPackage_purchasedAt`, `PatientPackage`.`expiredAt` AS `PatientPackage_expiredAt`, `PatientPackage`.`canceledAt` AS `PatientPackage_canceledAt`, `PatientPackage`.`createdBy` AS `PatientPackage_createdBy`, `PatientPackage`.`creatorType` AS `PatientPackage_creatorType`, `PatientPackage`.`channel` AS `PatientPackage_channel`, `PatientPackage`.`patientId` AS `PatientPackage_patientId`, `PatientPackage`.`subscriptionPackageId` AS `PatientPackage_subscriptionPackageId`, `PatientPackage__PatientPackage_patient`.`id` AS `PatientPackage__PatientPackage_patient_id`, `PatientPackage__PatientPackage_patient`.`name` AS `PatientPackage__PatientPackage_patient_name`, `PatientPackage__PatientPackage_patient`.`organizationEmployeeId` AS `PatientPackage__PatientPackage_patient_organizationEmployeeId`, `PatientPackage__PatientPackage_patient`.`nid` AS `PatientPackage__PatientPackage_patient_nid`, `PatientPackage__PatientPackage_patient`.`mobile` AS `PatientPackage__PatientPackage_patient_mobile`, `PatientPackage__PatientPackage_patient`.`gender` AS `PatientPackage__PatientPackage_patient_gender`, `PatientPackage__PatientPackage_patient`.`profilePic` AS `PatientPackage__PatientPackage_patient_profilePic`, `PatientPackage__PatientPackage_patient`.`dob` AS `PatientPackage__PatientPackage_patient_dob`, `PatientPackage__PatientPackage_patient`.`height` AS `PatientPackage__PatientPackage_patient_height`, `PatientPackage__PatientPackage_patient`.`weight` AS `PatientPackage__PatientPackage_patient_weight`, `PatientPackage__PatientPackage_patient`.`diseases` AS `PatientPackage__PatientPackage_patient_diseases`, `PatientPackage__PatientPackage_patient`.`email` AS `PatientPackage__PatientPackage_patient_email`, `PatientPackage__PatientPackage_patient`.`patientUniqueId` AS `PatientPackage__PatientPackage_patient_patientUniqueId`, `PatientPackage__PatientPackage_patient`.`password` AS `PatientPackage__PatientPackage_patient_password`, `PatientPackage__PatientPackage_patient`.`isActive` AS `PatientPackage__PatientPackage_patient_isActive`, `PatientPackage__PatientPackage_patient`.`createdById` AS `PatientPackage__PatientPackage_patient_createdById`, `PatientPackage__PatientPackage_patient`.`createdByType` AS `PatientPackage__PatientPackage_patient_createdByType`, `PatientPackage__PatientPackage_patient`.`source` AS `PatientPackage__PatientPackage_patient_source`, `PatientPackage__PatientPackage_patient`.`createdAt` AS `PatientPackage__PatientPackage_patient_createdAt`, `PatientPackage__PatientPackage_patient`.`updatedAt` AS `PatientPackage__PatientPackage_patient_updatedAt`, `PatientPackage__PatientPackage_patient`.`deletedAt` AS `PatientPackage__PatientPackage_patient_deletedAt`, `PatientPackage__PatientPackage_patient`.`b2bClientId` AS `PatientPackage__PatientPackage_patient_b2bClientId`, `PatientPackage__PatientPackage_patient`.`organizationId` AS `PatientPackage__PatientPackage_patient_organizationId`, `PatientPackage__PatientPackage_patient`.`divisionId` AS `PatientPackage__PatientPackage_patient_divisionId`, `PatientPackage__PatientPackage_patient`.`districtId` AS `PatientPackage__PatientPackage_patient_districtId`, `PatientPackage__PatientPackage_patient`.`areaId` AS `PatientPackage__PatientPackage_patient_areaId`, `PatientPackage__PatientPackage_subscriptionPackage`.`id` AS `PatientPackage__PatientPackage_subscriptionPackage_id`, `PatientPackage__PatientPackage_packageServices`.`id` AS `PatientPackage__PatientPackage_packageServices_id`, `PatientPackage__PatientPackage_packageServices`.`uuid` AS `PatientPackage__PatientPackage_packageServices_uuid`, `PatientPackage__PatientPackage_packageServices`.`createdAt` AS `PatientPackage__PatientPackage_packageServices_createdAt`, `PatientPackage__PatientPackage_packageServices`.`updatedAt` AS `PatientPackage__PatientPackage_packageServices_updatedAt`, `PatientPackage__PatientPackage_packageServices`.`slug` AS `PatientPackage__PatientPackage_packageServices_slug`, `PatientPackage__PatientPackage_packageServices`.`serviceType` AS `PatientPackage__PatientPackage_packageServices_serviceType`, `PatientPackage__PatientPackage_packageServices`.`value` AS `PatientPackage__PatientPackage_packageServices_value`, `PatientPackage__PatientPackage_packageServices`.`capAmount` AS `PatientPackage__PatientPackage_packageServices_capAmount`, `PatientPackage__PatientPackage_packageServices`.`numberOfUsage` AS `PatientPackage__PatientPackage_packageServices_numberOfUsage`, `PatientPackage__PatientPackage_packageServices`.`description` AS `PatientPackage__PatientPackage_packageServices_description`, `PatientPackage__PatientPackage_packageServices`.`remainingLimit` AS `PatientPackage__PatientPackage_packageServices_remainingLimit`, `PatientPackage__PatientPackage_packageServices`.`patientId` AS `PatientPackage__PatientPackage_packageServices_patientId`, `PatientPackage__PatientPackage_packageServices`.`patientPackageId` AS `PatientPackage__PatientPackage_packageServices_patientPackageId`, `PatientPackage__PatientPackage_packageServices`.`serviceId` AS `PatientPackage__PatientPackage_packageServices_serviceId`, `00cb3e58292b062565c105e677afe3d980a5faef`.`id` AS `00cb3e58292b062565c105e677afe3d980a5faef_id`, `00cb3e58292b062565c105e677afe3d980a5faef`.`uuid` AS `00cb3e58292b062565c105e677afe3d980a5faef_uuid`, `00cb3e58292b062565c105e677afe3d980a5faef`.`createdAt` AS `00cb3e58292b062565c105e677afe3d980a5faef_createdAt`, `00cb3e58292b062565c105e677afe3d980a5faef`.`updatedAt` AS `00cb3e58292b062565c105e677afe3d980a5faef_updatedAt`, `00cb3e58292b062565c105e677afe3d980a5faef`.`name` AS `00cb3e58292b062565c105e677afe3d980a5faef_name`, `00cb3e58292b062565c105e677afe3d980a5faef`.`slug` AS `00cb3e58292b062565c105e677afe3d980a5faef_slug`, `00cb3e58292b062565c105e677afe3d980a5faef`.`status` AS `00cb3e58292b062565c105e677afe3d980a5faef_status`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`id` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_id`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`uuid` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_uuid`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`createdAt` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_createdAt`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`updatedAt` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_updatedAt`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`patientPackage` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_patientPackage`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`slug` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_slug`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`referenceId` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_referenceId`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`remarks` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_remarks`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`patientId` AS `2fa963bb63e2faa246988848a2da0d0b63bdd037_patientId`, `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`patientPackageServiceId` AS `f255983d7dae0a98a631d46012390de05aeb7b4e`, `PatientPackage__PatientPackage_patientPackageInsurance`.`id` AS `PatientPackage__PatientPackage_patientPackageInsurance_id`, `PatientPackage__PatientPackage_patientPackageInsurance`.`uuid` AS `PatientPackage__PatientPackage_patientPackageInsurance_uuid`, `PatientPackage__PatientPackage_patientPackageInsurance`.`createdAt` AS `465bb8e6cb4f76176f7874206b2b714754990872`, `PatientPackage__PatientPackage_patientPackageInsurance`.`updatedAt` AS `4a329a7834bb8300a8bd18c54d117406ff40d3b0`, `PatientPackage__PatientPackage_patientPackageInsurance`.`insuranceMemberId` AS `f3bdc9fb3f2c02f8dd0da4fa52b5989a889667ef`, `PatientPackage__PatientPackage_patientPackageInsurance`.`memberName` AS `2098728d3966d85428be138a3748007fea679972`, `PatientPackage__PatientPackage_patientPackageInsurance`.`mobile` AS `PatientPackage__PatientPackage_patientPackageInsurance_mobile`, `PatientPackage__PatientPackage_patientPackageInsurance`.`nid` AS `PatientPackage__PatientPackage_patientPackageInsurance_nid`, `PatientPackage__PatientPackage_patientPackageInsurance`.`nomineeName` AS `0f3d3d946092ddec01ed58400a5406e1ef9b7d53`, `PatientPackage__PatientPackage_patientPackageInsurance`.`nomineeNID` AS `97352cee097fa5d5367f8dbb16fee28c287753d4`, `PatientPackage__PatientPackage_patientPackageInsurance`.`nomineeMobile` AS `eb45d4d4a46235d3cb0e3eac6bda8f0ee3aae4f1`, `PatientPackage__PatientPackage_patientPackageInsurance`.`relationshipWithNominee` AS `f687e034df9d3babf25b267cd93a2b11f76a46c7`, `PatientPackage__PatientPackage_patientPackageInsurance`.`patientPackageId` AS `7ef66db60923f308cab26ed29448bcdbd69d5f05`, `PatientPackage__PatientPackage_patientPackageInsurance`.`patientId` AS `40c5c6c1cab4b34327ec0f492a330c8099d7d270`, `PatientPackage__PatientPackage_patientPackageInsurance`.`subscriptionPackageId` AS `0e21a40f8f11f4c5031ed583e96741d694d5c092`, `PatientPackage__PatientPackage_patientPackageInsurance`.`insuranceProviderId` AS `4b2f9116a904f328fa5ce8dcf326d2d80ec09314` FROM `patient_package` `PatientPackage` LEFT JOIN `patient` `PatientPackage__PatientPackage_patient` ON `PatientPackage__PatientPackage_patient`.`id`=`PatientPackage`.`patientId` AND (`PatientPackage__PatientPackage_patient`.`deletedAt` IS NULL) LEFT JOIN `subscription_package` `PatientPackage__PatientPackage_subscriptionPackage` ON `PatientPackage__PatientPackage_subscriptionPackage`.`id`=`PatientPackage`.`subscriptionPackageId` AND (`PatientPackage__PatientPackage_subscriptionPackage`.`deletedAt` IS NULL) LEFT JOIN `patient_package_service` `PatientPackage__PatientPackage_packageServices` ON `PatientPackage__PatientPackage_packageServices`.`patientPackageId`=`PatientPackage`.`id` AND (`PatientPackage__PatientPackage_packageServices`.`deletedAt` IS NULL) LEFT JOIN `service` `00cb3e58292b062565c105e677afe3d980a5faef` ON `00cb3e58292b062565c105e677afe3d980a5faef`.`id`=`PatientPackage__PatientPackage_packageServices`.`serviceId` AND (`00cb3e58292b062565c105e677afe3d980a5faef`.`deletedAt` IS NULL) LEFT JOIN `patient_package_service_history` `2fa963bb63e2faa246988848a2da0d0b63bdd037` ON `2fa963bb63e2faa246988848a2da0d0b63bdd037`.`patientId`=`PatientPackage__PatientPackage_packageServices`.`id` AND (`2fa963bb63e2faa246988848a2da0d0b63bdd037`.`deletedAt` IS NULL) LEFT JOIN `patient_package_insurance` `PatientPackage__PatientPackage_patientPackageInsurance` ON `PatientPackage__PatientPackage_patientPackageInsurance`.`patientPackageId`=`PatientPackage`.`id` AND (`PatientPackage__PatientPackage_patientPackageInsurance`.`deletedAt` IS NULL) WHERE `PatientPackage`.`deletedAt` IS NULL) `distinctAlias` ORDER BY `distinctAlias`.`PatientPackage_createdAt` DESC, `PatientPackage_id` ASC LIMIT 10;
# Time: 2025-05-01T08:45:14.175455Z
# User@Host: shukhee_prod_user[shukhee_prod_user] @ [10.0.67.68] Id: 847827
# Query_time: 6.803284 Lock_time: 0.000004 Rows_sent: 10 Rows_examined: 1611449
SET timestamp=1746089107;
SELECT DISTINCT `distinctAlias`.`PatientPackage_id` AS `ids_PatientPackage_id`, `distinctAlias`.`PatientPackage_createdAt` FROM (SELECT `PatientPackage`.`id` AS `PatientPackage_id`, `PatientPackage`.`uuid` AS `PatientPackage_uuid`, `PatientPackage`.`createdAt` AS `PatientPackage_createdAt`, `PatientPackage`.`updatedAt` AS `PatientPackage_updatedAt`, `PatientPackage`.`name` AS `PatientPackage_name`, `PatientPackage`.`packageType` AS `PatientPackage_packageType`, `PatientPackage`.`description` AS `PatientPackage_description`, `PatientPackage`.`terms` AS `PatientPackage_terms`, `PatientPackage`.`userNumber` AS `PatientPackage_userNumber`, `PatientPackage`.`timePeriod` AS `PatientPackage_timePeriod`, `PatientPackage`.`price` AS `PatientPackage_price`, `PatientPackage`.`status` AS `PatientPackage_status`, `PatientPackage`.`paymentStatus` AS `PatientPackage_paymentStatus`, `PatientPackage`.`serviceStatus` AS `PatientPackage_serviceStatus`, `PatientPackage`.`requestRemarks` AS `PatientPackage_requestRemarks`, `PatientPackage`.`purchasedAt` AS `PatientPackage_purchasedAt`, `PatientPackage`.`expiredAt` AS `PatientPackage_expiredAt`, `PatientPackage`.`canceledAt` AS `PatientPackage_canceledAt`, `PatientPackage`.`createdBy` AS `PatientPackage_createdBy`, `PatientPackage`.`creatorType` AS `PatientPackage_creatorType`, `PatientPackage`.`channel` AS `PatientPackage_channel`, `PatientPackage`.`patientId` AS `PatientPackage_patientId`, `PatientPackage`.`subscriptionPackageId` AS `PatientPackage_subscriptionPackageId`, `PatientPackage__PatientPackage_patient`.`id` AS `PatientPackage__PatientPackage_patient_id`, `PatientPackage__PatientPackage_patient`.`name` AS `PatientPackage__PatientPackage_patient_name`, `PatientPackage__PatientPackage_patient`.`mobile` AS `PatientPackage__PatientPackage_patient_mobile` FROM `patient_package` `PatientPackage` LEFT JOIN `patient` `PatientPackage__PatientPackage_patient` ON `PatientPackage__PatientPackage_patient`.`id`=`PatientPackage`.`patientId` AND (`PatientPackage__PatientPackage_patient`.`deletedAt` IS NULL) WHERE ( ((`PatientPackage`.`paymentStatus` = 'Paid') AND (`PatientPackage`.`packageType` = 'b2b')) ) AND ( `PatientPackage`.`deletedAt` IS NULL )) `distinctAlias` ORDER BY `distinctAlias`.`PatientPackage_createdAt` DESC, `PatientPackage_id` ASC LIMIT 10;
# Time: 2025-05-01T08:43:39.857065Z
# User@Host: shukhee_prod_user[shukhee_prod_user] @ [10.0.67.68] Id: 847827
# Query_time: 4.114563 Lock_time: 0.000003 Rows_sent: 10 Rows_examined: 1612470
SET timestamp=1746089015;
SELECT DISTINCT `distinctAlias`.`PatientPackage_id` AS `ids_PatientPackage_id`, `distinctAlias`.`PatientPackage_createdAt` FROM (SELECT `PatientPackage`.`id` AS `PatientPackage_id`, `PatientPackage`.`uuid` AS `PatientPackage_uuid`, `PatientPackage`.`createdAt` AS `PatientPackage_createdAt`, `PatientPackage`.`updatedAt` AS `PatientPackage_updatedAt`, `PatientPackage`.`name` AS `PatientPackage_name`, `PatientPackage`.`packageType` AS `PatientPackage_packageType`, `PatientPackage`.`description` AS `PatientPackage_description`, `PatientPackage`.`terms` AS `PatientPackage_terms`, `PatientPackage`.`userNumber` AS `PatientPackage_userNumber`, `PatientPackage`.`timePeriod` AS `PatientPackage_timePeriod`, `PatientPackage`.`price` AS `PatientPackage_price`, `PatientPackage`.`status` AS `PatientPackage_status`, `PatientPackage`.`paymentStatus` AS `PatientPackage_paymentStatus`, `PatientPackage`.`serviceStatus` AS `PatientPackage_serviceStatus`, `PatientPackage`.`requestRemarks` AS `PatientPackage_requestRemarks`, `PatientPackage`.`purchasedAt` AS `PatientPackage_purchasedAt`, `PatientPackage`.`expiredAt` AS `PatientPackage_expiredAt`, `PatientPackage`.`canceledAt` AS `PatientPackage_canceledAt`, `PatientPackage`.`createdBy` AS `PatientPackage_createdBy`, `PatientPackage`.`creatorType` AS `PatientPackage_creatorType`, `PatientPackage`.`channel` AS `PatientPackage_channel`, `PatientPackage`.`patientId` AS `PatientPackage_patientId`, `PatientPackage`.`subscriptionPackageId` AS `PatientPackage_subscriptionPackageId`, `PatientPackage__PatientPackage_patient`.`id` AS `PatientPackage__PatientPackage_patient_id`, `PatientPackage__PatientPackage_patient`.`name` AS `PatientPackage__PatientPackage_patient_name`, `PatientPackage__PatientPackage_patient`.`mobile` AS `PatientPackage__PatientPackage_patient_mobile` FROM `patient_package` `PatientPackage` LEFT JOIN `patient` `PatientPackage__PatientPackage_patient` ON `PatientPackage__PatientPackage_patient`.`id`=`PatientPackage`.`patientId` AND (`PatientPackage__PatientPackage_patient`.`deletedAt` IS NULL) WHERE `PatientPackage`.`deletedAt` IS NULL) `distinctAlias` ORDER BY `distinctAlias`.`PatientPackage_createdAt` DESC, `PatientPackage_id` ASC LIMIT 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment