SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503321 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503321 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687472,528290,39932,267482,388144,969438,31310,80402,719533,222344,15716,466901,373505,375358,714944,880252,310348,324097,890740,186799,804641,921495,381404,58200,73804,825367,742672,343225,1040355,310780,198600,546106,773381,420137,83569,1158,770201,611824,535718,763955,535639,338078,917361,401447,766895,796493,131497,549079,509477,332279,318579,318311,757405,514618,956628,590197,627454,479459,86085,684600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000821s ]