SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335851 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335851 [ RunTime:0.003341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585291,218942,783700,725169,730254,281838,669217,617318,1034778,490247,161603,152933,798466,265917,751107,151929,984219,837044,318505,647880,175675,386965,339346,1007486,579686,333847,853950,1046674,867555,1025796,798592,627954,320252,108403,198733,810433,165367,793533,465136,833029,1029066,212740,444592,43704,165128,535636,237875,613678,175387,342920,866803,517458,982852,827865,609021,449190,894370,417607,575515,445281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]