gpt4 book ai didi

php - 是否有任何在线工具或可以简化此 MySQL SELECT 查询的人?

转载 作者:行者123 更新时间:2023-12-01 00:51:33 24 4
gpt4 key购买 nike

<分区>

我正在为图书馆的搜索框编写一个自动建议程序,它非常慢。有没有在线工具或者谁愿意帮我优化一下?

 SELECT *,
grbc_books.id book_id
FROM grbc_books
LEFT JOIN grbc_series
ON grbc_books.series_id = grbc_series.id
JOIN grbc_collections
ON grbc_books.collection_id = grbc_collections.id
LEFT JOIN grbc_places
ON grbc_books.place_id = grbc_places.id
RIGHT JOIN grbc_books_subjects
ON grbc_books_subjects.book_id = grbc_books.id
LEFT JOIN grbc_subjects
ON grbc_books_subjects.subject_id = grbc_subjects.id
RIGHT JOIN grbc_books_authors
ON grbc_books_authors.book_id = grbc_books.id
LEFT JOIN grbc_authors
ON grbc_books_authors.author_id = grbc_authors.id
AND ( ( title LIKE "%yea%" )
OR ( subtitle LIKE "%yea%" )
OR ( series LIKE "%yea%" )
OR ( `subject` LIKE "%yea%" )
OR ( `first` LIKE "%yea%" )
OR ( `last` LIKE "%yea%" )
OR ( place LIKE "%yea%" ) )
GROUP BY `title`,
subtitle
ORDER BY title
LIMIT 10;

提前致谢。

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com