SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437570 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437570 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263952,884494,132237,186563,589647,156116,805525,398951,519958,444508,491722,754948,731044,793162,248444,989790,89296,770782,840797,125644,670633,203200,355967,285918,889698,185752,531314,322891,104581,624058,370334,188259,208362,56633,124500,855918,398871,348514,87153,949792,725395,97222,568012,261297,854553,312622,262178,476372,296568,901501,334560,1020066,155360,682597,799340,571361,661549,83165,751461,269257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003367s ]