SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 27918 LIMIT 1 [ RunTime:0.000771s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 27918 [ RunTime:0.004778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006246,868444,473407,722196,17617,253185,395634,477819,286399,1044129,90858,685674,62624,603683,990140,572065,477055,561541,656640,311842,1015309,67708,176359,760167,469380,251725,117940,1015759,837636,372925,330538,517165,19471,691480,430959,854639,840736,533837,137847,608458,512890,654539,966230,350713,340623,711250,618050,623636,131099,1022781,868984,860665,453478,468717,424440,481004,918366,1011251,565746,742964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 27918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 27918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]