SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35687 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35687 [ RunTime:0.003127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383582,1012996,1003716,767098,138853,371008,340319,928943,535628,497411,140077,78816,777697,932605,569638,140386,214682,642229,772993,570805,556137,388422,6512,342603,527250,943413,508175,931278,863434,79380,401697,1010008,108486,542761,224199,660068,793647,723803,79454,952447,701725,383629,59621,1042903,1042023,505787,1038355,104062,1002645,290347,991759,589030,476223,112524,1034044,670825,669498,731065,579367,26076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000781s ]