SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538909 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538909 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961508,555918,163849,22372,680546,712246,301514,937140,284195,699898,257133,687495,603569,1040748,207653,131938,270133,554038,371055,514589,63020,278569,565760,105017,1043012,854703,751237,48321,600977,883070,268178,166061,767573,255349,440077,748894,253618,1044369,45150,9314,722399,983238,652844,828604,635037,172392,662199,86515,338990,834235,937895,128063,583489,390919,993125,334878,690813,780259,49830,379184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]