SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003513s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015890 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015890 [ RunTime:0.004597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348046,984484,107509,7910,982395,625284,537998,339264,380660,782508,418461,912837,928812,631173,418737,1021051,986494,923866,921810,892592,330905,822635,969689,325441,490875,674848,419682,398019,186049,119210,1023915,942211,997587,508550,329896,645086,878176,943508,874116,577777,466652,710702,563828,619014,933605,822371,1034965,213895,747393,586402,268067,458404,470219,372034,293516,952935,969400,721750,973649,918544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002870s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]