果物・その他果物の商品一覧

70件表示

表示件数:

(default) 9 queries took 32 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT * FROM data_branches WHERE del_flg <= 0 000
2 SELECT Item.* , Member.name AS name , Member.company AS company , Member.nickname AS nickname FROM items Item INNER JOIN members Member ON Member.id = Item.member_id WHERE Item.del_flg = 0 AND Item.save_flg = 1 AND Item.sale_rank >= 0 ORDER BY Item.sale_rank DESC LIMIT 0 ,4 441
3 SELECT Item.* , Member.name AS name , Member.company AS company , Member.nickname AS nickname FROM items Item INNER JOIN members Member ON Member.id = Item.member_id WHERE Item.del_flg = 0 AND Item.save_flg = 1 AND Item.sale_rank >= 07177177
4 SELECT MAX(tag) AS tag_name , count(tag) AS tag_cnt FROM ( SELECT `tag1` AS tag FROM `items` WHERE tag1 <> '' AND tag1 IS NOT NULL AND del_flg = 0 UNION ALL SELECT `tag2` AS tag FROM `items` WHERE tag2 <> '' AND tag2 IS NOT NULL AND del_flg = 0 UNION ALL SELECT `tag3` AS tag FROM `items` WHERE tag3 <> '' AND tag3 IS NOT NULL AND del_flg = 0 UNION ALL SELECT `tag4` AS tag FROM `items` WHERE tag4 <> '' AND tag4 IS NOT NULL AND del_flg = 0 UNION ALL SELECT `tag5` AS tag FROM `items` WHERE tag5 <> '' AND tag5 IS NOT NULL AND del_flg = 0 ) TEMP GROUP BY TEMP.tag ORDER BY count(TEMP.tag) DESC, TEMP.tag LIMIT 10 101019
5 SELECT Item.* , Member.name AS name, Member.id AS member_no , Member.company AS company , Member.nickname AS nickname FROM items Item LEFT JOIN members Member ON Member.id = Item.member_id WHERE Item.del_flg = 0 AND category LIKE '%果物・その他果物%' AND save_flg = 1 ORDER BY Item.modified DESC LIMIT 0 ,100 70702
6 SELECT Item.* , Member.name AS name, Member.id AS member_no , Member.company AS company , Member.nickname AS nickname FROM items Item LEFT JOIN members Member ON Member.id = Item.member_id WHERE Item.del_flg = 0 AND category LIKE '%果物・その他果物%' AND save_flg = 1 70703
7SELECT `HtmlPart`.`id`, `HtmlPart`.`part_type`, `HtmlPart`.`part_file_flg`, `HtmlPart`.`part_desc`, `HtmlPart`.`part_default`, `HtmlPart`.`part_html`, `HtmlPart`.`created`, `HtmlPart`.`modified` FROM `release_shop_sc`.`html_parts` AS `HtmlPart` WHERE `HtmlPart`.`part_type` = 1 LIMIT 1110
8SELECT `HtmlPart`.`id`, `HtmlPart`.`part_type`, `HtmlPart`.`part_file_flg`, `HtmlPart`.`part_desc`, `HtmlPart`.`part_default`, `HtmlPart`.`part_html`, `HtmlPart`.`created`, `HtmlPart`.`modified` FROM `release_shop_sc`.`html_parts` AS `HtmlPart` WHERE `HtmlPart`.`part_type` = 2 LIMIT 1110
9SELECT `HtmlPart`.`id`, `HtmlPart`.`part_type`, `HtmlPart`.`part_file_flg`, `HtmlPart`.`part_desc`, `HtmlPart`.`part_default`, `HtmlPart`.`part_html`, `HtmlPart`.`created`, `HtmlPart`.`modified` FROM `release_shop_sc`.`html_parts` AS `HtmlPart` WHERE `HtmlPart`.`part_type` = 3 LIMIT 1110