SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561085 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561085 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136274,921813,493745,514118,147138,598387,193417,591237,101888,740128,293564,848418,912945,101200,183287,623015,444778,434587,560896,769682,608849,632077,177982,966439,330028,522929,95226,811428,220427,851692,23425,929429,453669,663058,744808,185376,887881,533066,218060,795151,925873,892081,1013307,227599,675431,598098,446931,300814,462601,376959,475632,338804,507839,1002074,377003,794218,366273,978440,279586,1047127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]