黒毛和牛 仙台牛 特上カルビ 1000g

test1102e

【宮城県産】仙台牛 特上カルビ 1000g
※冷凍での発送になります。
※写真通りきれいな霜が降った焼肉用のお肉になります。

黒毛和牛 仙台牛 特上カルビ 1000g

【宮城県産】仙台牛 特上カルビ 1000g
※冷凍での発送になります。
※写真通りきれいな霜が降った焼肉用のお肉になります。

2,980円

商品番号 000281
登録日 2020年10月01日
カテゴリー 肉・牛肉
配送料の負担 送料込み
配送方法 クール便
発送元の地域 宮城県
発送までの日数 1~2日で発送

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

販売者

商品キーワード

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

この出品者の人気商品

商品ランキング

最近閲覧した商品

(default) 20 queries took 77 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 >= 07177178
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
5SELECT `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 1000
6SELECT `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 1110
7SELECT `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` = 281 AND `Item`.`del_flg` = 0 AND `Item`.`save_flg` = 1 LIMIT 1110
8SELECT `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 4441
9SELECT `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` = 165 ORDER BY `Item`.`sale_count` DESC LIMIT 4331
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 = 'j7fltuk26kssr1sjvcjt83fse6' OR Browse.member_id = '' GROUP BY Item.id LIMIT 12 0027
11SELECT COUNT(*) AS `count` FROM `release_shop_sc`.`browses` AS `Browse` WHERE `session_id` = 'j7fltuk26kssr1sjvcjt83fse6' AND `member_id` IS NULL AND `item_id` = 2811117
12INSERT INTO `release_shop_sc`.`browses` (`session_id`, `member_id`, `item_id`, `modified`, `created`) VALUES ('j7fltuk26kssr1sjvcjt83fse6', NULL, 281, '2021-04-16 20:32:46', '2021-04-16 20:32:46')113
13SELECT `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` = 281 AND `Review`.`del_flg` = 0 ORDER BY `Review`.`created` DESC LIMIT 10000
14SELECT `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` = 281000
15SELECT `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` = 281 AND `OrderItem`.`del_flg` = 0 LIMIT 1000
16SELECT COUNT(*) AS `count` FROM `release_shop_sc`.`favorite_items` AS `FavoriteItem` WHERE `item_id` = 281 AND `member_id` IS NULL110
17SELECT COUNT(*) AS `count` FROM `release_shop_sc`.`order_items` AS `OrderItem` WHERE `OrderItem`.`item_id` = 281 AND `OrderItem`.`member_id` IS NULL AND `OrderItem`.`del_flg` = 0 AND `OrderItem`.`created` > '2021-04-09 20:32:46'110
18SELECT `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
19SELECT `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
20SELECT `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