SELECT * FROM param t0 WHERE 
(t0.cparams_id = 1 AND MATCH (t0.value) AGAINST ("Шок* Сер* Беж*" IN BOOLEAN MODE)) 
AND (t0.cparams_id = 3 AND MATCH (t0.value) AGAINST ("s*" IN BOOLEAN MODE)) 

SELECT * FROM table t1 WHERE t1.type = 1 AND MATCH(t1.value) AGAINST ("Син*" IN BOOLEAN MODE)
SELECT * FROM table t2 WHERE t2.type = 2 AND MATCH(t2.value) AGAINST ("Жен*" IN BOOLEAN MODE)
SELECT * FROM table t3 WHERE t3.type = 3 AND MATCH(t3.value) AGAINST ("Зим*" IN BOOLEAN MODE)

SELECT t4.id_item FROM table t4 WHERE t4.id_item IN (
SELECT t3.id_item FROM table t3 WHERE t3.id_item IN (
SELECT t1.id_item FROM table t1 WHERE 
 t1.type = 1 AND MATCH(t1.value) AGAINST ("Сер*" IN BOOLEAN MODE)
) AND t3.type = 3 AND MATCH(t3.value) AGAINST ("s*" IN BOOLEAN MODE)
) AND t4.type = 4 AND MATCH(t4.value) AGAINST ("ж*" IN BOOLEAN MODE)

SELECT * FROM table t0 
INNER JOIN table t1 ON t1.id_item =t0.id_item AND t1.type =1 AND MATCH (t1.value) AGAINST ("Сер*"  IN BOOLEAN MODE)
INNER JOIN table t2 ON t2.id_item =t0.id_item AND t2.type =3 AND MATCH (t2.value) AGAINST ("s*"  IN BOOLEAN MODE)
INNER JOIN table t3 ON t3.id_item =t0.id_item AND t3.type =4 AND MATCH (t3.value) AGAINST ("ж*"  IN BOOLEAN MODE)
GROUP BY t0.id_item 
LIMIT 5