SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022028 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022028 [ RunTime:0.003855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943250,726234,476061,766687,351352,775176,367765,707816,127973,287765,656560,882332,980020,873365,77483,602516,309998,14786,448436,948713,206394,82596,72621,955504,607679,383968,484366,335983,67051,190908,904047,17202,350484,174682,202399,863488,764007,973413,857260,270498,44822,885145,600700,38543,104209,393155,24370,579760,514901,774219,543046,172934,477346,756690,617054,712574,880113,232640,461290,69051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]