排序: 最新 人气 销量
起批量: 以下
共 3362 件商品  |  1/211
上一页12345211页,到第
(default) 10 queries took 218 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name` FROM `jmuv3`.`categories` AS `Category` LEFT JOIN `jmuv3`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`parent_id` is null ORDER BY FIELD(`Category`.`name`, '食材', '粮油调料', '酒水饮料', '综合用品', '厨房用具', '专业设备', '办公用品', '家具', '信息化系统', '基建装潢'), `Category`.`id` ASC10102
2SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`name`, `ChildCategory`.`isrecommend`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`nc_code`, `ChildCategory`.`ft_code`, `ChildCategory`.`isshow`, `ChildCategory`.`sort` FROM `jmuv3`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (7, 5, 6, 1, 2, 4, 9, 10, 8, 3)53532
3SELECT `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 2002002002
4SELECT `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) 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) ASC2002003
5SELECT `Category`.`lft`, `Category`.`rght` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`id` = 4 LIMIT 1110
6SELECT `Category`.`id`, `Category`.`name` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 489 AND `Category`.`rght` >= 870 ORDER BY `Category`.`lft` asc113
7SELECT `Category`.`lft`, `Category`.`rght` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 4 LIMIT 1110
8SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 870 AND `Category`.`lft` > 489 ORDER BY `Category`.`lft` asc1901903
9SELECT COUNT(*) AS `count` FROM `jmuv3`.`goods` AS `Good` 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`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`goods_id` = `Good`.`id` AND `DefaultSpec`.`issetspec` = 1) LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`Category`.`id` = `Good`.`category_id`) WHERE `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Store`.`isaudit` = 1 AND `User`.`is_delete` = 0 AND `Good`.`category_id` IN (26, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 27, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 28, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 29, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 30, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 31, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 32, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 33, 1892, 4)1189
10SELECT `Good`.`id`, `Good`.`name`, `Good`.`type`, `Good`.`image`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`price`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` 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`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`goods_id` = `Good`.`id` AND `DefaultSpec`.`issetspec` = 1) LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`Category`.`id` = `Good`.`category_id`) WHERE `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Store`.`isaudit` = 1 AND `User`.`is_delete` = 0 AND `Good`.`category_id` IN (26, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 27, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 28, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 29, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 30, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 31, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 32, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 33, 1892, 4) ORDER BY `Store`.`grade` DESC, `Good`.`modified` DESC LIMIT 161616114

用户登录

×

商品价格仅对会员开放

15天内免登录

忘记密码? 立即注册