SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406019 LIMIT 1 [ RunTime:0.000752s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406019 [ RunTime:0.002514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699833,142936,536628,944285,943594,797605,914942,526813,4381,731531,718512,36385,450826,679810,923595,180175,9180,274971,1011685,1007440,89426,311214,490903,932818,517217,902543,609017,676194,763028,648876,243046,892604,1008382,27235,574155,276221,726444,803171,640245,1001134,472705,403817,938482,38,203301,158192,905497,472334,779222,186881,749338,406692,761605,850076,977318,283467,47736,649689,893365,527504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]