^ "select `kyoushitsu`.`id`, `kyoushitsu`.`code`, `kyoushitsu`.`is_open`, `kyoushitsu`.`plan`, `kyoushitsu`.`name`, `kyoushitsu`.`kana`, `kyoushitsu`.`online`, `kyoushitsu`.`tel`, `kyoushitsu`.`tel_time`, `kyoushitsu`.`zip`, `kyoushitsu`.`pref_id`, `kyoushitsu`.`city_id`, `kyoushitsu`.`address`, `kyoushitsu`.`lat`, `kyoushitsu`.`long`, `kyoushitsu`.`access`, `kyoushitsu`.`instagram`, `kyoushitsu`.`facebook`, `kyoushitsu`.`twitter`, `kyoushitsu`.`line`, `kyoushitsu`.`contact_types`, `kyoushitsu`.`feature_1`, `kyoushitsu`.`feature_2`, `kyoushitsu`.`feature_3`, `kyoushitsu`.`image_sub`, `kyoushitsu`.`movie`, `kyoushitsu`.`detail`, `kyoushitsu`.`news`, `kyoushitsu`.`news_start`, `kyoushitsu`.`news_end`, `kyoushitsu`.`email`, `kyoushitsu`.`user_login`, `kyoushitsu`.`is_valid`, `kyoushitsu`.`is_parent`, `kyoushitsu`.`has_own_pages`, `kyoushitsu`.`is_child`, `kyoushitsu`.`order_news`, `kyoushitsu`.`order_course`, `kyoushitsu`.`order_taiken`, `kyoushitsu`.`order_teacher`, `kyoushitsu`.`order_faq`, `kyoushitsu`.`order_blog`, `kyoushitsu`.`alliance_id`, `kyoushitsu`.`alliance_code`, `kyoushitsu`.`alliance_manager`, `kyoushitsu`.`contact_link`, `kyoushitsu`.`completeness` from `kyoushitsu` where `city_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `is_open` = ? and (`is_parent` != ? or (`is_parent` = ? and `has_own_pages` = ?)) and `kyoushitsu`.`deleted_at` is null group by `kyoushitsu`.`id` order by `plan` asc, `completeness` desc, `contents_created_at` desc, `random_order` asc, `id` desc limit 20 offset 0"
^ array:27 [
  0 => 13101
  1 => 13102
  2 => 13103
  3 => 13104
  4 => 13105
  5 => 13106
  6 => 13107
  7 => 13108
  8 => 13109
  9 => 13110
  10 => 13111
  11 => 13112
  12 => 13113
  13 => 13114
  14 => 13115
  15 => 13116
  16 => 13117
  17 => 13118
  18 => 13119
  19 => 13120
  20 => 13121
  21 => 13122
  22 => 13123
  23 => 1
  24 => 1
  25 => 1
  26 => 1
]
^ 9820