SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540595 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540595 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39272,397664,996988,413625,43155,301304,964710,619071,130680,323411,198862,364942,725924,391745,159869,821274,647540,670356,882502,409318,255429,826503,261666,223761,42534,271194,259373,451698,933101,356791,516329,899662,612041,230638,359025,67115,281398,802718,723736,64101,73398,169480,391560,467468,532881,944414,502208,323359,301041,192091,618585,406951,96165,786172,64366,260286,397481,432065,879709,845051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]