SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356711 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356711 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417613,717131,148667,84522,383632,64727,616765,301954,849340,234495,224997,1005184,688494,907554,256247,249751,476979,944866,1010012,815780,109013,700411,938423,662971,142564,502452,962779,595472,110378,85453,174169,894450,796938,936636,606823,672472,64205,433382,295954,157337,960832,965544,1022870,156807,839693,718527,180689,1011878,845759,895252,964180,745575,241701,217806,538566,367411,203266,41666,315716,223584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]