SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205438 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205438 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814914,649211,525989,648355,5427,192499,1019269,714046,576532,846797,215133,68296,200821,883948,831123,264317,7436,600339,504917,246130,123127,326170,325539,599924,4872,328230,565378,809202,288440,851223,812553,255771,689917,448714,745303,674314,422365,955383,804842,922242,894185,488314,1045853,212030,406375,939201,244855,666513,789253,20282,256700,894794,760713,490851,391163,271174,732482,148225,886735,719646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]