運営からお知らせ
<a href="https://google.com">機能</a>が追加されました。
2019-03-29
フリマサイト構築CMSを発表しました!
2018-12-07
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
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 AND Item.is_list = 1 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 AND Item.is_list = 1 | 29 | 29 | 1 | |
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 | 5 | 5 | 1 | |
5 | SELECT `Whatsnews`.`id`, `Whatsnews`.`comment_date`, `Whatsnews`.`title`, `Whatsnews`.`comment`, `Whatsnews`.`linkurl`, `Whatsnews`.`del_flg`, `Whatsnews`.`created`, `Whatsnews`.`modified` FROM `liblat01_furimo`.`whatsnews` AS `Whatsnews` WHERE `del_flg` = 0 ORDER BY `comment_date` DESC | 2 | 2 | 0 | |
6 | SELECT `HtmlPart`.`id`, `HtmlPart`.`part_type`, `HtmlPart`.`part_file_flg`, `HtmlPart`.`part_desc`, `HtmlPart`.`part_default`, `HtmlPart`.`part_html`, `HtmlPart`.`created`, `HtmlPart`.`modified` FROM `liblat01_furimo`.`html_parts` AS `HtmlPart` WHERE `HtmlPart`.`part_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
7 | SELECT `HtmlPart`.`id`, `HtmlPart`.`part_type`, `HtmlPart`.`part_file_flg`, `HtmlPart`.`part_desc`, `HtmlPart`.`part_default`, `HtmlPart`.`part_html`, `HtmlPart`.`created`, `HtmlPart`.`modified` FROM `liblat01_furimo`.`html_parts` AS `HtmlPart` WHERE `HtmlPart`.`part_type` = 2 LIMIT 1 | 1 | 1 | 0 |