SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311738 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311738 [ RunTime:0.003101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197552,643886,843382,639417,575705,1036575,679998,948458,699690,79557,838644,121201,901876,341578,81524,476224,192912,293217,561669,249998,536977,534594,138535,559030,1021623,263007,578943,761243,1032085,326838,258056,273618,464862,296690,210144,571184,337425,358913,758413,66197,797767,943760,20489,652540,657103,10907,1011148,145816,951476,548379,750251,325938,549108,297160,830334,687090,564254,202956,46321,516219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]