SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5878 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5878 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352361,604388,1007858,75471,929400,400485,853007,556548,269489,667799,410105,307652,1011437,145618,911499,134261,47630,6794,393106,840668,68869,1035552,779578,861715,330692,906664,767923,704346,863582,483117,888705,552312,981002,686160,86201,528232,519947,872011,436344,678361,139355,914929,357447,658641,408695,492056,468694,516852,859193,212952,263666,735137,87986,224781,634100,878377,26423,187533,290566,342705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]