/home/twhxtczfqg/checkout.fallinglizard.com/lib/SearchEngine/DefaultEngine.php:610 "Search Engine Debug 🔎 🪲"

Engine Type ⚙️: "SLiMS\SearchEngine\DefaultEngine"

SQL ⚙️: array:2 [
  "count" => "select count(distinct b.biblio_id) from biblio as b left join mst_publisher as mp on b.publisher_id=mp.publisher_id left join mst_place as mpl on b.publish_place_id=mpl.place_id left join item as i on b.biblio_id=i.biblio_id where b.opac_hide=0 and (i.coll_type_id in(select coll_type_id from mst_coll_type where coll_type_name = ?))"
  "query" => "select b.biblio_id, b.title, b.image, b.isbn_issn, b.publish_year, mp.publisher_name as `publisher`, mpl.place_name as `publish_place`, b.labels, b.input_date, b.edition, b.collation, b.series_title, b.call_number from biblio as b left join mst_publisher as mp on b.publisher_id=mp.publisher_id left join mst_place as mpl on b.publish_place_id=mpl.place_id left join item as i on b.biblio_id=i.biblio_id where b.opac_hide=0 and (i.coll_type_id in(select coll_type_id from mst_coll_type where coll_type_name = ?)) group by b.biblio_id order by b.last_update desc limit 10 offset 20"
]

Bind Value ⚒️: array:1 [
  0 => "Book"
]