SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310840 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310840 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938732,864520,739451,750251,748797,374652,171762,618857,855886,344998,383381,335674,906603,822078,704215,634326,383882,128553,529825,748051,105904,416370,263065,492389,1043553,6233,201650,450359,1708,562241,362572,441495,369645,382629,573417,760726,1004878,859504,933456,581686,661148,475701,930015,776000,354587,554335,408713,788848,739491,104571,398200,10928,626126,711609,609266,234771,178314,370318,318683,452046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]