Query : (select * from premade_product_set s where s.type = 'sell' and ( s.category_tag like '% 75 %' or s.category_tag like '% 86 %' or s.category_tag like '% 85 %' or s.category_tag like '% 84 %' or s.category_tag like '% 83 %' or s.category_tag like '% 82 %' or s.category_tag like '% 81 %' or s.category_tag like '% 80 %' or s.category_tag like '% 79 %' or s.category_tag like '% 78 %' or s.category_tag like '% 77 %' or s.category_tag like '% 76 %' or s.category_tag like '% 87 %' ) order by regdate desc) limit 0,32;
[ALL/Using where; Using filesort]: in (194)
: 3.2 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 146] : /home1/www/dev/lib/page.php
[line : 50] : /home1/www/dev/pages/shop.premade.list.php
Query : (select count(s.itemcode) as con from premade_product_set s where s.type = 'sell' and ( s.category_tag like '% 75 %' or s.category_tag like '% 86 %' or s.category_tag like '% 85 %' or s.category_tag like '% 84 %' or s.category_tag like '% 83 %' or s.category_tag like '% 82 %' or s.category_tag like '% 81 %' or s.category_tag like '% 80 %' or s.category_tag like '% 79 %' or s.category_tag like '% 78 %' or s.category_tag like '% 77 %' or s.category_tag like '% 76 %' or s.category_tag like '% 87 %' ))
[ALL/Using where]: in (194)
: 1 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 161] : /home1/www/dev/lib/page.php
[line : 51] : /home1/www/dev/pages/shop.premade.list.php
Query : select * from premade_item_good_text t , premade_item_good g where t.goodgrpno = g.goodgrpno and g.name_id = 'QUILT' and t.lang='en';
[ALL/Using where]: in PRIMARY (125)
: 0.5 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 58] : /home1/www/dev/pages/shop.premade.list.php