SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549541 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549541 [ RunTime:0.003423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514758,749112,969798,298831,152300,662760,701961,44577,215005,1048649,243236,220929,705490,123091,359620,664050,131969,667547,299610,242861,567177,1009259,182841,409826,377570,73902,1027843,984894,294373,742801,189967,584356,169289,306026,623396,1028486,203284,98934,969568,377190,340859,838013,188654,551546,808295,522859,954716,347617,30742,240740,766930,373918,35577,262579,370708,183111,150470,851259,11508,155987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]