SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409572 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409572 [ RunTime:0.005954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947428,883678,62451,698316,384858,432966,263324,131101,546130,337650,943886,947885,643818,901585,658771,950124,653485,477645,309493,397966,479027,138944,268543,917605,88909,1035954,226940,835440,741043,442551,585084,849345,716257,516294,591404,506443,668301,147896,692074,598935,200671,443103,802001,92436,488048,769013,584901,891313,269275,792871,494657,330713,963223,203071,830382,23150,442107,259609,1017278,953857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]