SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415963 LIMIT 1 [ RunTime:0.001322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415963 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114156,350515,867262,168055,415151,787221,609386,102005,403406,150139,836348,966794,756244,954169,55171,119157,464491,185229,198670,299461,1023240,686570,883275,621243,64303,363376,809180,960782,146436,503096,985472,489642,243254,273838,514249,256278,1001725,301656,1001993,255940,174459,146631,602701,1027159,10358,187484,219435,302900,708727,306942,292406,794610,389490,378937,11789,448379,365034,1024051,305823,522595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001179s ]