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 `AdmitCard`.`id`, `AdmitCard`.`heading`, `AdmitCard`.`title`, `AdmitCard`.`description`, `AdmitCard`.`keywords`, `AdmitCard`.`content`, `AdmitCard`.`url`, `AdmitCard`.`issue_date`, `AdmitCard`.`created`, `AdmitCard`.`modified`, `AdmitCard`.`status`, `AdmitCard`.`download_notification`, `AdmitCard`.`offical_website`, `AdmitCard`.`exam_date`, `AdmitCard`.`exam_id` FROM `fliqicom_education`.`admit_cards` AS `AdmitCard` WHERE `AdmitCard`.`url` = 'bpsssc-si-pet-admit-card' LIMIT 1 | | 1 | 1 | 1 |
4 | SELECT COUNT(*) AS `count` FROM `fliqicom_education`.`mock_papers` AS `MockPaper` LEFT JOIN `fliqicom_education`.`mocktest_urls` AS `MocktestUrl` ON (`MocktestUrl`.`target_id` = `MockPaper`.`id` AND `MocktestUrl`.`type` = 'paper') WHERE `MockPaper`.`exam_id` = 36 AND `MockPaper`.`active` = 1 | | 1 | 1 | 0 |
5 | SELECT COUNT(*) AS `count` FROM `fliqicom_education`.`previous_papers` AS `PreviousPaper` WHERE `PreviousPaper`.`exam_id` = 36 AND `PreviousPaper`.`status` = 1 | | 1 | 1 | 0 |
6 | SELECT COUNT(*) AS `count` FROM `fliqicom_education`.`all_exams` AS `Exam` WHERE `Exam`.`exam_id` = 36 AND `Exam`.`status` = 1 | | 1 | 1 | 0 |
7 | SELECT COUNT(*) AS `count` FROM `fliqicom_education`.`syllabus` AS `Syllabus` WHERE `Syllabus`.`exam_id` = 36 AND `Syllabus`.`status` = 1 | | 1 | 1 | 0 |
8 | SELECT `AdmitCard`.`id`, `AdmitCard`.`heading`, `AdmitCard`.`title`, `AdmitCard`.`description`, `AdmitCard`.`keywords`, `AdmitCard`.`content`, `AdmitCard`.`url`, `AdmitCard`.`issue_date`, `AdmitCard`.`created`, `AdmitCard`.`modified`, `AdmitCard`.`status`, `AdmitCard`.`download_notification`, `AdmitCard`.`offical_website`, `AdmitCard`.`exam_date`, `AdmitCard`.`exam_id` FROM `fliqicom_education`.`admit_cards` AS `AdmitCard` WHERE `AdmitCard`.`exam_id` = 36 AND `AdmitCard`.`status` = 1 LIMIT 1 | | 1 | 1 | 1 |
9 | SELECT `AnswerKey`.`id`, `AnswerKey`.`exam_id`, `AnswerKey`.`url`, `AnswerKey`.`hindi_title`, `AnswerKey`.`hindi_content`, `AnswerKey`.`eng_title`, `AnswerKey`.`eng_content`, `AnswerKey`.`image`, `AnswerKey`.`title`, `AnswerKey`.`description`, `AnswerKey`.`keywords`, `AnswerKey`.`og_banner`, `AnswerKey`.`status`, `AnswerKey`.`created`, `AnswerKey`.`modified` FROM `fliqicom_education`.`answer_key` AS `AnswerKey` WHERE `AnswerKey`.`exam_id` = 36 AND `AnswerKey`.`status` = 1 LIMIT 1 | | 0 | 0 | 0 |
10 | SELECT `CareerGrowth`.`id`, `CareerGrowth`.`exam_id`, `CareerGrowth`.`url`, `CareerGrowth`.`hindi_title`, `CareerGrowth`.`hindi_content`, `CareerGrowth`.`eng_title`, `CareerGrowth`.`eng_content`, `CareerGrowth`.`image`, `CareerGrowth`.`title`, `CareerGrowth`.`description`, `CareerGrowth`.`keywords`, `CareerGrowth`.`og_banner`, `CareerGrowth`.`status`, `CareerGrowth`.`created`, `CareerGrowth`.`modified` FROM `fliqicom_education`.`career_growth` AS `CareerGrowth` WHERE `CareerGrowth`.`exam_id` = 36 AND `CareerGrowth`.`status` = 1 LIMIT 1 | | 0 | 0 | 0 |
11 | SELECT `Result`.`id`, `Result`.`heading`, `Result`.`title`, `Result`.`description`, `Result`.`keywords`, `Result`.`content`, `Result`.`url`, `Result`.`issue_date`, `Result`.`created`, `Result`.`modified`, `Result`.`status`, `Result`.`download_notification`, `Result`.`offical_website`, `Result`.`exam_date`, `Result`.`exam_id` FROM `fliqicom_education`.`results` AS `Result` WHERE `Result`.`exam_id` = 36 AND `Result`.`status` = 1 LIMIT 1 | | 1 | 1 | 0 |
12 | SELECT `ExamHowToPrepare`.`id`, `ExamHowToPrepare`.`exam_id`, `ExamHowToPrepare`.`url`, `ExamHowToPrepare`.`hindi_title`, `ExamHowToPrepare`.`hindi_content`, `ExamHowToPrepare`.`eng_title`, `ExamHowToPrepare`.`eng_content`, `ExamHowToPrepare`.`image`, `ExamHowToPrepare`.`title`, `ExamHowToPrepare`.`description`, `ExamHowToPrepare`.`keywords`, `ExamHowToPrepare`.`og_banner`, `ExamHowToPrepare`.`status`, `ExamHowToPrepare`.`created`, `ExamHowToPrepare`.`modified` FROM `fliqicom_education`.`exam_how_to_prepare` AS `ExamHowToPrepare` WHERE `ExamHowToPrepare`.`exam_id` = 36 AND `ExamHowToPrepare`.`status` = 1 LIMIT 1 | | 0 | 0 | 0 |
13 | SELECT `EduPost`.`id`, `EduPost`.`heading`, `EduPost`.`url`, `EduPost`.`main_category`, `EduPost`.`category_id`, `EduPost`.`title`, `EduPost`.`description`, `EduPost`.`keywords`, `EduPost`.`content`, `EduPost`.`thumb`, `EduPost`.`starting_date`, `EduPost`.`closing_date`, `EduPost`.`created_by`, `EduPost`.`last_updated_by`, `EduPost`.`update_alert_date`, `EduPost`.`created`, `EduPost`.`modified`, `EduPost`.`upcomming`, `EduPost`.`headline`, `EduPost`.`feed`, `EduPost`.`active`, `EduPost`.`sitemap`, `EduPost`.`apply_online`, `EduPost`.`download_notification`, `EduPost`.`offical_website`, `EduPost`.`download_app_form`, `EduPost`.`ad_id`, `EduPost`.`exam_date`, `EduPost`.`interview_date`, `EduPost`.`application_fee`, `EduPost`.`eligibility`, `EduPost`.`age_limit`, `EduPost`.`fee_last_date`, `EduPost`.`mocktest_url`, `EduPost`.`og_banner`, `EduPost`.`exam_id`, `EduPost`.`vacancy_detail`, `EduPost`.`exam_mode`, `EduPost`.`selection_process`, `EduPost`.`pay_scale`, `EduPost`.`job_location`, `SeoUrl`.`url` FROM `fliqicom_education`.`edu_posts` AS `EduPost` LEFT JOIN `fliqicom_education`.`seo_urls` AS `SeoUrl` ON (`SeoUrl`.`target_id` = `EduPost`.`id` AND `SeoUrl`.`type` = 'post') WHERE `EduPost`.`exam_id` = 36 AND `EduPost`.`active` = 1 LIMIT 1 | | 0 | 0 | 8 |
14 | SELECT COUNT(*) AS `count` FROM `fliqicom_education`.`study_topics` AS `StudyTopic` LEFT JOIN `fliqicom_education`.`study_subject_seo` AS `StudySubjectSeo` ON (`StudyTopic`.`subject_id` = `StudySubjectSeo`.`subject_id`) LEFT JOIN `fliqicom_education`.`study_subject_seo` AS `StudySubjectSeoParent` ON (`StudyTopic`.`p_subject_id` = `StudySubjectSeoParent`.`subject_id`) LEFT JOIN `fliqicom_education`.`study_state_seo` AS `StudyStateSeo` ON (`StudyTopic`.`state_id` = `StudyStateSeo`.`state_id`) WHERE FIND_IN_SET('36',`StudyTopic`.`assoc_exams`) AND `StudyTopic`.`status` = 1 | | 1 | 1 | 0 |
15 | SELECT `Exam1`.`id`, `Exam1`.`parent_id`, `Exam1`.`name`, `Exam1`.`url`, `Exam1`.`title`, `Exam1`.`description`, `Exam1`.`content`, `Exam1`.`thumb`, `Exam1`.`created`, `Exam1`.`modified`, `Exam1`.`active`, `Exam1`.`featured`, `Exam1`.`is_home`, `Exam1`.`is_upcomming`, `Exam1`.`is_popular`, `Exam1`.`exam_date`, `Exam1`.`last_date`, `Exam1`.`og_banner`, `Exam1`.`display_order` FROM `fliqicom_education`.`exams` AS `Exam1` WHERE `Exam1`.`id` = 36 LIMIT 1 | | 1 | 1 | 0 |
16 | SELECT `MocktestUrl`.`id`, `MocktestUrl`.`section`, `MocktestUrl`.`url`, `MocktestUrl`.`type`, `MocktestUrl`.`target_id`, `MocktestUrl`.`created`, `MocktestUrl`.`status` FROM `fliqicom_education`.`mocktest_urls` AS `MocktestUrl` WHERE `MocktestUrl`.`url` = 'bihar-police-si' LIMIT 1 | | 1 | 1 | 0 |
17 | SELECT `EduExam`.`id`, `EduExam`.`parent_id`, `EduExam`.`name`, `EduExam`.`title`, `EduExam`.`description`, `EduExam`.`content`, `EduExam`.`thumb`, `EduExam`.`created`, `EduExam`.`modified`, `EduExam`.`active`, `EduExam`.`featured`, `EduExam`.`is_home`, `EduExam`.`og_banner`, `EduExam`.`display_order`, `EduExam`.`is_upcomming`, `EduExam`.`is_popular`, `EduExam`.`exam_date`, `EduExam`.`last_date`, `MocktestUrl`.`url` FROM `fliqicom_education`.`edu_exams` AS `EduExam` LEFT JOIN `fliqicom_education`.`mocktest_urls` AS `MocktestUrl` ON (`MocktestUrl`.`target_id` = `EduExam`.`id` AND `MocktestUrl`.`type` = 'exam') WHERE `EduExam`.`id` = 36 LIMIT 1 | | 1 | 1 | 0 |