SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402817 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402817 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536284,688375,585919,868936,424205,410069,567458,412486,1030608,149174,1016956,1000799,397632,867677,725266,237478,299594,841100,11955,359984,709456,155340,578902,785852,890193,440126,792447,128020,766886,15572,748965,520140,121766,907089,854417,239684,779146,178480,613791,431651,180088,316783,843440,556332,517473,167548,242521,2826,500034,570274,987417,229673,459146,54289,387289,528102,342052,132732,449651,330514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001702s ]