SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031100 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031100 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806405,201378,727669,8497,707427,573496,116011,86347,924933,917505,449650,377067,847470,492195,657180,920486,637107,804640,821399,300112,142878,56662,657240,131323,114085,933900,1028811,782477,945086,1025958,63987,880114,509767,485331,286035,1000002,393226,309894,425358,388545,49583,456596,24749,40376,880875,205312,329216,723349,88520,705110,1013595,697024,137613,874246,1013350,940196,797048,625220,638111,894086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]