^ "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:28 [
  0 => 27102
  1 => 27103
  2 => 27104
  3 => 27106
  4 => 27107
  5 => 27108
  6 => 27109
  7 => 27111
  8 => 27113
  9 => 27114
  10 => 27115
  11 => 27116
  12 => 27117
  13 => 27118
  14 => 27119
  15 => 27120
  16 => 27121
  17 => 27122
  18 => 27123
  19 => 27124
  20 => 27125
  21 => 27126
  22 => 27127
  23 => 27128
  24 => 1
  25 => 1
  26 => 1
  27 => 1
]

^ 2906