| 0.0002 |
SELECT GET_LOCK('9a6cd20dc6be1559525b8e8d6e652bdb', 300) AS ci_session_lock
|
| 0.0004 |
SELECT `data`
FROM `ci_sessions_custom`
WHERE `id` = 'vf6f1jckba0c5bnkhspc03f7ctiaq57c'
|
| 0.0003 |
SELECT `RoleId`
FROM `master_registered_user`
WHERE `UserId` IS NULL
AND `Status` = 1
AND 0 = 'MarkAsDelete IS NULL'
|
| 0.0002 |
SELECT `RoleId`
FROM `master_registered_user`
WHERE `UserId` IS NULL
AND `Status` = 1
AND 0 = 'MarkAsDelete IS NULL'
|
| 0.0013 |
SELECT mcourse.CourseId as CourseId,mcourse.AwaitingAccreditation as AwaitingAccreditation, mcourse.DemoWebshop as demo, mcourse.ProfessionalCategoryId as ProfessionalCategoryId, mcourse.TopicCategoryId as TopicCategoryId ,mcourse.CourseUniqueId as CourseUniqueId,mcourse.CourseUniqueName as CourseUniqueName,mcourse.Description,mcourse.Duration,mcourse.CurrencyCDM,mcourse.CurrencyCP,mcourse.BaseValue,mcourse.priceSetting,mcourse.PriceStyle,mcourse.IsFreeContent,mcourse.Title,mcourse.UserId,mcourse.PriceBand,mcourse.DisclosureCode,mcourse.PriceFinal,SUBSTRING_INDEX(mcourse.PriceFinal,',', 1) as MasterPrice,mcourse.ExpiryDate,null as WebinarClosingDate,mcourse.CreatedOn,mcourse.ModifiedOn,mcourse.Image,mcourse.PublishOn as PublishedOn, mcourse.sponsor_budget, mcourse.remaining_budget, mcourse.no_learners_get_benefits, mcourse.burden_of_disease, mcourse.planned_course_status, null as RegistrationLink,null as RegMaxLimit, null as WebinarDate, null as WebinarStartTime, null as TimeValue, null as SupportedTimeZones, null as VideoAvailability, null as Iswebinar,
(select count(*) from trans_wishlist where CourseId = mcourse.CourseId and Status = 1 and UserId IN ((select UserId from trans_user_iedetails as tie where tie.InstEmpId = '' and (tie.InstEmpTermsEndDate is NULL or tie.InstEmpTermsEndDate >= '2026-07-29')))) as WishlistCount, null as recycleCourses
FROM master_course as mcourse where 1 and CourseType = 2 Group By mcourse.CourseUniqueId Order By demo DESC, PublishedOn DESC
|
| 0.0019 |
SELECT `accretion`.*, `country`.`Name` as `CountryName`, `state`.`Name` as `StateName`
FROM `master_accreditation_details` as `accretion`
JOIN `master_country` as `country` ON `country`.`Id` = `accretion`.`CountryId`
JOIN `master_state` as `state` ON `state`.`Id` = `accretion`.`StateId`
WHERE `accretion`.`Status` = 1
AND `accretion`.`MarkAsDelete` IS NULL
ORDER BY `CountryName`, `StateName` ASC, `Organization` ASC
|
| 0.0003 |
SELECT `RoleId`
FROM `master_registered_user`
WHERE `UserId` IS NULL
AND `Status` = 1
AND 0 = 'MarkAsDelete IS NULL'
|
| 0.0012 |
SELECT * FROM ( SELECT mcourse.CourseId as CourseId,mcourse.AwaitingAccreditation as AwaitingAccreditation, mcourse.DemoWebshop as demo, mcourse.ProfessionalCategoryId as ProfessionalCategoryId, mcourse.TopicCategoryId as TopicCategoryId ,mcourse.CourseUniqueId as CourseUniqueId,mcourse.CourseUniqueName as CourseUniqueName,mcourse.Description,mcourse.Duration,mcourse.CurrencyCDM,mcourse.CurrencyCP,mcourse.BaseValue,mcourse.priceSetting,mcourse.PriceStyle,mcourse.IsFreeContent,mcourse.Title,mcourse.UserId,mcourse.PriceBand,mcourse.DisclosureCode,mcourse.PriceFinal,SUBSTRING_INDEX(mcourse.PriceFinal,',', 1) as MasterPrice,mcourse.ExpiryDate,null as WebinarClosingDate,mcourse.CreatedOn,mcourse.ModifiedOn,mcourse.Image,mcourse.PublishOn as PublishedOn, mcourse.sponsor_budget, mcourse.remaining_budget, mcourse.no_learners_get_benefits, mcourse.burden_of_disease, mcourse.planned_course_status, null as RegistrationLink,null as RegMaxLimit, null as WebinarDate, null as WebinarStartTime, null as TimeValue, null as SupportedTimeZones, null as VideoAvailability, null as Iswebinar,
(select count(*) from trans_wishlist where CourseId = mcourse.CourseId and Status = 1 and UserId IN ((select UserId from trans_user_iedetails as tie where tie.InstEmpId = '' and (tie.InstEmpTermsEndDate is NULL or tie.InstEmpTermsEndDate >= '2026-07-29')))) as WishlistCount, null as recycleCourses
FROM master_course as mcourse where 1 AND mcourse.sponsor_budget > 0 AND mcourse.IsFreeContent = 1 AND mcourse.planned_course_status = 1 ) master_course GROUP BY CourseUniqueId Order By demo DESC, PublishedOn DESC LIMIT 5
|
| 0.0004 |
SELECT
cp.UserId,
cp.OrganizationName,
cp.Status AS UserStatus,
curr.CurrencySymbol,
curr.Currency
FROM master_contentprovider cp
INNER JOIN master_registered_user ru ON ru.UserId = cp.UserId
LEFT JOIN master_country curr ON curr.Id = cp.Currency
WHERE cp.UserId IN (1046)
|
| 0.0007 |
SELECT
accreditation.CourseId,
accreditation.CreditPoint,
acc_details.CreditName AS ACreditName
FROM master_accreditation accreditation
JOIN master_accreditation_details acc_details
ON accreditation.Accreditor = acc_details.SlNo
WHERE accreditation.MarkAsDelete IS NULL
AND accreditation.Status = 1
AND accreditation.SubCategoryId IS NOT NULL
AND accreditation.CourseId IN (818,816)
UNION ALL
SELECT
taec.courseId AS CourseId,
taec.receiverCredits AS CreditPoint,
acc_details.CreditName AS ACreditName
FROM trans_accreditations_endorse_credits taec
JOIN master_accreditation_details acc_details
ON taec.receiverAccreditorId = acc_details.SlNo
JOIN trans_endorement_pb tepb
ON tepb.UserId = taec.receiverAccreditorUserId
AND tepb.ContributeId = taec.originalAccreditorUserId
WHERE tepb.IsVerified = 1
AND taec.courseId IN (818,816)
|
| 0.0007 |
SELECT `tacr`.`CourseId`, `master_registered_author`.*, `master_registered_author`.`Approved` as `authorApproved`, `tacr`.`Approval` as `courseAuthRelationApproval`, CONCAT(
master_registered_author.FirstName, ' ', master_registered_author.LastName
) as Name
FROM `master_registered_author`
JOIN `trans_authors_course_relation` as `tacr` ON `tacr`.`AuthId` = `master_registered_author`.`id`
WHERE `tacr`.`Status` = 1
AND `tacr`.`CourseId` IN('818', '816')
|
| 0.0004 |
SELECT
CourseId,
SEC_TO_TIME(SUM(TIME_TO_SEC(Duration))) AS Duration
FROM master_module
WHERE Status = 1
AND CourseId IN (818,816)
GROUP BY CourseId
|
| 0.0004 |
SELECT `CourseId`
FROM `trans_cart`
WHERE `trans_cart`.`CourseId` IN('818', '816')
AND `trans_cart`.`Status` = 1
AND trans_cart.MarkAsDelete IS NULL
AND trans_cart.MoveToWislistStatus IS NULL
|
| 0.0009 |
SELECT CourseId, COUNT(*) as TotalApplicants FROM (
SELECT DISTINCT
wish.CourseId,
reg.UserId
FROM master_basicuser b
INNER JOIN master_registered_user reg ON reg.UserId = b.UserId
LEFT JOIN trans_wishlist wish
ON wish.UserId = reg.UserId
AND wish.Status = 1
AND wish.MarkAsDelete IS NULL
WHERE reg.acc_verify_status = 1
AND b.Status = 1
AND b.CompleteStep IS NULL
AND reg.UserId NOT IN (
SELECT UserId
FROM master_course_subscription
WHERE STATUS = 1
AND CourseId = wish.CourseId
)
AND wish.CourseId IN (818,816)
UNION
SELECT DISTINCT
wish.CourseId,
reg.UserId
FROM master_premiumuser p
INNER JOIN master_registered_user reg ON reg.UserId = p.UserId
LEFT JOIN trans_wishlist wish
ON wish.UserId = reg.UserId
AND wish.Status = 1
AND wish.MarkAsDelete IS NULL
WHERE reg.acc_verify_status = 1
AND p.Status = 1
AND p.CompleteStep IS NULL
AND reg.UserId NOT IN (
SELECT UserId
FROM master_course_subscription
WHERE STATUS = 1
AND CourseId = wish.CourseId
)
AND wish.CourseId IN (818,816)
) as final
GROUP BY CourseId
|
| 0.0010 |
SELECT `CourseId`, AVG(Rating) AS Rating, COUNT(RatingId) AS RatingCount
FROM `master_course_rating`
WHERE `CourseId` IN('818', '816')
AND `ApprovedBySA` = 1
GROUP BY `CourseId`
|
| 0.0005 |
SELECT *
FROM `master_accreditation`
WHERE `MarkAsDelete` IS NULL
AND `SubCategoryId` IS NOT NULL
AND (
`CourseId` IN('818', '816')
OR `WebinarId` IN('818', '816')
)
|
| 0.0030 |
SELECT DISTINCT `UserId`, `CategoryId`
FROM `trans_user_fieldofinterest`
WHERE `CategoryId` IN(130, 8, 11, 12, 115, 90, 67, 297, 70, 23, 129, 69, 173, 231, 59)
|
| 0.0009 |
SELECT *
FROM `master_country`
WHERE (`ISO2` = "IN" OR `Id` = "IN")
AND `Status` = 1
|
| 0.0010 |
SELECT `CategoryId`, `CategoryName`, `isOther`, `CreatedBy`, `CreatedOn`, `ModifiedBy`, `ModifiedOn`, `Status`
FROM `master_category`
WHERE `Status` = 1
AND MarkAsDelete IS NULL
ORDER BY `CategoryName` ASC
|
| 0.0009 |
SELECT `profession`.`ProfessionId`, `profession`.`ProfessionName`, `band`.`BandName`, `band`.`BandID`
FROM `master_profession` AS `profession`
JOIN `master_band` AS `band` ON `band`.`BandID` = `profession`.`BandId`
WHERE `profession`.`Status` = 1
AND profession.MarkAsDelete IS NULL
AND `profession`.`ProfessionId` != 32
ORDER BY `profession`.`ProfessionName` ASC
|
| 0.0020 |
SELECT *
FROM `master_country`
WHERE `Status` = 1
AND MarkAsDelete IS NULL
ORDER BY `Id` ASC
|
| 0.0003 |
SELECT *
FROM `page_meta_data`
WHERE `page_slug` = 'free-content'
|
| 0.0003 |
SELECT COUNT(DISTINCT trans_cart.CourseId) as cnt
FROM `trans_cart`
JOIN `master_course` ON `master_course`.`CourseId` = `trans_cart`.`CourseId`
WHERE `trans_cart`.`Status` = 1
AND `trans_cart`.`MarkAsDelete` Is Null
AND `trans_cart`.`PurchaseStatus` Is Null
AND `trans_cart`.`CoursePrice` != '0.00'
AND `trans_cart`.`SessionId` IS NULL
AND `master_course`.`ActiveStatus` = 1
|
| 0.0003 |
SELECT *
FROM `master_subscription_plan`
WHERE `Duration` = 1
AND `Status` = 1
AND `MarkAsDelete` IS NULL
|
