FliQi Career Institute

(default) 10 queries took 2 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`url`, `Institution`.`sort_name`, `Institution`.`city_id`, `Institution`.`state_id`, `Institution`.`address`, `Institution`.`pincode`, `Institution`.`logo`, `Institution`.`cover_photo`, `Institution`.`title`, `Institution`.`description`, `Institution`.`keywords`, `Institution`.`content`, `Institution`.`contact_no`, `Institution`.`email`, `Institution`.`exams`, `Institution`.`exams_json`, `Institution`.`status`, `Institution`.`created`, `Institution`.`modified`, `MocktestUrl`.`url` FROM `fliqicom_education`.`institutes` AS `Institution` LEFT JOIN `fliqicom_education`.`mocktest_urls` AS `MocktestUrl` ON (`MocktestUrl`.`target_id` = `Institution`.`id` AND `MocktestUrl`.`type` = 'institution') WHERE 1 = 1	1	1	0
2	SELECT `Trending`.`title`, `Trending`.`url` FROM `fliqicom_education`.`trendings` AS `Trending` WHERE `Trending`.`status` = 1	4	4	0
3	SELECT `ExamSubjectTopic`.`id`, `ExamSubjectTopic`.`exam_id`, `ExamSubjectTopic`.`p_subject_id`, `ExamSubjectTopic`.`subject_id`, `ExamSubjectTopic`.`topic_id`, `ExamSubjectTopic`.`institute_id`, `ExamSubjectTopic`.`question_types`, `ExamSubjectTopic`.`weightage`, `ExamSubjectTopic`.`topic_pre`, `ExamSubjectTopic`.`sub_topic_pre`, `ExamSubjectTopic`.`order`, `ExamSubjectTopic`.`created`, `ExamSubjectTopic`.`modified`, `EduExam`.`id`, `EduExam`.`name` FROM `fliqicom_education`.`exam_subject_topic` AS `ExamSubjectTopic` LEFT JOIN `fliqicom_education`.`edu_exams` AS `EduExam` ON (`ExamSubjectTopic`.`exam_id` = `EduExam`.`id`) WHERE 1 = 1 GROUP BY exam_id ORDER BY `EduExam`.`name` ASC	8	8	2
4	SELECT `PackageExamSeo`.`exam_id`, `PackageExamSeo`.`url` FROM `fliqicom_education`.`package_exam_seo` AS `PackageExamSeo` WHERE 1 = 1	4	4	0
5	SELECT `PackageInstituteSeo`.`institute_id`, `PackageInstituteSeo`.`url` FROM `fliqicom_education`.`package_institute_seo` AS `PackageInstituteSeo` WHERE 1 = 1	3	3	0
6	SELECT `PackageExamSeo`.`id`, `PackageExamSeo`.`exam_id`, `PackageExamSeo`.`url`, `PackageExamSeo`.`title`, `PackageExamSeo`.`description`, `PackageExamSeo`.`keywords`, `PackageExamSeo`.`content`, `PackageExamSeo`.`og_banner` FROM `fliqicom_education`.`package_exam_seo` AS `PackageExamSeo` WHERE `PackageExamSeo`.`url` = 'fliqi' LIMIT 1	0	0	0
7	SELECT `PackageInstituteSeo`.`id`, `PackageInstituteSeo`.`institute_id`, `PackageInstituteSeo`.`url`, `PackageInstituteSeo`.`title`, `PackageInstituteSeo`.`description`, `PackageInstituteSeo`.`keywords`, `PackageInstituteSeo`.`content`, `PackageInstituteSeo`.`og_banner` FROM `fliqicom_education`.`package_institute_seo` AS `PackageInstituteSeo` WHERE `PackageInstituteSeo`.`url` = 'fliqi' LIMIT 1	1	1	0
8	SELECT `EduSubject`.`id`, `EduSubject`.`name` FROM `fliqicom_education`.`edu_subjects` AS `EduSubject` WHERE `EduSubject`.`id` = 4	1	1	0
9	SELECT `EduSubject`.`id`, `EduSubject`.`name` FROM `fliqicom_education`.`edu_subjects` AS `EduSubject` WHERE `EduSubject`.`id` = 14	1	1	0
10	SELECT `EduSubject`.`id`, `EduSubject`.`name` FROM `fliqicom_education`.`edu_subjects` AS `EduSubject` WHERE `EduSubject`.`id` = 14	1	1	0

(default) 10 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`url`, `Institution`.`sort_name`, `Institution`.`city_id`, `Institution`.`state_id`, `Institution`.`address`, `Institution`.`pincode`, `Institution`.`logo`, `Institution`.`cover_photo`, `Institution`.`title`, `Institution`.`description`, `Institution`.`keywords`, `Institution`.`content`, `Institution`.`contact_no`, `Institution`.`email`, `Institution`.`exams`, `Institution`.`exams_json`, `Institution`.`status`, `Institution`.`created`, `Institution`.`modified`, `MocktestUrl`.`url` FROM `fliqicom_education`.`institutes` AS `Institution` LEFT JOIN `fliqicom_education`.`mocktest_urls` AS `MocktestUrl` ON (`MocktestUrl`.`target_id` = `Institution`.`id` AND `MocktestUrl`.`type` = 'institution') WHERE 1 = 1

SELECT `Trending`.`title`, `Trending`.`url` FROM `fliqicom_education`.`trendings` AS `Trending` WHERE `Trending`.`status` = 1

SELECT `ExamSubjectTopic`.`id`, `ExamSubjectTopic`.`exam_id`, `ExamSubjectTopic`.`p_subject_id`, `ExamSubjectTopic`.`subject_id`, `ExamSubjectTopic`.`topic_id`, `ExamSubjectTopic`.`institute_id`, `ExamSubjectTopic`.`question_types`, `ExamSubjectTopic`.`weightage`, `ExamSubjectTopic`.`topic_pre`, `ExamSubjectTopic`.`sub_topic_pre`, `ExamSubjectTopic`.`order`, `ExamSubjectTopic`.`created`, `ExamSubjectTopic`.`modified`, `EduExam`.`id`, `EduExam`.`name` FROM `fliqicom_education`.`exam_subject_topic` AS `ExamSubjectTopic` LEFT JOIN `fliqicom_education`.`edu_exams` AS `EduExam` ON (`ExamSubjectTopic`.`exam_id` = `EduExam`.`id`) WHERE 1 = 1 GROUP BY exam_id ORDER BY `EduExam`.`name` ASC

SELECT `PackageExamSeo`.`exam_id`, `PackageExamSeo`.`url` FROM `fliqicom_education`.`package_exam_seo` AS `PackageExamSeo` WHERE 1 = 1

SELECT `PackageInstituteSeo`.`institute_id`, `PackageInstituteSeo`.`url` FROM `fliqicom_education`.`package_institute_seo` AS `PackageInstituteSeo` WHERE 1 = 1

SELECT `PackageExamSeo`.`id`, `PackageExamSeo`.`exam_id`, `PackageExamSeo`.`url`, `PackageExamSeo`.`title`, `PackageExamSeo`.`description`, `PackageExamSeo`.`keywords`, `PackageExamSeo`.`content`, `PackageExamSeo`.`og_banner` FROM `fliqicom_education`.`package_exam_seo` AS `PackageExamSeo` WHERE `PackageExamSeo`.`url` = 'fliqi' LIMIT 1

SELECT `PackageInstituteSeo`.`id`, `PackageInstituteSeo`.`institute_id`, `PackageInstituteSeo`.`url`, `PackageInstituteSeo`.`title`, `PackageInstituteSeo`.`description`, `PackageInstituteSeo`.`keywords`, `PackageInstituteSeo`.`content`, `PackageInstituteSeo`.`og_banner` FROM `fliqicom_education`.`package_institute_seo` AS `PackageInstituteSeo` WHERE `PackageInstituteSeo`.`url` = 'fliqi' LIMIT 1

SELECT `EduSubject`.`id`, `EduSubject`.`name` FROM `fliqicom_education`.`edu_subjects` AS `EduSubject` WHERE `EduSubject`.`id` = 4

SELECT `EduSubject`.`id`, `EduSubject`.`name` FROM `fliqicom_education`.`edu_subjects` AS `EduSubject` WHERE `EduSubject`.`id` = 14

(fliqi) 10 queries took 0 ms
Nr	Query	Affected	Num. rows
1	SELECT `Page`.`id`, `Page`.`name` FROM `fliqicom_livedb`.`pages` AS `Page` WHERE `Page`.`type` = 'institute' AND `Page`.`status` = 1 ORDER BY `Page`.`name` ASC	10	10
2	SELECT `InstitutePackage`.`id`, `InstitutePackage`.`name`, `InstitutePackage`.`url`, `InstitutePackage`.`package_image`, `InstitutePackage`.`total_price`, `InstitutePackage`.`institute_id`, `InstitutePackage`.`discount`, `InstitutePackage`.`addons`, `InstitutePackage`.`start_date`, `InstitutePackage`.`end_date`, `InstitutePackage`.`is_fee` FROM `fliqicom_livedb`.`institute_packages` AS `InstitutePackage` LEFT JOIN `fliqicom_livedb`.`pages` AS `Page` ON (`InstitutePackage`.`institute_id` = `Page`.`id`) WHERE `InstitutePackage`.`institute_id` = 2 AND `InstitutePackage`.`status` = 1 ORDER BY `InstitutePackage`.`id` DESC LIMIT 20	2	2
3	SELECT `Page`.`id`, `Page`.`name`, `Page`.`logo`, `Page`.`url` FROM `fliqicom_livedb`.`pages` AS `Page` WHERE `Page`.`id` = 2	1	1
4	SELECT `Page`.`id`, `Page`.`name`, `Page`.`logo`, `Page`.`url` FROM `fliqicom_livedb`.`pages` AS `Page` WHERE `Page`.`id` = 2	1	1
5	SELECT `InstitutePackagePrice`.`id`, `InstitutePackagePrice`.`institute_package_id`, `InstitutePackagePrice`.`subject_id`, `InstitutePackagePrice`.`amount`, `InstitutePackagePrice`.`discount`, `InstitutePackagePrice`.`faculty_id`, `InstitutePackagePrice`.`created`, `InstitutePackagePrice`.`total_quiz`, `InstitutePackagePrice`.`order`, `InstitutePackagePrice`.`sectional_test`, `InstitutePackagePrice`.`full_mocktest`, `InstitutePackagePrice`.`old_paper`, `InstitutePackagePrice`.`modified`, `InstitutePackagePrice`.`status` FROM `fliqicom_livedb`.`institute_packages_prices` AS `InstitutePackagePrice` WHERE `InstitutePackagePrice`.`institute_package_id` IN (9, 4)	3	3
6	SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `fliqicom_livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"20\"]'	0	0
7	SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `fliqicom_livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"21\"]'	0	0
8	SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `fliqicom_livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"21\"]'	0	0
9	SELECT `Page`.`id`, `Page`.`type`, `Page`.`name`, `Page`.`username`, `Page`.`password`, `Page`.`url`, `Page`.`about`, `Page`.`logo`, `Page`.`banner_1`, `Page`.`banner_2`, `Page`.`banner_3`, `Page`.`address1`, `Page`.`address2`, `Page`.`city`, `Page`.`state`, `Page`.`pincode`, `Page`.`email`, `Page`.`contact`, `Page`.`content`, `Page`.`facebook_url`, `Page`.`twitter_url`, `Page`.`youtube_url`, `Page`.`google_url`, `Page`.`linkedin_url`, `Page`.`status`, `Page`.`user_id`, `Page`.`title`, `Page`.`description`, `Page`.`keywords`, `Page`.`google_map_url`, `Page`.`created`, `Page`.`modified` FROM `fliqicom_livedb`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`status` = 1 AND `Page`.`type` = 'institute' LIMIT 1	1	1
10	SELECT `Page`.`id`, `Page`.`type`, `Page`.`name`, `Page`.`username`, `Page`.`password`, `Page`.`url`, `Page`.`about`, `Page`.`logo`, `Page`.`banner_1`, `Page`.`banner_2`, `Page`.`banner_3`, `Page`.`address1`, `Page`.`address2`, `Page`.`city`, `Page`.`state`, `Page`.`pincode`, `Page`.`email`, `Page`.`contact`, `Page`.`content`, `Page`.`facebook_url`, `Page`.`twitter_url`, `Page`.`youtube_url`, `Page`.`google_url`, `Page`.`linkedin_url`, `Page`.`status`, `Page`.`user_id`, `Page`.`title`, `Page`.`description`, `Page`.`keywords`, `Page`.`google_map_url`, `Page`.`created`, `Page`.`modified` FROM `fliqicom_livedb`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`status` = 1 AND `Page`.`type` = 'institute' LIMIT 1	1	1

(fliqi) 10 queries took 0 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Page`.`id`, `Page`.`name` FROM `fliqicom_livedb`.`pages` AS `Page` WHERE `Page`.`type` = 'institute' AND `Page`.`status` = 1 ORDER BY `Page`.`name` ASC

SELECT `InstitutePackage`.`id`, `InstitutePackage`.`name`, `InstitutePackage`.`url`, `InstitutePackage`.`package_image`, `InstitutePackage`.`total_price`, `InstitutePackage`.`institute_id`, `InstitutePackage`.`discount`, `InstitutePackage`.`addons`, `InstitutePackage`.`start_date`, `InstitutePackage`.`end_date`, `InstitutePackage`.`is_fee` FROM `fliqicom_livedb`.`institute_packages` AS `InstitutePackage` LEFT JOIN `fliqicom_livedb`.`pages` AS `Page` ON (`InstitutePackage`.`institute_id` = `Page`.`id`) WHERE `InstitutePackage`.`institute_id` = 2 AND `InstitutePackage`.`status` = 1 ORDER BY `InstitutePackage`.`id` DESC LIMIT 20

SELECT `Page`.`id`, `Page`.`name`, `Page`.`logo`, `Page`.`url` FROM `fliqicom_livedb`.`pages` AS `Page` WHERE `Page`.`id` = 2

SELECT `InstitutePackagePrice`.`id`, `InstitutePackagePrice`.`institute_package_id`, `InstitutePackagePrice`.`subject_id`, `InstitutePackagePrice`.`amount`, `InstitutePackagePrice`.`discount`, `InstitutePackagePrice`.`faculty_id`, `InstitutePackagePrice`.`created`, `InstitutePackagePrice`.`total_quiz`, `InstitutePackagePrice`.`order`, `InstitutePackagePrice`.`sectional_test`, `InstitutePackagePrice`.`full_mocktest`, `InstitutePackagePrice`.`old_paper`, `InstitutePackagePrice`.`modified`, `InstitutePackagePrice`.`status` FROM `fliqicom_livedb`.`institute_packages_prices` AS `InstitutePackagePrice` WHERE `InstitutePackagePrice`.`institute_package_id` IN (9, 4)

SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `fliqicom_livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"20\"]'

SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `fliqicom_livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"21\"]'

SELECT `Page`.`id`, `Page`.`type`, `Page`.`name`, `Page`.`username`, `Page`.`password`, `Page`.`url`, `Page`.`about`, `Page`.`logo`, `Page`.`banner_1`, `Page`.`banner_2`, `Page`.`banner_3`, `Page`.`address1`, `Page`.`address2`, `Page`.`city`, `Page`.`state`, `Page`.`pincode`, `Page`.`email`, `Page`.`contact`, `Page`.`content`, `Page`.`facebook_url`, `Page`.`twitter_url`, `Page`.`youtube_url`, `Page`.`google_url`, `Page`.`linkedin_url`, `Page`.`status`, `Page`.`user_id`, `Page`.`title`, `Page`.`description`, `Page`.`keywords`, `Page`.`google_map_url`, `Page`.`created`, `Page`.`modified` FROM `fliqicom_livedb`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`status` = 1 AND `Page`.`type` = 'institute' LIMIT 1