Query : (select * from premade_product_set s where s.type = 'sell' and ( s.category_tag like '% 107 %' or s.category_tag like '% 108 %' or s.category_tag like '% 109 %' or s.category_tag like '% 110 %' or s.category_tag like '% 112 %' or s.category_tag like '% 113 %' ) order by regdate desc) limit 0,32;
[ALL/Using where; Using filesort]: in (194)
: 2.5 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 '% 107 %' or s.category_tag like '% 108 %' or s.category_tag like '% 109 %' or s.category_tag like '% 110 %' or s.category_tag like '% 112 %' or s.category_tag like '% 113 %' ))
[ALL/Using where]: in (194)
: 0.7 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 = 'DOLL' 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