SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516991 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516991 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608133,153947,88613,159916,183161,1030126,248793,165471,748006,530155,824430,749966,483969,541660,1007507,766433,134241,97638,313882,227918,273514,262287,516386,45129,198938,455351,534512,537101,825282,583198,160904,619585,341266,636657,360460,562385,281557,12619,573161,664985,782617,956130,747405,264347,337133,120577,309774,801608,25938,332431,313628,561012,289516,114548,419175,10639,882615,918750,132161,119994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002379s ]