SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521819 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521819 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316425,390130,923686,968457,321495,38069,788725,209079,943549,302175,206196,615191,1028816,756550,602313,613738,463800,836436,284386,401996,622888,195050,675981,561279,1509,555352,442258,606704,149126,951282,381773,8936,1016370,470968,528856,1018031,594734,947287,969276,267365,1000674,599626,1001225,143392,36397,65247,809483,42224,439812,489804,4920,1016555,609374,600922,446246,39436,633059,679087,1009687,741858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]