SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502058 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502058 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617434,589383,971568,255978,256101,330359,1010459,1012721,106109,29867,718265,948457,550071,908174,855121,88680,914210,637018,305131,193539,919289,1014187,329263,1013773,749888,431120,1028117,120854,844620,539322,686725,594786,717809,738718,195991,581454,310915,767937,470967,1025531,754873,741785,662475,803046,623701,315663,536430,952802,25279,517,452599,384912,739886,503414,940191,974326,751294,98866,966748,1004097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]