SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415098 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415098 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472551,795709,896387,890330,571946,561776,257225,616626,132979,442668,677014,58762,704907,352211,746276,943246,154913,838129,1007704,35899,907235,854578,329282,129363,588221,490483,289067,846578,450207,789111,273151,169706,951625,91889,177643,267413,208269,755098,764562,208242,1017771,682875,556392,489891,230668,632698,278715,717001,8551,528907,674126,356071,951645,212533,130139,721837,402072,941647,589188,495588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001500s ]