中国领先

餐饮酒店互联网平台

3大协会

行业权威支持

500场

全国集采会

120亿

协议订单

爆款推荐

起批量: ≥ 20 箱 库存:2579箱

起批量: ≥ 5 箱 库存:9999589箱

起批量: ≥ 10 袋 库存:208袋

起批量: ≥ 200 千克 库存:1000千克

起批量: ≥ 50 盒 库存:999盒

起批量: ≥ 100 件 库存:20000件

(default) 12 queries took 71 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Category`.`id` FROM `jmuv3`.`recommends_categories` AS `RecommendsCategory` LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`RecommendsCategory`.`category_id` = `Category`.`id`) LEFT JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`type` = 3 AND `RecommendsCategory`.`recommend_id` = `Recommend`.`id`) WHERE `Recommend`.`code` = 'indexv2_hot_categories' AND `Recommend`.`type` = 3 ORDER BY `RecommendsCategory`.`sort_order` ASC, `RecommendsCategory`.`modified` DESC LIMIT 6003593593
2SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`id` IN (7, 55, 34, 38, 26, 59, 11, 52, 17, 48, 23, 18, 41, 49, 12, 56, 61, 27, 53, 5, 24, 35, 62, 50, 21, 32, 43, 57, 13, 51, 25, 6, 36, 1, 2, 4, 9, 10, 8, 3, 564, 590, 471, 211, 477, 759, 791, 776, 123, 460, 462, 574, 215, 286, 461, 530, 742, 456, 589, 208, 561, 811, 181, 582, 188, 578, 575, 735, 793, 473, 504, 788, 548, 708, 84, 738, 591, 599, 605, 815, 262, 513, 1891, 596, 706, 758, 765, 121, 282, 537, 122, 527, 289, 757, 209, 260, 586, 207, 455, 790, 265, 463, 577, 737, 762, 284, 486, 810, 291, 294, 459, 103, 570, 764, 190, 281, 545, 1894, 569, 576, 608, 714, 792, 115, 549, 585, 761, 734, 766, 808, 69, 285, 541, 496, 542, 567, 593, 760, 457, 264, 292, 492, 579, 503, 547, 602, 523, 552, 607, 744, 494, 495, 287, 521, 555, 711, 733, 107, 507, 466, 709, 263, 280, 467, 80, 288, 559, 787, 184, 189, 192, 202, 329, 510, 786, 106, 335, 543, 566, 111, 261, 293, 512, 266, 595, 501, 583, 95, 191, 789, 180, 517, 195, 782, 290, 568, 210, 212, 465, 778, 719, 739, 279, 81, 532, 713, 783, 177, 472, 538, 478, 505, 610, 327, 479, 604, 720, 816, 119, 179, 468, 194, 213, 324, 328, 707, 108, 544, 546, 458, 539, 515, 743, 217, 336, 514, 712, 491, 522, 554, 598, 497, 587, 185, 332, 518, 535, 556, 777, 785, 186, 296, 562, 813, 114, 295, 196, 480, 526, 531, 588, 104, 258, 297, 536, 259, 520, 563, 124, 183, 278, 736, 193, 197, 529, 774, 814, 83, 334, 609, 557, 763, 276, 525, 715, 267, 499, 558, 109, 592, 812, 326, 779, 117, 298, 581, 594, 64, 551, 1895, 584, 126, 571, 780, 603, 485, 565, 809, 216, 330, 475, 519, 550, 92, 474, 118, 489, 533, 597, 127, 516, 775, 66, 469, 553, 560, 67, 257, 331, 710, 93, 214, 325, 65, 182, 534, 572, 781, 283, 125, 524, 573, 580, 741, 784, 277, 333, 498, 187, 606, 68, 82, 178, 540, 718, 464, 493, 740, 120) ORDER BY FIELD(`Category`.`id`, 7,55,34,38,26,59,11,52,17,48,23,18,41,49,12,56,61,27,53,5,24,35,62,50,21,32,43,57,13,51,25,6,36,1,2,4,9,10,8,3,564,590,471,211,477,759,791,776,123,460,462,574,215,286,461,530,742,456,589,208,561,811,181,582,188,578,575,735,793,473,504,788,548,708,84,738,591,599,605,815,262,513,1891,596,706,758,765,121,282,537,122,527,289,757,209,260,586,207,455,790,265,463,577,737,762,284,486,810,291,294,459,103,570,764,190,281,545,1894,569,576,608,714,792,115,549,585,761,734,766,808,69,285,541,496,542,567,593,760,457,264,292,492,579,503,547,602,523,552,607,744,494,495,287,521,555,711,733,107,507,466,709,263,280,467,80,288,559,787,184,189,192,202,329,510,786,106,335,543,566,111,261,293,512,266,595,501,583,95,191,789,180,517,195,782,290,568,210,212,465,778,719,739,279,81,532,713,783,177,472,538,478,505,610,327,479,604,720,816,119,179,468,194,213,324,328,707,108,544,546,458,539,515,743,217,336,514,712,491,522,554,598,497,587,185,332,518,535,556,777,785,186,296,562,813,114,295,196,480,526,531,588,104,258,297,536,259,520,563,124,183,278,736,193,197,529,774,814,83,334,609,557,763,276,525,715,267,499,558,109,592,812,326,779,117,298,581,594,64,551,1895,584,126,571,780,603,485,565,809,216,330,475,519,550,92,474,118,489,533,597,127,516,775,66,469,553,560,67,257,331,710,93,214,325,65,182,534,572,781,283,125,524,573,580,741,784,277,333,498,187,606,68,82,178,540,718,464,493,740,120) ASC3593595
3SELECT `Adimage`.`link`, `Adimage`.`filename` FROM `jmuv3`.`adimages` AS `Adimage` LEFT JOIN `jmuv3`.`ads` AS `Ad` ON (`Adimage`.`ad_id` = `Ad`.`id`) WHERE `Adimage`.`codegroup` = 'index_banner' ORDER BY `Adimage`.`sort` ASC441
4SELECT `Adimage`.`link`, `Adimage`.`filename` FROM `jmuv3`.`adimages` AS `Adimage` LEFT JOIN `jmuv3`.`ads` AS `Ad` ON (`Adimage`.`ad_id` = `Ad`.`id`) WHERE `Adimage`.`codegroup` = 'index_ad' ORDER BY `Adimage`.`sort` ASC111
5SELECT `Good`.`id`, `Good`.`name`, `RecommendsGood`.`id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`image`, `RecommendsGood`.`goods_id`, `Recommend`.`id`, `Recommend`.`name` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) left JOIN `jmuv3`.`stores` AS `Store` ON (`Store`.`id` = `Good`.`store_id`) left JOIN `jmuv3`.`sellers` AS `Seller` ON (`Seller`.`id` = `Store`.`seller_id`) left JOIN `jmuv3`.`users` AS `User` ON (`User`.`id` = `Seller`.`user_id`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'indexv2_hot_goods' AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` DESC LIMIT 30773
6SELECT `Good`.`id`, `Good`.`name`, `Good`.`unit`, `Good`.`image`, `Good`.`ismianyi`, `Good`.`least`, `Store`.`id`, `Store`.`name`, `DefaultSpec`.`id`, `DefaultSpec`.`price`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`issetspec`, `Goodsview`.`id`, `Goodsview`.`stock`, `Goodsview`.`finish_volume`, `Goodsview`.`order_volume`, `Goodsview`.`order_count` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`id` IN (181162, 177704, 166384, 179312, 69348, 146419, 62579) AND `Good`.`isdelete` = 0 ORDER BY FIELD(`Good`.`id`, 181162,177704,166384,179312,69348,146419,62579) ASC771
7SELECT `Spec`.`id`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`goods_id` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`issetspec` = 0 AND `Spec`.`goods_id` IN (181162, 177704, 166384, 179312, 69348, 146419, 62579) ORDER BY `Spec`.`created` DESC111
8SELECT `Image`.`id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex`, `Image`.`goods_id` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (181162, 177704, 166384, 179312, 69348, 146419, 62579) ORDER BY `Image`.`created` DESC17171
9SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (181162, 177704, 166384, 179312, 69348, 146419, 62579) ORDER BY `id` ASC001
10SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (181162, 177704, 166384, 179312, 69348, 146419, 62579)7751
11SELECT `Store`.`id`, `Store`.`name`, `RecommendsStore`.`id`, `RecommendsStore`.`category_id`, `RecommendsStore`.`image`, `RecommendsStore`.`store_id`, `Recommend`.`id`, `Recommend`.`name` FROM `jmuv3`.`recommends_stores` AS `RecommendsStore` LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`RecommendsStore`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`recommends` AS `Recommend` ON (`RecommendsStore`.`recommend_id` = `Recommend`.`id`) WHERE `Recommend`.`code` = 'indexv2_hot_stores' AND `Recommend`.`type` = 1 AND `Store`.`isaudit` = 1 ORDER BY `RecommendsStore`.`sort` ASC, `RecommendsStore`.`modified` DESC LIMIT 10222
12SELECT `Store`.`id`, `Store`.`name`, `Store`.`logo` FROM `jmuv3`.`stores` AS `Store` WHERE `Store`.`id` IN (37240, 73) ORDER BY FIELD(`Store`.`id`, 37240,73) ASC221