SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467251 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467251 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812486,106476,355278,285529,150518,353667,724527,515522,851337,217471,314425,899870,144874,849337,880861,128061,264390,885343,335626,636033,275138,268526,115644,554921,500869,240512,398573,760382,666269,226960,78190,566903,278182,470417,301372,406602,642692,896503,691554,556315,132247,613207,799071,205860,954298,762311,430041,685618,764078,692065,974016,532630,1031832,463014,368139,819734,878770,561578,451555,802773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]