Query : (select * from premade_product_set s where s.type = 'sell' and ( s.category_tag like '% 24 %' or s.category_tag like '% 25 %' or s.category_tag like '% 26 %' or s.category_tag like '% 27 %' or s.category_tag like '% 28 %' or s.category_tag like '% 29 %' or s.category_tag like '% 30 %' or s.category_tag like '% 31 %' or s.category_tag like '% 32 %' ) 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 '% 24 %' or s.category_tag like '% 25 %' or s.category_tag like '% 26 %' or s.category_tag like '% 27 %' or s.category_tag like '% 28 %' or s.category_tag like '% 29 %' or s.category_tag like '% 30 %' or s.category_tag like '% 31 %' or s.category_tag like '% 32 %' ))
[ALL/Using where]: in (194)
: 0.8 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 = 'ART' and t.lang='en';
[ALL/Using where]: in PRIMARY (125)
: 0.4 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