SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54679 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54679 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944297,1034260,776833,723018,912641,495490,658030,175887,23975,161210,624428,357376,592672,338534,973982,87223,883736,384315,1010096,105887,399056,414708,551299,131124,639142,758949,906085,754503,820097,148600,582676,672753,797583,898865,107826,677356,458639,131746,87034,584593,1001842,234301,610454,862224,123215,354136,143953,566532,945733,479383,469362,498440,742452,132895,502660,183544,281091,655743,606421,424563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]