SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32612 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32612 [ RunTime:0.003102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800099,972714,1009434,530945,367253,123250,833034,548327,459893,37788,866929,253595,10850,902712,158331,406488,919535,876800,1044461,998789,63442,722601,530094,479052,430884,110742,342604,1024475,310039,1029598,839279,851005,576530,444935,95081,649704,617391,818514,624843,945993,896278,612900,132153,771309,554653,453279,740020,76375,933246,347288,972855,1013137,601106,349981,808122,516265,152282,610832,213863,739112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]