SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455316 LIMIT 1 [ RunTime:0.003641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455316 [ RunTime:0.006022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183230,470289,716146,618225,412758,396168,445008,922733,215040,593517,519552,259696,828001,463293,727894,94438,640037,573534,16683,55288,421831,763587,593966,726391,408010,108211,229253,589821,755927,453265,663716,408795,805612,200320,565566,593596,397545,21994,970512,326896,1116,805606,953098,954048,199616,840895,453175,11209,604975,304622,801164,579075,1032225,1043365,41735,722656,437999,395095,124888,866532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001476s ]