SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345663 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345663 [ RunTime:0.005079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025915,985172,759403,96644,408051,82861,871551,194827,359595,171428,757350,196422,811281,972105,898478,117017,820708,597671,710742,104722,866818,628930,1010570,529067,792948,123339,638723,538144,989049,742543,890732,36859,422745,211256,877428,483298,130004,571945,985957,563988,556243,442747,121410,64676,730,864852,920597,873970,342671,319000,743840,613770,323602,410655,892436,976836,422253,671631,392544,310386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]