| 1 | SELECT * FROM data_branches WHERE del_flg <= 0 | | 0 | 0 | 0 |
| 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 | | 4 | 4 | 1 |
| 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 >= 0 | | 717 | 717 | 7 |
| 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 | | 10 | 10 | 19 |
| 5 | 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 50 | | 50 | 50 | 19 |
| 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 ( tag1 LIKE '%フルーツ%' OR tag2 LIKE '%フルーツ%' OR tag3 LIKE '%フルーツ%' OR tag4 LIKE '%フルーツ%' OR tag5 LIKE '%フルーツ%' ) ORDER BY Item.modified DESC LIMIT 0 ,100 | | 100 | 100 | 2 |
| 7 | 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 ( tag1 LIKE '%フルーツ%' OR tag2 LIKE '%フルーツ%' OR tag3 LIKE '%フルーツ%' OR tag4 LIKE '%フルーツ%' OR tag5 LIKE '%フルーツ%' ) | | 140 | 140 | 3 |
| 8 | SELECT `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 1 | | 1 | 1 | 0 |
| 9 | SELECT `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 1 | | 1 | 1 | 0 |
| 10 | SELECT `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 1 | | 1 | 1 | 0 |
