# /var/www/slims9/lib/SearchEngine/DefaultEngine.php:608^ "Engine ⚙️ : 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 where b.opac_hide=0 and (b.biblio_id in(select bt.biblio_id from biblio_topic as bt left join mst_topic as mt on bt.topic_id=mt.topic_id where mt.topic like ?))"
"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 where b.opac_hide=0 and (b.biblio_id in(select bt.biblio_id from biblio_topic as bt left join mst_topic as mt on bt.topic_id=mt.topic_id where mt.topic like ?)) order by b.last_update desc limit 10 offset 0"
]
^ "Bind Value ⚒️"
^ array:1 [
0 => "%Psikologi Remaja%"
]
{"@context":"http:\/\/schema.org","@type":"Book","total_rows":6,"page":1,"records_each_page":10,"@graph":[{"@id":"http:\/\/lib.radenintan.ac.id\/index.php?p=show_detail&id=28865","name":"Remaja Ed.11 Jil.2","author":{"name":["Benedictine Widyasinta","Santrock, John W"]},"isbn":"978 979 075 686 1","publisher":"Erlangga","dateCreated":"2007","image":"49383.jpg.jpg"},{"@id":"http:\/\/lib.radenintan.ac.id\/index.php?p=show_detail&id=23717","name":"Psikologi Remaja","author":{"name":["Al-Mighwar, muhammad"]},"isbn":"979-730-816-4","publisher":"Pustaka Setia","dateCreated":"2006","image":"42895.jpg.jpg"},{"@id":"http:\/\/lib.radenintan.ac.id\/index.php?p=show_detail&id=23715","name":"psikologi Remaja","author":{"name":["Sulaeman, Dadang","Oemar Hamalik"]},"isbn":"979-538-109-1","publisher":"Mandar Maju","dateCreated":"1995","image":"42893.jpg.jpg"},{"@id":"http:\/\/lib.radenintan.ac.id\/index.php?p=show_detail&id=5699","name":"Psikologi remaja","author":{"name":["Sarwono, Sarlito Wirawan"]},"isbn":"9794211974","publisher":"PT. RajaGrafindo Persada","dateCreated":"2008","image":"14171.jpg.jpg"},{"@id":"http:\/\/lib.radenintan.ac.id\/index.php?p=show_detail&id=3789","name":"Problema remaja di Indonesia","author":{"name":["Daradjat, Zakiah"]},"isbn":"","publisher":"Bulan Bintang","dateCreated":"1974"},{"@id":"http:\/\/lib.radenintan.ac.id\/index.php?p=show_detail&id=18947","name":"Mitos Cantik di Media","author":{"name":["Amalia, Lia","Abdul Azis Muslim"]},"isbn":"978 602 8480 47 5","publisher":"STAIN Ponorogo Press","dateCreated":"2009","image":"cv_novel_mitos.jpg.jpg"}]}