| 0.0005 |
SELECT *
FROM `settings`
WHERE `key` = 'timezone'
|
| 0.0002 |
SELECT GET_LOCK('8e51f7eaef9956b938dd6c5ae09dcdfe', 300) AS ci_session_lock
|
| 0.0010 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = '89a0636fbd3013c4f8cd2d7864a6ed4fb53c55af'
|
| 0.0013 |
DELETE FROM `ci_sessions`
WHERE `timestamp` < 1783362150
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'randCallRange'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'language'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'course_accessibility'
|
| 0.0002 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'affiliate_course'
|
| 0.0010 |
SELECT *
FROM `course`
WHERE `slug` = 'oraclefusion'
|
| 0.0003 |
SELECT `id`
FROM `course`
WHERE `slug` = 'oraclefusion'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'language_dirs'
|
| 0.0003 |
SELECT *
FROM `course`
WHERE `id` = '220'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_name'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'author'
|
| 0.0002 |
SELECT *
FROM `course`
WHERE `id` = '220'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `course`
WHERE `id` = '220'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'favicon'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'favicon'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'favicon'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'favicon'
|
| 0.0005 |
SELECT `e`.`id` as `enrolment_id`, `c`.`id` as `course_id`, `c`.`title` as `course_title`, `e`.`expiry_date`, `o`.`offer_percentage`, `o`.`offer_amount`, `o`.`valid_to` as `offer_expiry_date`
FROM `enrol` `e`
JOIN `course` `c` ON `e`.`course_id` = `c`.`id`
INNER JOIN `offers` `o` ON `o`.`course_id` = `c`.`id` AND `o`.`status` = "active" AND `o`.`valid_to` >= "2026-07-16"
WHERE `e`.`expiry_date` >= '2026-07-16'
AND `e`.`expiry_date` <= '2026-09-14'
AND `e`.`user_id` IS NULL
ORDER BY `e`.`expiry_date` ASC
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'phone'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'phone'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_email'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_email'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'phone'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'phone'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_email'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_email'
|
| 0.0009 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'dark_logo'
|
| 0.0002 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'course_bundle'
|
| 0.0002 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'ebook'
|
| 0.0002 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'tutor_booking'
|
| 0.0002 |
SELECT *
FROM `custom_page`
WHERE `button_position` = 'header'
|
| 0.0002 |
SELECT *
FROM `category`
WHERE `parent` =0
|
| 0.0002 |
SELECT *
FROM `category`
WHERE `parent` = '5'
|
| 0.0002 |
SELECT *
FROM `category`
WHERE `parent` = '8'
|
| 0.0002 |
SELECT *
FROM `category`
WHERE `parent` = '13'
|
| 0.0001 |
SELECT *
FROM `category`
WHERE `parent` = '19'
|
| 0.0001 |
SELECT *
FROM `category`
WHERE `parent` = '21'
|
| 0.0001 |
SELECT *
FROM `category`
WHERE `parent` = '27'
|
| 0.0001 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'ebook'
|
| 0.0002 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'course_bundle'
|
| 0.0042 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'tutor_booking'
|
| 0.0002 |
SELECT *
FROM `custom_page`
WHERE `button_position` = 'header'
|
| 0.0024 |
SELECT *
FROM `course`
WHERE `status` = 'active'
AND `is_top_course` = 1
OR `is_top10_course` = 1
OR `show_it_in_category` = 1
|
| 0.0011 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'recaptcha_status'
|
| 0.0009 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'cookie_status'
|
| 0.0016 |
SELECT *
FROM `course`
WHERE `slug` = 'oraclefusion'
|
| 0.0004 |
SELECT *
FROM `users`
WHERE `id` = '1'
|
| 0.0002 |
SELECT *
FROM `ratings_count`
WHERE `id` = '220'
|
| 0.0002 |
SELECT *
FROM `users`
WHERE `id` = '1'
|
| 0.0298 |
SELECT
section.id AS section_id,
section.title AS section_title,
section.course_id,
section.order AS section_order,
section.start_date,
section.end_date,
section.restricted_by,
chapters.id AS chapter_id,
chapters.title AS chapter_title,
chapters.order AS chapter_order,
lesson.id AS lesson_id,
lesson.title AS lesson_title,
lesson.duration,
lesson.section_id AS lesson_section_id,
lesson.chapter_id AS lesson_chapter_id,
lesson.video_type,
lesson.video_url
FROM
section
LEFT JOIN
chapters ON chapters.section_id = section.id
LEFT JOIN
lesson ON lesson.section_id = section.id
OR lesson.chapter_id = chapters.id
WHERE
section.course_id = '220'
ORDER BY
section.order ASC, chapters.order ASC, lesson.order ASC;
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = '1'
|
| 0.0003 |
SELECT *
FROM `users`
WHERE `id` = '1'
|
| 0.0002 |
SELECT *
FROM `users`
WHERE `id` = '3212'
|
| 0.0002 |
SELECT *
FROM `users`
WHERE `id` = '3212'
|
| 0.0003 |
SELECT *
FROM `rating`
WHERE `user_id` IS NULL
AND `ratable_id` = '220'
AND `ratable_type` = 'course'
|
| 0.0006 |
SELECT *
FROM `custom_reviews`
WHERE `course_id` = '220'
ORDER BY `id` DESC
LIMIT 5
|
| 0.0004 |
SELECT *
FROM `custom_reviews`
WHERE `course_id` = '220'
ORDER BY `id` DESC
|
| 0.0056 |
SELECT *
FROM `enrol`
WHERE `user_id` IS NULL
AND `course_id` = '220'
|
| 0.0004 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0007 |
SELECT *
FROM `course`
WHERE `id` = '220'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_currency'
|
| 0.0003 |
SELECT *
FROM `currency`
WHERE `code` = 'INR'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'currency_position'
|
| 0.0272 |
SELECT *
FROM `lesson`
WHERE `course_id` = '220'
AND `lesson_type` = 'quiz'
|
| 0.0008 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'certificate'
|
| 0.0002 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'affiliate_course'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0003 |
SELECT *
FROM `course`
WHERE `id` = '220'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'theme'
|
| 0.0002 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'affiliate_course'
|
| 0.0024 |
SELECT *
FROM `course`
WHERE `status` = 'active'
AND `is_top_course` = 1
OR `is_top10_course` = 1
OR `show_it_in_category` = 1
|
| 0.0003 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'recaptcha_status'
|
| 0.0002 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'scorm_course'
|
| 0.0002 |
SELECT *
FROM `addons`
WHERE `unique_identifier` = 'h5p'
|
| 0.0017 |
SELECT *
FROM `course`
WHERE (
`is_top_course` = 1
OR `is_top10_course` = 1
OR `show_it_in_category` = 1
)
AND (
`id` != '220'
)
AND (
`category_id` = '5'
OR `sub_category_id` = '6'
)
AND (
`course_type` = 'general'
)
AND (
`status` = 'active'
)
ORDER BY `order` ASC
LIMIT 4
|
| 0.0003 |
SELECT *
FROM `users`
WHERE `id` = '1'
|
| 0.0002 |
SELECT *
FROM `ratings_count`
WHERE `id` = '226'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_currency'
|
| 0.0003 |
SELECT *
FROM `currency`
WHERE `code` = 'INR'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'currency_position'
|
| 0.0002 |
SELECT *
FROM `users`
WHERE `id` = '1'
|
| 0.0001 |
SELECT *
FROM `ratings_count`
WHERE `id` = '219'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_currency'
|
| 0.0003 |
SELECT *
FROM `currency`
WHERE `code` = 'INR'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'currency_position'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_currency'
|
| 0.0004 |
SELECT *
FROM `currency`
WHERE `code` = 'INR'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'currency_position'
|
| 0.0002 |
SELECT *
FROM `users`
WHERE `id` = '1,1946'
|
| 0.0001 |
SELECT *
FROM `ratings_count`
WHERE `id` = '87'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_currency'
|
| 0.0003 |
SELECT *
FROM `currency`
WHERE `code` = 'INR'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'currency_position'
|
| 0.0002 |
SELECT *
FROM `users`
WHERE `id` = '1,698'
|
| 0.0001 |
SELECT *
FROM `ratings_count`
WHERE `id` = '88'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'system_currency'
|
| 0.0002 |
SELECT *
FROM `currency`
WHERE `code` = 'INR'
|
| 0.0001 |
SELECT *
FROM `settings`
WHERE `key` = 'currency_position'
|
| 0.0003 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'facebook'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'twitter'
|
| 0.0003 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'linkedin'
|
| 0.0014 |
SELECT *
FROM `settings`
WHERE `key` = 'paypal'
|
| 0.0003 |
SELECT *
FROM `settings`
WHERE `key` = 'stripe_keys'
|
| 0.0002 |
SELECT *
FROM `frontend_settings`
WHERE `key` = 'light_logo'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'allow_instructor'
|
| 0.0002 |
SELECT *
FROM `custom_page`
WHERE `button_position` = 'footer'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'footer_link'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key` = 'footer_text'
|
| 0.0005 |
SELECT *
FROM `settings`
WHERE `key` = 'google_analytics_id'
|
Contact Us
