SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68850 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68850 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202645,103901,366838,38144,73818,143539,652578,898290,652492,125745,762652,232150,190530,214993,44862,994633,881433,812019,104101,695554,715645,789723,235437,414057,250294,801038,96016,397724,141270,475064,340903,167037,38861,694727,657229,366523,259603,416083,437694,170237,328387,932141,849960,810811,555158,446794,840258,526306,192302,194281,181285,340577,122753,556421,840587,392968,216803,334354,787965,169619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]