SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002847s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036717 LIMIT 1 [ RunTime:0.002737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036717 [ RunTime:0.003478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134025,686774,815056,249710,795883,174189,123138,468985,23352,252826,1045431,201399,32676,983682,790010,709806,1039584,104795,179347,187293,812375,438761,266288,408407,183853,966209,158734,910999,383080,233613,590470,448934,742435,582693,588337,74581,980310,770539,454741,954000,733306,923586,572731,214753,822114,605091,731346,284008,292496,84571,240467,943240,549248,4390,785110,803902,853039,273985,358400,1012145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]