SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005909s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191021 LIMIT 1 [ RunTime:0.003270s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191021 [ RunTime:0.003270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048727,140199,528111,131862,1011341,963052,629796,858627,429323,351272,554359,887814,802362,536457,274427,642621,926593,206884,725483,882163,968774,147480,172165,726986,945169,615084,366627,351028,40479,331877,528273,907397,971401,365977,540018,152538,821643,663277,1042060,916439,962752,438135,321353,787272,445596,409937,245387,49489,880232,977229,816892,986889,336406,258303,539240,421321,909949,395942,417322,690803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]