RELEASEコマース｜奈良県産富有柿（4L 10玉入り）

奈良県産富有柿（4L 10玉入り）

秋の味覚を奈良からいち早くお届け！
富有柿は、その名前から「富が有る」果実とも言われ、縁起物として贈り物にもおすすめです。
ふっくら丸みを帯びた果実には、甘味と果汁がたっぷり！

奈良県産富有柿（4L 10玉入り）

1,700円

売り切れお気に入り

商品番号	000258
登録日	2020年09月28日
カテゴリー	果物・柿
配送料の負担	送料込み
配送方法	宅配便
発送元の地域	奈良県
発送までの日数	1～2日で発送

売り切れお気に入り

(default) 20 queries took 75 ms
Nr	Query	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 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 `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`members` AS `Member` WHERE `id` IS NULL AND `del_flg` = 0 AND `role` = 'user' LIMIT 1	0	0	0
6	SELECT `Config`.`id`, `Config`.`code`, `Config`.`name`, `Config`.`unit_name`, `Config`.`type`, `Config`.`number`, `Config`.`value`, `Config`.`description`, `Config`.`rank`, `Config`.`del_flg`, `Config`.`created`, `Config`.`modified` FROM `release_shop_sc`.`configs` AS `Config` WHERE `Config`.`code` = 'view_without_login' AND `Config`.`del_flg` = 0 LIMIT 1	1	1	0
7	SELECT `Item`.`id`, `Item`.`member_id`, `Item`.`title`, `Item`.`price`, `Item`.`fee`, `Item`.`category`, `Item`.`discription`, `Item`.`message`, `Item`.`password`, `Item`.`review`, `Item`.`review_auther`, `Item`.`tag1`, `Item`.`tag2`, `Item`.`tag3`, `Item`.`tag4`, `Item`.`tag5`, `Item`.`main_image_file_name`, `Item`.`sub_image1_file_name`, `Item`.`sub_image2_file_name`, `Item`.`sub_image3_file_name`, `Item`.`sub_image4_file_name`, `Item`.`file_name`, `Item`.`file_path`, `Item`.`file_type`, `Item`.`file_extension`, `Item`.`file_size`, `Item`.`selling`, `Item`.`sale_count`, `Item`.`pickup`, `Item`.`sale_rank`, `Item`.`seller_rank`, `Item`.`quantity`, `Item`.`shippingpayer`, `Item`.`shippingmethod`, `Item`.`shippingfromarea`, `Item`.`shippingduration`, `Item`.`image_file_name`, `Item`.`aboutshippingcost`, `Item`.`del_flg`, `Item`.`save_flg`, `Item`.`close_flg`, `Item`.`created`, `Item`.`modified`, `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`items` AS `Item` LEFT JOIN `release_shop_sc`.`members` AS `Member` ON (`Item`.`member_id` = `Member`.`id`) WHERE `Item`.`id` = 258 AND `Item`.`del_flg` = 0 AND `Item`.`save_flg` = 1 LIMIT 1	1	1	0
8	SELECT `Item`.`id`, `Item`.`member_id`, `Item`.`title`, `Item`.`price`, `Item`.`fee`, `Item`.`category`, `Item`.`discription`, `Item`.`message`, `Item`.`password`, `Item`.`review`, `Item`.`review_auther`, `Item`.`tag1`, `Item`.`tag2`, `Item`.`tag3`, `Item`.`tag4`, `Item`.`tag5`, `Item`.`main_image_file_name`, `Item`.`sub_image1_file_name`, `Item`.`sub_image2_file_name`, `Item`.`sub_image3_file_name`, `Item`.`sub_image4_file_name`, `Item`.`file_name`, `Item`.`file_path`, `Item`.`file_type`, `Item`.`file_extension`, `Item`.`file_size`, `Item`.`selling`, `Item`.`sale_count`, `Item`.`pickup`, `Item`.`sale_rank`, `Item`.`seller_rank`, `Item`.`quantity`, `Item`.`shippingpayer`, `Item`.`shippingmethod`, `Item`.`shippingfromarea`, `Item`.`shippingduration`, `Item`.`image_file_name`, `Item`.`aboutshippingcost`, `Item`.`del_flg`, `Item`.`save_flg`, `Item`.`close_flg`, `Item`.`created`, `Item`.`modified`, `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`items` AS `Item` LEFT JOIN `release_shop_sc`.`members` AS `Member` ON (`Item`.`member_id` = `Member`.`id`) WHERE `Item`.`del_flg` = 0 AND `Item`.`save_flg` = 1 AND `Item`.`selling` = 1 AND `Item`.`category` = '果物・柿' ORDER BY `Item`.`sale_count` DESC LIMIT 4	4	4	1
9	SELECT `Item`.`id`, `Item`.`member_id`, `Item`.`title`, `Item`.`price`, `Item`.`fee`, `Item`.`category`, `Item`.`discription`, `Item`.`message`, `Item`.`password`, `Item`.`review`, `Item`.`review_auther`, `Item`.`tag1`, `Item`.`tag2`, `Item`.`tag3`, `Item`.`tag4`, `Item`.`tag5`, `Item`.`main_image_file_name`, `Item`.`sub_image1_file_name`, `Item`.`sub_image2_file_name`, `Item`.`sub_image3_file_name`, `Item`.`sub_image4_file_name`, `Item`.`file_name`, `Item`.`file_path`, `Item`.`file_type`, `Item`.`file_extension`, `Item`.`file_size`, `Item`.`selling`, `Item`.`sale_count`, `Item`.`pickup`, `Item`.`sale_rank`, `Item`.`seller_rank`, `Item`.`quantity`, `Item`.`shippingpayer`, `Item`.`shippingmethod`, `Item`.`shippingfromarea`, `Item`.`shippingduration`, `Item`.`image_file_name`, `Item`.`aboutshippingcost`, `Item`.`del_flg`, `Item`.`save_flg`, `Item`.`close_flg`, `Item`.`created`, `Item`.`modified`, `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`items` AS `Item` LEFT JOIN `release_shop_sc`.`members` AS `Member` ON (`Item`.`member_id` = `Member`.`id`) WHERE `Item`.`del_flg` = 0 AND `Item`.`save_flg` = 1 AND `Item`.`selling` = 1 AND `Item`.`member_id` = 147 ORDER BY `Item`.`sale_count` DESC LIMIT 4	1	1	1
10	SELECT * FROM browses Browse INNER JOIN items Item ON Browse.item_id = Item.id AND Item.selling = 1 AND Item.save_flg = 1 AND Item.del_flg = 0 INNER JOIN members Member ON Member.id = Item.member_id WHERE Browse.id > 0 AND Browse.session_id = 'dpq6nflo668ieag18v6iamkt70' OR Browse.member_id = '' GROUP BY Item.id LIMIT 12	0	0	27
11	SELECT COUNT(*) AS `count` FROM `release_shop_sc`.`browses` AS `Browse` WHERE `session_id` = 'dpq6nflo668ieag18v6iamkt70' AND `member_id` IS NULL AND `item_id` = 258	1	1	17
12	INSERT INTO `release_shop_sc`.`browses` (`session_id`, `member_id`, `item_id`, `modified`, `created`) VALUES ('dpq6nflo668ieag18v6iamkt70', NULL, 258, '2021-04-16 19:11:09', '2021-04-16 19:11:09')	1	1	2
13	SELECT `Review`.`id`, `Review`.`member_id`, `Review`.`item_id`, `Review`.`comment`, `Review`.`rating`, `Review`.`del_flg`, `Review`.`created`, `Review`.`modified`, `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`reviews` AS `Review` LEFT JOIN `release_shop_sc`.`members` AS `Member` ON (`Review`.`member_id` = `Member`.`id`) WHERE `Review`.`item_id` = 258 AND `Review`.`del_flg` = 0 ORDER BY `Review`.`created` DESC LIMIT 10	0	0	0
14	SELECT `Review`.`id`, `Review`.`member_id`, `Review`.`item_id`, `Review`.`comment`, `Review`.`rating`, `Review`.`del_flg`, `Review`.`created`, `Review`.`modified` FROM `release_shop_sc`.`reviews` AS `Review` WHERE `Review`.`item_id` = 258	0	0	0
15	SELECT `OrderItem`.`id`, `OrderItem`.`item_id`, `OrderItem`.`member_id`, `OrderItem`.`title`, `OrderItem`.`price`, `OrderItem`.`quantity`, `OrderItem`.`fee`, `OrderItem`.`total`, `OrderItem`.`status`, `OrderItem`.`name`, `OrderItem`.`name_kana`, `OrderItem`.`company`, `OrderItem`.`postcode`, `OrderItem`.`address`, `OrderItem`.`phone`, `OrderItem`.`gender`, `OrderItem`.`email`, `OrderItem`.`sale_ym`, `OrderItem`.`del_flg`, `OrderItem`.`rank`, `OrderItem`.`created`, `OrderItem`.`modified` FROM `release_shop_sc`.`order_items` AS `OrderItem` WHERE `OrderItem`.`member_id` IS NULL AND `OrderItem`.`item_id` = 258 AND `OrderItem`.`del_flg` = 0 LIMIT 1	0	0	0
16	SELECT COUNT(*) AS `count` FROM `release_shop_sc`.`favorite_items` AS `FavoriteItem` WHERE `item_id` = 258 AND `member_id` IS NULL	1	1	0
17	SELECT COUNT(*) AS `count` FROM `release_shop_sc`.`order_items` AS `OrderItem` WHERE `OrderItem`.`item_id` = 258 AND `OrderItem`.`member_id` IS NULL AND `OrderItem`.`del_flg` = 0 AND `OrderItem`.`created` > '2021-04-09 19:11:09'	1	1	0
18	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
19	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
20	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

(default) 20 queries took 75 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT * FROM data_branches WHERE del_flg <= 0

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

717

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

SELECT `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`members` AS `Member` WHERE `id` IS NULL AND `del_flg` = 0 AND `role` = 'user' LIMIT 1

SELECT `Config`.`id`, `Config`.`code`, `Config`.`name`, `Config`.`unit_name`, `Config`.`type`, `Config`.`number`, `Config`.`value`, `Config`.`description`, `Config`.`rank`, `Config`.`del_flg`, `Config`.`created`, `Config`.`modified` FROM `release_shop_sc`.`configs` AS `Config` WHERE `Config`.`code` = 'view_without_login' AND `Config`.`del_flg` = 0 LIMIT 1

SELECT `Item`.`id`, `Item`.`member_id`, `Item`.`title`, `Item`.`price`, `Item`.`fee`, `Item`.`category`, `Item`.`discription`, `Item`.`message`, `Item`.`password`, `Item`.`review`, `Item`.`review_auther`, `Item`.`tag1`, `Item`.`tag2`, `Item`.`tag3`, `Item`.`tag4`, `Item`.`tag5`, `Item`.`main_image_file_name`, `Item`.`sub_image1_file_name`, `Item`.`sub_image2_file_name`, `Item`.`sub_image3_file_name`, `Item`.`sub_image4_file_name`, `Item`.`file_name`, `Item`.`file_path`, `Item`.`file_type`, `Item`.`file_extension`, `Item`.`file_size`, `Item`.`selling`, `Item`.`sale_count`, `Item`.`pickup`, `Item`.`sale_rank`, `Item`.`seller_rank`, `Item`.`quantity`, `Item`.`shippingpayer`, `Item`.`shippingmethod`, `Item`.`shippingfromarea`, `Item`.`shippingduration`, `Item`.`image_file_name`, `Item`.`aboutshippingcost`, `Item`.`del_flg`, `Item`.`save_flg`, `Item`.`close_flg`, `Item`.`created`, `Item`.`modified`, `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`items` AS `Item` LEFT JOIN `release_shop_sc`.`members` AS `Member` ON (`Item`.`member_id` = `Member`.`id`) WHERE `Item`.`id` = 258 AND `Item`.`del_flg` = 0 AND `Item`.`save_flg` = 1 LIMIT 1

SELECT `Item`.`id`, `Item`.`member_id`, `Item`.`title`, `Item`.`price`, `Item`.`fee`, `Item`.`category`, `Item`.`discription`, `Item`.`message`, `Item`.`password`, `Item`.`review`, `Item`.`review_auther`, `Item`.`tag1`, `Item`.`tag2`, `Item`.`tag3`, `Item`.`tag4`, `Item`.`tag5`, `Item`.`main_image_file_name`, `Item`.`sub_image1_file_name`, `Item`.`sub_image2_file_name`, `Item`.`sub_image3_file_name`, `Item`.`sub_image4_file_name`, `Item`.`file_name`, `Item`.`file_path`, `Item`.`file_type`, `Item`.`file_extension`, `Item`.`file_size`, `Item`.`selling`, `Item`.`sale_count`, `Item`.`pickup`, `Item`.`sale_rank`, `Item`.`seller_rank`, `Item`.`quantity`, `Item`.`shippingpayer`, `Item`.`shippingmethod`, `Item`.`shippingfromarea`, `Item`.`shippingduration`, `Item`.`image_file_name`, `Item`.`aboutshippingcost`, `Item`.`del_flg`, `Item`.`save_flg`, `Item`.`close_flg`, `Item`.`created`, `Item`.`modified`, `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`items` AS `Item` LEFT JOIN `release_shop_sc`.`members` AS `Member` ON (`Item`.`member_id` = `Member`.`id`) WHERE `Item`.`del_flg` = 0 AND `Item`.`save_flg` = 1 AND `Item`.`selling` = 1 AND `Item`.`category` = '果物・柿' ORDER BY `Item`.`sale_count` DESC LIMIT 4

SELECT `Item`.`id`, `Item`.`member_id`, `Item`.`title`, `Item`.`price`, `Item`.`fee`, `Item`.`category`, `Item`.`discription`, `Item`.`message`, `Item`.`password`, `Item`.`review`, `Item`.`review_auther`, `Item`.`tag1`, `Item`.`tag2`, `Item`.`tag3`, `Item`.`tag4`, `Item`.`tag5`, `Item`.`main_image_file_name`, `Item`.`sub_image1_file_name`, `Item`.`sub_image2_file_name`, `Item`.`sub_image3_file_name`, `Item`.`sub_image4_file_name`, `Item`.`file_name`, `Item`.`file_path`, `Item`.`file_type`, `Item`.`file_extension`, `Item`.`file_size`, `Item`.`selling`, `Item`.`sale_count`, `Item`.`pickup`, `Item`.`sale_rank`, `Item`.`seller_rank`, `Item`.`quantity`, `Item`.`shippingpayer`, `Item`.`shippingmethod`, `Item`.`shippingfromarea`, `Item`.`shippingduration`, `Item`.`image_file_name`, `Item`.`aboutshippingcost`, `Item`.`del_flg`, `Item`.`save_flg`, `Item`.`close_flg`, `Item`.`created`, `Item`.`modified`, `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`items` AS `Item` LEFT JOIN `release_shop_sc`.`members` AS `Member` ON (`Item`.`member_id` = `Member`.`id`) WHERE `Item`.`del_flg` = 0 AND `Item`.`save_flg` = 1 AND `Item`.`selling` = 1 AND `Item`.`member_id` = 147 ORDER BY `Item`.`sale_count` DESC LIMIT 4

SELECT * FROM browses Browse INNER JOIN items Item ON Browse.item_id = Item.id AND Item.selling = 1 AND Item.save_flg = 1 AND Item.del_flg = 0 INNER JOIN members Member ON Member.id = Item.member_id WHERE Browse.id > 0 AND Browse.session_id = 'dpq6nflo668ieag18v6iamkt70' OR Browse.member_id = '' GROUP BY Item.id LIMIT 12

SELECT COUNT(*) AS `count` FROM `release_shop_sc`.`browses` AS `Browse` WHERE `session_id` = 'dpq6nflo668ieag18v6iamkt70' AND `member_id` IS NULL AND `item_id` = 258

INSERT INTO `release_shop_sc`.`browses` (`session_id`, `member_id`, `item_id`, `modified`, `created`) VALUES ('dpq6nflo668ieag18v6iamkt70', NULL, 258, '2021-04-16 19:11:09', '2021-04-16 19:11:09')

SELECT `Review`.`id`, `Review`.`member_id`, `Review`.`item_id`, `Review`.`comment`, `Review`.`rating`, `Review`.`del_flg`, `Review`.`created`, `Review`.`modified`, `Member`.`id`, `Member`.`user_id`, `Member`.`password`, `Member`.`name`, `Member`.`name_kana`, `Member`.`company`, `Member`.`postcode`, `Member`.`address`, `Member`.`phone`, `Member`.`gender`, `Member`.`birthday`, `Member`.`nickname`, `Member`.`email`, `Member`.`password_hint`, `Member`.`mailmag_flg`, `Member`.`comment`, `Member`.`admin_message`, `Member`.`point`, `Member`.`image_file_name`, `Member`.`user_rank`, `Member`.`role`, `Member`.`status`, `Member`.`notification_to_saller_flag`, `Member`.`purchased_to_saller_flag`, `Member`.`bank_name`, `Member`.`branch_name`, `Member`.`branch_code`, `Member`.`account_no`, `Member`.`deposit_name`, `Member`.`tmp_key`, `Member`.`admin_level`, `Member`.`created`, `Member`.`modified`, `Member`.`del_flg` FROM `release_shop_sc`.`reviews` AS `Review` LEFT JOIN `release_shop_sc`.`members` AS `Member` ON (`Review`.`member_id` = `Member`.`id`) WHERE `Review`.`item_id` = 258 AND `Review`.`del_flg` = 0 ORDER BY `Review`.`created` DESC LIMIT 10

SELECT `OrderItem`.`id`, `OrderItem`.`item_id`, `OrderItem`.`member_id`, `OrderItem`.`title`, `OrderItem`.`price`, `OrderItem`.`quantity`, `OrderItem`.`fee`, `OrderItem`.`total`, `OrderItem`.`status`, `OrderItem`.`name`, `OrderItem`.`name_kana`, `OrderItem`.`company`, `OrderItem`.`postcode`, `OrderItem`.`address`, `OrderItem`.`phone`, `OrderItem`.`gender`, `OrderItem`.`email`, `OrderItem`.`sale_ym`, `OrderItem`.`del_flg`, `OrderItem`.`rank`, `OrderItem`.`created`, `OrderItem`.`modified` FROM `release_shop_sc`.`order_items` AS `OrderItem` WHERE `OrderItem`.`member_id` IS NULL AND `OrderItem`.`item_id` = 258 AND `OrderItem`.`del_flg` = 0 LIMIT 1

SELECT COUNT(*) AS `count` FROM `release_shop_sc`.`favorite_items` AS `FavoriteItem` WHERE `item_id` = 258 AND `member_id` IS NULL

SELECT COUNT(*) AS `count` FROM `release_shop_sc`.`order_items` AS `OrderItem` WHERE `OrderItem`.`item_id` = 258 AND `OrderItem`.`member_id` IS NULL AND `OrderItem`.`del_flg` = 0 AND `OrderItem`.`created` > '2021-04-09 19:11:09'

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

奈良県産富有柿（4L 10玉入り）

奈良県産富有柿（4L 10玉入り）

買った人のレビュー / 総合評価 ( 登録なし )

販売者

商品キーワード

この商品を買った人はこんな商品も買っています

この出品者の人気商品

商品ランキング

最近閲覧した商品

カテゴリー

現在の人気キーワード

ご利用案内

お問い合わせ