SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 115231 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 115231 [ RunTime:0.002506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135910,462953,893662,456380,637702,813215,675200,192471,285727,823630,413638,845631,904157,1009490,912677,178885,281065,36244,222863,643079,287889,1045831,774785,946702,169050,962775,586222,572489,193821,527911,985871,239358,285749,994236,396574,1028368,918410,768369,639382,757407,383100,1041512,781434,522189,393499,197303,205005,320385,607531,539034,783970,70198,206324,210089,544155,282022,905471,448552,740361,665962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 115231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 115231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]