SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507087 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507087 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113792,556462,999987,943422,405679,353994,314783,919024,456760,504874,984314,902352,491315,57887,461942,500209,30538,465011,389719,559517,1039207,882185,238820,34299,629444,839112,703738,756546,647518,240381,81415,419636,569042,434910,1014226,761401,389225,1015322,758378,1010809,425962,564387,552426,965224,918293,758870,411799,485644,235656,445987,659209,1009198,467976,886727,13380,190679,94177,176226,75420,91389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]