(default) 122 queries took 19 ms Nr Query Error Affected Num. rows Took (ms) 1 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 27 1 1 0 2 SELECT `PlanDetail`.`id`, `PlanDetail`.`created`, `PlanDetail`.`modified`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_detail_note_id`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`benefits_schedule_wysiwyg`, `PlanDetail`.`benefits_description_wysiwyg`, `PlanDetail`.`exclusions_wysiwyg`, `PlanDetail`.`provider_network_url`, `PlanDetail`.`application_url`, `PlanDetail`.`vision_wysiwyg` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`company_id` = (27) 1 1 1 3 SELECT `Applicant`.`id`, `Applicant`.`company_id`, `Applicant`.`name`, `Applicant`.`amount` FROM `applicants` AS `Applicant` WHERE `Applicant`.`company_id` = (27) 0 0 0 4 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 3 1 1 0 5 SELECT `PlanDetail`.`id`, `PlanDetail`.`created`, `PlanDetail`.`modified`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_detail_note_id`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`benefits_schedule_wysiwyg`, `PlanDetail`.`benefits_description_wysiwyg`, `PlanDetail`.`exclusions_wysiwyg`, `PlanDetail`.`provider_network_url`, `PlanDetail`.`application_url`, `PlanDetail`.`vision_wysiwyg` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`company_id` = (3) 3 3 1 6 SELECT `Applicant`.`id`, `Applicant`.`company_id`, `Applicant`.`name`, `Applicant`.`amount` FROM `applicants` AS `Applicant` WHERE `Applicant`.`company_id` = (3) 0 0 0 7 SELECT COUNT(*) AS `count` FROM `plans` AS `Plan` inner JOIN plans_zips AS `PZips` ON (`Plan`.`id` = `PZips`.`plan_id`) inner JOIN zips AS `Zips` ON (`Zips`.`id` = `PZips`.`zip_id`) LEFT JOIN `plan_details` AS `PlanDetail` ON (`Plan`.`plan_detail_id` = `PlanDetail`.`id`) LEFT JOIN `ages` AS `Age` ON (`Plan`.`age_id` = `Age`.`id`) LEFT JOIN `applicants` AS `Applicant` ON (`Plan`.`applicant_id` = `Applicant`.`id`) WHERE ((((18 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (NOT (`PlanDetail`.`company_id` IN (27, 3))))) OR (((22 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (`PlanDetail`.`company_id` = 27))) OR (((22 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (`PlanDetail`.`company_id` = 3)))) 1 1 0 8 SELECT `Plan`.`id`, `Plan`.`created`, `Plan`.`modified`, `Plan`.`plan_detail_id`, `Plan`.`monthly_cost`, `Plan`.`dental_cost`, `Plan`.`age_id`, `Plan`.`applicant_id`, `Plan`.`state_id`, `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id`, `Age`.`id`, `Age`.`name`, `Applicant`.`id`, `Applicant`.`name` FROM `plans` AS `Plan` inner JOIN plans_zips AS `PZips` ON (`Plan`.`id` = `PZips`.`plan_id`) inner JOIN zips AS `Zips` ON (`Zips`.`id` = `PZips`.`zip_id`) LEFT JOIN `plan_details` AS `PlanDetail` ON (`Plan`.`plan_detail_id` = `PlanDetail`.`id`) LEFT JOIN `ages` AS `Age` ON (`Plan`.`age_id` = `Age`.`id`) LEFT JOIN `applicants` AS `Applicant` ON (`Plan`.`applicant_id` = `Applicant`.`id`) WHERE ((((18 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (NOT (`PlanDetail`.`company_id` IN (27, 3))))) OR (((22 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (`PlanDetail`.`company_id` = 27))) OR (((22 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (`PlanDetail`.`company_id` = 3)))) ORDER BY `monthly_cost` ASC LIMIT 100 22 22 1 9 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 54 1 1 0 10 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 21 1 1 0 11 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 12 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 88 1 1 0 13 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4 1 1 0 14 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 15 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 48 1 1 0 16 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20 1 1 0 17 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 18 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 42 1 1 0 19 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20 1 1 0 20 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 21 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 55 1 1 0 22 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 21 1 1 0 23 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 24 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 82 1 1 0 25 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 18 1 1 1 26 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 27 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 80 1 1 0 28 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 18 1 1 0 29 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 30 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 50 1 1 0 31 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20 1 1 0 32 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 33 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 56 1 1 0 34 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 21 1 1 0 35 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 36 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 86 1 1 0 37 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4 1 1 0 38 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 39 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 65 1 1 0 40 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 16 1 1 0 41 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 4 1 1 0 42 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 87 1 1 0 43 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4 1 1 0 44 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 45 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 52 1 1 0 46 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20 1 1 0 47 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 48 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 78 1 1 0 49 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 18 1 1 0 50 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 51 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 44 1 1 0 52 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20 1 1 0 53 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 54 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 94 1 1 0 55 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 27 1 1 0 56 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 57 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 84 1 1 0 58 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4 1 1 0 59 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 60 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 85 1 1 0 61 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4 1 1 0 62 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 63 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 46 1 1 0 64 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20 1 1 0 65 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 66 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 61 1 1 0 67 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 3 1 1 0 68 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 69 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 62 1 1 0 70 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 3 1 1 0 71 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1 1 1 0 72 SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 60 1 1 0 73 SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 3 1 1 0 74 SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2 1 1 0 75 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 76 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 77 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16 1 1 0 78 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16 1 1 0 79 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 80 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 81 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 82 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16 1 1 0 83 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 84 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 85 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16 1 1 0 86 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 87 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16 1 1 0 88 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 89 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16 1 1 0 90 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 4 1 1 0 91 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 92 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14 1 1 0 93 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16 1 1 0 94 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 18 1 1 0 95 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 18 1 1 0 96 SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 18 1 1 0 97 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 98 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 99 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 100 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 101 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 102 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2 1 1 0 103 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2 1 1 0 104 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 105 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 106 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 107 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2 1 1 0 108 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 109 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 110 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2 1 1 0 111 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 112 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2 1 1 0 113 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 114 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 115 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27 1 1 0 116 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2 1 1 0 117 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2 1 1 0 118 SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2 1 1 0 119 SELECT `Zip`.`id`, `Zip`.`title`, `PlansZip`.`id`, `PlansZip`.`plan_id`, `PlansZip`.`zip_id` FROM `zips` AS `Zip` JOIN `plans_zips` AS `PlansZip` ON (`PlansZip`.`plan_id` IN (254, 775, 138, 116, 261, 506, 502, 240, 269, 763, 842, 769, 247, 498, 124, 859, 751, 757, 131, 317, 333, 301) AND `PlansZip`.`zip_id` = `Zip`.`id`) ORDER BY `Zip`.`title` ASC 9585 9585 13 120 SELECT `PlanDetail`.`id`, `PlanDetail`.`name` FROM `plan_details` AS `PlanDetail` LEFT JOIN `companies` AS `Company` ON (`PlanDetail`.`company_id` = `Company`.`id`) LEFT JOIN `plan_types` AS `PlanType` ON (`PlanDetail`.`plan_type_id` = `PlanType`.`id`) LEFT JOIN `plan_detail_notes` AS `PlanDetailNote` ON (`PlanDetail`.`plan_detail_note_id` = `PlanDetailNote`.`id`) WHERE 1 = 1 GROUP BY `PlanDetail`.`name` ORDER BY `PlanDetail`.`name` ASC 28 28 0 121 SELECT `Plan`.`id`, `Plan`.`created`, `Plan`.`modified`, `Plan`.`plan_detail_id`, `Plan`.`monthly_cost`, `Plan`.`dental_cost`, `Plan`.`age_id`, `Plan`.`applicant_id`, `Plan`.`state_id` FROM `plans` AS `Plan` WHERE `Plan`.`plan_detail_id` IN (54, 84, 85, 86, 87, 55, 63, 94, 78, 68, 65, 76, 74, 75, 77, 88, 61, 62, 80, 60, 56, 44, 50, 82, 46, 52, 42, 48) 604 604 1 122 SELECT `Definition`.`id`, `Definition`.`term`, `Definition`.`definition`, `DefinitionsPlanDetail`.`id`, `DefinitionsPlanDetail`.`definition_id`, `DefinitionsPlanDetail`.`plan_detail_id` FROM `definitions` AS `Definition` JOIN `definitions_plan_details` AS `DefinitionsPlanDetail` ON (`DefinitionsPlanDetail`.`plan_detail_id` IN (54, 84, 85, 86, 87, 55, 63, 94, 78, 68, 65, 76, 74, 75, 77, 88, 61, 62, 80, 60, 56, 44, 50, 82, 46, 52, 42, 48) AND `DefinitionsPlanDetail`.`definition_id` = `Definition`.`id`) ================================================================================ -- phpMyAdmin SQL Dump -- version 2.8.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: May 12, 2011 at 08:56 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 -- -- Database: `db_1` -- -- -------------------------------------------------------- -- -- Table structure for table `acos` -- CREATE TABLE `acos` ( `id` int(10) NOT NULL auto_increment, `parent_id` int(10) default NULL, `model` varchar(255) default NULL, `foreign_key` int(10) default NULL, `alias` varchar(255) default NULL, `lft` int(10) default NULL, `rght` int(10) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=175 DEFAULT CHARSET=latin1 AUTO_INCREMENT=175 ; -- -------------------------------------------------------- -- -- Table structure for table `ages` -- CREATE TABLE `ages` ( `id` int(11) NOT NULL auto_increment, `min_age` text NOT NULL, `max_age` text NOT NULL, `name` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ; -- -------------------------------------------------------- -- -- Table structure for table `applicants` -- CREATE TABLE `applicants` ( `id` int(11) NOT NULL auto_increment, `company_id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `amount` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ; -- -------------------------------------------------------- -- -- Table structure for table `aros` -- CREATE TABLE `aros` ( `id` int(10) NOT NULL auto_increment, `parent_id` int(10) default NULL, `model` varchar(255) default NULL, `foreign_key` int(10) default NULL, `alias` varchar(255) default NULL, `lft` int(10) default NULL, `rght` int(10) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -------------------------------------------------------- -- -- Table structure for table `aros_acos` -- CREATE TABLE `aros_acos` ( `id` int(10) NOT NULL auto_increment, `aro_id` int(10) NOT NULL, `aco_id` int(10) NOT NULL, `_create` varchar(2) NOT NULL default '0', `_read` varchar(2) NOT NULL default '0', `_update` varchar(2) NOT NULL default '0', `_delete` varchar(2) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `ARO_ACO_KEY` (`aro_id`,`aco_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `companies` -- CREATE TABLE `companies` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL, `company_logo_url` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ; -- -------------------------------------------------------- -- -- Table structure for table `definitions` -- CREATE TABLE `definitions` ( `id` int(11) NOT NULL auto_increment, `term` varchar(50) NOT NULL, `definition` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `definitions_plan_details` -- CREATE TABLE `definitions_plan_details` ( `id` int(11) NOT NULL auto_increment, `definition_id` int(11) NOT NULL, `plan_detail_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `plan_detail_notes` -- CREATE TABLE `plan_detail_notes` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ; -- -------------------------------------------------------- -- -- Table structure for table `plan_details` -- CREATE TABLE `plan_details` ( `id` int(11) NOT NULL auto_increment, `created` datetime default NULL, `modified` datetime default NULL, `effective_date` datetime NOT NULL, `expiration_date` datetime NOT NULL, `active` tinyint(1) NOT NULL, `name` varchar(100) NOT NULL, `plan_detail_note_id` int(11) default NULL, `company_id` int(11) NOT NULL, `plan_type_id` int(11) NOT NULL, `max_benefit` decimal(18,2) NOT NULL, `deductible` varchar(25) NOT NULL, `preventive` varchar(25) NOT NULL, `basic` varchar(25) NOT NULL, `major` varchar(25) NOT NULL, `ortho` text NOT NULL, `benefits_schedule_wysiwyg` text NOT NULL, `benefits_description_wysiwyg` text NOT NULL, `exclusions_wysiwyg` text NOT NULL, `provider_network_url` text NOT NULL, `application_url` text NOT NULL, `vision_wysiwyg` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=latin1 AUTO_INCREMENT=95 ; -- -------------------------------------------------------- -- -- Table structure for table `plan_types` -- CREATE TABLE `plan_types` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, `description` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -------------------------------------------------------- -- -- Table structure for table `plans` -- CREATE TABLE `plans` ( `id` int(11) NOT NULL auto_increment, `created` datetime default NULL, `modified` datetime default NULL, `plan_detail_id` int(11) NOT NULL, `monthly_cost` decimal(18,2) NOT NULL, `dental_cost` decimal(18,2) NOT NULL default '0.00', `age_id` int(11) NOT NULL, `applicant_id` int(11) NOT NULL, `state_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=898 DEFAULT CHARSET=latin1 AUTO_INCREMENT=898 ; -- -------------------------------------------------------- -- -- Table structure for table `plans_zips` -- CREATE TABLE `plans_zips` ( `id` int(11) NOT NULL auto_increment, `plan_id` int(11) NOT NULL, `zip_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `plan_id` (`plan_id`,`zip_id`) ) ENGINE=MyISAM AUTO_INCREMENT=330800 DEFAULT CHARSET=latin1 AUTO_INCREMENT=330800 ; -- -------------------------------------------------------- -- -- Table structure for table `states` -- CREATE TABLE `states` ( `id` int(11) NOT NULL auto_increment, `name` varchar(75) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `username` varchar(50) NOT NULL, `password` char(40) NOT NULL, `name` varchar(50) NOT NULL, `email` varchar(255) NOT NULL, `group_id` int(11) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Table structure for table `zips` -- CREATE TABLE `zips` ( `id` int(11) NOT NULL auto_increment, `state_id` int(2) NOT NULL, `title` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1374 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1374 ;