- 1
Query : (select * from premade_product_set s where s.type = 'sell' and ( s.category_tag like '% 89 %' or s.category_tag like '% 104 %' or s.category_tag like '% 103 %' or s.category_tag like '% 102 %' or s.category_tag like '% 100 %' or s.category_tag like '% 99 %' or s.category_tag like '% 98 %' or s.category_tag like '% 97 %' or s.category_tag like '% 96 %' or s.category_tag like '% 95 %' or s.category_tag like '% 94 %' or s.category_tag like '% 93 %' or s.category_tag like '% 92 %' or s.category_tag like '% 91 %' or s.category_tag like '% 90 %' or s.category_tag like '% 105 %' ) order by regdate desc) limit 0,32;
[ALL/Using where; Using filesort]: in (194)
: 5.7 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 '% 89 %' or s.category_tag like '% 104 %' or s.category_tag like '% 103 %' or s.category_tag like '% 102 %' or s.category_tag like '% 100 %' or s.category_tag like '% 99 %' or s.category_tag like '% 98 %' or s.category_tag like '% 97 %' or s.category_tag like '% 96 %' or s.category_tag like '% 95 %' or s.category_tag like '% 94 %' or s.category_tag like '% 93 %' or s.category_tag like '% 92 %' or s.category_tag like '% 91 %' or s.category_tag like '% 90 %' or s.category_tag like '% 105 %' ))
[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 = 'HOUSENINTERIOR' and t.lang='en';
[ALL/Using where]: in PRIMARY (125)
: 0.6 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