SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002938s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480280 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480280 [ RunTime:0.004216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420796,18817,815993,787718,649415,37298,952083,1045097,960138,609125,37351,846126,613346,604769,575215,245082,71430,486457,40877,369752,461630,35648,971638,728951,419874,473233,760789,284086,324276,505894,1001403,867187,116842,77788,803890,426670,771375,127661,1041065,160985,740150,330657,734620,419079,224224,837256,554686,820269,622224,976976,979595,111419,964086,780825,114518,568263,921523,502321,191612,549758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]