| No. | 
				time | 
				query | 
			
							
					| 1 | 
					0.001777 | 
					
						 connect 
											 | 
				
							
					| 2 | 
					0.000607 | 
					
						 DESCRIBE `prefecture` 
											 | 
				
							
					| 3 | 
					0.000417 | 
					
						 SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '14') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										p | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 4 | 
					0.000507 | 
					
						 DESCRIBE `city` 
											 | 
				
							
					| 5 | 
					0.000417 | 
					
						 SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '904') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 6 | 
					0.000547 | 
					
						 DESCRIBE `summary_count_school` 
											 | 
				
							
					| 7 | 
					0.000857 | 
					
						 SELECT `s_c_s`.* FROM `summary_count_school` AS `s_c_s` WHERE (s_c_s.is_latest = 1) AND (s_c_s.category_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = '904') AND (s_c_s.station_id = 0) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id = 0) AND (s_c_s.count > 0) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_c_s | 
										
											range										 | 
										multi | 
										multi | 
										28 | 
										 | 
										17 | 
										Using index condition; Using where | 
									 
															 
											 | 
				
							
					| 8 | 
					0.000517 | 
					
						 DESCRIBE `station` 
											 | 
				
							
					| 9 | 
					0.000397 | 
					
						 SELECT `s`.* FROM `station` AS `s` WHERE (s.city_id = '904') GROUP BY `s`.`id` 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											ref										 | 
										PRIMARY,city_id,ix_lat_lon_station | 
										city_id | 
										4 | 
										const | 
										9 | 
										Using index condition | 
									 
															 
											 | 
				
							
					| 10 | 
					0.000697 | 
					
						 SELECT `s_c_s`.* FROM `summary_count_school` AS `s_c_s` WHERE (s_c_s.is_latest = 1) AND (s_c_s.category_id = 6) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id IN ('5215', '5216', '5217', '5218', '5219', '5220', '5221', '5262', '5263')) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id = 0) AND (s_c_s.count > 0) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_c_s | 
										
											range										 | 
										multi | 
										multi | 
										28 | 
										 | 
										9 | 
										Using index condition; Using where | 
									 
															 
											 | 
				
							
					| 11 | 
					0.000657 | 
					
						 DESCRIBE `station_unit` 
											 | 
				
							
					| 12 | 
					0.000367 | 
					
						 SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.prefecture_id = '14') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											ref										 | 
										prefecture_id | 
										prefecture_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 13 | 
					0.000527 | 
					
						 DESCRIBE `major_city` 
											 | 
				
							
					| 14 | 
					0.000367 | 
					
						 SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.prefecture_id = '14') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										m_c | 
										
											ref										 | 
										prefecture_id | 
										prefecture_id | 
										4 | 
										const | 
										2 | 
										 | 
									 
															 
											 | 
				
							
					| 15 | 
					0.000537 | 
					
						 SELECT `s_c_s`.* FROM `summary_count_school` AS `s_c_s` WHERE (s_c_s.is_latest = 1) AND (s_c_s.category_id = 6) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id = 0) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id IN ('6', '7')) AND (s_c_s.count > 0) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_c_s | 
										
											range										 | 
										multi | 
										multi | 
										28 | 
										 | 
										2 | 
										Using index condition; Using where | 
									 
															 
											 | 
				
							
					| 16 | 
					0.000727 | 
					
						 DESCRIBE `school` 
											 | 
				
							
					| 17 | 
					0.000537 | 
					
						 DESCRIBE `category_school` 
											 | 
				
							
					| 18 | 
					0.001217 | 
					
						 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.category_id = 6) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c_s | 
										
											ref										 | 
										ix_category_id_category_school | 
										ix_category_id_category_school | 
										4 | 
										const | 
										152 | 
										 | 
									 
															 
											 | 
				
							
					| 19 | 
					0.001707 | 
					
						 SELECT COUNT(1) AS `zend_paginator_row_count` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013172', '3013187', '3013188', '3013189', '3013208', '3013230', '3013236', '3013238', '3013256', '3013265', '3013266', '3013293', '3013292', '3013311', '3013425', '3013429', '3013467', '3013474', '3013490', '3013904', '3013947', '3013955', '3013959', '3013960', '3014015', '3014017', '3014022', '3014063', '3014096', '3014099', '3014106', '3014112', '3014134', '3014171', '3014202', '3014206', '3014207', '3014208', '3014226', '3014229', '3014247', '3014295', '3014297', '3014313', '3014316', '3014333', '3014094', '3014423', '3014428', '3014429', '3014441', '3014442', '3014445', '3014394', '3014485', '3014498', '3014526', '3014534', '3014559', '3014573', '3014576', '3014581', '3014583', '3014598', '3014605', '3014617', '3014618', '3014619', '3014646', '3014647', '3014694', '3014705', '3014725', '3014755', '3014771', '3014782', '3014783', '3014793', '3014800', '3014832', '3014849', '3014856', '3014867', '3014882', '3014886', '3014909', '3014976', '3014977', '3014982', '3015030', '3014993', '3014994', '3015010', '3015048', '3015053', '3015070', '3015094', '3015112', '3015156', '3015188', '3015205', '3015286', '3015369', '3015393', '3015396', '3015403', '3015416', '3015451', '3015453', '3015457', '3014644', '3015471', '3015478', '3015488', '3015519', '3015531', '3015545', '3015551', '3015552', '3015562', '3015601', '3015608', '3015635', '3015660', '3015687', '3015689', '3015701', '3015718', '3015765', '3015607', '3015786', '3015792', '3015834', '3014802', '3015880', '3015901', '3015929', '3015939', '3015989', '3015990', '3016030', '3016146', '3016147', '3014425', '3016254', '3016259', '3016080', '3016337', '3016348', '3016360', '3016401', '3016418')) AND (s.city_id = '904') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											range										 | 
										PRIMARY,city_id | 
										city_id | 
										9 | 
										 | 
										152 | 
										Using index condition; Using where | 
									 
															 
											 | 
				
							
					| 20 | 
					0.001957 | 
					
						 SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013172', '3013187', '3013188', '3013189', '3013208', '3013230', '3013236', '3013238', '3013256', '3013265', '3013266', '3013293', '3013292', '3013311', '3013425', '3013429', '3013467', '3013474', '3013490', '3013904', '3013947', '3013955', '3013959', '3013960', '3014015', '3014017', '3014022', '3014063', '3014096', '3014099', '3014106', '3014112', '3014134', '3014171', '3014202', '3014206', '3014207', '3014208', '3014226', '3014229', '3014247', '3014295', '3014297', '3014313', '3014316', '3014333', '3014094', '3014423', '3014428', '3014429', '3014441', '3014442', '3014445', '3014394', '3014485', '3014498', '3014526', '3014534', '3014559', '3014573', '3014576', '3014581', '3014583', '3014598', '3014605', '3014617', '3014618', '3014619', '3014646', '3014647', '3014694', '3014705', '3014725', '3014755', '3014771', '3014782', '3014783', '3014793', '3014800', '3014832', '3014849', '3014856', '3014867', '3014882', '3014886', '3014909', '3014976', '3014977', '3014982', '3015030', '3014993', '3014994', '3015010', '3015048', '3015053', '3015070', '3015094', '3015112', '3015156', '3015188', '3015205', '3015286', '3015369', '3015393', '3015396', '3015403', '3015416', '3015451', '3015453', '3015457', '3014644', '3015471', '3015478', '3015488', '3015519', '3015531', '3015545', '3015551', '3015552', '3015562', '3015601', '3015608', '3015635', '3015660', '3015687', '3015689', '3015701', '3015718', '3015765', '3015607', '3015786', '3015792', '3015834', '3014802', '3015880', '3015901', '3015929', '3015939', '3015989', '3015990', '3016030', '3016146', '3016147', '3014425', '3016254', '3016259', '3016080', '3016337', '3016348', '3016360', '3016401', '3016418')) AND (s.city_id = '904') ORDER BY `s`.`is_charged` DESC, `s`.`score` DESC LIMIT 20 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											range										 | 
										PRIMARY,city_id | 
										city_id | 
										9 | 
										 | 
										152 | 
										Using index condition; Using where; Using filesort | 
									 
															 
											 | 
				
							
					| 21 | 
					0.000377 | 
					
						 SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('904', '904')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											range										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										 | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 22 | 
					0.000387 | 
					
						 SELECT `p`.* FROM `prefecture` AS `p` 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										p | 
										
											ALL										 | 
										 | 
										 | 
										 | 
										 | 
										47 | 
										 | 
									 
															 
											 | 
				
							
					| 23 | 
					0.000507 | 
					
						 DESCRIBE `school_station` 
											 | 
				
							
					| 24 | 
					0.000367 | 
					
						 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3015451', '3015552')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											range										 | 
										school_id | 
										school_id | 
										4 | 
										 | 
										2 | 
										Using index condition | 
									 
															 
											 | 
				
							
					| 25 | 
					0.000557 | 
					
						 DESCRIBE `station_station_unit` 
											 | 
				
							
					| 26 | 
					0.000367 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id IN ('5215', '5215')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											range										 | 
										station_id | 
										station_id | 
										4 | 
										 | 
										1 | 
										Using index condition | 
									 
															 
											 | 
				
							
					| 27 | 
					0.000577 | 
					
						 DESCRIBE `city_major_city` 
											 | 
				
							
					| 28 | 
					0.000377 | 
					
						 SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id IN ('904', '904')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c_m_c | 
										
											range										 | 
										city_id | 
										city_id | 
										4 | 
										 | 
										1 | 
										Using index condition | 
									 
															 
											 | 
				
							
					| 29 | 
					0.000267 | 
					
						 SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.id IN ('6')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										m_c | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 30 | 
					0.000407 | 
					
						 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3015451', '3015552')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											range										 | 
										school_id | 
										school_id | 
										4 | 
										 | 
										2 | 
										Using index condition | 
									 
															 
											 | 
				
							
					| 31 | 
					0.000517 | 
					
						 SELECT `s`.* FROM `station` AS `s` WHERE (s.id IN ('5215', '5215')) GROUP BY `s`.`id` 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											range										 | 
										PRIMARY,city_id,ix_lat_lon_station | 
										PRIMARY | 
										4 | 
										 | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 32 | 
					0.000717 | 
					
						 DESCRIBE `school_score` 
											 | 
				
							
					| 33 | 
					0.017797 | 
					
						 SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id IN ('3015451', '3015552')) AND (s_s.is_latest = 1) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											range										 | 
										school_id | 
										school_id | 
										4 | 
										 | 
										22205 | 
										Using index condition; Using where | 
									 
															 
											 | 
				
							
					| 34 | 
					0.000457 | 
					
						 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3015451', '3015552')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c_s | 
										
											range										 | 
										school_id | 
										school_id | 
										4 | 
										 | 
										8 | 
										Using index condition | 
									 
															 
											 | 
				
							
					| 35 | 
					0.002197 | 
					
						 connect 
											 | 
				
							
					| 36 | 
					0.000477 | 
					
						 SELECT `s_c_s`.* FROM `summary_count_school` AS `s_c_s` WHERE (s_c_s.is_latest = 1) AND (s_c_s.category_id = 0) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id = 0) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id = 0) LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_c_s | 
										
											ref										 | 
										multi | 
										multi | 
										28 | 
										const,const,const,const,const,const,const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 37 | 
					0.000557 | 
					
						 SELECT `p`.* FROM `prefecture` AS `p` 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										p | 
										
											ALL										 | 
										 | 
										 | 
										 | 
										 | 
										47 | 
										 | 
									 
															 
											 | 
				
							
					| 38 | 
					0.000527 | 
					
						 SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '14') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											ref										 | 
										prefecture_id | 
										prefecture_id | 
										5 | 
										const | 
										49 | 
										 | 
									 
															 
											 | 
				
							
					| 39 | 
					0.000677 | 
					
						 DESCRIBE `summary_count_kuchikomi` 
											 | 
				
							
					| 40 | 
					0.000417 | 
					
						 SELECT `s_c_k`.* FROM `summary_count_kuchikomi` AS `s_c_k` WHERE (s_c_k.is_latest = 1) AND (s_c_k.category_id = 6) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = '904') AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = 0) LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_c_k | 
										
											ref										 | 
										multi | 
										multi | 
										20 | 
										const,const,const,const,const | 
										1 | 
										Using index condition | 
									 
															 
											 | 
				
							
					| 41 | 
					0.000537 | 
					
						 DESCRIBE `dancer` 
											 | 
				
							
					| 42 | 
					0.000427 | 
					
						 SELECT `c`.`id` FROM `dancer` AS `c`
 INNER JOIN `dancer_column` AS `d_c` ON c.id = d_c.dancer_id AND d_c.valid = 1 ORDER BY `d_c`.`timestamp_created` DESC 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										d_c | 
										
											ALL										 | 
										ix_dancer_id_dancer_column | 
										 | 
										 | 
										 | 
										29 | 
										Using where; Using filesort | 
									 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											eq_ref										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										jobikai_dance.d_c.dancer_id | 
										1 | 
										Using index | 
									 
															 
											 | 
				
							
					| 43 | 
					0.000387 | 
					
						 SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('17', '16', '15', '14', '13')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											range										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										 | 
										5 | 
										Using where | 
									 
															 
											 | 
				
							
					| 44 | 
					0.000487 | 
					
						 DESCRIBE `dancer_column` 
											 | 
				
							
					| 45 | 
					0.000397 | 
					
						 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '17') ORDER BY `timestamp_created` ASC 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											ref										 | 
										ix_dancer_id_dancer_column | 
										ix_dancer_id_dancer_column | 
										5 | 
										const | 
										2 | 
										Using index condition; Using where; Using filesort | 
									 
															 
											 | 
				
							
					| 46 | 
					0.000407 | 
					
						 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '16') ORDER BY `timestamp_created` ASC 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											ref										 | 
										ix_dancer_id_dancer_column | 
										ix_dancer_id_dancer_column | 
										5 | 
										const | 
										2 | 
										Using index condition; Using where; Using filesort | 
									 
															 
											 | 
				
							
					| 47 | 
					0.000427 | 
					
						 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '15') ORDER BY `timestamp_created` ASC 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											ref										 | 
										ix_dancer_id_dancer_column | 
										ix_dancer_id_dancer_column | 
										5 | 
										const | 
										2 | 
										Using index condition; Using where; Using filesort | 
									 
															 
											 | 
				
							
					| 48 | 
					0.000397 | 
					
						 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '14') ORDER BY `timestamp_created` ASC 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											ref										 | 
										ix_dancer_id_dancer_column | 
										ix_dancer_id_dancer_column | 
										5 | 
										const | 
										2 | 
										Using index condition; Using where; Using filesort | 
									 
															 
											 | 
				
							
					| 49 | 
					0.000357 | 
					
						 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '13') ORDER BY `timestamp_created` ASC 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											ref										 | 
										ix_dancer_id_dancer_column | 
										ix_dancer_id_dancer_column | 
										5 | 
										const | 
										1 | 
										Using index condition; Using where; Using filesort | 
									 
															 
											 |