SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407815 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407815 [ RunTime:0.001429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615370,698587,106581,528778,488041,860493,515787,37834,817426,456970,933787,640470,1032760,499378,568113,80143,789595,549567,658593,780317,896430,912418,826929,163534,584638,669951,630232,744207,659989,673574,569864,181081,841169,838095,975586,321065,624538,657506,757280,294140,434545,127709,303315,22760,885579,78622,469361,421276,355497,546547,604568,50966,933991,1006912,507589,749864,542607,811640,917399,893980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]