SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50271 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50271 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481852,219873,206681,13552,583537,780300,314271,929437,135601,259869,692913,866216,154065,627314,703600,105046,771910,425593,816170,894057,579447,75651,346963,829591,219393,190893,430101,278186,533109,900814,1011126,394425,159510,320038,669469,770683,500677,390144,594713,709393,708736,944886,1028421,477582,643587,599616,832911,771899,1021,217376,614821,796328,226501,495320,337088,668187,50195,978809,839002,390967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]