| No. | 
				time | 
				query | 
			
							
					| 1 | 
					0.002027 | 
					
						 connect 
											 | 
				
							
					| 2 | 
					0.000857 | 
					
						 DESCRIBE `school` 
											 | 
				
							
					| 3 | 
					0.000517 | 
					
						 SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3014595') AND (s.registration_status = 1) AND (s.is_opening = 1) LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 4 | 
					0.000677 | 
					
						 DESCRIBE `school_score` 
											 | 
				
							
					| 5 | 
					0.022867 | 
					
						 SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3014595') AND (s_s.is_latest = 1) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										22350 | 
										Using where | 
									 
															 
											 | 
				
							
					| 6 | 
					0.000677 | 
					
						 DESCRIBE `access_log_school` 
											 | 
				
							
					| 7 | 
					0.008687 | 
					
						 SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.113') AND (school_id = '3014595') AND (timestamp_created >= '2025-11-03 15:21:19') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										access_log_school | 
										
											index_merge										 | 
										school_id,ix_ip_address_access_log_school | 
										ix_ip_address_access_log_school,school_id | 
										767,4 | 
										 | 
										1 | 
										Using intersect(ix_ip_address_access_log_school,school_id); Using where | 
									 
															 
											 | 
				
							
					| 8 | 
					0.000657 | 
					
						 DESCRIBE `access_count_school` 
											 | 
				
							
					| 9 | 
					0.000417 | 
					
						 SELECT `acs`.* FROM `access_count_school` AS `acs` WHERE (acs.school_id = '3014595') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										acs | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 10 | 
					0.000697 | 
					
						 UPDATE `access_count_school` SET `count` = ?, `timestamp_modified` = ? WHERE (`access_count_school`.`id` = 263) 
											 | 
				
							
					| 11 | 
					0.000407 | 
					
						 SELECT `access_count_school`.* FROM `access_count_school` WHERE (`access_count_school`.`id` = 263) LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										access_count_school | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 12 | 
					0.000517 | 
					
						 INSERT INTO `access_log_school` (`school_id`, `ip_address`, `timestamp_created`, `timestamp_modified`) VALUES (?, ?, ?, ?) 
											 | 
				
							
					| 13 | 
					0.000367 | 
					
						 SELECT `access_log_school`.* FROM `access_log_school` WHERE (`access_log_school`.`id` = 14577159) LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										access_log_school | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 14 | 
					0.000607 | 
					
						 DESCRIBE `school_station` 
											 | 
				
							
					| 15 | 
					0.000427 | 
					
						 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014595') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										9 | 
										 | 
									 
															 
											 | 
				
							
					| 16 | 
					0.000477 | 
					
						 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '6177') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										17 | 
										 | 
									 
															 
											 | 
				
							
					| 17 | 
					0.000627 | 
					
						 SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3014416', '3014416', '3014595', '3013265', '3013755', '3014619', '3015284', '3014850', '3014970', '3014570', '3015355', '3015684', '3015137', '3015880', '3015961', '3016083', '3015985')) AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											range										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										 | 
										16 | 
										Using where | 
									 
															 
											 | 
				
							
					| 18 | 
					0.000927 | 
					
						 SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '1450') AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											ref										 | 
										city_id | 
										city_id | 
										5 | 
										const | 
										73 | 
										Using where | 
									 
															 
											 | 
				
							
					| 19 | 
					0.000537 | 
					
						 DESCRIBE `city` 
											 | 
				
							
					| 20 | 
					0.000367 | 
					
						 SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '1450') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 21 | 
					0.000637 | 
					
						 SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '27') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c | 
										
											ref										 | 
										prefecture_id | 
										prefecture_id | 
										5 | 
										const | 
										61 | 
										 | 
									 
															 
											 | 
				
							
					| 22 | 
					0.005147 | 
					
						 SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('1277', '1441', '1442', '1443', '1444', '1445', '1446', '1447', '1448', '1449', '1450', '1451', '1452', '1453', '1454', '1455', '1456', '1457', '1458', '1459', '1460', '1461', '1462', '1463', '1464', '1465', '1466', '1467', '1468', '1469', '1470', '1471', '1472', '1473', '1474', '1475', '1476', '1477', '1478', '1479', '1480', '1481', '1484', '1485', '1486', '1487', '1488', '1489', '1490', '1492', '1493', '1494', '1495', '1496', '1497', '1498', '1499', '1501', '1504', '1505', '1506')) AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											range										 | 
										city_id | 
										city_id | 
										5 | 
										 | 
										665 | 
										Using index condition; Using where | 
									 
															 
											 | 
				
							
					| 23 | 
					0.000577 | 
					
						 DESCRIBE `prefecture` 
											 | 
				
							
					| 24 | 
					0.000377 | 
					
						 SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '27') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										p | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 25 | 
					0.000457 | 
					
						 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014595') ORDER BY `distance` ASC LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										9 | 
										Using index condition; Using filesort | 
									 
															 
											 | 
				
							
					| 26 | 
					0.000657 | 
					
						 DESCRIBE `station` 
											 | 
				
							
					| 27 | 
					0.000407 | 
					
						 SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6177') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 28 | 
					0.000547 | 
					
						 DESCRIBE `station_unit` 
											 | 
				
							
					| 29 | 
					0.000477 | 
					
						 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014595') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										9 | 
										 | 
									 
															 
											 | 
				
							
					| 30 | 
					0.000497 | 
					
						 DESCRIBE `station_station_unit` 
											 | 
				
							
					| 31 | 
					0.000387 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6177') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 32 | 
					0.000367 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2847') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 33 | 
					0.000357 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6178') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 34 | 
					0.000337 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2845') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 35 | 
					0.000367 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6175') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 36 | 
					0.000357 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6176') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 37 | 
					0.000347 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2849') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 38 | 
					0.000357 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '3205') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 39 | 
					0.000337 | 
					
						 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6217') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s_s | 
										
											ref										 | 
										station_id | 
										station_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 40 | 
					0.000317 | 
					
						 SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										 | 
										
																					 | 
										 | 
										 | 
										 | 
										 | 
										 | 
										Impossible WHERE | 
									 
															 
											 | 
				
							
					| 41 | 
					0.000577 | 
					
						 DESCRIBE `major_city` 
											 | 
				
							
					| 42 | 
					0.000497 | 
					
						 DESCRIBE `city_major_city` 
											 | 
				
							
					| 43 | 
					0.000377 | 
					
						 SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '1450') 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c_m_c | 
										
											ref										 | 
										city_id | 
										city_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 44 | 
					0.000317 | 
					
						 SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (false) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										 | 
										
																					 | 
										 | 
										 | 
										 | 
										 | 
										 | 
										Impossible WHERE | 
									 
															 
											 | 
				
							
					| 45 | 
					0.000967 | 
					
						 DESCRIBE `kuchikomi` 
											 | 
				
							
					| 46 | 
					0.000407 | 
					
						 SELECT COUNT(1) AS `zend_paginator_row_count` FROM `kuchikomi` AS `k` WHERE (k.school_id = '3014595') AND (k.valid = 1) LIMIT 5 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										k | 
										
											ref										 | 
										ix_school_id_kuchikomi | 
										ix_school_id_kuchikomi | 
										4 | 
										const | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 47 | 
					0.000457 | 
					
						 SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.school_id = '3014595') AND (k.valid = 1) ORDER BY `k`.`posted_at` DESC LIMIT 5 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										k | 
										
											ref										 | 
										ix_school_id_kuchikomi | 
										ix_school_id_kuchikomi | 
										4 | 
										const | 
										1 | 
										Using index condition; Using where; Using filesort | 
									 
															 
											 | 
				
							
					| 48 | 
					0.000797 | 
					
						 DESCRIBE `kuchikomi_category` 
											 | 
				
							
					| 49 | 
					0.000407 | 
					
						 SELECT `k_c`.* FROM `kuchikomi_category` AS `k_c` WHERE (k_c.kuchikomi_id IN ('1307')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										k_c | 
										
											ref										 | 
										kuchikomi_id | 
										kuchikomi_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 50 | 
					0.000857 | 
					
						 DESCRIBE `member` 
											 | 
				
							
					| 51 | 
					0.000437 | 
					
						 SELECT `m`.* FROM `member` AS `m` WHERE (m.id IN ('2954')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										m | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 52 | 
					0.000517 | 
					
						 SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3014595')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 53 | 
					0.000737 | 
					
						 DESCRIBE `access_count_kuchikomi` 
											 | 
				
							
					| 54 | 
					0.000397 | 
					
						 SELECT `a_c_k`.* FROM `access_count_kuchikomi` AS `a_c_k` WHERE (a_c_k.kuchikomi_id IN ('1307')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										a_c_k | 
										
											ref										 | 
										kuchikomi_id | 
										kuchikomi_id | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 55 | 
					0.000727 | 
					
						 DESCRIBE `kuchikomi_questionnaire_answer` 
											 | 
				
							
					| 56 | 
					0.000457 | 
					
						 SELECT `k_q_a`.* FROM `kuchikomi_questionnaire_answer` AS `k_q_a` WHERE (k_q_a.kuchikomi_id IN ('1307')) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										k_q_a | 
										
											ref										 | 
										ix_kuchikomi_id_kuchikomi_questionnaire_answer | 
										ix_kuchikomi_id_kuchikomi_questionnaire_answer | 
										4 | 
										const | 
										6 | 
										 | 
									 
															 
											 | 
				
							
					| 57 | 
					0.001897 | 
					
						 connect 
											 | 
				
							
					| 58 | 
					0.000597 | 
					
						 DESCRIBE `summary_count_school` 
											 | 
				
							
					| 59 | 
					0.000507 | 
					
						 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 | 
										 | 
									 
															 
											 | 
				
							
					| 60 | 
					0.000917 | 
					
						 DESCRIBE `feature_school` 
											 | 
				
							
					| 61 | 
					0.000407 | 
					
						 SELECT `f_s`.* FROM `feature_school` AS `f_s` WHERE (f_s.school_id = '3014595') AND (f_s.valid = 1) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										f_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 62 | 
					0.000737 | 
					
						 DESCRIBE `gallery_school` 
											 | 
				
							
					| 63 | 
					0.000437 | 
					
						 SELECT `g_s`.* FROM `gallery_school` AS `g_s` WHERE (g_s.school_id = '3014595') AND (g_s.valid = 1) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										g_s | 
										
											ref										 | 
										ix_school_id_gallery_school | 
										ix_school_id_gallery_school | 
										4 | 
										const | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 64 | 
					0.000707 | 
					
						 DESCRIBE `campaign_school` 
											 | 
				
							
					| 65 | 
					0.000487 | 
					
						 SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3014595') AND (c_s.valid = 1) AND (c_s.expiration_date = "0000-00-00" || c_s.expiration_date IS NULL || c_s.expiration_date >= 2025-11-04) ORDER BY `timestamp_created` DESC LIMIT 3 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c_s | 
										
											ref										 | 
										school_id,ix_expiration_date_campaign_school | 
										school_id | 
										4 | 
										const | 
										1 | 
										Using index condition; Using where; Using filesort | 
									 
															 
											 | 
				
							
					| 66 | 
					0.000817 | 
					
						 DESCRIBE `announcement_school` 
											 | 
				
							
					| 67 | 
					0.000537 | 
					
						 SELECT `a`.* FROM `announcement_school` AS `a` WHERE (a.school_id = '3014595') AND (a.valid = 1) AND (a.post_start_date <= '2025-11-04') AND (a.post_end_date   >= '2025-11-04') ORDER BY `timestamp_created` DESC 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										a | 
										
											ref										 | 
										school_id,ix_date_announcement_school | 
										school_id | 
										4 | 
										const | 
										1 | 
										Using index condition; Using where; Using filesort | 
									 
															 
											 | 
				
							
					| 68 | 
					0.000867 | 
					
						 DESCRIBE `staff_school` 
											 | 
				
							
					| 69 | 
					0.000427 | 
					
						 SELECT `s`.* FROM `staff_school` AS `s` WHERE (s.school_id = '3014595') AND (s.valid = 1) 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 70 | 
					0.000647 | 
					
						 DESCRIBE `category_school` 
											 | 
				
							
					| 71 | 
					0.000387 | 
					
						 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014595') AND (c_s.valid = 1) LIMIT 5 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 72 | 
					0.000377 | 
					
						 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014595') AND (c_s.valid = 1) LIMIT 5 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 73 | 
					0.000377 | 
					
						 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014595') AND (c_s.valid = 1) LIMIT 5 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 74 | 
					0.000427 | 
					
						 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014595') AND (c_s.valid = 1) LIMIT 6 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										c_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										1 | 
										Using where | 
									 
															 
											 | 
				
							
					| 75 | 
					0.000467 | 
					
						 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014595') ORDER BY `time` ASC, `distance` ASC LIMIT 3 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s_s | 
										
											ref										 | 
										school_id | 
										school_id | 
										4 | 
										const | 
										9 | 
										Using index condition; Using filesort | 
									 
															 
											 | 
				
							
					| 76 | 
					0.000377 | 
					
						 SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6177') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 77 | 
					0.000367 | 
					
						 SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '2847') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 78 | 
					0.000377 | 
					
						 SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6178') LIMIT 1 
													
								
									| id | 
									select_type | 
									table | 
									type | 
									possible_keys | 
									key | 
									key_len | 
									ref | 
									rows | 
									Extra | 
								 
																	
										| 1 | 
										SIMPLE | 
										s | 
										
											const										 | 
										PRIMARY | 
										PRIMARY | 
										4 | 
										const | 
										1 | 
										 | 
									 
															 
											 | 
				
							
					| 79 | 
					0.000737 | 
					
						 DESCRIBE `dancer` 
											 | 
				
							
					| 80 | 
					0.000637 | 
					
						 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 | 
									 
															 
											 | 
				
							
					| 81 | 
					0.000447 | 
					
						 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 | 
									 
															 
											 | 
				
							
					| 82 | 
					0.000597 | 
					
						 DESCRIBE `dancer_column` 
											 | 
				
							
					| 83 | 
					0.000467 | 
					
						 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 | 
									 
															 
											 | 
				
							
					| 84 | 
					0.000437 | 
					
						 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 | 
									 
															 
											 | 
				
							
					| 85 | 
					0.000437 | 
					
						 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 | 
									 
															 
											 | 
				
							
					| 86 | 
					0.000427 | 
					
						 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 | 
									 
															 
											 | 
				
							
					| 87 | 
					0.000427 | 
					
						 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 | 
									 
															 
											 |