SELECT
`materials`.`id`,
`materials`.`uid`,
`materials`.`title`,
`materials`.`type`,
`materials`.`tag`,
`materials`.`description`,
`materials`.`content`,
`materials`.`photo_list`,
`materials`.`video_list`,
`materials`.`view`,
`materials`.`likes`,
`materials`.`share`,
`materials`.`comment`,
`materials`.`customer`,
`materials`.`create_time`,
`materials`.`is_top`,
`materials`.`status`
FROM
`ap_material_like` `like_material`
INNER JOIN `ap_materials` `materials` ON `materials`.`id` = `like_material`.`material_id`
WHERE
`materials`.`seller_id` = 2
AND `materials`.`status` = 1
AND `materials`.`display` = 1
AND
(
`materials`.`m_category_id` IN ( 10001, 10005, 10008 )
AND ( ( `materials`.`tag` LIKE '%胖%' ) OR ( `materials`.`content` LIKE '%胖%' ) )
AND `like_material`.`uid` = '196893'
AND `like_material`.`typeid` = 3
AND `like_material`.`status` = 1
)
OR (
`materials`.`m_category_id` IN ( 10011, 10012, 10013, 10014, 10015 )
AND ( ( `materials`.`title` LIKE '%胖%' ) OR ( `materials`.`description` LIKE '%胖%' ) OR ( `materials`.`tag` LIKE '%胖%' ) )
AND `like_material`.`uid` = '196893'
AND `like_material`.`typeid` = 3
AND `like_material`.`status` = 1
)
ORDER BY
`like_material`.`create_time` DESC
LIMIT 0, 20
그럼 실제로 필요한 것은
SELECT
`materials`.`id`,
`materials`.`uid`,
`materials`.`title`,
`materials`.`type`,
`materials`.`tag`,
`materials`.`description`,
`materials`.`content`,
`materials`.`photo_list`,
`materials`.`video_list`,
`materials`.`view`,
`materials`.`likes`,
`materials`.`share`,
`materials`.`comment`,
`materials`.`customer`,
`materials`.`create_time`,
`materials`.`is_top`,
`materials`.`status`
FROM
`ap_material_like` `like_material`
INNER JOIN `ap_materials` `materials` ON `materials`.`id` = `like_material`.`material_id`
WHERE
`materials`.`seller_id` = 2
AND `materials`.`status` = 1
AND `materials`.`display` = 1
AND ( {括号开头}
(
`materials`.`m_category_id` IN ( 10001, 10016, 10017 )
AND ( ( `materials`.`tag` LIKE '%胖%' ) OR ( `materials`.`content` LIKE '%胖%' ) )
AND `like_material`.`uid` = '196893'
AND `like_material`.`typeid` = 3
AND `like_material`.`status` = 1
)
OR (
`materials`.`m_category_id` IN ( 10020, 10021, 10022, 10023, 10024 )
AND ( ( `materials`.`title` LIKE '%胖%' ) OR ( `materials`.`description` LIKE '%胖%' ) OR ( `materials`.`tag` LIKE '%胖%' ) )
AND `like_material`.`uid` = '196893'
AND `like_material`.`typeid` = 3
AND `like_material`.`status` = 1
)
){括号结束}
ORDER BY
`like_material`.`create_time` DESC
LIMIT 0, 20
프로젝트의 코드
인쇄된 SQL 문은
그럼 실제로 필요한 것은
그리고 키워드는 여전히 이렇습니다
$sql = 'SQL';
$result = Db::query($sql);