SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 830816 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 830816 [ RunTime:0.002284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100097,452414,211301,347769,212447,551516,674375,251100,170229,531544,143237,203582,51859,188656,169818,324200,936714,143510,691263,417415,306142,458895,589737,781026,182886,878475,866274,174539,625563,1000256,830545,472365,604865,603150,962629,496986,235088,417978,195932,677065,296813,610074,300530,991177,518460,758392,173257,74366,200657,1016208,460671,37283,753082,205062,52267,847077,281866,753395,336990,1045011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 830816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 830816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]